In short: An audit file (XAF) is a standard Dutch file with data from your accounts. In Odoo 19 with the Dutch localisation you export it from the General Ledger report. The Trial Balance report gives the overview your accountant usually wants next to it. Check the file before sending it. The Belastingdienst says that from 1 January 2027 only XAF 4.0 is accepted for submission, so check which version your Odoo exports.

Your accountant asks for an audit file and a kolommenbalans, and you wonder where to find them in Odoo. It is a question we regularly get at our helpdesk. This article explains what these documents are, how to create them in Odoo 19 and how to check them before they leave your company.
We use the labels of the English interface. This article is not fiscal advice. Which file you must supply, and when, is something to agree with your accountant or the Belastingdienst.
What is an audit file?
XAF stands for XML Auditfile Financieel. According to the Belastingdienst it is an open standard for exchanging data from administrative systems, for reporting and audit purposes. The Belastingdienst, curators and the accountancy sector are named as key users. The file is in XML and has the extension .xaf, so you read it with suitable software and not as a normal report.
The Belastingdienst can request an audit file during an audit, and accountants often use one as well. It is not a separate report that you maintain, but an export from your accounts at a given moment.
XAF 4.0 from 1 January 2027
This point needs attention now. In a notice dated 22 April 2026, the Belastingdienst's service for software suppliers states that from 1 January 2027 only XAF 4.0 is accepted for submission, and that older versions are no longer wanted from that date. Version 4.0 is simplified to 90 fields, compared with 250 in version 3.2. RGS must be included only if it is already present in the software.
What about Odoo? The Odoo documentation does not mention a XAF version. In the Odoo 19 database we checked ourselves, with Dutch reports module version 19.0.1.5, the export template still uses the XAF 3.2 format. That can change with an update, so check your own file as described below. Does your file show version 3.2 and do you expect to have to supply one? Then discuss in good time with your accountant and your Odoo partner how you will handle this.
What the Dutch localisation offers
According to the documentation, Netherlands - Accounting (l10n_nl) and Netherlands - Accounting Reports (l10n_nl_reports) are installed automatically. They provide a Dutch chart of accounts, taxes, fiscal positions, and Dutch tax and profit and loss reports. The documentation also describes the XAF export and filing the VAT return through XBRL with a separate SBR module.
The export template we checked covers the following parts:
- a header with the fiscal year, currency and software;
- company data;
- customers and suppliers;
- the general ledger accounts;
- VAT codes and periods;
- the opening balance;
- the transactions.
More about working with your accountant and RGS can be found in Odoo accounting for Dutch businesses.
How to create the audit file
- Open the Accounting app and go to Reporting, General Ledger.
- Use the filters to select the range of entries to export, usually one fiscal year.
- Click the gear icon and then click XAF.
- Save the file under a clear name with the company and the period.
These steps come directly from the documentation. Since the filters determine what is exported, a filter that is set too narrowly can make the file incomplete. So look at the filters before you click.
The kolommenbalans: Trial Balance in Odoo
A kolommenbalans is a Dutch term for an overview of all general ledger accounts with debit and credit amounts in separate columns. Definitions vary slightly, so ask your accountant exactly what is expected. In the Odoo menus we checked, there is no report with that name. The closest report is Trial Balance, under Accounting and Reporting. In a Dutch interface it is called Proefbalans.
In the database we checked, this report shows an opening balance, the debit and credit of the selected period, and an end balance per account. Reports can be exported to PDF, or to XLSX through the arrow next to the PDF button. The documentation also describes a Comparison menu for comparing periods.
Does your accountant want more columns, such as a separate split into balance sheet and profit and loss? Then an XLSX export is a practical starting point. If this overview is requested often, you can consider a custom report.
Before you export: clean up first
An audit file only shows what is in your accounts. So first go through these points:
- Are the bank accounts reconciled and does the balance match the statement? See the year-end closing checklist.
- Is anything left in draft that belongs to this period?
- Is the balance on the suspense account explainable?
- Have you corrected or explained odd postings, such as manual entries on the bank?
- Have you agreed with your accountant whether the period has been locked?
How to check the audit file
- Check the version. Open the file in a text editor. The first lines show the format and version, along with the fiscal year and dates.
- Check the company. In a database with several companies, verify that the company and VAT number in the header are correct.
- Compare the totals. Compare debit and credit in the file with the Trial Balance for the same period and the same filters.
- Check the opening balance. It should match the closing balance of the previous year.
- Sample the transactions. Look up a few entries from the beginning and end of the period, including one from each main journal.
- Have it read. Ask your accountant to load the file in their software before you consider it final.
The Belastingdienst's Validation Test Service is intended for software suppliers with a support subscription. So as a company you depend mainly on the checks above and on your accountant.
And in Belgium?
XAF is a Dutch format. In the Belgian localisation documentation we found no audit file export. For Belgian companies, the General Ledger and Trial Balance exports are the logical starting point. Ask your accountant which format they prefer.
What this means for you
Do not wait until someone asks. Export a test file now, check the version and discuss the result with your accountant. The Belastingdienst advises preparing in the fourth quarter of 2026. Also keep using account codes, even though they become optional in Odoo 20, as described in Accounting in Odoo 20. After an upgrade, test the export again.
Frequently asked questions
What is an audit file (XAF)?
The XML Auditfile Financieel is an open standard for exchanging data from administrative systems, for reporting and audit purposes. The Belastingdienst, curators and the accountancy sector use the format. An XAF file has the extension .xaf and you read it with suitable software.
How do I create an audit file in Odoo?
Open the Accounting app and go to Reporting, General Ledger. Use the filters to select the entries you want to export, click the gear icon and click XAF. Then check the file before you send it on.
Which XAF version do I need from 2027?
According to a notice from the Belastingdienst of 22 April 2026, only XAF 4.0 is accepted for submission from 1 January 2027. Check which version your Odoo exports and discuss with your accountant what that means for you.
Finally
Would you like help checking your audit file or preparing your accounts for your accountant? Contact DAADit Group or take the free Business Scan.