For bookkeepers & accountantsPricingLog inConvert a statement

Home › Guides › How to import a bank statement into QuickBooks Desktop

How to import a bank statement into QuickBooks Desktop

QuickBooks Desktop imports bank data from QBO (Web Connect) files — an OFX variant — rather than plain CSV. This guide explains the options when all you have is a statement PDF.

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

Step by step

  1. Understand the formats. QuickBooks Desktop accepts .qbo Web Connect files for bank feeds. It does not import bank transactions from a plain CSV the way QuickBooks Online does.
  2. Get the transactions out of the PDF. Convert the statement PDF to structured transactions (Excel or CSV) with a statement converter, and confirm they reconcile to the statement.
  3. Choose your route in. If your bank offers a QBO download for the period, use that. Otherwise, the converted file gives you verified transactions to enter or to feed through a QBO-generating utility — the important part is that the data is extracted and reconciled first, not retyped.
  4. Import and reconcile. Use File, then Utilities, then Import, then Web Connect Files for a QBO file, and reconcile the account against the statement.

Questions and answers

Can QuickBooks Desktop import Excel files for banking?

Not for bank transactions. Excel/CSV is the working format for reviewing and verifying the extracted transactions; the Desktop bank feed itself uses QBO files.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Related reading from the blog

QuickBooks · November 4, 2026

QuickBooks duplicate transactions after import: causes and cleanup

Why QuickBooks shows duplicate transactions after an import, how feed overlap creates them, and the safe exclude, delete, and prevention workflow.

QuickBooks · November 4, 2026

Splitting a large CSV for QuickBooks Online, safely

Split a large bank CSV for the QuickBooks Online upload size limit by month, with continuity checks at every cut so no transaction is lost or doubled.

QuickBooks · November 3, 2026

QuickBooks import errors caused by dates, and how to fix them

Fix QuickBooks Online date import errors from weekday text, mixed formats, and day month ambiguity, with a safe format choice for every converted file.

More on the StatementVerified blog.

All guides

How to convert a bank statement · How to convert a bank statement PDF to Excel · How to import a bank statement into QuickBooks Online · How to import a bank statement into QuickBooks Desktop · How to import a bank statement into Xero

Bank statements in. Clean books out.

Your first conversion is free — no card, no sign-up — and every result is reconciled against the statement itself before you download it.

Convert a statement — free