Skip to content
LedgerLocal

How to Import a Bank Statement into QuickBooks Desktop

QuickBooks Desktop does not read a PDF or a raw CSV statement directly. It expects a Web Connect file — usually .qfx, .qbo, or .ofx — that it can match to a bank or credit card account. This guide covers the direct route and the spreadsheet route, then matching and reconciliation.

Before you start

  • Back up your company file. It is the fastest way out of any import mistake.
  • Make sure the bank or credit card account already exists in the chart of accounts (Lists → Chart of Accounts). Create it first if it does not.
  • Know the statement period and ending balance so you can verify the import later.

Option 1: Web Connect (QFX/OFX) file from your bank

Many banks let you download transactions in Quicken or Web Connect format. In your bank’s transaction history, look for a download or export option and choose Quicken, QFX, QBO, or OFX. OFX is the underlying Open Financial Exchange format; QFX and QBO are the variants QuickBooks Desktop uses.

  1. Download the file for the statement period you want.
  2. In QuickBooks Desktop, open Banking → Bank Feeds → Import Web Connect (.qfx/.qbo) file.
  3. Select the file.
  4. Choose the account the transactions belong to, or let QuickBooks match it.
  5. Confirm the import and review the transactions in the Bank Feeds window.

If your bank offers a live bank feed connection, you can set that up instead under Banking → Bank Feeds → Set Up Bank Feed. The download route above is useful when a direct connection is unavailable or you only need a specific period.

Option 2: CSV export converted to QFX

Plenty of banks and credit card issuers offer only a CSV download. QuickBooks Desktop will not import that CSV as a bank feed, but you can convert it first:

  1. Download the CSV, XLS, or XLSX export from your bank.
  2. Check that it has a header row and columns for date, description, and amount, or separate debit and credit columns. Clean up any rows that are not transactions, such as balance summaries.
  3. Open the CSV to QFX converter , load the file, map the columns, and generate the .qfx download. The conversion happens in your browser; the file is not uploaded.
  4. Import the resulting .qfx with Banking → Bank Feeds → Import Web Connect (.qfx/.qbo) file.

This is the same workflow as a bank-provided QFX file once the file exists, so everything below applies to both options.

Option 3: Manual entry

If the bank only provides a PDF statement, you can enter transactions by hand in the register or through batch entry. It works, but it is slower and more error-prone than importing a file. If you go this route, enter each transaction carefully and reconcile as soon as you finish so mistakes surface while the statement is still in front of you.

Matching the account

During import, QuickBooks Desktop asks which account the file belongs to. Pick the existing bank or credit card account. A few details matter:

  • Do not import the same statement into two different accounts. The transactions will be duplicated across accounts.
  • For a credit card, choose the credit card account so charges and payments map to the correct side of the liability.
  • If the account does not exist yet, create it before importing rather than letting QuickBooks create an unexpected duplicate.

Review and match transactions

After the import, transactions appear in the Bank Feeds window, typically marked as new. Work through them:

  • Match a downloaded transaction to an existing entry when you already recorded it — for example, a check you wrote that has now cleared.
  • Add or categorize transactions that are not in QuickBooks yet, assigning the correct expense, income, or transfer account.
  • Watch for transfers between two accounts you own. A transfer has two sides; make sure both are recorded so the balances agree.
  • Rules can automate recurring categorization, but review what they do before trusting them on a live file.

Reconcile the account

  1. In QuickBooks Desktop, open Banking → Reconcile.
  2. Select the account and enter the statement ending date and ending balance.
  3. Check off the transactions that appear on the statement.
  4. Finish when the difference is $0.00. If it is not zero, look for missed transactions, duplicates from a repeated import, or entries dated outside the statement period.

Reconciliation is the step that proves the import was complete and correct. If the difference will not clear, a common culprit is importing the same period twice, so check for duplicate dates and amounts first.

Common problems

  • Duplicates after a repeat import. Use the dedupe option in the converter when you generate a QFX, and always test on a backup copy of the company file.
  • Charges showing as payments on a credit card. The file may have been imported into the wrong account type. Delete the import and retry against the credit card account.
  • Dates on the wrong day. Some exports use a different date order. Check the first few transactions after import.
  • Missing transactions. Statement exports sometimes omit pending items. Compare the count and total against the statement.

Tools that help

  • CSV to QFX — convert a bank or credit card CSV into a Web Connect file for Bank Feeds.
  • CSV to IIF — write check and deposit transactions straight into a tab-delimited IIF file for QuickBooks Desktop.
  • IIF to CSV — inspect an existing IIF file and export it to CSV before importing.

All three tools run entirely in your browser. Your files are never uploaded, and no account is required. LedgerLocal is not affiliated with Intuit; QuickBooks and QuickBooks Desktop are trademarks of Intuit Inc.