Import a QBO File into QuickBooks: Online and Desktop

To import a QBO file into QuickBooks Online, go to Transactions, then Bank transactions, pick the account, open the Link account dropdown, and choose Upload from file; drop in the .qbo, review the side-by-side preview, and select Save. To import a QBO file into QuickBooks Desktop, open File, then Utilities, then Import, then Web Connect Files, pick the .qbo, and choose the account to add it to. Both products read the same Web Connect (.qbo) file.

A QBO file, also called a Web Connect file, is the format QuickBooks reads when you import bank or credit card transactions by hand instead of using a live bank feed. If your bank only gives you a CSV or Excel export, you can convert your CSV to a QBO file first, then follow the steps below. The rest of this guide covers the exact clicks for QuickBooks Online and QuickBooks Desktop, the requirements each version has, and what to do when an import is rejected.

QuickBooks Online vs Desktop: where the QBO import lives

The menu path and the file limits are different in each product. This table shows where to go and what each version expects before you start.

How do I import a QBO file into QuickBooks Online?

Sign in to QuickBooks Online, go to Transactions, and select Bank transactions. Click the account tile you want the data in, open the Link account dropdown, and choose Upload from file. Drop in the .qbo file, match it to the right account, review the side-by-side preview, and select Save. QuickBooks Online accepts .qbo, .csv, .txt, .qfx, and .ofx, up to 1,000 rows per upload.

1. Go to Transactions, then Bank transactions.
2. Select the tile for the account you want the transactions in. If the account is not set up yet, add it first.
3. Open the Link account dropdown and choose Upload from file.
4. Select Drag and drop or select files, then pick your .qbo file.
5. Confirm the QuickBooks account the file maps to and select Next.
6. Check the side-by-side preview, fix anything that looks off, and select Save.

The transactions land in the For review tab of that account, where you categorize and add them just like live bank-feed data. If you only have a spreadsheet, our CSV to QuickBooks Online guide covers the same upload starting from a CSV.

How do I import a QBO file into QuickBooks Desktop?

In QuickBooks Desktop, open the File menu, choose Utilities, then Import, then Web Connect Files. Select your .qbo file, then tell QuickBooks whether to use an existing account or create a new one. The transactions appear in the Bank Feeds center for you to match and add. Desktop reads only the .qbo (Web Connect) format for this import, and you must be signed in to your Intuit Account inside the app.

1. Sign in to your Intuit Account inside QuickBooks Desktop if you are not already.
2. Open File, then Utilities, then Import, then Web Connect Files.
3. Browse to your .qbo file and open it.
4. When prompted, choose Use an existing QuickBooks account and pick the matching bank or credit card account, or create a new one.
5. Confirm the import and let QuickBooks load the transactions.
6. Open the Bank Feeds center to review, match, and add the transactions to your register.

QuickBooks Desktop has no built-in CSV importer for bank transactions, so the .qbo route is the standard way to bring a spreadsheet of activity into Desktop. Our CSV to QuickBooks Desktop guide shows the full path from a raw CSV to an imported register.

Before you import: three things that trip people up

Most failed imports come down to three issues. First, the file has to be a real .qbo (Web Connect) file, not a CSV renamed with a .qbo extension or an .ofx or .qfx. Second, in Desktop an account with an active direct-connect bank feed (the yellow lightning icon) blocks a Web Connect import until you deactivate the feed under Bank Feed Settings. Third, the account or financial-institution ID inside the file has to match the account you import into, or QuickBooks warns that the IDs do not line up.

If you hit a specific code or a file cannot be read message, our QuickBooks Web Connect import error guide lists the common OL and OLE codes and how to clear each one.

How do I open a QBO file in QuickBooks?

You do not open a .qbo file by double-clicking it; you import it. In QuickBooks Online, use Transactions, Bank transactions, then Upload from file. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files. The .qbo is a data file QuickBooks reads during import, not a document you open in a viewer.

Why won't my QBO file import into QuickBooks?

The usual causes are a corrupted or mislabeled file, an account-ID mismatch, or an active live bank feed in Desktop. Confirm the file is a genuine Web Connect .qbo, deactivate any direct-connect feed on the target account, and import into the account the file was built for. Rebuilding the file with a clean reconvert usually fixes a malformed .qbo.

Can I import a QBO file into QuickBooks Online?

Yes. QuickBooks Online accepts .qbo files through Transactions, Bank transactions, then the Link account dropdown and Upload from file. Alongside .qbo it also reads .csv, .txt, .qfx, and .ofx. Each upload can hold up to 1,000 rows and must be 350 KB or smaller, so split very large date ranges into separate files before importing.

What program opens a QBO file?

A .qbo file is built for QuickBooks, so QuickBooks Online or QuickBooks Desktop is what reads it. It is a text-based Web Connect (OFX) file, so a plain-text editor will show the raw markup, but you cannot edit it safely there. To actually use the data, import it into QuickBooks rather than trying to open it in another app.

Can I open a QBO file in Excel?

Not in a useful way. A .qbo is an OFX-based text file, so Excel shows tag markup instead of clean columns. If you need the transactions in a spreadsheet, keep your original CSV or Excel export, or work the other direction: start from the spreadsheet and use our Excel to QBO converter to build the .qbo only when you are ready to import.

How do I send a QBO file to my accountant?

Attach the .qbo to an email or share it through your firm's portal, and note which bank or credit card account and date range it covers. Your accountant imports it the same way you would. If you also exchange engagement letters or signed authorizations, an online document e-signing tool keeps that paperwork moving without printing and scanning.

Does QuickBooks Desktop still support Web Connect import?

Yes. File, Utilities, Import, Web Connect Files is still the supported way to import a .qbo into QuickBooks Desktop, and it is the only built-in route for bringing bank or credit card transactions in from a file. You do need to be signed in to your Intuit Account inside the app for the import to run.

How many transactions can one QBO file hold?

For QuickBooks Online, keep each upload to 1,000 rows and 350 KB or less, and split larger date ranges into separate files. QuickBooks Desktop has no strict row cap, but very large files import slowly and are easier to troubleshoot when you break them into monthly or statement-sized batches.

Related guides: convert a spreadsheet with the CSV to QBO converter, compare tools on our best CSV to QBO converter roundup, follow the full how to convert CSV to QBO walkthrough, or handle card data with credit card CSV to QuickBooks. If your transactions are still locked in a PDF statement, convert the PDF bank statement to a clean CSV first, and if you would rather skip the spreadsheet, go straight from a PDF bank statement to a QBO file.