Xero Bank Statement CSV Cleaner

What it does

Upload a bank statement export. Get back a CSV ready to import into Xero via Bank Accounts > Import a Statement — with dates formatted correctly for your region and encoding confirmed as UTF-8 (Xero silently rejects non-UTF-8 files).

The regional date problem

Xero is popular across the UK, Australia, New Zealand, and the US — and each region uses different date formats. Xero expects DD/MM/YYYY for UK and ANZ users and will silently misparse US-format dates, booking January 3 as March 1. This tool:

1. Detects your source date format automatically from the data
2. Flags ambiguous dates where it can't tell DD/MM from MM/DD (e.g. if all day values happen to be ≤ 12) and asks you to confirm
3. Reformats to DD/MM/YYYY (or to YYYY-MM-DD, which Xero also accepts)

No more misposted transactions because you forgot to reformat a US bank export before importing into a Xero UK account.

What it handles automatically

• Date format detection and conversion — Detects MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD, and variants; reformats to Xero's preferred DD/MM/YYYY
• Currency cleaning — Strips symbols, commas, and parenthetical negatives
• Encoding conversion — Fixes Windows-1252/ANSI exports (common from older banking portals) to UTF-8
• Column mapping — Auto-maps Date, Amount, Payee, Description, Reference, ChequeNumber even when your bank uses different names
• Signed Amount convention — Converts separate Debit/Credit columns to Xero's single signed Amount column if needed

How it works

1. Upload your bank export (CSV, XLSX, or TSV)
2. Confirm the date format if the tool flags it as ambiguous
3. Review the column mapping
4. Preview 5 rows to verify the output (free)
5. Export the cleaned file — one-time $7

Xero import instructions

After downloading your cleaned CSV:

1. In Xero, go to Accounting → Bank Accounts
2. Select your bank account → click Import a Statement
3. Upload the cleaned CSV
4. Xero auto-maps columns from the header row
5. Review and confirm the import

Minimum requirements

Xero requires at minimum two columns: Date and Amount. All other columns are optional but highly recommended for reconciliation:

• Payee: Helps Xero create automatic reconciliation rules
• Description: The bank's narrative for the transaction
• Reference: Bank reference number or cheque number

FAQ

My dates look like "15 Jan 2024" — will the tool handle that? Yes. The date detector recognises named-month formats (15 Jan 2024, January 15 2024) and converts them correctly.

Xero says "UTF-8 encoding required" — does this tool fix that? Yes. The most common cause of this error is a Windows-1252 (ANSI) encoded file exported from older banking software. The tool detects the encoding and converts to UTF-8 before export.

I'm in the US using Xero — should I use DD/MM/YYYY? If your Xero organisation is set to US region, Xero expects MM/DD/YYYY. Use the format toggle in the mapping step to select your Xero region's date format.

Does it store my data? No. All processing happens in your browser. Your financial data never touches a server.