Bookkeeping · Cleanups & Fixes · Guide · Working level
The books cleanup playbook: rescuing a ledger nobody has touched in months
A phase-by-phase sequence for cleaning up neglected books: start with bank reconciliations, triage in one hour, decide rebuild versus repair, and keep the business running while you dig out.
Books that nobody has touched for six months are not fixed by opening the software and "catching up." They are fixed by working a sequence: reconcile the cash accounts first, then let every downstream problem — miscategorized expenses, phantom receivables, negative liabilities — fall out of a ledger you can finally trust. Bank reconciliations come first, always, because the bank statement is the one record in the whole mess that a third party produced.
This playbook covers the full arc: a one-hour diagnostic, the phase order, the rebuild-versus-repair decision, and how to keep current operations running while you excavate the past.
Why bank reconciliations come first
Everything in a ledger is an assertion someone typed. The bank statement is the only document in the pile produced by an institution with no stake in how the books look. Reconciling cash to the statements does three things at once: it proves which transactions are real, it surfaces duplicates and gaps mechanically (they show up as unmatched items), and it gives you a hard boundary — once a month reconciles, you know its cash activity is complete and you never have to wonder about it again.
Start any other way and you will do work twice. Categorize before reconciling and you will categorize duplicates that later get deleted. Chase receivables before reconciling and you will dun customers whose payments are sitting unmatched in the feed. Reconciliation is the load-bearing wall; see /bookkeeping/cleanups-fixes/uncleared-transactions-cleanup for handling the ancient items it will surface.
The one-hour diagnostic
Before quoting a timeline — to a client, a boss, or yourself — spend one hour measuring the damage. You are counting, not fixing.
Run this checklist and write down the numbers.
| Step | What you do | What proves it's done |
|---|---|---|
| 1 | Count unreconciled months per bank and card account | A list: account, last reconciled date |
| 2 | Count uncategorized/suspense transactions | One number per holding account |
| 3 | Pull the balance sheet, all dates, and circle anything negative or frozen | Marked-up balance sheet |
| 4 | Check Undeposited Funds (or equivalent clearing account) balance | Dollar amount and age of oldest item |
| 5 | Compare payroll liability accounts to the last filed Form 941 | Match / no-match note per quarter |
| 6 | Note the last filed tax year and whether books were adjusted after filing | Filed-through date |
| 7 | Ask: bank feeds connected the whole time, or gaps? | Feed coverage map by month |
The balance sheet review in step 3 is its own discipline — /bookkeeping/cleanups-fixes/diagnosing-balance-sheet-problems walks through the symptom patterns. For scoping, you only need the count of wrong-looking lines.
A planning rule that holds up in practice: two to four hours per neglected month for a service business with one checking account and one card. Inventory, payroll corrections, or multiple entities can double it. The diagnostic tells you which multiplier applies.
Illustrative allocation for a single-entity service business; inventory or payroll problems shift the mix.
Rebuild or repair?
The most expensive mistake in cleanup work is repairing a file that should have been abandoned. The second most expensive is rebuilding one that needed a week of repairs.
Use this decision table before touching a transaction.
| Factor | Points toward repair | Points toward rebuild |
|---|---|---|
| Age of mess | Under ~18 months | Multiple years unreconciled |
| Source of entries | Mostly bank feeds | Heavy manual entry, imports gone wrong |
| Chart of accounts | Sane, under ~80 accounts | Duplicated, nonsensical, hundreds of accounts |
| Duplicates | Scattered | Systemic (feed reconnected repeatedly) |
| Open AR/AP | Mostly real | Mostly fiction |
| Filed returns | Books match filings | Books never matched any filing |
A rebuild means a new file (or a new start date in the same platform): enter opening balances from the last filed tax return and the bank statements, bring forward only genuinely open invoices and bills, and archive the old file read-only for history. The mechanics are the same as a software migration — /bookkeeping/cleanups-fixes/migration-cleanup-new-software covers the opening-balance entries and the cutover checklist.
The cleanup sequence
Once you have chosen repair, work the phases in order. Each phase assumes the ones before it are done; skipping ahead creates rework.
The full sequence, in the order the dependencies demand.
| Phase | Work | Depends on | Exit test |
|---|---|---|---|
| 1 | Reconcile every bank and card account, oldest month first | Statements gathered | Every month reconciles to the statement with no forced plugs |
| 2 | Kill duplicates surfaced by phase 1 | Phase 1 | No transaction appears twice; see /bookkeeping/cleanups-fixes/duplicate-transactions-fix |
| 3 | Categorize everything in suspense and uncategorized accounts | Phases 1–2 | Suspense balances are zero |
| 4 | Clean AR: apply unapplied payments, write off or fix stale invoices | Phase 3 | AR aging contains only genuinely open invoices |
| 5 | Clean AP: apply credits, mark bills paid outside the system | Phase 3 | AP aging matches vendor statements |
| 6 | Tie payroll and sales tax liabilities to filed returns | Phases 1–3 | Liability accounts match the last filed quarter |
| 7 | Fix remaining balance sheet accounts: loans to amortization schedules, fixed assets, equity | Phases 1–6 | Every balance sheet line is explainable |
| 8 | Preparer review of any adjustments touching filed years | All | Preparer sign-off, closing date set |
Phase 7 is where depreciation catch-up usually appears; the entries follow the same logic as any depreciation posting — see /fundamentals/depreciation-basics on the tax desk for how the schedules are built.
Most corrections in phases 4 through 7 are ordinary transactions — applying a payment, voiding a duplicate — not journal entries. Resist the urge to fix everything with a journal entry; that habit is itself a mess to clean up later (/bookkeeping/cleanups-fixes/journal-entry-abuse-cleanup). When a true adjusting entry is warranted — say, a year of missed depreciation on equipment in a still-open year — post it explicitly and document it:
| Account | Debit | Credit |
|---|---|---|
| Depreciation expense | 4,800 | |
| Accumulated depreciation — equipment | 4,800 |
Post catch-up entries only in open years; adjustments to filed years go through the tax preparer.
Keeping the business running while you dig out
A cleanup that lets three new months pile up behind it has failed. Run two tracks from day one:
- Stabilize the present. Connect or repair the bank feeds, categorize new activity weekly, and reconcile each new month within days of the statement arriving. This takes an hour or two a week and stops the hole from growing.
- Work the backlog oldest-first. Old months first, because later months inherit their errors — an uncategorized January deposit becomes a February reconciliation problem.
- Protect finished work. As each backlog month passes its exit test, set the closing date (with a password where the software offers one) forward to cover it. Nothing you fixed can silently un-fix itself. The habit matters beyond cleanups — see /bookkeeping/cleanups-fixes/retained-earnings-changed for what happens without it.
- Report honestly in the meantime. Until the cleanup reaches a given month, label any report from it "unreconciled — subject to cleanup." Lenders and owners can work with a caveat; they cannot work with numbers that quietly change next month.
When to involve the tax preparer
Three trigger points, in ascending urgency:
- At scoping, if any neglected period crosses a filed return. You need the return as filed to know what the books must tie to.
- Before posting any adjustment dated in a filed year. The preparer may want the adjustment pushed into the current year instead, or may need to amend.
- Immediately, if the diagnostic reveals unfiled payroll or sales tax returns. Those carry penalties that grow monthly, and they outrank every cosmetic problem in the ledger. Payroll tie-out mechanics are in /bookkeeping/cleanups-fixes/payroll-liabilities-wrong; the filing framework is IRS Form 941 and Publication 15.
Where this playbook does not apply
Two honest limits. First, if the entity has no records at all — no feeds, no statements retrievable, cash-heavy operations — this is a reconstruction engagement, not a cleanup, and it starts with Publication 583-style record rebuilding from bank subpoenas of your own accounts, not from software. Second, if the books were manipulated rather than neglected — revenue invented, expenses hidden — stop treating it as bookkeeping. Cleanup assumes error; deliberate misstatement is a matter for the owner, the preparer, and possibly counsel before any entry is touched.
After the cleanup: making it stick
The last phase of every cleanup is preventing the next one. Set a monthly close checklist (reconcile, review suspense, review agings, lock the period), calendar it, and treat a missed month as an incident rather than a norm. Books rot at a constant rate; the only variable is how long you let them.
Frequently asked questions
- Where do you start when cleaning up months of neglected bookkeeping?
- Start with bank and credit card reconciliations, oldest month first. Reconciliations anchor the books to an external source of truth — the bank statement — and every other cleanup task depends on knowing that cash is right. Categorization, receivables, payables, and payroll corrections all come after the cash accounts tie to the statements.
- Should you rebuild neglected books from scratch or repair the existing file?
- Repair when the chart of accounts is sane, most transactions came from bank feeds, and the mess is under roughly eighteen months old. Rebuild — a fresh file with clean opening balances — when the ledger has years of unreconciled activity, a chaotic chart of accounts, or so many duplicates that deleting them costs more than re-entering from statements.
- How long does a bookkeeping cleanup take?
- A rough planning rule: two to four hours per neglected month for a simple service business with one bank account and one card, more with inventory, payroll problems, or multiple entities. A one-hour diagnostic pass — counting unreconciled months, uncategorized transactions, and negative balances — will tell you which end of the range you face.
- When should the tax preparer get involved in a cleanup?
- Before you adjust anything in a year that has already been filed. Retained earnings, prior-year expenses, and closed-period balances feed filed returns; changing them without the preparer's knowledge creates a books-to-return mismatch. Involve the preparer at the scoping stage if any neglected period crosses a tax filing.
- Can the business keep operating while its books are being cleaned up?
- Yes — run two tracks. Keep current months live: categorize the bank feed weekly and reconcile each new month on time, so the hole stops growing. Work the backlog separately, oldest month first. Never let cleanup of the past crowd out maintenance of the present; a cleanup that lets three new months pile up has failed.