QuickBooks
How to import missing bank transactions into QuickBooks
When QuickBooks is missing older months or statement-only history, use reviewable CSV rows to backfill transactions carefully.
Why transactions go missing
The common pattern is not that QuickBooks lost a perfect import file. The missing period often sits outside the bank-feed window, outside the bank CSV export limit, or inside an old account archive where only statement PDFs remain.
Use the statement as the upstream file
Original statement PDFs usually work best. Clear scans or phone photos can still be tested if the transaction table is readable. No bank login is required, and redacted files are fine as long as dates, descriptions, and amounts stay visible.
The output QuickBooks can work with
For the simplest cleanup flow, shape the file into Date, Description, and Amount. Money out should be negative and money in should be positive. The point is to preserve real transaction rows, not generic PDF text.
- Date
- Description
- Amount
Review before import
Users should test one month first, compare the row count against the statement, check the sign direction, and watch for summary pages, balance lines, or duplicate rows before importing the next batch.
Missing-history CSV example
Date,Description,Amount 2025-01-03,CLIENT PAYMENT,1840.00 2025-01-06,ACH VENDOR PAYMENT,-415.20 2025-01-31,MONTHLY FEE,-18.00
Review before import. Historical cleanup is safer in smaller month-by-month batches than one large backfill.
FAQ
Can I import several missing months at once?
It is safer to import one month or one date range at a time so duplicates, wrong signs, and bad rows are easier to catch.
Do I need a native QBO file?
Not for the current DocuRows workflow. The current product promise is a reviewable QuickBooks-ready CSV, not native .qbo export.
Can I test with redacted statements?
Yes. Redacted files are fine if the transaction table remains readable.
Turn a statement file into reviewable rows
Upload a PDF, scan, screenshot, or clear photo and review the rows before downloading CSV.