bank statement → OFX

PDF to QBO Converter for QuickBooks Online and Desktop

Upload a PDF, scanned or photographed bank or credit card statement and get date, description and amount on every row, ready for the QuickBooks Online bank upload screen. If you only work in QuickBooks Desktop with Web Connect files, this page tells you plainly which tools produce .QBO and what to check first.

Reads text PDFs, scans and phone photos
Up to 50 files per batch on Plus
CSV, OFX and Excel export

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|
<OFX> for MS Money & accounting software, <CSV> for spreadsheets

What a PDF to QBO converter actually has to do

A PDF to QBO converter reads the transactions on a bank statement and writes them into a .QBO file, which is OFX plus two Intuit tags that identify the bank. QuickBooks Desktop checks that bank identifier against its own list before it reads a single transaction. QuickBooks Online is more forgiving: it accepts CSV on the upload screen, so a clean converted CSV is usually the faster and safer route. OFXStatement converts PDF, scanned and photographed statements to OFX, CSV and Excel, and does not issue .QBO files.

Why a .QBO file made from a PDF often fails in QuickBooks

The failure is rarely the transactions. It is the bank identifier inside the file, which no converter vendor owns.

The bank ID is checked first

QuickBooks Desktop reads the INTU.BID tag and compares it with its own institution registry, so a file with a missing or invented value is rejected before any rows are read.

Borrowed identifiers

When we tested one popular converter, its default value belonged to Wells Fargo, so a Chase statement would import as the wrong institution.

Renaming does not work

A .qbo made by renaming an OFX file is byte for byte the same OFX, without the Intuit tags QuickBooks looks for.

Retyping is slow

A long statement takes an hour or more to key in per month per account, and transposition errors only surface at reconciliation.

Pick the route that matches how your QuickBooks is set up

Most bookkeepers working in QuickBooks Online never need a .QBO file at all. The converted data goes in as CSV and lands in the For Review tab.

CSV Built for the QuickBooks Online Upload

Date, description and amount in the layout the upload screen maps, so the column mapping step takes seconds instead of a cleanup session.

Scans and Phone Photos Included

Clients who send a photographed statement or a flattened scan are handled the same way as a text PDF, with no separate OCR tool in the middle.

Batches for a Full Year

Plus converts up to 50 files in one go and can merge several months into one file, so a catch up engagement is one upload, not twelve.

Balances Check Out

Statement totals sit next to the rows, so you can confirm they add up before anything touches the ledger.

From PDF statement to QuickBooks Online in 4 steps

One account per file, checked against the statement totals before you import.

1

Upload the statement

Drop in a PDF, a scan or a photo.

2

Check the rows

Compare the closing balance and the transaction count with the statement itself.

3

Download CSV

Choose CSV for QuickBooks Online, or OFX if your other systems such as Xero or NetSuite read it.

4

Import and categorize

In QuickBooks Online go to Transactions, Bank transactions, Upload transactions, map the columns once and accept the matches.

Who this fits and who it does not

The honest split depends on which QuickBooks product holds the books.

QuickBooks Online Bookkeepers

Clients send PDFs because the bank feed disconnected or never existed. CSV upload fixes that without any institution tag.

Catch Up and Cleanup Work

A year of statements for a new client, where the bank feed only backfills 90 days.

Multi Software Practices

Firms that keep some clients in Xero, NetSuite or Sage use the same OFX or CSV from one converter.

QuickBooks Desktop Users

If Web Connect is your only import path you need a tool that writes .QBO. We say so below and link the comparison.

Common Search Terms

pdf to qbo converter pdf to qbo convert pdf to qbo convert pdf bank statements to qbo pdf bank statement to quickbooks convert pdf to quickbooks file

Can I convert a PDF bank statement to QBO?

Yes, but only a few tools do it, and the result depends on the bank identifier the tool writes. A .QBO file is an OFX file with two extra Intuit fields, INTU.BID and INTU.USERID. QuickBooks Desktop checks the INTU.BID value against the financial institution list that Intuit maintains, which has thousands of entries and none reserved for converter vendors. So a converter either borrows a real bank number or the file is refused. We chose not to issue .QBO files for that reason and removed the format from the product. The longer history is in our notes on PDF2QBO being discontinued.

What does QuickBooks Online accept instead?

The manual upload screen in QuickBooks Online accepts CSV, QBO, QFX and QIF files, and CSV is the one you can build from any statement without bank specific tags. A clean CSV has a date column, a description column and either one signed amount column or separate debit and credit columns. After the first upload QuickBooks remembers the mapping per account, so month two takes less than a minute. The full walk through, including the duplicate trap on overlapping dates, is in our guide to importing a bank statement into QuickBooks.

PDF to QBO routes compared

RouteOutputQuickBooks OnlineQuickBooks DesktopWhere it wins
OFXStatementCSV, OFX, ExcelCSV upload, no bank tag neededNo .QBO fileScans and photos, batches of 50, one export for several accounting systems
MoneyThumb Convert2QBO.QBO and OFXAccepted by the upload screenWeb Connect importCheaper at low volume and for long statements, since a 40 page month counts as one conversion
ProperConvert.QBO and othersAccepted by the upload screenWeb Connect, with a borrowed bank IDDesktop users who want a file Web Connect will open
Manual retypingYour own spreadsheetCSV uploadNoOne short statement a year

