Skip to main content

Export data using the Moss API

Learn about the Moss API and how it compares to other ways to get data out of Moss.

R
Written by Rosanna Howard
Updated today

The Moss API lets your organisation connect Moss to other business tools, such as project management software, cash flow tools, reporting dashboards, or other systems your team relies on. It gives authorised applications secure, automated access to your Moss data, so you can reduce manual exports and keep your financial systems in sync.

This article explains what the Moss API is and how it compares with other ways to get data out of Moss. For setup, data availability, and next steps, see Getting started with the Moss API.


What is the Moss API?

The Moss API is a way for your IT team or integration partner to connect Moss with other systems programmatically. Instead of downloading CSV files or relying on file-based delivery, your systems can pull data from Moss when needed and, for some data types, write data back to Moss.

You can use the API to support custom integrations, automation, reporting, and analytics across your finance stack. Typical use cases include:

  • building custom dashboards

  • connecting Moss to internal tools or unsupported systems

  • automating workflows

  • consolidating data across multiple entities

  • syncing selected data back into Moss, such as suppliers or cost centres

The API is best suited to organisations that want more flexibility than standard exports or built-in integrations can provide. It usually requires support from an IT team, data team, or implementation partner.


Ways to get data out of Moss

Moss offers several ways to export and connect your financial data. Each option supports a different need. Choosing the right one depends on whether you need a one-off export, scheduled file delivery, a standard accounting export, or a custom integration.

CSV export

A CSV export is the simplest option, allowing you to download expense data or transaction lists directly from the Moss app as CSV files. This works well for ad hoc analysis, quick checks, or uploading data into accounting software that is not supported by a native integration.

You should use CSV export when:

  • you need a one-off export

  • you want a quick data extract for spreadsheet analysis

  • you need to upload data manually into another system

SFTP

Moss can deliver files automatically to your SFTP server on a set schedule. You can choose which datasets to include, define delivery times, and optionally include attachments as ZIP files. This is useful when downstream systems are designed to pick up files from a server regularly.

You should use SFTP when:

  • you want automated file-based delivery

  • your downstream systems expect scheduled file drops

  • you need to export data sets such as card transactions, invoices, or reimbursements without manual intervention

  • you have your own SFTP server

Accounting integrations

Moss offers out-the-box integrations with popular accounting systems including DATEV (DUO and Direct), AFAS, Exact Online, Exact Globe, MS Dynamics 365 Business Central, Oracle NetSuite, QuickBooks Online, SAP Business One, Twinfield, and Xero. View the full list of supported accounting integrations here.

Moss accounting integrations are designed for standard pre-accounting exports into supported ERP and accounting systems. These integrations send approved invoices, reimbursements, and card transactions directly to your accounting software in its native format, mapped to your chart of accounts, tax codes, and cost centres. You configure field mapping, accounting periods, and posting periods to match your ERP’s requirements.

You should use an accounting integration when:

  • your accounting software is supported by Moss

  • you want a managed export workflow into your ERP

  • you want to map data to your chart of accounts, tax codes, and cost centres without building a custom integration

Moss API

The Moss API gives your business direct, programmable access to Moss data. Unlike CSV export, SFTP, or standard accounting integrations, the Moss API allows your systems to request exactly the data they need, when they need it, and combine it with data from other sources.

You should use the Moss API when:

  • you want to build custom dashboards or reports (e.g. using tools like Google BigQuery, Looker Studio, Metabase, or Power BI)

  • you want to automate workflows across systems (e.g. using tools like n8n for supplier communication, compliance reporting, or expense routing)

  • you want to connect Moss to AI tools (e.g. expense classification, anomaly detection, or spend analysis)

  • you need a consolidated view across multiple entities (e.g. cash forecasting, group-level spend analysis, cross-entity reporting)

  • you want to write selected data back to Moss (e.g. creating suppliers, syncing cost centres from another system).

Keep in mind:

  • the API requires technical setup and maintenance

  • it is not the best choice for standard accounting export if your ERP is already supported via an accounting integration


Can I use more than one option?

Yes! These options are complementary and can be used together. For example, an organisation might use:

  • an accounting integration for standard monthly ERP export

  • the API for custom dashboards or additional system integrations

  • CSV export for occasional ad hoc analysis


Next steps

To learn more about what data is available, common use cases, pricing, and how to get started, see Getting started with the Moss API.

Did this answer your question?