How to Import Bank Transactions Into QuickBooks Desktop

Quick Answer: QuickBooks Desktop imports bank transactions from a Web Connect file, which is a .QBO file. Download it from your bank, then in QuickBooks choose Banking > Bank Feeds > Import Web Connect Files, select the file, link it to an existing or new account, and review the transactions in the Bank Feeds Center. Desktop does not accept CSV, QFX or QIF files for bank transactions.

Importing a bank file into QuickBooks Desktop means importing one specific format: the .QBO file the industry calls Web Connect. Every other route either needs a live connection to the bank or goes around the banking module entirely. Once the file is right, the import takes four clicks, and the transactions land in the same review screen a live feed uses.

Can you import bank transactions into QuickBooks Desktop?

Yes, from a .QBO file. Intuit's Web Connect troubleshooting article is blunt about it: a .qbo file is the only type Web Connect can read, which rules out Quicken's QFX and QIF files. It also advises downloading the file directly from your bank's website rather than from inside QuickBooks.

What Desktop does not do is read a bank CSV into the banking module. On Intuit's QuickBooks community, a support reply answered the CSV question directly: Desktop does not currently have the capability to upload .CSV files of banking transactions, and the supported file is .QBO. That is the main difference from QuickBooks Online, whose upload screen takes CSV. The separate guide on importing CSV bank transactions into QuickBooks Desktop covers the workarounds.

How do you import a Web Connect file?

Step 1: Get the .QBO file

Sign in to your bank's website and look for an export or download option labelled QuickBooks, QuickBooks Web Connect or .QBO. Choose the date range. Some banks let you pick dates freely; others cap the download at a fixed window (Intuit mentions 30, 60 or 90 days as examples). Save the file somewhere you can find it.

If your bank only offers QFX (the Quicken version) or CSV, see the section on other sources below.

Step 2: Import it

Intuit's Bank Feeds setup article gives this sequence:

1. Open your company file and go to Banking > Bank Feeds > Import Web Connect Files. (The same command is under File > Utilities > Import > Web Connect Files.)
2. Select the .QBO file you saved and choose Open.
3. When asked which account to use, either select an existing QuickBooks account or create a new one. Pick carefully; linking to the wrong register puts every transaction in the wrong place.
4. Select Continue, then OK on the confirmation message.

Importing a Web Connect file requires you to be signed in to your Intuit account inside QuickBooks Desktop. If you are not, the import will stop and ask you to sign in.

Step 3: Review in the Bank Feeds Center

The imported lines appear in Banking > Bank Feeds > Bank Feeds Center for that account. From there you match each line to an existing transaction (a check you wrote, a deposit you recorded) or add it as a new one with a payee and account.

Nothing reaches your registers until you add or match it in this screen, so an import can always be reviewed before it affects the books.

Which QuickBooks Desktop versions can import bank files?

Bank feeds, including Web Connect, are an Intuit service tied to supported versions. Under Intuit's service discontinuation policy, QuickBooks Desktop 2023 (Pro Plus, Premier Plus, Enterprise Solutions 23.0, Mac Plus and the accountant editions) was discontinued after May 31, 2026. From that date those versions can no longer download transactions or send online payments and transfers, and Intuit says uploading transactions is discontinued too.

That puts any older release, including the 2019 and 2020 versions people still search for, past its service date as well. If you run one of them and the import fails with a version or sign-in message, the practical choices are upgrading to a supported release or entering transactions another way, covered below.

QuickBooks Enterprise works the same way as Pro and Premier for Web Connect. Enterprise and the Accountant edition also have Batch Enter Transactions, which accepts pasted spreadsheet rows, explained further down.

Common Web Connect errors

Intuit's download article is the source of the duplicate-download rule, and it is the reason to keep a note of the last date you imported.

What if your bank does not offer a .QBO download?

You have several options, in rough order of preference:

1. Direct Connect. Some banks connect straight to QuickBooks Desktop so transactions download without any file. The companion guide to QuickBooks Desktop bank feeds explains the setup.
2. Convert the statement or export to .QBO. If you have the statement as a PDF, or the bank's CSV, convert it into a Web Connect file and import it with the steps above. QuickBankConvert produces .QBO files from statement PDFs on its Plus plan and above (see pricing); the PDF to QBO page shows the output, and the free QBO file checker lets you inspect any .QBO file, from any source, before you import it.
3. Batch Enter Transactions (Enterprise and Accountant editions only). Intuit's batch entry article describes copying rows from Excel and pasting them into Accountant > Batch Enter Transactions for checks, deposits and credit card charges. These go straight into the register rather than through the Bank Feeds Center, so there is no matching step.
4. Type them in. For a handful of transactions, entering them in the register is quickest.

A converted .QBO file has one advantage over the paste method: it arrives in the Bank Feeds Center, where QuickBooks matches it against checks and deposits you have already entered. Pasted or typed transactions do not get that check, so duplicates are your responsibility.

Tips for a clean import

• Back up the company file before importing a large history.
• Import one account per file, and one file at a time, oldest first.
• After each import, compare the ending balance in the Bank Feeds Center with the bank statement for that date.
• Reconcile the account once the period is in; the guide to reconciling in QuickBooks Desktop covers that step.

For a broader view that also covers QuickBooks Online and getting files out of PDF statements, see importing bank statements into QuickBooks.

Related guides

• Live bank connections in QuickBooks Desktop
• CSV and Excel workarounds for Desktop
• Statement PDF to a Web Connect file
• QuickBooks and statement files