Import notes
- Map *Date and *Amount first.
- Map optional source fields only when needed.
- Review warnings and duplicates in Xero.
Convert Bank Statement to Xero CSV
Convert a bank statement into a mapping-ready Xero CSV. Review the transactions and warnings before downloading the file for manual bank import.
Choose the source statement
Accepted: CSV, TSV, delimited TXT and selectable-text PDF Beta. Scanned or image-only PDF is Coming Soon.
Auto priority: Transaction, Posting, Value, Settlement, then legacy Date.
An unresolved automatic result blocks Xero downloads.
Conversion result
Source data accounting
Only included posted transactions enter Xero CSV files. Every excluded source row remains in the audit.
Export
Xero may save your field mapping for future files with the same headers. Import each account separately and review Xero’s own warnings and duplicate checks.
Some non-Roman characters might not be fully supported by Xero. Bank File Flow preserves Unicode text and does not silently remove international characters.
Before you import
Upload the CSV to the intended Xero bank account, map the required fields and confirm the selected date format.
Limitations
- No Xero API connection or bookkeeping.
- Optional values stay blank unless present.
- Scanned PDFs are not supported.
Xero CSV questions
What CSV format does this tool prepare for Xero?
The file includes *Date, *Amount, Payee, Description, Reference and Check Number columns for mapping during Xero’s manual bank import.
Can I review transactions before downloading the Xero CSV?
Yes. Review the detected transactions, warnings and available reconciliation before export.
Are scanned bank statement PDFs supported?
No. Selectable-text PDF input is Beta, but scanned or image-only PDFs are not supported.
Is this an official Xero integration?
No. This is an independent file-conversion tool. Xero does not certify or endorse it, and import behavior can vary by Xero region or plan.