Fixing your books

7 signs your books need a cleanup (and how one works)

Books don’t announce that they’re broken. They keep producing reports, the reports keep looking official, and the numbers drift further from reality every month. Here are the signs I look for when an owner asks me whether their books need professional cleanup, and what the cleanup involves when the answer is yes.

The 7 signs

1. Your reports surprise you in ways you can’t explain. You know your business. When the P&L says you made $18,000 in a month that felt tight, or shows a loss in your busiest season, and nobody can explain why, the books are talking about a business that isn’t yours.

2. Nothing has been reconciled in months. Reconciliation is matching your books to your bank statements until they agree. Skip it and errors accumulate silently: duplicates, missing transactions, amounts that never matched. Ask yourself when each account was last reconciled. If the answer is a shrug, that’s the sign.

3. “Uncategorized” or “Ask My Accountant” is a top category. Those parking-lot categories are where decisions went to wait. A few entries is normal life. Hundreds of them means your reports are built on a foundation of “we’ll figure it out later,” and later never came.

4. Business and personal spending share accounts. The business card bought groceries; the personal card bought inventory. Every mixed month makes your true business picture blurrier and your tax position shakier. This one deserves its own article, and it has one: mixing business and personal expenses.

5. Your bank balance and your books disagree. The books say $22,000; the bank says $9,400. Some gap from timing is normal. A large, persistent, unexplained gap means transactions are missing, duplicated, or wrong.

6. Income looks bigger than reality. The expensive one. Refunds never recorded, transfers between accounts counted as revenue, loan deposits booked as income. I’ve cleaned up books where the owner was making decisions, and about to pay taxes, off income that was overstated.

7. Your CPA sent the books back. When a tax preparer returns your file with a list of questions you can’t answer, that’s a professional telling you, politely, that the books need a cleanup before they’ll stand behind a filing.

What a professional cleanup involves

When I take on a cleanup, the work runs in a consistent order:

  1. Review and honest assessment. I look through the file first and tell you what I find, including what’s fine. You get scope, timeline, and price before anything changes.
  2. Reconcile everything. Every bank, credit card, and loan account matched to statements. This is where duplicates and missing months surface.
  3. Recategorize. Transactions moved to categories that match how your business runs, so reports mean something.
  4. Separate business from personal. Cleanly recorded, so your P&L reflects the business alone.
  5. Fix the structural stuff. Overstated income corrected, transfers untangled, payroll entries matched to filings.
  6. Document. You get a record of what changed and why, which your CPA will appreciate more than flowers.

One project from my desk: 18 to 19 months of messy, unreconciled books. The owner had stopped opening QuickBooks entirely. A few weeks later they had reports they could read, books their CPA could file from, and, their words, a weight gone.

After the cleanup

A cleaned file that goes back to the same habits is a subscription to future cleanups. It’s why I pair cleanup projects with ongoing monthly service, planned as at least a year together. Fix it once, then keep it fixed; that’s the whole strategy.

If you recognize your books in more than 2 of the signs above, get a review. A good bookkeeper will look before quoting, tell you plainly what’s needed, and skip the judgment. Whatever state your file is in, I’ve seen worse.

Quick answers

What is a bookkeeping cleanup?

A cleanup fixes books that exist but are wrong. It means recategorizing transactions, removing duplicates, reconciling every account against statements, separating business from personal spending, and documenting what changed.

How do I know if my QuickBooks needs a cleanup?

The reliable test: do you trust your reports enough to make a decision from them? If your P&L surprises you in ways you can't explain, your accounts haven't been reconciled in months, or your uncategorized pile keeps growing, it needs a cleanup.

How long does a QuickBooks cleanup take?

It depends on how many months and accounts are affected. Focused cleanups take days; an 18-month tangle takes weeks. A bookkeeper should review your file first and give you a scope and timeline before starting.

Can I clean up my books myself?

If the problems are small and recent, yes, start with reconciling every account. Deep tangles usually cost more in owner-hours than a professional cleanup costs in dollars, and DIY fixes on top of miscategorized history often compound the mess.

Rather hand the books to someone who does this all day?

Dave offers a free consultation: a conversation about your business, a look at your books, and a straight answer about what they need.