Reach out to Cledara Support to turn on GBAT10 exports in your workspace.
The GBAT10 format is widely used for importing journal entries in accounting systems such as Mamut and Tripletex.
Admins and Finance users can configure the export template by mapping the custom accounting fields in Cledara to GBAT10 columns.
Here are the step-by-step guides on how to set up and export your GBAT10 exports:
Map custom accounting fields to GBAT10 columns
Export transactions in GBAT10 format
Map custom accounting fields to GBAT10 columns
-
Create custom accounting fields in any of your application’s Accounting tab.
You will need four custom fields for the following columns:
- VAT Code
- Expense account
- Supplier number (optional)
- Asset account (if double-entry accounting is used)
-
Head to Settings > Integrations > Accounting > Accounting export templates, and click Set up to choose the template.
- Select the GBAT10 template.
-
Map your custom accounting fields to the corresponding GBAT10 columns:
- Fill in the default values for these columns. These defaults will apply unless specific values are customised for individual applications.
-
To customise the expense codes for each vendor, head to each application's Accounting tab and edit their value. All transactions under this application will use the customised values in the export.
Export transactions in GBAT10 format
Once you’ve completed the configuration, exporting transactions in the GBAT10 format is simple:
- Head to the Transactions tab.
- Click Filter results > Export.
- Select the desired timeframe for the transactions.
- Click Export to generate the file.
You may need to manually define the currency during the import process.
When importing your Cledara GBAT10 export file, keep in mind that the transaction amounts are listed in the currency of your Cledara account, either GBP or EUR. However, your accounting software may require these amounts in a different currency.
For instance, if your software assumes amounts are in NOK, you’ll need to manually convert the figures in the CSV file before importing, or directly in the software after importing.
Be sure to check your accounting platform’s requirements and adjust the transaction amounts as necessary to ensure accurate records.