MoneyThumb lists monthly plans of 5 conversions for 24.95 dollars, 20 for 49.95 dollars and 60 for 99.95 dollars, and yearly plans from 124.95 dollars for 25 conversions up to 799.95 dollars for 800, as listed when we last checked in October 2026. Read the full ladder on our MoneyThumb pricing breakdown and the head to head in the MoneyThumb alternative comparison. If you want every converter side by side, the bank statement converter comparison covers the rest.

A worked example with real numbers

Take a bookkeeper taking over a client with 12 months of statements on one checking account and one credit card. That is 24 statements. With a monthly 5 conversion plan at 24.95 dollars you would need five months of billing to clear the backlog, roughly 125 dollars, before the next client. With a yearly plan of 25 conversions at 124.95 dollars the backlog fits, with one conversion spare. Converting to CSV with OFXStatement on a Starter plan, the same 24 statements are one batch, and the cost is the annual plan you were going to carry for the other clients anyway. The break even moves with your volume. Below about 60 statement months a year a per conversion plan is usually cheaper, and above about 240 the flat plan wins. We would rather you pick the cheaper tool than the one that sells you a plan you under use. Before paying anyone, run the six point test on one real statement.

When you should pick a different tool

Choose a .QBO writing converter if your client is on QuickBooks Desktop, the account has no live bank feed attached, and Web Connect is how you import. Check three things before paying. First, whether the file sets a bank identifier that matches the real bank. Second, whether it creates a unique transaction ID per row so re-importing overlapping months does not duplicate. Third, whether the tool counts a multi account statement once or per account. If your client is on QuickBooks Online, Xero, NetSuite, Sage or Zoho, a CSV or OFX route needs none of that, and the Xero bank statement converter page shows the same pattern for a second system. For high volume work, the bulk bank statement converter covers merging and batching.

Why QuickBooks still rejects a clean file sometimes

Three causes cover most failed uploads. Dates in a format the column mapping does not expect, such as day first dates in a US account. A header row that repeats on every page of a long statement, which turns into rows of text in the amount column. And a live bank feed already attached to the account, which blocks Web Connect imports on Desktop until the connection is deactivated. Intuit documents the supported file types on its QuickBooks support site, and it is worth checking the current screen names there because the menus move between versions.

What this costs compared with doing it by hand

A 5 page statement with 60 transactions takes an experienced person 15 to 25 minutes to key in and check. A 24 statement backlog is therefore 6 to 10 hours before any categorizing. At a bookkeeper rate of 40 to 75 dollars an hour that is 240 to 750 dollars of time, against a plan that costs 294 dollars for the year on the Starter annual price. Seen that way the conversion tool pays for itself on the first catch up client, and every month after is margin. See current plans on the pricing page.

PDF to QBO Converter FAQ

Yes, with a tool that writes .QBO files, such as MoneyThumb or ProperConvert. The catch is the INTU.BID bank identifier QuickBooks Desktop checks. OFXStatement does not issue .QBO. It converts statements to CSV, OFX and Excel, and CSV is accepted by QuickBooks Online.

No. A QBO file is OFX plus Intuit tags INTU.BID and INTU.USERID. Without a bank identifier that QuickBooks recognizes, a renamed file is rejected even when every transaction inside it is correct.

Convert the PDF to CSV first, because QuickBooks cannot read PDF. Then go to Transactions, Bank transactions, Upload transactions, choose the file, map date, description and amount, and accept the rows into the For Review tab.

Per conversion plans start near 25 dollars a month for 5 conversions. Yearly plans run from about 125 dollars for 25 conversions to 800 dollars for 800. OFXStatement Starter is 294 dollars a year and handles batches of statements for CSV and OFX.

Only if date ranges overlap. CSV rows carry no transaction ID, so QuickBooks cannot tell a row was already imported. Convert clean, non overlapping periods and the duplicates never appear.

Yes. Scanned and photographed statements are converted the same way as text PDFs, and you should still compare the closing balance with the original before importing.

Related Resources

Other Bank Statement Converters

JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Financial Capital One TD Bank Charles Schwab Bank of New York Mellon State Street BMO USA Ally Financial Regions Financial Fifth Third Bank Huntington Bancshares KeyBank Citizens Financial Group First Citizens BancShares Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bancorporation East West Bancorp First National of Nebraska Cullen Frost Bankers BOK Financial Fulton Financial Associated Banc-Corp Valley National Bancorp Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Financial Partners Webster Financial Cadence Bank Old National Bancorp First Interstate BancSystem Umpqua Holdings First Hawaiian Bank Prosperity Bancshares SouthState Corporation First Merchants First Bank Holding Glacier Bancorp First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Bancorporation Pacific Premier Bancorp Bank OZK United Community Banks Customers Bancorp Texas Capital Bancshares SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA Citizens Bank Santander Bank Flagstar Bank PNC Credit Card U.S. Bank Credit Card Apple Card

Payment Processor and Marketplace Statement Converters