Skip to content
fileshape

Import layout

Xero bank statement import CSV columns

Xero manual bank statement CSV.

The Xero bank statement import layout has 5 columns; the required columns are Date, Amount.

Xero imports bank statements from CSV through the bank account's Import a statement option. Only Date and Amount are required, but Payee, Description and Reference are what Xero's reconciliation suggestions and bank rules work on, so filling them makes reconciling much faster.

After uploading, Xero shows a column assignment step where you match each CSV column to a statement field, and it remembers your choices for next time. Imported lines appear on the reconcile tab, and a whole imported statement can be deleted if it was wrong, which makes it reasonably safe to try a small file first.

Import rules to know

  • Amount is signed: negative for spend, positive for money received.
  • The date format must match the organisation's regional setting (DD/MM/YYYY for India, UK and Australia).
  • Import each date range once to avoid duplicate statement lines.

Columns

ColumnRequiredExampleNotes
DateYes
AmountYes
Payee
Description
Reference

Guides