PDFCellsConvert a PDF bank statement to a QuickBooks .qbo file
Open the statement in PDFCells, let it check that the balances tie, then export QuickBooks (.qbo) and upload it in QuickBooks Online under Bank transactions › Upload from file. QuickBooks Online usually accepts the file. QuickBooks Desktop imports bank transactions only as Web Connect .qbo files and may refuse one made by a converter; there is no OFX or CSV fallback in Desktop.
Steps
- Go to pdfcells.com and choose the PDF, or drop it on the page. Drop several files to open them as a batch. A password-protected PDF asks for its password.
- Each table opens in an editable grid next to the page. Totals that don't add up, balances that don't tie, text in a number column and cells OCR was unsure of are flagged. Fix any cell, merge or split columns, or undo. The .qbo export switches on only when the numbers tie.
- Choose Bank statement (OFX, QBO, Xero CSV) in the export bar, pick QuickBooks (.qbo), optionally type the account number, and download.
- In QuickBooks Online: Bank transactions › Link account › Upload from file (or “Upload transactions manually” for an account not connected to a bank). Choose the file and the account to put the transactions in. Intuit accepts up to 1,000 transactions and 350 KB per upload (Intuit help).
What is in the file
- An OFX 1.02 bank statement with one transaction per row: type (credit, debit or check), date, signed amount, payee (first 32 characters), the description as the memo (up to 255 characters),and the check number when the statement has one.
- The
<INTU.BID>3000block QuickBooks looks for. Intuit publishes no generic bank id; 3000 is the value converters commonly use. - A FITID per transaction, built from the date, amount, description and position among identical rows. Exporting the same statement twice gives the same ids, so QuickBooks skips transactions it already has.
- The closing balance, dated at the end of the statement period when one is printed in a table title, otherwise at the last transaction date. Credit card statements use OFX’s credit card message set.
QuickBooks Online vs Desktop
| QuickBooks Online | QuickBooks Desktop | |
|---|---|---|
| .qbo from PDFCells | Usually fine. It asks which account to use, so the placeholder account number doesn’t matter. | Web Connect reads only .qbo files, needs a supported Desktop version and sign-in to your Intuit account, and may stop with “QuickBooks is unable to verify the Financial Institution information for this download” (Intuit help). |
| If refused | Upload the bank CSV instead and map its columns (Intuit also accepts OFX and QFX). | Desktop has no OFX or CSV bank import to fall back on. Use the bank’s own .qbo download for recent periods, or a desktop converter that states Desktop support. |
The file follows the OFX 1.02 structure. It has not been test-imported into every QuickBooks edition, so check the first import before relying on it.
Before you export
OFX, QBO and Xero files are only offered when PDFCells' own checks say the numbers are consistent: with a balance column, every row's balance must equal the previous balance plus that row's amount; without one, the statement's summary must tie (opening + credits − debits = closing) and the transactions must add up to it. When a check fails, the export panel says why, with the page and row where it can.
Many statements print dates as month and day only (01/15), with the year only in the statement period. For the statement formats (OFX, QBO, Xero CSV and the bank CSV), PDFCells takes each date's year from the printed period, so December dates on a January statement get the earlier year. When the page prints no period, the export panel's Statement year picker asks for the year, and those formats stay off until you pick one rather than guess. In the Excel export these dates stay as printed text. The period is read from the page's text, table titles and rows. A scanned page read with AI has no page text, so a statement whose period sits outside its tables needs the picked year there; a batch can't ask, so a batch statement whose period isn't found stays blocked, and a saved batch reopened later keeps only its tables' titles and rows to find it in.
Other ways to get a .qbo file
Many banks offer QuickBooks or Quicken downloads of recent activity (bank notes). For older statements there are desktop converters built for this job, such as ProperConvert and MoneyThumb, which support more import targets than PDFCells (comparison, comparison).
Questions
Will QuickBooks import a .qbo made from a PDF?
QuickBooks Online usually does. QuickBooks Desktop may refuse a .qbo whose bank id it doesn’t recognise, and Web Connect reads only .qbo files, so OFX or CSV aren’t a fallback there. For Desktop, use the bank’s own .qbo download or a converter that states Desktop support.
Will importing twice create duplicates?
Not when you import the same export again. Each transaction has a stable FITID,and QuickBooks skips ids it has already imported into that account. Editing a statement after import changes the ids of edited rows, and of rows identical to an edited one (two same-day coffees), so re-importing after edits can duplicate those.
Why is the QBO export greyed out?
The statement’s numbers don’t tie yet, or it isn’t read as a statement. The panel says which page and row to fix. If the dates have no year and the page prints no statement period, pick the year in the Statement year picker.
Does PDFCells connect to QuickBooks directly?
No. It makes a file you upload. There is no QuickBooks login or sync.