Xero bank statement CSV import: columns, rules and steps
Updated November 20, 2026 · Ruslan Vorobev, founder of Statement to Excel
Xero imports bank statements as CSV, OFX, QFX, QBO or QIF files. If your bank offers an OFX or QFX download, Xero recommends using it. When you only have the PDF, or the bank's CSV has columns Xero doesn't want, you prepare a CSV in Xero's format and import it.
For organisations in the US and Canada, Xero can also read some PDF statements directly from the same Import a Statement screen, though not on every plan and not when one PDF holds several accounts. Check Xero Central for your plan. A CSV is still the way to go for those cases, for scans that don't read cleanly, and when you want each statement checked against its balances before it reaches Xero.
The columns Xero expects
| Column | Required | What goes in it |
|---|---|---|
| Date | Yes | The transaction date, in one supported format |
| Amount | Yes | Income as positive, spending as negative, both in this one column |
| Payee | No | Who paid or was paid. If it matches an existing contact, Xero links it |
| Description | No | Text shown as the transaction's description |
| Reference | No | Your reference for the transaction |
| Cheque number | No | The check number, if there is one |
If your bank provides them, you can add two more columns: Analysis code and Transaction type.
Rules that make the import work
- Delete opening and closing balance columns. Xero calculates the balance from the transactions.
- Delete the bank account number and any empty rows.
- Put income and spending in the single Amount column, with spending as negative numbers.
- Use one date format for every row. Xero accepts DD/MM/YYYY, MM/DD/YYYY and YYYY/MM/DD among others, and asks which one you used when dates are ambiguous.
- A file can have up to 100,000 rows.
- To import, you need the administrator role, or the standard role with bank accounts access.
| *Date | *Amount | Payee | Description | Reference |
|---|---|---|---|---|
| 01/02/2026 | -282.80 | VERIZON WIRELESS | VERIZON WIRELESS | |
| 01/14/2026 | -3024.66 | CHECK #1960 | CHECK #1960 | 1960 |
Import the file into Xero
- In the Accounting menu, select Bank accounts.
- For the account you want, click the menu icon (three dots) and select Import a Statement.
- Drop the file into File to upload (or click Select file), then click Next.
- The first time, assign each column to a Xero field (Transaction Date, Transaction Amount and any optional fields), then click Next.
- If Xero asks, select the date format your file uses and click Next.
- Review the transactions, clear any you don't want to import, and click Complete import.
The statement lines then wait on the Reconcile tab, where you match them or create transactions.
From a PDF statement to a Xero CSV
Statement to Excel exports Xero CSV straight from a PDF statement: *Date and *Amount, plus Payee, Description and Reference, with check numbers placed in Reference, plain numbers without $ signs or commas, and no balance column. Before you download, it checks the opening balance plus all transactions against the closing balance, so a missed row doesn't end up in Xero. For doing the check yourself, see how to check a converted statement.
Have a PDF statement to convert?
Excel, QuickBooks or Xero CSV in about 30 seconds, checked against the statement's balances. The first 10 pages are free, no signup.
Convert a statement