Xero CSV import validator
Check a bank statement CSV before importing into Xero. Built for UK, Australia and New Zealand workflows.
Free · No account · Downloadable report
Your bank statement CSV
Local processing. File contents stay in this tab. No upload or browser storage.
Check report
Load the example to see a report before using your own file.
What this check covers
Checks Date and Amount columns, real calendar dates, signed decimal amounts, row widths and repeated rows. This is a bank statement check, not a sales invoice or contacts importer. Mapping, currency, account state and acceptance still need review in Xero.
Use comma, semicolon or tab delimiters. Date: DD/MM/YYYY or YYYY-MM-DD. Amount: a signed number with a decimal point, without currency symbols or thousands separators. Other layouts may be accepted by Xero after mapping; this tool flags them for review.
Independent tool, not affiliated with or endorsed by Xero.
Reference: Xero: CSV bank statement imports
Need to repair the CSV?
Preview the browser repair workflow and sample export before buying. £99 for 12 months per office, up to 3 users.
Preview deliverables and termsCSV Repair Office · £99 / 12 months — review purchase