StatementCheap

Convert PDF bank statements to QBO

Turn a PDF statement into a .qbo Web Connect file you can import into QuickBooks. We check the transactions against the statement's balances first, so you import complete data.

  • 5 free pages every day, no sign-up
  • Checked against the statement's balances
  • Files never stored

Drop PDF statements here

or choose files. Any bank, any country. Scanned PDFs work too.

5 free pages every day. No sign-up.

🔒 Read on Cloudflare's network · files never stored · never used to train AI

Updated · By the StatementCheap team

What a QBO file is

A .qbo file is QuickBooks' Web Connect format. Banks offer it so customers can download transactions straight into QuickBooks. It's a variant of OFX, the open standard for financial data, with details QuickBooks expects. Quicken uses a close cousin, .qfx. Our guide to QBO vs OFX vs QFX explains the differences.

The problem: many banks only offer Web Connect for recent activity, and some don't offer it at all. Older months often exist only as PDF statements. That's where a PDF to QBO converter comes in.

How to convert a PDF to QBO

  1. Download the statement from online banking as a PDF.
  2. Upload it on the converter. Each file can be up to 200 pages and 25 MB.
  3. Check the reconciliation result. A reconciled statement means the opening balance plus the transactions equals the closing balance.
  4. Choose QuickBooks and download the .qbo file. A 3-column CSV (date, description, amount) is also available.

Import into QuickBooks Online

Intuit's help article describes these steps for uploading a file:

  1. Go to Accounting, then Bank transactions.
  2. Select the account tile if you see one.
  3. Open the Link account dropdown and choose Upload from file.
  4. Select your file, pick the QuickBooks account it belongs to and continue.
  5. Choose the transactions to import and finish.

Intuit lists .csv, .txt, .qbo and .ofx as accepted transaction files and recommends QBO. Files must be 350 KB or less, with up to 1,000 lines per upload. If you're bringing in a long history, split it into several files, such as one per statement.

One honest note: QuickBooks Online can now read some PDF statements itself. Intuit says it uses AI to extract transactions from an uploaded PDF or image, for statements in English. If that works for you, you may not need a converter. A separate converter still helps if you use QuickBooks Desktop, want an Excel copy for your records, or want a balance check before anything touches your books. Our step-by-step QuickBooks Online guide covers both routes.

Import into QuickBooks Desktop

In QuickBooks Desktop, Intuit's help describes going to Banking > Bank Feeds > Import Web Connect Files. Choose the .qbo file, then pick the existing QuickBooks account it belongs to (or create one), and review the transactions in the Bank Feeds Center. Intuit notes that importing Web Connect files requires you to sign in to your Intuit account within QuickBooks Desktop. Menu names can vary slightly between Desktop versions, so back up your company file before your first import.

Credit card statements

Card statements convert to .qbo too. The file is marked as a credit card statement, so purchases come in as charges and payments as credits. Import it into the matching credit card account in QuickBooks, not your checking account. Before importing, check that the converted statement reconciled against its previous and new balance.

Avoid duplicate transactions

If the account also has a live bank feed, check the dates before you import. Importing a statement that overlaps with transactions already downloaded can create duplicates. The safest approach is to import only the months the feed doesn't cover.

Already have a CSV?

If your bank gave you a CSV but QuickBooks wants a .qbo, use our CSV to QBO tool. If you're starting from a PDF, the converter on the home page does it in one step.

Cost

Most statements are a few pages. With 5 free pages every day, a small catch-up job may cost nothing. A $6 pack covers 150 pages, and plans start at $9 a month for 500 pages. A failed conversion isn't charged. See pricing.

Works with statements from any bank, including Chase, Bank of America, Wells Fargo, Capital One, Barclays and HSBC.

FAQ

Does the QBO file work with QuickBooks Online and Desktop?
It's a standard Web Connect file, the format both products import. In QuickBooks Online use Upload from file; in Desktop use Banking > Bank Feeds > Import Web Connect Files.
Should I use QBO or CSV for QuickBooks Online?
Intuit recommends QBO files. Use the 3-column CSV if you want to review or edit the rows in a spreadsheet before importing.
Can I convert credit card statements to QBO?
Yes. Purchases come through as charges and payments as credits. Import the file into the matching credit card account in QuickBooks.
Why does QuickBooks say my file is too large?
Intuit limits uploaded transaction files to 350 KB and 1,000 lines. Convert and import one statement at a time if you hit the limit.
Do you connect to QuickBooks directly?
No. We don't connect to QuickBooks or to your bank. You download the file and import it yourself, which keeps you in control of what goes into your books.