ledgaroo

Importing a statement

Every format holds the same checked transactions. Download the one your software imports, then follow its steps below.

Excel, Numbers or Sheets

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.

What is in the file: Excel.

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. Payee holds the name cut out of the bank's description, or the one your rule sets, and Description holds the description whole.

What is in the file: Xero CSV.

QuickBooks

Download the QBO or QuickBooks CSV

  1. In QuickBooks Online, go to All apps, then Accounting, then Bank transactions.
  2. Open the Link account menu, choose Upload from file and select the file.
  3. For the QuickBooks CSV, match its Date, Description and Amount columns to the ones QuickBooks names, and say the dates are dd/mm/yyyy.

The QBO carries the currency shown on its button, so check it is the account’s before you download. The CSV carries no currency and takes at most 1,000 transactions, so the QBO is the one to prefer.

What is in the file: QBO and QuickBooks CSV.

MYOB

Download the OFX

  1. In MYOB, go to the Banking menu and choose Banking hub.
  2. On the account, click the three dots, choose Import statement and pick the file.

In AccountRight on the desktop, go to Banking, then Reconcile Accounts, then Get Statement. The file has to be under 10MB. MYOB takes a QIF too, with its dates day first, but an OFX writes every date year first, so it cannot be misread, and it carries an id for each transaction and the currency, which a QIF cannot.

What is in the file: OFX.

Reckon

Download the Reckon QIF

  1. In Reckon One, go to the Banking menu and choose Bank accounts.
  2. Next to the account, click More, then Upload transactions file.
  3. Choose the bank account, click Select File, pick the file and click Import the file.

In Reckon Accounts Personal, choose File, then Import, then QIF Files, browse to the file and choose the account. Reckon Accounts reads a QIF’s dates only day first, as dd/mm/yyyy, which is how the Reckon QIF writes them. In Reckon One, an upload overwrites any imported bank transactions not yet allocated, so allocate those first.

What is in the file: QIF.

Quicken

Download the QIF

  1. In Quicken for Windows, set up the account first if you have not: a QIF goes into an account that already exists.
  2. Choose File, then File Import, then QIF File.
  3. In the QIF Import window, choose the account under Quicken account to import into, browse to the file, and choose Import.

Quicken for Mac reads a QIF only when you start a new data file, not into an account you already have. A QIF gives no transaction an id, so Quicken cannot tell one it already holds: import each statement once.

What is in the file: QIF.

Twinfield

Download the Twinfield CSV

  1. In Twinfield, add the bank account under the IBAN the statement prints, if it is not there already.
  2. Open the file manager (Bestandsbeheer), choose Uploaden, pick the file and choose Uploaden again.
  3. From the action menu at the start of the file’s row, choose Importeren.
  4. The first time only, choose Nieuw to make a template. Name it, leave the separator on Komma and the text indicator on double quotes, set Kopregel to 1 and Eerste dataregel to 2, and give each column the Waarde its heading names. When every Test is green, choose Opslaan.
  5. Choose the template, keep Via elektronische bankafschriften, and choose Verwerken. The statement waits under Kas & Banken, Bankafschriften.

Twinfield keeps the template for your whole environment and offers it for any file with the same six columns, so every statement after the first is the upload, Importeren and Verwerken. The headings are the Dutch names of the fields Twinfield’s template offers. This is the layout Twinfield’s help shows passing its template test: import one statement and check it before you rely on it.

What is in the file: Twinfield CSV.

Software that reads MT940

Download the MT940

  1. Set up the bank account in your accounting software, under the IBAN the statement prints, if it is not there already.
  2. Find its screen for importing bank statements, choose MT940 if it asks for a format, and pick the file.

Packages differ in which MT940 files they read. Some take only the files of banks they know, as Moneybird reads only Dutch banks’ own. Ours names no bank, so import one statement and check it before you rely on it. An MT940 names its account and states its opening balance, so we can only write one when the statement prints an IBAN and its opening balance is known.

What is in the file: MT940.

Sage Accounting

Download the Sage CSV

  1. In Sage Accounting, open Banking and find the bank account.
  2. Choose Actions, then Import statement, pick the file and choose Review transactions.
  3. Say the dates in the file are DD/MM/YYYY, then choose Continue.
  4. Review the transactions and choose Confirm import.

The columns are the ones Sage asks for: Date, Description and Amount, with money out negative, then the payee under Payee name. Sage does not import into a foreign currency bank account, and it needs a description on every row.

What is in the file: Sage CSV.

FreeAgent

Download the FreeAgent CSV

  1. In FreeAgent, open Banking, then Bank Accounts, and choose the account.
  2. Choose Upload Statement, then Select a file, and pick the file.
  3. Choose Upload Statement.

FreeAgent wants no header row and no commas or quote marks, so the file has none: a comma or quote mark in a description is written as a space. Uploading a CSV needs access level 6 or above in FreeAgent.

What is in the file: FreeAgent CSV.

Wave

Download the Wave CSV

  1. In Wave, open Accounting, then Transactions.
  2. Choose More, then Upload transactions. Pick the file and the payment account, and choose Upload.
  3. Confirm the date, amount and description columns Wave picks, then choose Upload my statement.

The file names no currency, so Wave records the transactions in the payment account’s. From a credit card statement, purchases are written positive and payments negative, the way round Wave asks for on a card.

What is in the file: Wave CSV.

Other software

Download the CSV in a layout of your own

  1. Find the page in your software's help that says what its statement import wants: the columns, the date format, and whether money out is negative or in a column of its own.
  2. Under Download, on the Other software row, choose New layout.
  3. Set the columns and their order, the dates, one amount column or money in and money out, the separator and the decimal mark, and whether the first line names the columns. The start of the file shows beneath as you go.
  4. Name the layout for the software and save it. It gets a button of its own, in this browser, for every statement after.

A layout of your own comes with Premium. It is kept in your browser and nowhere else, so set it up again on another computer.