CSV → Xero bank statement (English CSV)
Prepare a five-column bank-statement CSV for Xero’s English-language import workflow, then import the download yourself.
Purpose
Upload the original bank CSV, inspect canonical or mapped fields, choose an existing booking or value date, and verify the source and destination account currencies match. The server validates the original bytes before exporting the five Xero columns.
Workflow fit
For an eligible single-account, single-currency CSV bank statement that needs a five-column format for Xero’s English-language bank-statement import.
Implementation note
English-language Xero bank-statement profile only. Up to 50,000 movements subject to channel limits. Output contains no currency; no exchange-rate conversion, invented Payee/Reference, automatic Xero import, reconciliation or external acceptance verification. Check the receiving account and duplicates before import.
Xero bank statement EN · Date,Amount,Payee,Description,Reference
Exactly Date,Amount,Payee,Description,Reference, in that order. The date uses yyyy/MM/dd and must originate from the BOOKING or VALUE field you genuinely inspected.
ValidConvert cannot invent a beneficiary or reference. Fields not evidenced by your source must remain empty where the Java writer permits it; do not add fictional information to force an import.
No. Review one real source account and one currency per file. Enter both ISO 4217 currencies explicitly; they must match. The exported CSV does not encode a currency or convert amounts.
No. The file must be uploaded to the appropriate account in Xero by you. The import is not independently verified for your Xero region, account configuration or software version; check the result and duplicates yourself.
The profile supports at most 50,000 movements, subject to web trial limits of 10,000 and the input-file size limit of 10,000,000 bytes. Paid conversion uses at least one prepaid credit per started 10,000,000 bytes, up to the paid-channel limits.
Related converters
Explore other production-ready routes connected to this format.