How to import a QBO file into QuickBooks Online

A QBO file is the Web Connect format QuickBooks uses for bank downloads. It is OFX 1.x with an Intuit header, so QuickBooks knows which bank and account the transactions came from. QuickBooks Online accepts it through the same upload screen as CSV, but there is no column mapping, because dates, amounts and transaction IDs sit in fixed fields.

This guide follows Intuit’s help article Manually upload transactions into QuickBooks Online, checked on the date at the top of this page.

Before you upload

Check the file size. Intuit’s article sets two limits per upload: 350 KB and 1,000 lines, one transaction per line. The file also has to be in English. A year of a busy business account often goes over both. Split it by date and upload the parts in order.

Pick the date range on purpose. Intuit’s advice depends on the account. For a new account with no transactions, go back as far as you want QuickBooks to track. For an account with only an opening balance, start on the opening balance date. For an account that already has transactions, start the day after the last one. Getting this right prevents most duplicates.

Set up bank rules first, if you use them. Rules apply as transactions arrive in the For review list, so creating them before the upload saves a round of manual categorising.

Know the account type. A credit card statement goes into a credit card account in QuickBooks, not a bank account. Picking the wrong type flips the meaning of every amount.

Steps

1. Open Bank transactions. Go to All apps, then Accounting, then Bank transactions. If the account you want already has a tile, select it.
2. Choose Upload from file. Open the Link account dropdown and select Upload from file. If the account is not connected to online banking, use the option to upload transactions manually.
3. Select the QBO file. Drag in or browse to the .qbo file and click Continue.
4. Pick the QuickBooks account. In the QuickBooks account dropdown, choose the bank or credit card account the file belongs to, or select Add New to create one, then click Continue.
5. Select the transactions to import. Tick the transactions you want, click Continue, then Yes and Done.
6. Review them in For review. Open the account's For review list and add, match or categorise each downloaded transaction.

QuickBooks Online labels and menus differ slightly between regions and plans. If a step does not match your screen, Intuit’s article above has the current wording for the US edition.

Where a QBO file comes from

Many US banks offer QBO directly under a name like “QuickBooks Web Connect” in their download menu; the list of banks that export CSV and other formats shows which ones say so on their own help pages. If the bank only gives you PDF statements, the PDF to QBO converter builds a .qbo file in your browser. Intuit’s article also describes uploading a PDF or image of an English-language statement, which QuickBooks reads with AI and then asks you to check. It splits long statements into files under 1,000 rows and 350 KB, and gives every transaction a stable ID, so converting the same statement twice produces the same IDs.

Common upload problems

The upload is rejected or stops partway. Check the size first. A file over 350 KB or over 1,000 lines needs to be split by date.

Transactions appear twice. QuickBooks matches repeats by the transaction IDs in the file (FITID). Two files for the same period from different sources, for example the bank’s own QBO and a converted PDF, carry different IDs and both import. Keep to one source per account and period, and move duplicates to Excluded in the For review list.

Amounts have the wrong sign. With QBO this almost always means the file was uploaded to the wrong account type, such as a credit card file into a checking account. Exclude those transactions in For review before adding any of them, then upload the file again into the right account. For CSV uploads, Intuit’s screen has an option to reverse all values; QBO files do not need it.

“Bank not supported” or a similar message. QuickBooks checks the bank ID (INTU.BID) inside the file against Intuit’s list. The PDF to QBO page explains how to set that ID. Also check the size limits and the account type.

QBO or CSV?

Both work in QuickBooks Online. QBO needs no mapping and handles duplicates through its transaction IDs. CSV shows you each column before anything is posted, which some accountants prefer when the source was a scanned or messy statement. Intuit’s CSV upload takes a three-column layout (Date, Description, Amount) or a four-column one with credits and debits apart; the QuickBooks Online CSV export writes the three-column version.

Once the transactions are in, reconcile the account against the statement. The guide on how to reconcile a bank statement covers the method. Working in Xero instead? See how to import a bank statement into Xero.