Import an OFX, QBO or QFX bank statement file into Xero

Download an OFX, QBO or QFX bank statement file from an online banking account, then import it into the matching bank account in Xero. Choose OFX, QBO or QFX format if your online banking offers it, before QIF or CSV format.

Download a monthly file from online banking and save it

Download a monthly OFX, QBO or QFX file containing the bank transactions you want to import into the matching bank account in Xero. If you have multiple bank accounts, download a monthly file for each account separately.

You'll need to split up the file if it contains more than 1,000 bank transactions.

Xero recognizes duplicate transactions already imported in other OFX, QBO or QFX files, and excludes them during import.

Save your file with .ofx, .qbo or .qfx as the file extension. For example, you might name your file Jan13bankstatement.ofx.

Import your file into Xero

  1. Go to Accounts, then Bank Accounts.
  2. Find the bank account you want to import your file into. Click Manage Account, then click Import a Statement.
  3. Click Browse and select your saved file.
  4. Click Import.
  5. Click Save.