How to Clean Up Messy Accounting Books

Every accountant and bookkeeper knows the feeling: a new client hands you a login and says the books are “basically done. This should be easy for you.” You open the file and the balance sheet has a $14,000 balance in Undeposited Funds, three checking accounts that haven’t been reconciled since last spring, and a chart of accounts with four different versions of “Office Supplies and Miscellaneous Expenses.” The books aren’t done. They’re a mess. And somebody has to clean them up.

This guide walks through how to do exactly that — the same order a seasoned accountant works in, so you fix the foundation before you polish the details. Whether you’re cleaning up your own business or you do this for a living, the process is the same.

What “clean books” actually means

Clean books aren’t about being tidy for its own sake. They’re books you can trust. That means every number on the financial statements traces back to something real:

• Every number can be proven — tied to a source document or some kind of “proof” of existence and occurrence.
• Bank and credit card balances match the actual statements.
• The balance sheet only contains assets and liabilities that truly exist.
• Income and expenses are categorized consistently and correctly.
• There are no mystery transactions, duplicates, or “ask my accountant” entries left hanging.

If you can’t trust the balance sheet, you can’t trust anything else in the books.

Signs your books need a cleanup

First, if you think the books need to be cleaned up, they probably do. You likely already suspect it, but here are some clues:

• Accounts haven’t been reconciled in months (or ever).
• The balance sheet has numbers nobody can explain.
• When you look at your bank balances, do they look right?
• Undeposited Funds still has payments received months ago.
• A clearing account that keeps growing.
• The chart of accounts has duplicates and one-off categories.
• Accounts receivable shows invoices that were paid long ago.
• Your A/R aging has negative balances.
• Personal and business spending are mixed together.

Catch-up vs. cleanup: which one do you have?

These get used interchangeably, but they’re different jobs. Catch-up bookkeeping means transactions were never recorded — you’re behind and need to get current. Cleanup bookkeeping means the entries exist but are wrong, miscategorized, or unreconciled.

Most real projects are both: catch up the missing months first, then clean up what’s already in the file. Figure out which you’re dealing with before you start, because it changes the order of operations. Hint: in many cases you need both, but the distinction is important to understand.

The step-by-step cleanup process

The balance sheet is your checklist. In fact, even after the books are clean, this is how you keep them clean — by reviewing the balance sheet weekly and monthly.

The balance sheet is where errors hide and compound, and getting it right is what makes the profit & loss trustworthy. Do it one period at a time so the work stays reviewable.

1. Reconcile every bank and credit card account

This “should” be obvious, but in my career I’ve run into many business owners who, for example, didn’t realize that you reconcile credit card accounts just as you do every bank account.

This is usually the first way you force out errors and omissions. If your reconciliation balances every month and you don’t plug in any numbers, then you know you’ve accounted for every transaction that occurred — and at the same time, you flush out anything on the books that never cleared.

The math is simple. Beginning balance + additions − subtractions = ending balance. I don’t care if the difference is $0.10. With a CSV you can sort and find the difference in a minute, so there are no excuses. And while $0.10 may not seem significant, what is significant is that when you’ve been this strict about things, there’s no chance anything is missing or mis-stated.

2. Fix and consolidate the chart of accounts

Your chart of accounts is the spine of your entire accounting system. It drives what your financial reports look like and, with that, how easy or difficult they are to read. Merge duplicate accounts. Get rid of the one-off categories nobody uses. Make sure accounts are the right type (an expense miscoded as an asset will quietly distort everything). A lean, sensible chart of accounts is the difference between reports you can read and reports you dread.

3. Clean up accounts receivable

I’m not sure I ever took on a client in my 30 years of doing this where there weren’t negative amounts in their A/R aging. Review the A/R aging. Almost every client I ever took on also had invoices that were actually paid. Write off what’s genuinely uncollectible, and investigate anything ancient. Stale receivables overstate both your income and what you think you’re owed.

