Reading Time: 2 minutes, 4 secs

Manually import a bank statement into Xero

Short Answer

Get the formatting of your spreadsheet right, then click Accounts > Bank Accounts > Manage > Import Bank Statement

There are a lot of options available when manually importing a bank statement into Xero. We recommend that where possibly you use a QIF (Quicken) file as this type of file doesn’t require any amendments before Xero takes it.

CSV Files are really flexible and nearly all banks allow you to export data as a CSV. However, they do need to be formatted in a particular way for Xero to understand them.

For Xero to accept the import it will need:

  • An Amount column – This should show a positive amount when money is paid in and a negative amount when paid out. Banks often don’t include this column in their CSV reports, instead they have separate Paid In and Paid Out columns (both with positive numbers). If that’s the case just add a new column.
  • A date – All bank statements need dates for each transaction.
  • No blank lines – Xero doesn’t like blank lines. Similarly empty description fields tend to break the import.

You can edit CSV files using Microsoft Excel.
You can read more about importing bank statements here.

Once you’ve made sure the CSV file is all setup for Xero.

  1. Click Accounts > Bank Accounts
  2. Find the Account you are going to import the Statement for
  3. Click Manage Account > Import a Statement
  4. Click Browse and find your file
  5. Click Import
  6. Now tell Xero what each column of your spreadsheet contains. At minimum you are going to need a Date, a Description and an Amount. Note the box at the bottom right will show you how this will appear in the Xero reconciliation.
  7. Click Save.

Now check that the statement balance showing from the Accounts > Bank Accounts screen matches the actual bank statement.


Watch the video

QIF files all fit a very standard format so if you export one of these from your online banking you don’t have to worry about manipulating it into a format that Xero accepts. Just follow the steps below:

  1. Click Accounts > Bank Accounts
  2. Find the Account you are going to import the Statement for
  3. Click Manage Account > Import a Statement
  4. Click Browse and find your file
  5. Click Import

Now check that the statement balance showing from the Accounts > Bank Accounts screen matches the actual bank statement.