How to Import a QBO File into QuickBooks (Online and Desktop)

Before you import: check your QBO file

A QBO file is valid XML. Before importing, confirm two things: the file opens without errors in a text editor (it should start with OFXHEADER:100 or an XML declaration), and the date range in the file does not overlap significantly with transactions already in your QuickBooks register.

Overlap is fine in small amounts. QuickBooks uses the unique transaction ID (FITID) in each QBO file to detect and skip duplicates. But if you import a file generated from the same source twice, the FITIDs will differ and QuickBooks will import duplicates. Always import from the last transaction date already in your register.

If you need to create a QBO file from a PDF bank statement first, see our guide to converting bank statement PDFs to QBO.

How to import a QBO file into QuickBooks Online

1. Go to Bookkeeping (or Accounting), then Transactions.
2. Click the Banking tab.
3. Click the dropdown arrow next to Update in the top right and select Upload from file.
4. Click Browse and select your QBO file.
5. Select the QuickBooks account to link the import to from the dropdown.
6. Click Next. QuickBooks reads the QBO file and displays the transactions found.
7. Click Next again to confirm.
8. The transactions appear in the For Review tab. Review, match, and add them to your books.

QuickBooks Online skips the column-mapping step for QBO files because the format is structured. There is nothing to map. The import is faster and cleaner than CSV.

How to import a QBO file into QuickBooks Desktop

1. Open QuickBooks Desktop and go to Banking in the top menu.
2. Select Import Web Connect File.
3. Browse to your QBO file and click Open.
4. QuickBooks will ask: use an existing QuickBooks account or create a new one.
5. Select Use an existing QuickBooks account and choose the correct account from the list.
6. Click Continue.
7. Transactions are added to the register. A confirmation dialog shows how many transactions were imported and how many were skipped as duplicates.

QuickBooks Desktop does not have a review queue like QuickBooks Online. Imported transactions go directly to the register. Check the register after import to confirm the transactions look correct.

Common QBO import errors and fixes

Error: file not recognized or invalid file format

This usually means the QBO file is malformed XML. Open it in a text editor and check for any obvious issues: unclosed tags, special characters in description fields, or a missing OFXHEADER section. If the file was generated by a conversion tool, re-run the conversion and download a fresh copy.

Error: account not found (QuickBooks Desktop)

QuickBooks Desktop matches QBO files to accounts using the financial institution ID (FIID) in the file. If the FIID does not match the bank configured for that account in Desktop, you get this error. Either update the FIID in the QBO XML to match what Desktop expects, or reconfigure the Desktop account to accept the FIID in your file.

Transactions imported but amounts are wrong sign

Debits should be negative amounts in QBO files (e.g., -250.00 for a $250 payment). Credits should be positive. If your conversion tool got the signs reversed, debits will appear as deposits in QuickBooks. Re-run the conversion and verify the TRNAMT values in the XML before importing.

Duplicate transactions after import

If you imported the same transactions twice, it is likely that the FITIDs in the second QBO file were different from the first (perhaps you regenerated the file). Find the duplicates in your register by sorting by date and looking for identical amounts on the same date. Delete the duplicates manually. Going forward, import only from the last date already in your register.

Importing multiple months at once

You can generate a single QBO file covering multiple months and import it in one step. QuickBooks handles large imports well. For QuickBooks Desktop, split imports covering more than two years into 6-month chunks to stay within the file size limit.

For any issues with your QuickBooks import workflow more broadly, see our complete guide to importing bank statements into QuickBooks.

FAQ

How many transactions can a QBO file contain?

There is no defined limit in the QBO format itself. QuickBooks Online handles large imports without issues. QuickBooks Desktop has a practical file size limit. For very large imports, split by date range into multiple files.

Can I import a QBO file into Xero?

Xero does not natively accept QBO files. Xero uses OFX or CSV for bank imports. Some conversion tools output OFX which Xero accepts. Alternatively, export as CSV and import using Xero's CSV import.

Why does QuickBooks say 0 transactions were imported?

This usually means all transactions in the QBO file were recognized as duplicates based on their FITIDs. It can also mean the date range in the file falls entirely within a period already imported. Check your register to confirm the expected transactions are already there.