Generating Audit File

1. Go to the company. The Audit File section is visible.
2. In the Year field select a year.
3. [Optional] In the Transactions From field select an alternative period.
4. [Optional] In the Transactions To field select an alternative period.
5. Click Generate File. A progress bar indicates the status of the file. The following confirmation processes apply, depending on your audit file selection: Generating an audit file for France: When the file is ready an email is sent with a link to your company. From your company, click All Audit Files. Generating an audit file for Netherlands: When the file is ready an email is sent with a link to the audit file library.

To access the audit file library your company. From your company, click All Audit Files. The audit files are stored in the following structure:

• France: Library | Audit File Library | The audit files for France are stored in this location.
• Netherlands: Library | Audit File Library | NL | The audit files for the Netherlands are stored in this location.

Notes:

When generating an audit file for the Netherlands, the user's language must be set to English.

If there is an error generating the file for France a message is displayed. Refresh the screen and refer to the log in the Audit File Log section. An email is also sent with a link to the company where the error occurred. If the error is related to a memory limit, see Localization Settings.

6. [Optional] To view the file click All Audit Files.

Notes: If there is an error generating the file for Netherlands an email is sent describing the error. A break in the consecutive naming of the audit files does not prevent the audit files from being merged correctly.

Notes: When generating audit files for France the maximum size of the audit file is defined in the Accounting Localization Settings (FF) custom setting.If the file generation batch process fails all related files created by the batch process are deleted.

If numerous files are generated, see the following section in order to merge them into one file.

Merging Numerous Files

Depending on the amount of information, numerous files may be generated. Each file name uses the following convention:

{nine digit SIREN number}FEC {financial year} {yyyy}-{mm}-{dd} {time} - {sequence suffix}.txt

For example, if three files are generated the file names could look as follows:

• 123456789FEC 2020 2020-12-24 12:30:00 - 1.txt
• 123456789FEC 2020 2020-12-24 12:31:00 - 2.txt
• 123456789FEC 2020 2020-12-24 12:32:00 - 3.txt

Before sending your file to the relevant tax authorities you must merge the numerous file into one file. The steps differ for Windows or Mac users.

Windows

1. Download all generated files to an empty folder.
2. Open the Command Prompt.
3. Navigate to the folder in the Command Prompt.
4. Enter the following command:

   copy /b *.csv merge.txt

   All CSV files are copied into one file.
5. Navigate to the new file and rename it according to the following convention:

   {nine digit SIREN number}FEC{YYYYMMDD}.txt
   

   For example: 819801804FEC20190630.txt.

Note: The date must be the closing period date.

Mac

1. Download all generated files to an empty folder.
2. Open the Terminal.
3. Navigate to the folder in the Terminal.
4. Enter the following command:

   cat *.csv >merged.txt

   All CSV files are copied into one file.
5. Navigate to the new file and rename it according to the following convention:

   {nine digit SIREN number}FEC{YYYYMMDD}.txt
   

   For example: 819801804FEC20190630.txt.

Note: The date must be the closing period date.