ledgaroo

Importing the file

Every format is written from the same checked transactions, so the only question is which one your software asks for. These are the steps for each.

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.

Its 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, because a statement does not separate them.

QuickBooks

Download the QBO

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

QuickBooks reads the currency recorded in the file and refuses one that disagrees with the account, so check the currency shown on the QBO button before downloading.

Exact, AFAS, Twinfield and other Dutch and German software

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.

MT940 names the account it is for, so the file is only offered where the statement prints an account number the parser can verify, and where it printed an opening balance for the file to state. Where it does not, the button says which of the two 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.

Quicken takes the QIF the same way, through File then Import. OFX records the currency and the date range and QIF records neither, so pick OFX where the software takes it.

A spreadsheet

Download the Excel file

Open it and the dates are dates and the amounts are numbers, with nothing to import and nothing to configure. Prefer the Excel file to the CSV wherever you have the choice: a CSV is read by guessing, and an Excel outside the English-speaking world separates columns with a semicolon and decimals with a comma, which turns 1,850.00 into something else entirely.

Plain CSV is there for software that asks for one, with Date, Description, Amount and Balance as its columns and one signed amount a row. If your software wants a shape none of these match, the CSV is the one to edit.