Xero Export Bank Statement to Excel
Xero exports bank statements with reconciliation markers, split transaction rows, and currency columns that need cleaning before analysis. This page shows you how to work with the Date, Amount, Payee, Description, Reference, and Reconciled Status columns that Xero's bank export creates.
Upload your Xero bank export and get back a spreadsheet where split transactions sum correctly, reconciliation status works in formulas, and multi-currency amounts convert automatically.
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 Status |
| Transaction ID |
| Source |
| Spend Money Account |
| Receive Money Account |
| Tax Amount |
| Currency |
| Exchange Rate |
Common questions
How do I remove duplicate rows from split transactions in Xero bank exports?
Use the Transaction ID column to identify duplicates. Either filter to show only the first occurrence of each Transaction ID, or create a helper column with COUNTIF to mark rows where the Transaction ID appears earlier in the sheet, then filter those out.
How do I convert Xero's Reconciled Status text to TRUE/FALSE in Excel?
Create a new column with the formula =A2="Reconciled" where A2 is your Reconciled Status cell. This returns TRUE for reconciled transactions and FALSE otherwise, which you can then use in COUNTIF, SUMIF, and filter functions.
How do I sum Xero bank transactions in multiple currencies?
Multiply each Amount by its Exchange Rate to convert to your base currency, or filter the Currency column to analyze one currency at a time. Summing the raw Amount column when multiple currencies exist gives you a number with no real meaning.
Why are dates from my Xero bank export not sorting correctly in Excel?
Excel is reading the Date column as text because Xero's date format does not match your system settings. Select the column, use Data > Text to Columns, choose Delimited, click Next twice, set Column data format to Date with the correct order (DMY or MDY), then Finish.
Which column should I use for vendor names, Payee or Description?
Check both columns in your specific export. Payee usually contains the cleaner vendor name, while Description often includes invoice numbers or payment details. If both have useful information, concatenate them with a formula like =A2&" - "&B2, but inspect a sample first to avoid redundancy.
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