The Xero bank statement CSV format
Xero's statement import reads a CSV with one row per transaction. Two columns are essential, the rest help matching.
Columns
- Date (required): in your organisation's date order, day first in the UK and Australia (31/01/2024).
- Amount (required): one signed column. Money out is negative, money in is positive.
- Payee: who paid or was paid. Xero uses it for bank rules and matching.
- Description and Reference: free text, shown in reconciliation.
Common import problems
- Spent shows as received: the amount's sign is reversed. Out must be negative.
- Wrong dates: month and day swapped because the file uses another date order than the organisation.
- Two amount columns: statements print money in and money out separately; Xero wants one signed column. The converter merges them.
- Thousands separators or currency signs inside amounts: write 1234.56, not £1,234.56.
Your statements stay on your computer
The PDF is read by code running in this browser tab. Nothing is uploaded: there's no server that could receive it. You can check: load the page, turn off Wi‑Fi, and convert a statement.
We count anonymous events (a file was read, a check passed, a CSV was downloaded) to know what to improve. No file names, amounts or text from your statements are ever sent.