How to Plan a Major QuickBooks Cleanup When the Books Don't Match the Bank

Taking over a set of books that someone else kept badly is one of the hardest jobs in practice work. The ledger says one thing, the bank says another, and every layer you peel back reveals more of the same. We see this pattern often, and there is a sane way through it.

What a deep cleanup usually uncovers

The classic signature is a bank balance in QuickBooks that drifts far from the real bank balance. When you dig in, you typically find a cluster of related faults: deposits recorded manually but never matched to the bank feed, real bank transactions excluded from the feed to keep the reconciliation “clean,” and credit memos used for purposes they were never meant for, such as tracking restricted-fund disbursements. A large negative Accounts Receivable balance is a frequent companion symptom.

None of this is a QuickBooks bug. It is a workflow problem: someone forced the books to reconcile instead of making the books reflect reality.

Should you undo the reconciliations?

Sometimes, yes. If deposits were fabricated and real bank lines were excluded, the reconciliations built on that foundation are not trustworthy. Unreconciling, deleting or voiding the false entries, and re-matching the genuine bank transactions is the honest fix.

But do not start there. First, scope the damage. Pick a sample period, compare the excluded-transactions list against actual bank statements, and estimate how far back the problem goes. That tells you whether this is a targeted repair or a full rebuild, and it lets you give the client a realistic estimate before you burn hours.

A workable sequence

1. Pull bank statements for the affected period and export the excluded and manually entered transactions from QuickBooks.
2. Build a reconciliation worksheet outside QuickBooks so you can see, line by line, what the bank recorded versus what the books recorded.
3. Fix in dated order, oldest first, so downstream balances stay consistent.
4. Reconcile each month as you complete it, so you always know your progress.
5. Document everything with screenshots and a running log, both for the client and for your own file.

What this means for the client relationship

Set expectations early. A cleanup like this is not a few journal entries, and quoting it as one will hurt both parties. Give the client a written scope, an estimate range, and a point at which you will reassess. If a prior preparer was paid for cleanup work that missed the core problem, say so factually and let the documentation speak.

If the damage turns out to sit in the company file itself, or the file is too tangled to repair in place, our colleagues at ledgerclinic.com cover what broken books do to a set of ledgers and how a practice-grade rebuild is structured, and qbo.support has step-by-step help on undoing reconciliations and managing bank feed exclusions in QuickBooks Online.

The most useful next step is a scoping pass: one month, fully traced from bank statement to ledger. That single exercise will tell you, and your client, exactly how big this project really is.