Bookkeeping cleanup checklist for accounting firms

A bookkeeping cleanup checklist for accounting firms has eight items, and the order matters more than the items: a paid diagnostic, a freeze date, bank and card tie-out to every statement, duplicate removal, chart and categorization by rule, balance-sheet tie-outs to outside documents, a P&L read, and a memo. Run in that order, a cleanup lands on budget. Run in any other order, the categorization step gets done twice and the quote doubles.

We run an accounting firm, and about a third of our new-client work starts as a catch-up engagement. This is the checklist our staff runs, written so you can put it in your own engagement template. For the reasoning behind the sequence, we wrote why a cleanup is a sequence, not a project; this is the operational version.

The checklist

1. Diagnostic (paid, two to three hours): last provably-correct balance sheet date, unreconciled months per account, Uncategorized and Ask My Accountant totals, Undeposited Funds balance and age, loan balances versus lender statements, duplicate count.
2. Freeze date: the last date the balance sheet was right, written into the engagement letter.
3. Bank and card tie-out: every account, every month, from the freeze date forward, to the statement.
4. Duplicates: transactions and vendors, removed or reversed with a note.
5. Chart and categorization: fix the chart first, then code by payee rule, then judgment.
6. Balance-sheet tie-outs: loans, payroll liabilities, sales tax, Undeposited Funds, intercompany.
7. P&L read: month by month, human eyes, one batched question list.
8. Memo: what was wrong, what was fixed, what couldn't be, what the preparer needs, what changes.

Step 0: the paid diagnostic

Nothing gets fixed in the diagnostic. It measures. Someone opens the file and produces a single page with numbers on it: the last month each bank and card account was reconciled, the dollar total sitting in Uncategorized, the count of transactions in Ask My Accountant, the Undeposited Funds balance and how old its oldest item is, each loan's book balance next to the lender's balance, and a count of obvious duplicates from a quick sort by amount and date.

Charge for it, even if it's a few hundred dollars. The charge does three things. It tells you what the job will cost before you quote it. It tells the client the size of the problem in numbers rather than adjectives. And it filters out the prospect who wants a free second opinion on their own DIY books and was never going to sign. Every fixed-fee cleanup we've regretted was one where we quoted from a phone call and skipped the diagnostic.

The diagnostic also decides whether the engagement is a cleanup at all. If the last reconciled month is August and the problem is three months of feed, that's a monthly-close onboarding, not a cleanup, and it should be priced as one.

Steps 1 to 3: every transaction present before anyone touches the P&L

Freeze the starting point. Pick the last date the balance sheet was provably right. Usually it's the last filed return; sometimes it's the last clean reconciliation. Everything before that date is locked. If the client wants earlier years touched, that's a separate engagement with its own diagnostic, because a tax preparer built returns on those numbers.

Tie every bank and card account to its statements. Month by month, from the freeze date to today. Don't categorize anything. Don't fix vendor names. The only goal is that every transaction the bank saw exists in the ledger and every month ties. Missing deposits and missing expenses surface here because the statement is the truth and the books have to match it. When a month won't tie, the difference between the uncleared list and the statement tells you exactly what was never entered or was entered twice.

This is the step where firms lose the most time when they skip it. A transaction categorized in week one that turns out to be a duplicate in week three is work done twice, and a bookkeeper who has already coded 400 lines resists deleting any of them.

Kill the duplicates. With every account tied, duplicates are visible: the check that was also entered as a bill payment, the deposit recorded from the invoice and again from the feed, the vendor bill paid twice in the books and once in reality. Delete them in open periods; reverse them with a note in closed ones. Merge the vendor list at the same time. Eleven versions of the same utility company are a categorization error waiting to happen in step 5.

Steps 4 to 6: categorize by rule, tie every balance-sheet account, batch the questions

Fix the chart before the transactions. The 140-account chart the last bookkeeper built collapses into one the owner can read, with old accounts mapped to new. Then sort Uncategorized by payee. The same payee almost always gets the same account, so a rule written once codes the next two years. What survives the rules is the genuine judgment work, and it's usually a tenth of what the pile looked like.

Tie every balance-sheet account to something outside the books. Loans to the lender statement, with interest split from principal. Payroll liabilities to the payroll reports and the filed 941s. Sales tax to the filed returns. Undeposited Funds to zero, because cash received and never deposited went somewhere: an owner draw, an expense paid in cash, or a duplicate sale. Intercompany to the other entity's books. An account you can't tie to anything is a finding for the memo, not a plug.

Read the P&L month by month. This is the human step. A month with no rent expense. Revenue that doubled and vanished. The owner's personal spending in Office Expense. Cost of goods with no matching sales. Each is either a fix or a client question. Batch the questions into one list with the transactions attached, send it once, and ask for answers within ten business days. Clients answer one list. They do not answer forty emails.

Write the memo. Two pages: what was wrong, what was fixed, what couldn't be fixed and why, the prior-period adjustments the tax preparer needs to know about, and what has to change so it doesn't recur. That last section is where the monthly close gets sold, because the books were a mess for a reason, and the reason is almost never that the last bookkeeper was incompetent. Nobody owned the close.

Pricing the cleanup as a fixed fee per month

Quote from the diagnostic, per month of catch-up, with a floor. The per-month rate scales with account count and transaction volume, both of which the diagnostic gave you. Two clauses protect the fee: a change-order rate for any account or year outside the diagnostic, and a clause that the fee assumes the client answers the batched question list within ten business days.

Hourly cleanups punish the efficient firm and make the client anxious about every email. A fixed fee from a real diagnostic is the version both sides like, and the diagnostic fee is what makes the fixed fee safe to quote.

Why Q4 is the month to sell cleanups

The owner who ignored the books all year starts feeling the tax return in October. The extended returns are due October 15, the calendar-year close is ten weeks out, and the "can you just get this caught up" calls start. A firm with a productized cleanup (diagnostic, freeze date, eight steps, fixed fee, memo) closes those calls at a real price. The firm that quotes hourly from a phone call does the same work for less money and more stress.

There is a second reason. Every cleanup finished in Q4 becomes a monthly-close client in January, because the memo's last section already made the case, and the client just paid for a year of catch-up they'd rather not repeat.

Where the platform comes in

Woven is our product, built inside our own firm, and the checklist above maps to what it does out of the box: statement import that reads the bank's own PDF and ties it line by line against the ledger for step 3, a duplicate finder and many-to-one vendor merge for step 4, categorization rules learned from the bookkeeper's first choice for step 5, a loan sub-ledger tied to lender statements for step 6, and one batched question list sent through the client portal for step 7. Firm pricing is per client at $39, $32, or $25 a month depending on volume, and bank connections are free. If you'd like to watch the sequence run on a real catch-up file, book a demo.