Import Bank Statements into QuickBooks Desktop (Web Connect)

QuickBooks Desktop doesn’t import bank CSV files. To bring in statement activity, you use either a Web Connect file (.qbo) or an IIF file. They solve different problems, so it’s worth choosing deliberately.

Web Connect vs IIF

	Web Connect (.qbo)	IIF
Where transactions go	Bank Feeds center, for review	Directly into the register
Categories	Assigned during review (or by rules)	Already in the file
Duplicate protection	Yes, by transaction ID	No
Best for	Statements and bank downloads	Transactions already categorized in a spreadsheet

Web Connect is the safer default: nothing reaches your books until you accept it, and transactions already downloaded are recognized. IIF is faster when the categorization is done, but it writes straight to the register and can’t be undone with one click.

Importing a Web Connect file

1. Get the .qbo file: from the bank’s download page, or by converting a PDF statement or a CSV export.
2. In QuickBooks Desktop, choose File > Utilities > Import > Web Connect Files.
3. Select the file. QuickBooks asks which account to use:
   • Use an existing QuickBooks account and pick the bank or card account, or
   • Create a new QuickBooks account if this is a new account.
4. QuickBooks reads the file and confirms the import.
5. Open the Bank Feeds center (Banking > Bank Feeds), select the account and review the downloaded transactions: add them, match them to existing entries, or create rules.

QuickBooks links the account number inside the file to the account you chose. Later files with the same account number go to the same account without asking. When converting statements yourself, keep the same account number for each account; a different number makes QuickBooks treat the file as a new account.

Importing an IIF file

IIF (Intuit Interchange Format) is a tab-separated text format that describes each transaction and the account on the other side of it.

1. Prepare the file: a CSV to IIF converter builds it from a spreadsheet with date, description, amount and, optionally, a category column for each line’s account.
2. Back up the company file (File > Back Up Company). An IIF import can’t be reversed in one step.
3. Switch to single-user mode if others are working in the file.
4. Choose File > Utilities > Import > IIF Files and select the file.
5. Open the account register and check the new transactions and their accounts.

Account names in the IIF file must match your chart of accounts exactly, including sub-accounts written as Parent:Child. An account name QuickBooks doesn’t know is created during the import, often with a type you didn’t intend.

Common errors

• “QuickBooks is unable to verify the financial institution”: the bank identifier in the file isn’t one this version of QuickBooks accepts, or the file came from a source it doesn’t trust. Try importing into an existing account rather than creating a new one, and make sure QuickBooks Desktop is up to date. A QBO file generated with a standard identifier is accepted by current versions.
• Transactions go to the wrong account: the file’s account number was linked to another account earlier. Change the link in the Bank Feeds center (edit the account’s online services), then import again.
• Nothing appears after import: the transactions may already have been downloaded before; QuickBooks skips IDs it has seen. Check the register for those dates.
• The file won’t open or is rejected as invalid: look at it in the QBO file viewer, which points out missing tags, bad dates and other problems.
• IIF import creates strange accounts or names: an account name was misspelled, or the Name column was filled. Restore the backup, fix the names and import again.

Checking the import

Whichever method you use, finish with a reconciliation (Banking > Reconcile) against the statement for the same period. If the ending balance agrees and no transactions are left over, everything came in exactly once.