Import a QIF bank statement file into Xero

Download a QIF bank statement file from an online banking account, then import it into the matching bank account in Xero. Choose QIF format only if your online banking doesn't offer OFX format.

Download the QIF file from online banking and save it

Download a QIF (Quicken Interchange Format) file containing the bank transactions you want to import into the matching bank account in Xero. If you have multiple bank accounts, download a file for each account separately.

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

Xero recognises duplicate transactions already imported in other QIF files, and excludes them during import.

Save each file with .qif as the file extension. For example, you might name your file Jan13bankstatement.qif.

Import your file into Xero

  1. In the Accounts menu, select 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 QIF file.
  4. Click Import.
  5. Choose the date format, if prompted to.
  6. Click Save.

Choose the date format

If your file contains dates that could be either DD/MM/YY, MM/DD/YY or YY/MM/DD Xero prompts you to confirm the format.

Use the Date Format field to select the correct format. Use Next > to view the next statement line, changing the date format if you need to. Then click Save.

Image showing date format field.