Export the Xero Account Transactions report straight into Google Sheets: every transaction line with its date, account, source, reference and amounts. Filter it the way you need, convert currencies, and refresh it automatically.










All optional. Tick any combination. See every setting with examples
To show the report in a currency other than your Xero base currency, pick a target currency, for example EUR, and choose how rates are applied:
The report appears in your sheet with every transaction line: date, account, source, description, reference, debit, credit, gross, net and tax.

Change the date range, filters or settings without rebuilding the report. You don't need to be signed in to Xero to edit or refresh a template.

Browse the Xero guides, or ask our support team.