Skip navigation

Open an audit file as a trial balance worksheet

Open an audit file (XAF) from an accounting package and instantly see the trial balance worksheet: trial balance, list of balances, profit and loss and balance sheet per account. With a check on whether the file balances, and a download for Excel.

  • Free
  • Trial balance worksheet and trial balance
  • CSV for Excel
  • File stays in your browser

Open an audit file (XAF)

From audit file to trial balance worksheet

An audit file contains all entries of a year, but cannot be read without software. If you receive a file from a client or a previous bookkeeper, you first want to know what is in it: which accounts, which balances, and whether it adds up.

For each account, the viewer adds up the opening balance and all entries and puts the balance in the profit and loss or balance sheet columns, following the classification that the package itself provides in the file. That way you see the figures and the result in one table.

What you see

  • Company, financial year, accounting package and number of entry lines
  • The trial balance worksheet per general ledger account, with totals
  • Profit or loss for the financial year
  • The number of lines and the totals per journal
  • Four checks: does the file balance, and is it complete?

The audit file never leaves your browser

An audit file contains the complete administration of a company. The viewer therefore reads the file only in your own browser. Nothing is sent to a server, nothing is stored and nothing ends up in the URL.

Questions about audit files and the trial balance worksheet

What is an audit file?

An audit file is an export of an entire financial administration in one fixed format: the general ledger scheme, the opening balance and all entries of a financial year. The full name is XML Auditfile Financieel, abbreviated XAF. The format is meant for handing an administration over to an accountant or the Dutch Tax Administration, independently of the accounting package.

How do I open an XAF file?

Drag the .xaf file into the viewer at the top of this page, or click to choose it. You will see the trial balance worksheet per account, the journals and whether the file balances. In a text editor or browser you only see the XML itself.

What is a trial balance worksheet?

An overview of all general ledger accounts in four pairs of columns: the trial balance (all debit and credit entries), the list of balances (the balance per account), the profit and loss account and the balance sheet. The difference in the profit and loss columns is the result, and it returns as a difference in the balance sheet columns.

What is the difference between a trial balance and a list of balances?

The trial balance shows the total debit and the total credit per account. The list of balances shows only the difference: the balance, on the debit or the credit side. For both, the totals on the left and right must be equal.

How do I create an audit file in my accounting package?

Almost every Dutch accounting package has an export called XML Auditfile Financieel or audit file, usually under reports or under import and export. You choose the financial year and get a .xaf or .xml file.

Which versions of the audit file does the viewer read?

XAF 3.1, 3.2, 3.2.1 and 4.0, the versions that accounting packages currently export. The viewer does not read the old text format with the .adf extension.

Is my audit file sent anywhere?

No. The file is read in your own browser and is not sent to Agentancy or anyone else, not put in the URL and not stored. Refresh the page and it is gone.

What does the viewer check?

Whether debit and credit of all entries are equal, whether the opening balance is in balance, whether the totals that the package states in the file match the lines, and whether every entry is on an account from the general ledger. It is not a full validation against the specification of the format.

Have the entries in that file created automatically?

Agentancy reads invoices and receipts, chooses the general ledger account and VAT code per line from your own administration and posts in your accounting package. Try it free for 30 days.

We connect your first administration together in a 20-minute call.