Old bank transactions into QuickBooks, from the PDF statements.
Two years behind, and the bank feed reaches back a few months. Start from the PDF statements. DocsToBooks reads each one, checks it against the totals the bank printed, and tells you which months tie out before anything goes into the books.
A year in one run.
Drop in 24 monthly PDFs for an account. Each statement is checked on its own, and each month's opening is compared with the previous month's closing, so a missing month shows as a gap.
The months that tie out, and the ones that don't.
The run overview lists every statement as Reconciled or Doesn't reconcile, with the difference. You start your review where the difference is.
Out to the ledger.
QBO for QuickBooks Online, IIF for QuickBooks Desktop, CSV or Excel for anything else. Export the whole run, or only the statements for the months the feed doesn't cover.
Tie out the statements before they reach the books.
A catch-up import that is short one row looks finished until the reconcile screen is off by an amount nobody can place. Checking each statement first means the difference is found while the PDF is still open in front of you, not three months later.
Questions
How far back can I go?
As far back as you have statements. Many banks keep PDF statements longer than a feed or download reaches, though the history available varies.
Won't I get duplicates where the feed and the statements overlap?
You might, if you import both for the same dates. Export only the months before the feed starts, or match the overlap in your ledger's review screen as usual. We never remove duplicate rows ourselves: two identical transactions on one day are often real.
Is there a pack for one big catch-up job?
Yes. The catch-up pack is 250 statements for $199, one-time, valid 6 months, on top of a paid plan (Solo or above). Checks are free on the Free plan; exporting needs a plan, and so does a pack.
The client gave me paper statements.
Scans are read from the page image and checked the same way; each figure must read the same in two passes. Scan reading is Experimental for now and the certificate says so.
What if one month doesn't reconcile?
Its certificate names the check and the amount. Where the statement prints a running balance, that check shows where the rows first differ. You can export it marked, or leave it out and enter that month by hand.
Pricing and packs · QuickBooks Desktop · How it works · Layouts · Catching up from PDF statements
Start with the oldest month.
Checks are free. Exporting needs a plan; a statement counts when you export it.