How to Import a Bank Statement into QuickBooks Desktop (QBO & IIF)

QuickBooks Desktop won't read your bank's PDF statement — but it will import a .qbo Web Connect file or an IIF. Here's how to get from statement to imported transactions in minutes.

Option 1: Web Connect (.qbo)

Convert your statement to .qbo, then in QuickBooks go to File → Utilities → Import → Web Connect Files. Transactions land in the bank feed for review and matching, exactly as if downloaded from your bank. Note: some QuickBooks versions validate the bank ID inside the file — if yours rejects it, use the IIF route below.

Option 2: direct IIF import

IIF is QuickBooks Desktop's own tab-separated import format with no bank validation. Convert the statement to IIF, back up your company file, then File → Utilities → Import → IIF Files. Transactions post directly to the account you choose.

Which to pick

QBO gives you the bank-feed review workflow (recommended for reconciliation). IIF is the fallback that always works, and the only route into some older QuickBooks versions. Either way you skip typing every line — our converter produces both from the same statement.

Convert your bank statement now

Free — upload a PDF or image and download a clean spreadsheet.

Open the converter →