Before you start, make sure you know the following:
What data your accounting team wants in the export (e.g. payments, suppliers, or both)
What format or structure their system accepts (column headers, date format, decimal separator, etc.)
Whether you’re exporting for credit card payments, reimbursements, or invoices — or all of them
In this article, you can learn how to get all the above-mentioned information.
What Is the Export Formats Builder?
This CSV Builder is a feature in Moss that lets you:
Select exactly which data fields to export (like date, vendor, category, amount, tax, etc.)
Choose the column order and field names
Match your export to your accounting system’s requirements (with very few exceptions)
Save templates you can reuse every month
Note: If you have multiple entities, and need to build the same export template for every entity, you can simply import a template you have already created in Moss. You can find this under Settings/Accounting - Tab “Export Formats”. Click create export format and select “Import from other entity” in this case.
Export templates
You have two options to build your CSV export template
Creating a custom CSV export template
At the end of the article, you can learn how to try out your template.
Build your CSV using a preset template
You can watch this recording to learn who to build a CSV using a present template.
Go to the Accounting section in your Moss dashboard via Settings.
Click “Export Formats” in the top right subheadings
Click on “Create export format”
Next you will select if you would like to create a format from scratch, or - if you already have an existing template for another entity within Moss with a template you want to use.
Note: CSV templates are linked to the type of export they were created for. That means a template built for card transactions can’t be reused for invoices, and vice versa — even if the format looks similar. Each export module pulls from a different dataset, so templates aren’t interchangeable across modules.
You are now on the main page to set the general formatting of the CSV. Here you are asked to
Give your template a clear name (e.g. “Monthly DATEV Export” or “UK Entity — Credit Card Transactions”).
Choose the transaction type you want to export:
Card payments
Reimbursements
Invoices
Prepaid Expenses
Balance Movements
Now you check the mapping and coding per each field. We have built these templates using the most common configurations and data points. You might need to change these (if the template allows) to suit your needs.
Note: If you do not have the option to view or amend any fields in this step (i.e. Diamant), this means the accounting software does not allow any deviation from the template.
Once you have checked or amended as needed, don’t forget to save your template. The button is at the bottom of the mapping page.
You can always come back to make changes, by clicking on the three dots on the right of your template.
Build your CSV without a preset template from Moss
You can watch this recording to learn who to build a CSV without using a present template.
Go to the Accounting section in your Moss dashboard via Settings.
Click “Export Formats” in the top right subheadings
Click on “Create export format”
Next you will select if you would like to create a format from scratch, or - if you already have an existing template for another entity within Moss with a template you want to use.
Note: CSV templates are linked to the type of export they were created for. That means a template built for card transactions can’t be reused for invoices, and vice versa — even if the format looks similar. Each export module pulls from a different dataset, so templates aren’t interchangeable across modules.
You are now on the main page to set the general formatting of the CSV. Here you are asked to
Give your template a clear name (e.g. “Monthly DATEV Export” or “UK Entity — Credit Card Transactions”).
Choose the transaction type you want to export:
Card payments
Reimbursements
Invoices
Prepaid Expenses
Balance Movements
You can now define key formatting like date and amount format, column and decimal separator, file format (UTF-8 or Windows-1252), and if your file should have a header column, or subheadings.
If you need to include an expense and corresponding payment per transaction, we recommend you select the option “Create entry header and entry line for each payment”
Once you have defined your file format, click continue.
Now you create your template by clicking “Add column”, giving it a name and finding the appropriate data to map.
In many cases we have different versions to select. This is where knowing what you need beforehand is important. Select the version you want and click. We now show a demo value in column VALUE to show you how it will look.
Add the next column and create your mapping as needed and make sure to press “Save format” when you are finished.
You can always come back to make changes, by clicking on the three dots on the right of your template.
Try out your template
Now all you need are some :
Transactions ready to export
An import method for your accounting software
Export and import into your accounting software to check it’s working as expected
If something seems off, you can easily go back and edit your template using the three dots on the right of your template.