Xero Bank CSV Check
Check your bank CSV before importing into Xero.
Free complete diagnostic. No account, licence or upload. One UTF-8 CSV, up to 5 MB (5,000,000 bytes) and 10,000 data records. Files stay in this tab; nothing is saved automatically.
Choose delimiter before opening a file. Non-UTF-8 exports must be re-exported as UTF-8.
Not checked. Open a file or try the synthetic example.
Inspect the synthetic input
Date,Amount,Description 31/02/2026,12.00,Impossible date 01/02/2026,invalid,Review date order and amount 2026-02-03,0.10,Same payment 2026-02-03,0.10,Same payment 2026-02-04,0.20,Other paymentAmbiguous dates example
Confirm your columns
Your diagnostic
Private report may contain financial data. Share only with an authorised recipient. Print the downloaded HTML as PDF using A4 or Letter.
Review the next step
Review fixes and export with CSV Repair. Review and complete export are a separate offer, subject to the current plan. Your free diagnostic stays available here.
Scope and limitations
| Supported | UTF-8 / BOM; comma, semicolon or tab; quoted multiline fields; column mapping; calendar dates; amounts; candidate duplicates; exact totals. |
|---|---|
| Not checked | Xero account state, saved mapping, currency, exchange rates or import acceptance. No PDF, XLSX, OFX, bank connection, Xero API or accounting advice. |
No records are removed or corrected. Identical transactions may be legitimate. Totals include only records with valid dates, amounts and column widths. Units are shown without assuming a currency.
Independent tool, not affiliated with Xero. Rules version 1.0.0. No import approval or certification.
Official sources: Import a CSV bank statement; Resolve import errors; Change import mapping.