As an accountant, you can quickly win the confidence of a prospective client by searching out the deposit where a payment was booked straight to income and swapping that out with the missing invoice payment to clean up their A/R. It’s an easy thing to do, and it shows them you really know what you’re doing. It also subtly highlights that whoever was doing the books before was asleep at the wheel.

4. Clean up accounts payable

A/P works just like A/R in reverse. Do the same thing on the A/P aging. Old unpaid bills that were actually paid (or were never real) inflate your liabilities. Match bills to payments and clear the noise. While you’re here, look for where you can take advantage of timely payment discounts. This is a great way to improve cash flow if the company has the cash flow to support it.

5. Resolve unapplied payments and undeposited funds

Here’s the scenario. A payment comes in and someone books it on the invoice, then deposits it into Undeposited Funds. Then they forget to record the actual deposit in the bank account. Then someone catches the missing deposit, figures out what it is, and books it to income thinking, “my job is done here.” This is how many files get messy. If money is sitting in Undeposited Funds going back more than a few days to a week, it’s almost guaranteed to be duplicated income.

6. True up payroll liabilities, loans, and equity

Your payroll liabilities are a special type of clearing account. Money comes out of the paychecks and into the liability. Then payments are made to send that money to the government, reducing the liability. Here’s a quick way to review payroll liabilities — what we’d call a “reasonableness test” in auditing. It may never clear perfectly to $0.00 because of timing differences, and sometimes taxes in small amounts are paid quarterly rather than with each pay run.

Drill into the payroll liabilities account and read the running balance. The pattern should be clear: paychecks come in and the balance increases, then the payments go out and bring it near $0.00. If you see the balance rising, or you see it keep coming back to the exact same number without ever clearing out, something is wrong.

Loan balances should always tie to a statement. Period. Full stop. Get the statement from the bank and reconcile it. Equity is a little trickier but far from impossible — the main thing you want to do here is make sure it agrees with the last filed tax return.

7. Review the balance sheet and P&L

Now do it again. Once you think you’ve cleaned the books up, review the balance sheet line by line. Does it make sense? If there are loans on the books, there should be interest expense. What is the percentage of interest compared to the average loan balance? Does that look reasonable compared to interest rates?

Run these statements monthly so you can analyze patterns and make sure it all makes sense. Question everything, test anything that looks off, and make sure you can prove every number. Compare statements year over year. If revenue went up 30%, did COGS (Cost of Goods Sold) do about the same? Analyze the relationships for the expected behavior. Look for anomalies and test them.

Should you DIY or hire a pro?

You know the expression? You can’t solve a problem with the same mind that created it. If you created the mess, you should probably get help. Then, if you’re inclined, stay involved in the process and learn so you can take it back over. Or you might decide your time is better spent on things you’re better suited to do — things that help the business grow.

If it’s a few simple things, sure — follow this process and fix it yourself. Then if things look OK and you can keep them that way, you’re all good. But if you’re way behind (catch-up) and the balance sheet is full of numbers you can’t explain (cleanup), or a tax deadline is bearing down, bring in a professional who does cleanup and catch-up work for a living. A good bookkeeper or accountant will get it right faster and hand you a clean starting point you can actually maintain. That’s not a failure; it’s leverage.

How to keep them clean after

The cleanup is the hard part. Staying clean is a rhythm: reconcile every account monthly, categorize transactions as they come in with consistent rules, keep personal and business separate, and review your statements every month instead of every April. The right tools make that rhythm almost automatic — which is exactly why we built 🧹Clean Books.

As I said above, it’s the same process applied weekly, or any time you sit down to update your books. Start with the bank accounts (bank feeds and reconciliations) and work your way down, then over to the Profit and Loss. Then review everything. Make sure it makes sense.

Frequently asked questions

Oh, and hey — did you know we have a Clean Accountants and Bookkeepers Directory?

Want the bigger picture on why any of this matters? Read Why Clean. Why Now.