◈ StatementCheck / bank file clinic
100% in your browser
Free Xero CSV converter

Your bank export has quirks.
Find them before your accounting import.

Map messy bank CSV columns, normalize transaction signs and dates, and download an import-ready file with an explanation of every warning and rejected row. Your statements never leave your device.

01 Open your bank CSV
02 Review columns and sign rules
03 Inspect warnings and export

Import settings Free

No account • No bank credentials • Files processed locally
Choose a bank-exported CSV file
UTF-8 or Windows-1252 CSV • up to 5 MB

Map your columns

For signed amounts, map Amount. For separate expense/income columns, map Debit and Credit instead.
Need multiple statements every month?
The offline batch edition adds multi-file processing and portable mapping recipes. No cloud account or recurring bill. Purchase link will appear when the store opens.

Validation report

Nothing is silently discarded. Check transaction totals against your statement before importing into Xero.

Choose a CSV file to begin. You can also load a synthetic example below.
0Input rows
0Exportable
0Errors

Net amount: —

DateAmountPayeeReference
No transactions loaded

Findings 0

Source / rowSeverityFinding
No validation performed
Before importing: This is a format converter, not bank/accounting verification. Check direction of payments, statement balances, potential duplicates already in Xero, and your locale. Your accounting system performs the final import validation. Do not use this tool with PDF statements.

Having trouble with Xero CSV imports? Read our practical guide to date formats, amounts, signs and common errors →

What does the converter change?

Converts source dates to YYYY/MM/DD (a documented Xero import format), normalizes amounts to signed two-decimal numbers, merges debit/credit columns when necessary, and maps optional payee, description and reference. It flags invalid dates, ambiguous amounts, malformed CSV and repeated records. Repeated records remain in the preview—review them before importing. The tool never contacts Xero or your bank.

Supported target fields are Date, Amount, Payee, Description, Reference. Read Xero's official bank CSV instructions.

This tool is independent from and not endorsed by Xero. It does not constitute accounting advice. Avoid opening an untrusted exported CSV in a spreadsheet without reviewing formula warnings.