Xero accepts bank statements as OFX or CSV. OFX is the smoother path because there's no column mapping.
The OFX route (recommended)
- Convert your statement and download the OFX export.
- In Xero, open the bank account and choose Manage account → Import a statement.
- Select the OFX file and import. Xero reads the dates, descriptions and signed amounts directly — no mapping screen.
The CSV route
If you prefer CSV, download it instead and use the same import screen. Xero will ask you to map columns; our layout is date, description, amount, balance, so the mapping takes a few seconds. Xero expects a single signed amount column, which is exactly what we produce.
Currency
The export carries the statement's own currency, detected during conversion. Import it into a Xero bank account of the same currency — Xero will refuse a mismatch, which is the correct behaviour.
After the import
Xero's statement balance should equal the statement's printed closing balance — NoRekey verified that before you exported. From there, reconcile as you would with a live bank feed.