How to Export Bank Transactions from Xero
Xero exports bank transactions as a CSV file containing transaction dates, payees, amounts, reconciliation status, and account codes. The export includes columns for tax rates, tracking categories, and reference numbers that often need cleaning before analysis.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountOr start with
See it on a sample file
What DataMimi shows for a Xero bank statement
658 rows, Jul 2025 – Aug 2026. Computed by DataMimi from a sample export with the same columns as yours — the data is invented, the figures are exactly what the app produces from it.
What this export contains
| Date |
| Amount |
| Payee |
| Description |
| Reference |
| Reconciled |
| Account Code |
| Account Name |
| Tax Type |
| Tax Amount |
| Tracking Category 1 |
| Tracking Category 2 |
| Contact |
Common questions
How do I export bank transactions from Xero?
In Xero, go to Accounting > Bank Accounts, click the account name, then click the Export button above the transaction list. Choose CSV format and select your date range. Xero downloads a file named with the account name and date range.
What does the asterisk in the Reconciled column mean?
An asterisk (*) means the transaction has been reconciled in Xero. A blank cell means it has not been reconciled. You need to convert these to text like 'Yes' and 'No' before filtering or counting reconciliation status in most spreadsheet tools.
Why are tracking categories showing as column headers?
Xero creates a separate column for each tracking category you have enabled, using the category name as the column header. If you have tracking categories named 'Department' and 'Project', those exact words appear as column headers in your export.
How do I get separate debit and credit columns from Xero bank export?
The Amount column uses negative numbers for money out and positive for money in. Create two new columns: one with a formula that shows the amount only if it is positive, another that shows the absolute value only if the amount is negative.
Can I export bank transactions from multiple accounts at once in Xero?
No, Xero exports one bank account at a time. You must export each account separately and then combine the CSV files if you need a consolidated view of transactions across accounts.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file