Edit

Share via

Export General Ledger entries for tax audits

  • Article

In France, companies must provide corporate tax and VAT information, such as transactions and general ledger postings, for audits. The information must be provided in a file format that's specified by tax authorities. In Business Central, this information is recorded in a standard audit file that is designed to provide information about account types that include posted entries.

Note

There is a new feature in release 22.1. To use this feature, run the Audit File Export Document page.

Export the audit file

  1. Select the Lightbulb that opens the Tell Me feature. icon, enter Audit File Export Document, and then select the related link.
  2. Select New to create new exporting process.
  3. In the Audit File Export Format field, select FEC to specifiy the format that's used to export the audit file.
  4. On the FEC FastTab, mark the Include Opening Balances field to include opening balances in the audit report file. The balances are calculated as of the date before the first date of the period covered by the report.
  5. Enter the Default Source Code to specify the source code to be used if there is no code specified in the G/L entry.
  6. Enter information in the remaining fields as described in the article, How to export Audit Files.

Numbering in the "EcritureNum" tag

The numbering in the "EcritureNum" tag must increase over time and not contain any breaks. This transaction numbering must be unique for the whole file or specific to each journal code. Using the No. field in the G/L Regusters provides unique numbering. However, if you post multiple invoices through one journal, all of the invoices will have one common No.. French regulation requires a unique number for each invoice.

To fufill this requirment, run the report with an additional option. To do this, follow next steps:

  1. Select the Lightbulb that opens the Tell Me feature. icon and enter Export G/L Entries - Tax Audit.
  2. Select the Use Transaction No. field. When you select this field, the transaction number is used as the progressive number in audit file. If you don't select this field, the general ledger register number is used as the progressive number.
  3. Select OK to create the report.

See also

French Local Functionality How to use Audit Files Export app

Find free e-learning modules for Business Central here