How to import a PDF bank statement into QuickBooks as a QBO file

By Kayabyte · Last updated 28 October 2026

QuickBooks can bring in bank transactions from a file, and the format it prefers is QBO (a Web Connect file). If your bank only gave you a PDF statement, or its direct connection to QuickBooks is broken or doesn’t go back far enough, you need to turn the PDF into something QuickBooks accepts. This guide walks through the options and what to watch for. It is a how-to, not accounting advice; check with your bookkeeper for anything that affects your books.

1. First try the bank’s own download

In your online banking, look for a download or export option that offers QuickBooks, Web Connect or QBO. The exact labels vary by bank. If it exists, it is the best route: the file comes straight from the bank. Banks often limit this to the last few months, or to a date range you pick, so for older periods you may be left with only PDF statements.

2. Import a CSV instead

QuickBooks Online accepts CSV files for bank transactions through its upload option (the exact labels vary by version and by country). You map your columns to Date, Description and either one Amount column or separate In and Out columns. The requirements are strict:

One header row, one transaction per row, no blank rows or subtotals.
Dates in a consistent format that matches your QuickBooks region settings.
Amounts as plain numbers, without currency symbols.

Getting a CSV out of a PDF by hand means the copy-and-paste cleanup described in How to convert a PDF bank statement to CSV. It works, but it takes time and a CSV carries no bank identity, so it won’t match the way a bank-sourced file does.

QuickBooks Desktop is more picky: it generally wants QBO, OFX or QFX files rather than plain CSV, unless you use a separate import tool. Check what your version offers.

3. Why QBO is different from a CSV

A QBO file is really an OFX file with a few extra fields that QuickBooks looks for, in particular identifiers for the bank (an institution ID and a bank ID) and the account. Each transaction also carries a unique ID. That has two consequences:

QuickBooks uses those IDs to spot duplicates, so importing the same month twice should not double your transactions.
Older QuickBooks Desktop versions can reject files whose bank identity they don’t recognize or that don’t match the account you picked. Some versions check the bank ID; the exact behavior varies by version.

Hand-writing a QBO in a text editor is possible but fiddly, and one bad character can make the whole import fail. Not recommended.

4. Where Balanced helps

Balanced is a Mac app we make that reads a PDF statement and exports a QBO file ready for QuickBooks. You open the PDF, review the table in the preview, and choose QBO in the export step.

Works with text PDFs, scanned PDFs and images (read with Apple’s on-device text recognition) and CSV files, from any bank. Headers and months are understood in ten languages: English, Norwegian, Swedish, Danish, German, Dutch, French, Spanish, Italian and Portuguese.
The preview lets you fix column roles, date order and sign handling before anything is written. Balanced remembers the bank’s layout for next time.
The QBO has a bank id setting, with a default of 3000. If QuickBooks complains about the bank, try changing it, or check which value your version expects.
The totals check compares opening balance plus transactions with the closing balance. If it doesn’t add up, you see which rows are off and by how much, and exporting requires an explicit “Export anyway”.
No AI guessing: every number is copied from your statement and checked.
Your statements are processed on your Mac and never leave it.

After exporting, in QuickBooks use the bank-file upload or Web Connect import (the exact labels vary by version), choose the file, pick the matching bank account, and review the transactions before accepting them.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file, which is enough to test an import into a QuickBooks test file or a sandbox company. Pro is USD 59 per year or USD 7.99 per month; see pricing.

Limits to know about

We cannot promise a file will be accepted by every version of QuickBooks, or that every bank layout will be read correctly; always check the preview. Heavily skewed or poor-quality scans can fail. A password-protected PDF must be unlocked first with the password from your bank. Balanced needs macOS 14 or later and runs on Apple silicon and Intel.