How to import a bank statement into QuickBooks Desktop

The two ways in

How to import a Web Connect (.qbo) file

1. Download the transactions from your bank as “QuickBooks Web Connect (.qbo)”, or make the .qbo file with a converter. Save it where you can find it.
2. In QuickBooks, go to File › Utilities › Import › Web Connect Files. (Also under Banking › Bank Feeds › Import Web Connect Files.)
3. Select the .qbo file and choose Open.
4. When asked to Select Bank Account, choose Use an existing QuickBooks account and pick your bank account. Create a new account only if this account isn’t in QuickBooks yet.
5. Select Continue, then OK when QuickBooks says the data has been read.
6. Open the Bank Feeds Center and review the transactions: add each new one to a category or payee, and match those already entered.

After the first import, QuickBooks links the file’s account number to the account you chose, so later files from the same bank account go to the same place. Our QBO file guide explains what is inside the file.

How to import an IIF file

1. Back up: File › Back Up Company › Create Local Backup. Restoring it is the only undo.
2. Match the names: every account named in the file must exist in your chart of accounts, spelled exactly the same, or QuickBooks creates a new account.
3. Import: File › Utilities › Import › IIF Files, then pick the file.
4. Let it check: QuickBooks Desktop 2019 and later can review the file before importing. Intuit advises against “Import it for me. I’ll fix it later”. Rows it can’t import are saved to a new file with the reason for each.
5. Compare: open the bank register and check the new transactions and the ending balance against the statement.

If your bank only gives you a CSV

QuickBooks Desktop has no CSV import for bank transactions; Intuit staff say so plainly in its community forum. Convert the CSV first:

• CSV to QBO for the Web Connect route, with review and duplicate protection. Converting the same CSV again gives the same transaction IDs, so a re-import is skipped.
• CSV to IIF to post the transactions straight to two accounts you name.
• Spreadsheet instead of CSV? Excel to IIF works the same way, and so does Excel to QBO.

Both run in your browser, match the columns for you, and show you the result before you download.

If all you have is a PDF statement

Unlike QuickBooks Online, Desktop can’t read a PDF statement. Convert it to a .qbo file (or an .iif) first. Our converter reads the statement in your browser, checks every row against the statement’s balances, and points out anything that doesn’t add up before you download. Bank and savings statements are supported; credit card statements aren’t yet.

For IIF instead, use the bank statement to IIF converter: you type the bank account’s name and the account that holds the other side, exactly as they are in QuickBooks.

Check your QuickBooks version first

Intuit retires each Desktop version on a schedule. Its policy page says that once a version is discontinued, you can no longer download transactions, and uploading transactions is discontinued too; Intuit staff confirm in the community forum that this includes importing .qbo files. QuickBooks Desktop 2023 was discontinued on 31 May 2026.

If Web Connect imports suddenly stopped working, press F2 in QuickBooks to see your version. On a retired version, upgrading brings them back. IIF import isn’t one of the online services the policy lists.

Common problems

The transactions went into a new account

At the Select Bank Account step, QuickBooks was told to create an account. Remove the extra account and anything you accepted into it, then import again and choose your existing account.

The bank is shown as “Wells Fargo”

QuickBooks names the bank from the Intuit bank ID in the file. Converter-made files usually carry Wells Fargo’s ID. Rename the account if it bothers you; the transactions are unaffected.

Duplicates after an IIF import

The same file, or overlapping dates, went in twice. Restore the backup from before the import, or delete the copies from the register.

An IIF import created stray accounts

An account name in the file didn’t match your chart of accounts exactly. Merge or delete the stray accounts and correct the names in the file.

Questions

Sources

Read on 6 October 2026. Software changes its menus often; if a step here no longer matches what you see, please tell us at hello@safebankstatementconverter.com and we will fix it.

1. Intuit QuickBooks Community: Import web connect (.qbo) files
2. Intuit: Export, import, and edit IIF files
3. Intuit: Improved IIF import in QuickBooks 2019 and later
4. Intuit QuickBooks Community: Uploading CSV bank transactions to QuickBooks Desktop
5. Intuit: QuickBooks Desktop 2023 service discontinuation policy
6. Intuit QuickBooks Community: Managing QBO files after a version goes out of support