Importing the file

Xero

Download the Xero CSV

1. In Xero, open Accounting, then Bank accounts.
2. On the account, choose Manage account, then Import a statement.
3. Upload the file.

The header row is the one Xero asks for: Date, Amount, Payee, Description, Reference, with dates written 2026-01-23. The bank's description fills both Payee and Description.

QuickBooks

Download the QBO

1. In QuickBooks, open Transactions, then Bank transactions.
2. Choose Upload from file and select the .qbo file.

QuickBooks refuses a file whose currency does not match the account, so check the currency shown on the QBO button before you download.

Exact, AFAS, Twinfield and other Dutch and German packages

Download the MT940

1. Download the MT940.
2. In your accounting package, find the bank import or electronic statement screen.
3. Choose MT940 as the format and pick the file.

An MT940 names its account and states its opening balance, so we can only write one when the statement prints both. If it does not, the button says which one is missing.

MYOB and Quicken

Download the OFX or QIF

1. In MYOB, open Banking, then Bank transactions.
2. Choose Import statement and pick the file.

In Quicken, use File, then Import, for the QIF. OFX records the currency and the date range and QIF does not, so pick OFX where your software takes it.

A spreadsheet

Download the Excel file

Open it and the dates are dates and the amounts are numbers. There is nothing to import and nothing to set up. Prefer Excel over CSV where you can. Outside the English-speaking world, Excel reads a CSV with semicolons and comma decimals, which turns 1,850.00 into something else.

Plain CSV is for software that asks for one. Its columns are Date, Description, Amount and Balance, with one signed amount a row. If your software wants a different shape, the CSV is the one to edit.