Export transactions in bulk, down to the journal line

When you need to investigate a balance, reconcile a report or prepare an audit extract, account totals are only the starting point. You need the individual entries behind them.

xpnAi supports bulk transaction exports with journal-line level detail, giving you the underlying general ledger data to work with in a spreadsheet or another analysis tool.

Get the detail behind the totals

General ledger exports can include account information, net, tax and gross amounts, and the tax type recorded on each journal line. Journal identifiers and line numbers help you trace the entries; Xero journal-line identifiers are also included where available.

Choose the organisations, period and fields you need. Use the extract to investigate movements, test transactions or reconcile the figures in your management reports.

Choose a format that fits the work

Export as CSV, compressed CSV or Parquet. Plain CSV opens directly in a spreadsheet; compressed CSV reduces the download size, while Parquet suits tools that support it.

Each file supports up to 100,000 rows. Larger results can span multiple files, so ask your agent to retrieve every part and check the total row count before treating the export as complete.

Try it with your agent

Export the general ledger for [organisation] for October 2026
at journal-line level as compressed CSV. Include account details,
journal identifiers, line numbers, and net, tax and gross amounts.

Confirm the currency and last successful sync time. Retrieve
every file needed for the complete extract, check the exported
row count against the matching total, and flag unavailable fields.

Read the transaction export guide for file handling and download details. If you also need the supporting invoices and receipts, use bulk attachment downloads alongside your transaction extract.