Home › Guides › Import a PDF bank statement into QuickBooks Desktop

Import a PDF bank statement into QuickBooks Desktop

QuickBooks Desktop can't read PDF statements. Convert the PDF to a Web Connect (.qbo) file in your browser, then import it — step by step.

🔒 Files never leave your device✓ Balance check on every row⚡ Seconds, not hours🆓 Free: 10 pages/day, no signup

See pricing — unlock Pro when you need more →

Why you need a QBO file

QuickBooks Desktop's bank feeds import Web Connect (.qbo) files — the format banks provide for direct downloads. When your bank only gives you PDFs (older periods, closed accounts, some business cards), convert the PDF to QBO first.

Step by step

  1. Download the original PDF statements from online banking (not scans).
  2. Drop them into TidyLedger above. Check the green balance badge.
  3. Choose QBO, set the account type (checking, savings or credit card) and download. QBO export is part of Pro — from $6 for a 24-hour pass.
  4. In QuickBooks Desktop choose File → Utilities → Import → Web Connect Files, select the .qbo, and link it to the right account.
  5. Add or match the transactions in the Bank Feeds Center.

Only need a spreadsheet?

Excel and CSV are free (10 pages a day). If your bank also offers CSV downloads, Bankfold turns those into QBO free up to 150 transactions.

Try it free above See Pro pricing

FAQ

Can QuickBooks Desktop import a PDF bank statement?

No. It imports Web Connect (.qbo) files. Convert the PDF to QBO with TidyLedger, then use File → Utilities → Import → Web Connect Files.

Is it really private?

Yes. The PDF is read by JavaScript running in your browser tab; the file and its contents are never sent over the network. You can verify it in your browser's developer tools (Network tab), or disconnect from the internet after the page loads — conversion still works.

Which banks are supported?

TidyLedger doesn't rely on per-bank templates. It reads the table layout of any text-based PDF statement, so it works with most banks and credit cards in Canada, the US, the UK, Europe and Australia. See the list of tested banks.

Does it work with scanned statements?

Not yet. Scanned or photographed statements have no text layer; OCR support is coming. Download the original PDF from online banking for best results.

What about password-protected PDFs?

Supported. You'll be asked for the password, which is used only inside your browser to open the file.

How accurate is it?

When the statement has a running balance, every transaction is verified against it and you'll see a green “balances reconcile” badge. Rows that don't add up are highlighted so you can fix them before exporting.

QuickBooks rejects my CSV or puts transactions in the wrong month. Can TidyLedger help?

That's usually the date column. QuickBooks reads CSV dates in the format you pick at upload, so 01/04 can land in January or April. TidyLedger's CSV and Excel use one unambiguous date format (YYYY-MM-DD) and plain numbers without currency symbols. With Pro, the QBO (Web Connect) file carries its dates in a fixed format, so there's no date step at all.

I already converted a statement with another tool. How do I know nothing was missed?

Use the free bank statement balance checker on this site. Paste the rows with the statement's opening and closing balance, and it shows where the running balance breaks: a missing row, a duplicate or a flipped sign. Nothing is uploaded.

What's free?

10 pages per day with CSV and Excel export, no account needed. Pro adds unlimited pages, batch conversion and QBO/OFX export.