What CSV columns does Xero require?

Xero requires Date, Amount, Payee, Description, and Reference columns in CSV. Our converter automatically maps bank statement fields to this format.

Can I use this for bank reconciliation in Xero?

Yes. After importing the CSV, Xero will match transactions against your existing invoices and bills for reconciliation.

Does this work with any bank?

Yes. We support 500+ bank statement formats worldwide. As long as you have the PDF, we can convert it to Xero's import format.

What if the dates are in a different format?

Our converter normalizes dates to the format Xero expects (DD/MM/YYYY or MM/DD/YYYY based on your Xero region settings). No manual reformatting needed.

Convert Bank Statements for Xero Import

Upload your bank statement PDF and download a CSV file that imports directly into Xero for bank reconciliation. Skip the manual data entry.

How to Import into Xero

1

Upload Your Bank Statement PDF

Upload the PDF from your bank. We support digital PDFs from 500+ banks and scanned statements with OCR.

2

Review Extracted Transactions

Preview the parsed transactions — dates, payees, amounts, and references — before downloading.

3

Download Xero CSV

Export as CSV in Xero-compatible format. In Xero, go to Accounting > Bank Accounts > Import a Statement and upload the file.

Xero CSV Format Details

Our converter maps fields to Xero's required CSV format: Date, Amount, Payee, Description, and Reference. Ready for Xero's bank statement import.

What you get:

Clean, deduplicated transaction rows
Properly formatted dates for Xero
Amount columns mapped to Xero's expected layout
Ready to upload — no column rearranging needed

Xero Import FAQ

Need a Different Format?

Our converter also exports to Excel and JSON. Visit the homepage to convert for any accounting software or workflow.

Go to Bank Statement Converter