Why QuickBooks can't see your whole banking history
When you connect a bank account in QuickBooks Online, the feed typically pulls about 90 days of transactions. Some banks send more, some send less — that's the bank's decision, not Intuit's. If you're onboarding a new client mid-year, catching up after a move off Desktop, or rebuilding a year that was never reconciled, 90 days doesn't get you there.
For everything older, banks give you exactly one thing: PDF statements.
The PDF problem
QuickBooks Online can't read a PDF. The upload dialog accepts CSV, QBO, QFX, and OFX files — that's it. So the job splits in two: get the transactions out of the PDF into a structured file, then upload that file.
Retyping by hand works for a page or two. A 12-page business checking statement with 300 transactions is a different story, and every keystroke is a chance to transpose a digit you'll spend an hour hunting at reconciliation time. Conversion is the practical route.
Step 1: Convert the PDF to a QuickBooks-ready file
Run the statement through a converter that produces CSV, Excel, QBO, or OFX output. Two things matter more than anything else:
- Debits and credits must land in the right place. A conversion that flips signs will import cleanly and poison your books quietly.
- The output should be checked against the statement's own numbers. Every statement prints an opening balance, a closing balance, and totals. If the extracted transactions don't reconcile to those, something was dropped or misread. ReconCSV runs this check automatically and flags the discrepancy before you import anything — far cheaper than finding it during your bank rec.
Download one file per statement period. If the PDF covers multiple accounts (banks often bundle checking and savings in one document), split it into one file per account — each goes into its own QuickBooks account.
Step 2: Choose CSV or QBO (Web Connect)
Option A: CSV
QuickBooks accepts two CSV layouts:
| Layout | Columns | How amounts work |
|---|---|---|
| 3-column | Date, Description, Amount | Money out is negative, money in is positive |
| 4-column | Date, Description, Credit, Debit | Two separate columns, both positive |
The 3-column layout is simpler and less error-prone: one place for the amount, and the sign carries the direction. The 4-column layout mirrors how statements are printed, but a converter that puts a debit in the credit column — or leaves stray values in both — will import garbage that still "looks right" in the mapping preview.
Whichever layout you use, dates should be MM/DD/YYYY for a US QuickBooks company.
Option B: QBO (Web Connect)
A .qbo file is the Web Connect format QuickBooks Desktop used for bank downloads for years, and QuickBooks Online still accepts it. It has two advantages over CSV:
- Every transaction carries a FITID (Financial Institution Transaction ID). QuickBooks uses it to detect duplicates, so re-uploading the same file won't double-post.
- There's no column-mapping step — the file declares its own structure.
The upload walkthrough below is the same for either type; the file picker is the only difference.
Step 3: Upload into QuickBooks Online
- Go to Banking (or Transactions > Bank transactions in newer layouts).
- Open the account tile's dropdown and choose Upload from file. If the account isn't connected to a feed, the upload link sits right on the tile.
- Select your CSV or QBO file.
- Pick the QuickBooks account the transactions belong to.
- For CSV files: confirm the date format, the column mapping, and whether the file is 3-column or 4-column. Check the preview — the first few Amount values should match the statement by eye.
- Confirm the import, then categorize and add the transactions from the For review tab.
- Reconcile the account against the statement's closing balance before moving on.
Fixing the three most common import errors
Everything imported with the wrong sign. Money out shows up as income. This happens when a converter treats a printed "Payments" column as positive amounts without flipping them. Delete the imported batch before categorizing (select all in For review, exclude, then delete from the Excluded tab), fix the file, and re-import. A converter that reconciles against the statement's closing balance catches a sign flip immediately, because the math stops working.
Dates came in wrong or were rejected. QuickBooks wants MM/DD/YYYY for US companies. Files formatted DD/MM/YYYY — common with converters built for European statements — either fail outright or, worse, silently swap day and month for the first twelve days of every month. Spot-check one row against the PDF before you categorize.
Duplicates after import. If the bank feed reconnects and pulls the same period, or you upload overlapping files, you'll see doubles. QBO files protect you via FITID; CSVs don't. Keep imports to non-overlapping statement periods, and reconcile right after importing — a duplicate shows up as a difference you can trace.
The 60-second sanity check
After import and before categorizing, compare three numbers per account: QuickBooks opening balance vs. statement opening balance, imported totals vs. statement totals, closing balance vs. closing balance. If all three match, the file was good. If they don't, fix the file — don't "adjust" the books to cover a bad conversion.