Create XML audit file
<< Click to Display Table of Contents >> Create XML audit file |
The XML Audit file Financial (XAF) is an open standard for the exchange of data from administrative systems for reporting and control purposes. The Dutch tax administration, trustees and accountancy are important users of the audit file.
An XML audit file can be created via Bookkeeping > Financial > Create XML audit file.
An audit file can be created as XAF versions 2.0, 3.2 and 4.0.
Additional to XAF v2.0, XAF v3.2 also supports:
–VAT codes
–Periods
–Cost types and cost centres
–Sub ledgers debtors and creditors
Compared with XAF v3.2, XAF v4.0 is a simplified file. Most importantly, it does not support sub ledgers for debtors and creditors, and it does not contain postal addresses, contact names, telephone and fax numbers and websites of debtors and creditors.
A default folder for XML audit files can be entered in the settings at Book > Other.
When the default folder is set, the location will be shown as [DEFAULT]\{B-folder name}.xaf.
The actual location will not be visible. It is possible to choose another location.
By using the Custom menu to execute the rule Maatwerk.exe /XML_Audit_Period, an audit file can be created with the option to select a period.
Skip 11-test
During the creation of the audit file, a so-called 11-test will be performed on the VAT number of debtors and creditors.
By checking this option, the 11-test will be skipped.
Use External number 1
If the External code 1 at the general ledger account has been entered, this number will be used instead of the general ledger number.
A warning message is given when an external number is used for several general ledgers, or when an external number is equal to a general ledger number.
Only the first found record is saved in the audit file.
External code/description
If the external code / description at the general ledger account has been entered, this code will be used instead of the general ledger description.
Validations
An audit file will be created even when discrepancies are present. Any notifications are displayed in the screen.
To be able to create a correct audit file, the address in the company data must be entered.
The codes in the countries table used must comply with the ISO 3166-1 standard.
The company data can be entered in the Maintenance menu.
URL of this topic:
https://mill7.nl/M7_EN/index.html?create_xml_auditfile.htm