Import a bank statement

Import a statement

1. Select Accounting > Bank accounts and open the account.
2. Select Import statement.
3. Click to browse, or drag and drop your file. Accepted formats are CSV, OFX, QFX and QIF.
4. Check the preview. It lists the lines that will be added and marks duplicates, which are skipped.
5. Confirm the import. The new lines appear under Reconcile, ready to match.

CSV format

The first row must be column headers. Download the sample file from the import page if you need a template.

OFX, QFX and QIF files are the formats most banks offer for download and need no column set-up at all.

Preparing a CSV in a spreadsheet

1. Download the sample file from the import page and open it in Excel or Google Sheets.
2. Paste your bank’s rows under the sample headings, or rename your own headings to match date, description, amount and so on.
3. Check that every row has a date and an amount, and delete bank summary lines or blank rows.
4. Save as CSV (comma separated) and upload it.

Tips

• If your bank offers OFX, QFX or QIF, use those. They need no column set-up or preparation.
• Import in date order and avoid gaps; a missing week is a common reason balances do not agree.
• Download statements for the same period for every account and import them together.
• A reference or payee column, when your bank provides one, makes bank rules and matching more accurate.

After you import

Go straight to the reconcile screen. Select Reconcile with rules for lines with one exact match, then work through the rest. See Reconcile bank transactions. If anything looks wrong you can remove the statement. See View and delete bank statements.

Frequently asked questions