A repeatable catch-up bookkeeping workflow is the difference between a profitable cleanup engagement and a black hole that eats your margin. After enough of these, I stopped improvising and built a fixed sequence: scope, gather, import, reconcile, close. Below is the bookkeeping checklist I actually use, in order, so you can scope catch-up engagements accurately and finish them without the late-night surprises that make cleanup work so dreaded.
Step 1: Scope before you quote
Most cleanup engagements lose money because they were priced before anyone knew the size of the mess. Before you commit to a fee, answer four questions:
- How many months of backlog? Count the unrecorded statement periods, not the calendar months the client mentions.
- How many accounts? Each bank and credit-card account is a separate import and a separate reconciliation.
- Are the accounts open and connected? Closed or non-connected accounts mean no bank feed — you’ll be working from PDF/CSV/Excel statements.
- What’s the current state of the file? A brand-new file is easier than one with months of miscoded transactions you have to unwind.
Write the answers down. That’s your scope and your price.
Step 2: Gather the source documents
Request every bank and credit-card statement for the full date range, plus any loan and payroll records. Confirm there are no gaps between statement periods. A missing month is the most common cause of a cleanup that won’t reconcile, and it’s far cheaper to catch it now.
Step 3: Import instead of keying
This is the step that breaks the cleanup-workflow bottleneck. Rather than entering months of transactions by hand, I convert the PDF/CSV/Excel statements into an import file. I run them through Bookmonstic, which reads and categorizes every transaction with AI and exports a QuickBooks “batch transactions import file” or a Xero “precoded import file” — no rules to build and no bank feed required, which matters because cleanup accounts are often closed or non-connected. (Disclosure: I’m a CPA and Bookmonstic is my own tool.) For the QuickBooks side specifically, this guide on importing bank statements into QuickBooks walks through the import options.
Step 4: Reconcile period by period
Reconcile each statement period in date order against its ending balance. Don’t import everything and reconcile once at the end — that lets small errors compound. Tying out each month keeps every discrepancy contained to a single period.
Step 5: Review, adjust, and close
Once the periods reconcile, review the categorizations for judgment calls (owner draws vs. distributions, capitalizable vs. expense), book any adjusting entries, lock the period, and document what you did. That closing memo is your protection if the client questions the work later.
The one-page checklist
1. Scope: months, accounts, connected status, file condition 2. Gather: all statements, no gaps, supporting docs 3. Import: statements to batch/precoded import file, review exceptions 4. Reconcile: period by period to ending balance 5. Close: adjusting entries, lock periods, document
Frequently asked questions
How do I price a catch-up bookkeeping engagement? Price after scoping, never before. Once you know the number of months, number of accounts, and the file’s condition, you can estimate hours honestly. Quoting before scoping is the number-one cause of unprofitable cleanups.
What slows down a cleanup workflow the most? Manual data entry and manual coding. Converting statements into a batch transactions import file or precoded import file removes that bottleneck so your time goes to judgment calls and reconciliation instead of typing.
Should I reconcile at the end or as I go? As you go. Reconciling each statement period in order keeps errors from compounding and makes any discrepancy easy to isolate.
What if the client only has PDFs, not CSVs? That’s fine. A PDF bank statement is a complete record and can be converted into an import file just like a CSV, so you’re never blocked by the file format the client happens to have.
Written by the founder of Bookmonstic, a practicing CPA. Bookmonstic turns PDF/CSV/Excel bank statements into AI-categorized, import-ready files for QuickBooks and Xero — no rules to build, no API. Try it free →
Leave a Reply