A cleanup is not one task — it's a sequence. Work it in order and the books come back into agreement with the real world one account at a time.
1 · Establish the starting point
Before touching a single transaction, back up the company file and confirm the cleanup start date with whoever owns the books. Everything before that date is history you reconcile; everything after is what you'll keep current. Skipping this step is how cleanups turn into do-overs.
2 · Reconcile every account
Reconciliation is the spine of the cleanup. For each bank and credit-card account, tie the QuickBooks balance to the statement, month by month, until the difference is zero. Unreconciled accounts are the single most common reason a small-business file can't be trusted.
3 · Correct categorization
With balances tied out, fix how transactions are classified: miscategorized expenses, personal charges booked to the business, duplicates, and the undeposited-funds account that silently inflates income. Consistent categorization is what makes the P&L mean something.
A note on undeposited funds
The undeposited-funds account is where deposits go to be grouped before they hit the bank. Left unmanaged, it accumulates phantom balances that overstate revenue. Clearing it is tedious and worth every minute.
A stale undeposited-funds balance is one of the most common things we find in reviewed files — if yours carries one, clearing it belongs on the cleanup list, not the someday list.
4 · Review and hand back
Finish with a pass over the financial statements — does the balance sheet balance, does the P&L read the way the business actually ran? Document every material change so the owner (or their CPA) can follow what happened and why. A cleanup nobody can audit isn't finished.
Questions about cleaning up QuickBooks yourself
Can I clean up QuickBooks myself?
Yes — the method in this guide is the same one a specialist follows. The realistic limits are time and the trickier messes (opening balances, multi-year reconciliation, a file that won't reconcile). If you get stuck on those, that's the moment to bring in help.
How far back should I go?
As far back as the books need to be trustworthy for their purpose — usually the current tax year at minimum, often the prior year too. If you're filing or seeking financing, reconcile every period that will be relied on.
What do I need before I start?
A backup of the company file, statements for every bank and credit-card account in the cleanup period, and admin access to QuickBooks. Gathering the statements in one place before you begin is what keeps reconciliation moving month by month.
How do I know the cleanup is finished?
Every account reconciles to the statement with a zero difference, the balance sheet balances, the P&L reads the way the business actually ran, and every material change is documented. If any of those is missing, the cleanup isn't done yet.