QuickBooks Web Connect (.qbo) files: what they are and how to import them

What a Web Connect file is

With Direct Connect, QuickBooks connects to your bank’s server itself. With Web Connect, you sign in to your bank’s website, download your transactions as a .qbo file and import that file. Which one you can use depends on your bank.

A .qbo file is an OFX file (Open Financial Exchange, the standard format for bank downloads) with a few additions for QuickBooks. It holds the account and each transaction’s date, amount, payee, memo and ID (FITID). QuickBooks remembers these IDs, so it can skip transactions it already has. An Intuit bank ID in an <INTU.BID> line tells QuickBooks which bank the file comes from.

The file is not the same as QuickBooks Online, which is also called “QBO”. To see what a file holds before you import it, open it in the bank file viewer.

Import a .qbo file into QuickBooks Desktop

1. Back up your company file. An import can’t be undone.
2. Sign in to your Intuit Account inside QuickBooks Desktop. Importing Web Connect files requires it. If QuickBooks keeps asking you to sign in, change the Bank Feeds mode.
3. Download the .qbo file from your bank’s website, not from inside QuickBooks.
4. Go to Banking → Bank Feeds → Import Web Connect Files. Older instructions use File → Utilities → Import → Web Connect Files.
5. Choose the .qbo file and click Open.
6. Choose Use an existing QuickBooks account and pick the account, or Create a new QuickBooks account. Click Continue.
7. Click OK when QuickBooks says the data has been read, then review the transactions in the Bank Feeds Center.

In QuickBooks Desktop for Mac, the import is under Banking → Downloaded Transactions → Import File.

QuickBooks Desktop imports bank transactions from Web Connect files, not from a CSV. If your bank offers only CSV or Excel, make a .qbo file with the CSV to OFX, QFX and QBO converter. If it offers QFX (the Quicken version) or plain OFX, the bank format converter turns it into QBO and keeps the transaction IDs.

Upload a bank file to QuickBooks Online

1. Go to All apps → Accounting → Bank transactions. In the older menus this is Transactions → Bank transactions.
2. Select the account’s tile, if shown. Open the Link account drop-down and choose Upload from file.
3. Click Drag and drop or select files, choose the file and click Continue.
4. Choose the QuickBooks account the transactions belong to, or Add New, and click Continue.
5. Match the columns to QuickBooks fields if asked, select the transactions, and click Continue. Click Yes, then Done.

QuickBooks Online takes .qbo, .qfx, .ofx, .csv and .txt files, and Intuit suggests QBO. Each upload must be in English, up to 350 KB and 1,000 lines, so split long statements by date. A CSV needs three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), with one date format throughout.

How far back you can import

• Bank connections: a newly connected account in QuickBooks Online downloads between 90 days and 24 months of history, depending on the bank. Upload older transactions from a file.
• Web Connect downloads: your bank decides how far back they go. If its site doesn’t ask for dates, you get the most it allows.
• Overlapping dates: QuickBooks skips transactions whose IDs it has already imported, so overlaps don’t create duplicates. The same transaction can’t be imported twice, even after you delete it.
• Older Desktop versions: Intuit ends online banking for discontinued versions. QuickBooks Desktop 2023 was discontinued after 31 May 2026, so on 2023 or older, imports may stop working.

Fixing import errors

“QuickBooks is unable to verify the Financial Institution information for this download”

QuickBooks couldn’t match the bank details in the file, which include the Intuit bank ID. Download a fresh file from the bank’s website and try again. If your bank has stopped offering Web Connect, Intuit’s advice is to disconnect the account in QuickBooks. For a file you made or converted yourself, set your bank’s Intuit ID in the bank format converter, which rewrites the bank ID and leaves the transactions unchanged.

“We can’t read the file” or “Your data was not imported into QuickBooks”

1. Download a fresh .qbo file from the bank’s website and import it.
2. Switch Bank Feeds to Classic mode: Banking → Bank Feeds → Change Bank Feeds Mode → Classic mode (Register mode), then import again.
3. Import the file into a test company (File → New Company). If it works there, disconnect and reconnect the account in your real company file. If it fails, the file is the problem: contact your bank.

OL- and OLSU- error codes

Codes such as OL-221, OL-301 or OLSU-1011 can come from the bank, your internet connection, the bank account in your company file, a file QuickBooks can’t read, or an unsupported QuickBooks version. Intuit’s steps: make sure the file is a .qbo file, test in a new company file, deactivate online services on inactive accounts that still show a lightning bolt, and turn online banking off and on for the account. If it persists, contact your bank with your Bank Feeds log.

The account isn’t listed, or nothing is imported

If your account isn’t in the list, the account type in the file may not match the one in QuickBooks, such as a credit card file and a checking account. If nothing is imported, QuickBooks has already seen those transaction IDs. To import them again, restore a backup made before the earlier import.