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

Short answer: to import a QBO file into QuickBooks Desktop, go to File > Utilities > Import > Web Connect Files, pick the .qbo file, choose the account, and click Continue. In QuickBooks Online, open Transactions > Bank transactions, select the account, click Link account > Upload from file (or use File Upload), choose the .qbo file, map it to the right account, and finish. The transactions then land in the For Review tab, where you categorize and accept them. The whole import takes about a minute once you have a valid .qbo file.

If you do not have a .qbo file yet, that is the first step. A .qbo file (also called a Web Connect file) is the format QuickBooks reads for bank transactions. You can convert a PDF bank statement to a QuickBooks QBO file in a couple of minutes, then follow the import steps below. This guide covers both QuickBooks Desktop and QuickBooks Online, plus the handful of errors that stop an import and how to clear them.

What is a QBO file and why does QuickBooks need it?

A QBO file is a Web Connect file: an OFX-based text file that holds a list of bank or credit card transactions with their dates, amounts, descriptions, and a unique ID per transaction. QuickBooks reads this format natively, which is why a .qbo import drops cleanly into the right register without retyping anything. Banks that support Web Connect let you download a .qbo directly. When yours does not, or when you are working from a PDF or a printed statement, you create the .qbo with a converter and import it the same way.

The unique transaction ID inside the file (the FITID) is what lets QuickBooks block duplicates. Import the same .qbo twice and QuickBooks skips the transactions it has already seen, which protects your register from double entries.

How do I import a QBO file into QuickBooks Desktop?

In QuickBooks Desktop, open File > Utilities > Import > Web Connect Files, select your .qbo file, then choose whether to use an existing account or create a new one, and click Continue. QuickBooks reads the file, matches it to the account, and moves the transactions into Bank Feeds for review. You can reach the same screen from the top menu under Banking > Bank Feeds > Import Web Connect File.

Step by step:

Back up your company file first: File > Back Up Company > Create Local Backup. An import is hard to undo, so a backup gives you a clean restore point.
Go to File > Utilities > Import > Web Connect Files.
Browse to the .qbo file on your computer and click Open.
When prompted, pick Use an existing QuickBooks account if the account already exists in your chart of accounts, or Create a new QuickBooks account if it does not.
Confirm the bank name, account type, and account number match the statement, then click Continue.
Open the Bank Feeds center to review, categorize, and add the transactions to your register.

If the account is currently connected to a live bank feed (a yellow lightning icon in the chart of accounts), deactivate that connection before importing. Edit the account, open the Bank Feed Settings tab, choose Deactivate All Online Services, save, and then run the Web Connect import. A live direct-connect link and a manual .qbo import cannot run on the same account at once.

How do I import a QBO file into QuickBooks Online?

In QuickBooks Online, go to Transactions > Bank transactions, pick the account you want, then click the dropdown next to Link account and choose Upload from file. Select your .qbo file, tell QuickBooks which account it belongs to, and confirm. The transactions appear in the For Review tab, where you categorize them and add them to your books.

Step by step:

Open Transactions > Bank transactions (older layouts show this as Banking).
If you have never connected this account, click Upload transactions; otherwise click the arrow next to Link account and pick Upload from file.
Click Browse, select the .qbo file, and click Next.
Choose the QuickBooks account the transactions should post to.
QuickBooks reads the file and shows you the count of transactions it will import. Confirm to finish.
Go to the For Review tab to categorize, match, and accept each transaction.

QuickBooks Online also accepts CSV uploads, but a .qbo carries the bank name, account, and transaction IDs already formatted, so it imports with fewer mapping steps and built-in duplicate protection. If your data is already in a spreadsheet, you can convert a CSV file to a QBO file first, then upload it the same way.

Where do imported transactions go after the import?

Imported transactions land in the For Review tab (QuickBooks Online) or the Bank Feeds center (QuickBooks Desktop), not directly into your registers. Nothing posts to your books until you review it. For each line you assign a category or account, match it to an existing transaction or invoice if one exists, and then accept it. This review step is the safeguard that keeps a bad category or a duplicate from hitting your financials.

Set up bank rules to speed this up. A rule that recognizes a recurring payee and assigns the category automatically turns a long review list into a quick confirm-and-accept pass. Once you have categorized the imported batch, run a reconciliation against the same statement to confirm the ending balance matches.

Why won't my QBO file import into QuickBooks?

The most common reason a .qbo file will not import is an account mismatch: the bank ID or account number inside the file does not match the account you are importing into. Other frequent causes are an out-of-date QuickBooks version, a live bank feed that needs deactivating first, or a file that is not actually a valid .qbo. Here is how to clear each one:

Account or financial institution mismatch. If you see "QuickBooks is unable to verify the Financial Institution Information," the bank routing or account number in the file differs from the account in QuickBooks. Edit the account, deactivate online services on the Bank Feed Settings tab, and import again so QuickBooks lets you map it manually.
Nothing imported. If the import runs but adds zero transactions, QuickBooks has likely seen those transaction IDs before and treated them as duplicates, or the date range is empty. Check the For Review tab and confirm the file actually contains the dates you expect.
Old QuickBooks version. QuickBooks Desktop stops importing Web Connect files for versions more than three years old. If you are on a sunset version, update or use a supported year. A version mismatch is also a common trigger for the QuickBooks Web Connect error QBWC1039.
Invalid file. A renamed PDF or a corrupt export will fail. Make sure the file genuinely ends in .qbo and came from your bank or a reliable converter.

If the file itself is the problem, regenerate a clean one. Converting straight from the original PDF bank statement to a QBO file produces a properly formatted Web Connect file with valid transaction IDs, which clears most "won't import" errors at the source.

Can I import a full year of statements at once?

Yes. You can import several .qbo files in sequence, one per statement, and QuickBooks merges them into the same account while skipping any duplicate transactions. For catch-up bookkeeping or year-end cleanup, this is the fastest way to load months of history that the live bank feed cannot reach (most feeds only go back 90 days). Convert each monthly PDF to a .qbo, then import them oldest to newest so balances build in order.

If you have a stack of statements to process, a batch PDF-to-QuickBooks conversion turns a folder of PDFs into ready-to-import .qbo files in one pass, which saves the repetitive download-and-convert loop. When you need the same transactions in a spreadsheet for analysis alongside the import, you can also convert the PDF bank statements to Excel and keep both formats.

Do I import a QBO file or a CSV file?

Use a .qbo file when you can, because it imports with the bank, account, and transaction IDs already in place and gives you automatic duplicate protection. A CSV import works too but requires you to map columns (date, description, amount) by hand each time and offers no built-in duplicate blocking. For recurring monthly imports, the .qbo format saves time and reduces the chance of a mismatched column quietly importing wrong data. If your bank only offers CSV or your data already lives in a spreadsheet, a CSV to QBO converter gets you back to the cleaner .qbo path before you import.

From PDF statement to imported in QuickBooks

If your bank does not offer a Web Connect download, or you are working from PDF statements an accountant sent you, the path is simple: convert the PDF to a .qbo file, then run the import steps above. Our PDF bank statement to QuickBooks converter reads the statement, including scanned and image-based PDFs, and produces a QBO file formatted for both QuickBooks Online and Desktop. Drop the file into the converter at the top of this page, download the .qbo, and you are ready to import in under two minutes.

For QuickBooks Desktop users who prefer the IIF route, our PDF to IIF converter produces an IIF file instead, which posts transactions directly without the Web Connect review step. Either way, the conversion is the part that used to take an hour of manual entry, and it is now the quick part.