Accounting flat file

Created by Erik Åkerlund, Modified on Wed, 07 Feb 2024 at 01:56 PM by Jenny Johansson

If your ERP-system can receive a flat csv file, choose the integration plugin AccountingCsvExporter in menu Auotpilot - Tab Integrations.


1. Click on the plus sign, choose the plugin. Give it a name in tab Overview.


2. Fill in the format settings.

    Type in the delimiter you want to have in the file.

    Fill in the file suffix (csv or txt or leave blank, then no file suffix).

    Interface, export date and Journal Entry number will build up the file name if you leave the File name field blank.

    For example TS (stands for Treasury Systems).

    Fill in if you want to have separate file names for realized, unrealized and reverse of unrealized files.

    The file name with below parameters will be TS_YYMMDDXXXX_REAL.csv. The XXXX is a unique Journal Entry number.

    Click on button Apply for save the parameters.

3. Mappings


    Add the different fields you need in your file by clicking on the plus sign.

    In the Expression you can choose from different menus to select which kind of values you will add, for example in                   Accounting Value you find the account number.  

    You need to adjust the format for Amounts and Dates.

    You can add many more fields than in this example.

    Note; A consultant can help you with the different Expressions.

   


4. In History tab you will see the result of exporting the accounting files.


5. In Advanced tab you see the folder the files will be exported to in Azure. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article