Hundred MSHome / Blog / How to clean up messy books
How to clean up messy books: five steps, in the right order
Stuck on this in your own books?Bring it to a free 30-minute call with Narek. No pitch.
Book a callClean up messy books in this order: pick a cut-off date and stop the mess growing, reconcile bank and card accounts first, rebuild receivables and payables against customer and supplier records, clear suspense and uncategorized accounts, then document what you did and lock the periods. Cash comes first because every other balance depends on it.
- Set a cut-off date and keep new transactions clean while the past is repaired.
- Reconcile cash first. Every other balance depends on it.
- Rebuild receivables and payables from customer and supplier records, not from your own system.
How to tell your books need a cleanup
- The bank balance in the accounting system does not match the bank.
- Customers appear to owe money they say they have paid.
- There is a growing balance in suspense, uncategorized or "ask my accountant".
- Nobody can explain last quarter in two sentences.
- Your tax preparer or an investor has started asking questions you cannot answer.
One of these is a warning. Three or more means decisions are being made on numbers that are wrong, and nobody knows by how much.
Step 1. Pick a cut-off date and stop the mess growing
Choose the date from which the books will be right. Usually that is the start of the current fiscal year, or the last period an accountant signed. From today, new transactions follow a clean process, even while the past is still being repaired. Otherwise you are mopping the floor with the tap still running.
Open your balance sheet and pick the three largest balances. For each one, could you show a document from outside your system that agrees with it today?
Step 2. Reconcile cash first
Bank accounts, credit cards and payment processors, month by month, from the cut-off date forward. Cash is the one area where the truth exists outside your system, on a statement. Once cash is right, every other problem becomes smaller and easier to see.
If the difference will not clear, do not post a plug entry to make it go away. An unexplained difference is information. It is usually a duplicate, a missing deposit or a transfer recorded once instead of twice.
Step 3. Rebuild receivables and payables from outside evidence
Ask your main customers for their record of what they owe you, and ask suppliers for statements. Match invoice by invoice. This is slow, and it is where the real money turns up.
In one cleanup we matched 106 of 106 invoices against the customer's own records and found that the unexplained balance was 19 checks that had been mailed to the wrong address. The full story is here. The usual answer would have been to write the balance off.
Step 4. Clear suspense, uncategorized and undeposited funds
Every line in these accounts is a decision somebody postponed. Work through them oldest first. Group the repeats, because forty lines are often the same monthly charge, and fix the rule that put them there so they stop coming back.
Step 5. Document, then lock
Write down what was wrong, what you changed and why, with the evidence attached. Then lock the repaired periods. If a past tax return is affected, tell your tax adviser before anything else. A cleanup without notes has to be done again the first time someone asks a question about it.
What a cleanup should leave behind
| You should have | Why it matters |
|---|---|
| Reconciliations for every balance sheet account | Proof that each balance ties to outside evidence |
| A list of adjustments with reasons | Your tax adviser and auditor will ask |
| Locked periods | Nobody can undo the work by accident |
| A written monthly routine | So the books stay clean after the cleanup |
Do it yourself, or get help?
If the mess is a few months old and mostly about categorizing, a careful bookkeeper can fix it. Get help when the bank will not reconcile, when receivables or payables are wrong, when more than one system holds the billing, or when a deadline is close: a tax filing, an audit, a funding round or a sale.
Where this goes wrong
| The problem | What it costs you | The fix |
|---|---|---|
| A plug entry forces the bank to reconcile | The real error stays hidden and grows | Leave the difference open until it is explained |
| An old balance is written off unchecked | Real money is lost | Match it invoice by invoice against the other side first |
| Nothing is documented | The cleanup has to be redone when someone asks a question | Keep a list of every adjustment with the reason and the evidence |
Based on our own client work. Cleanups are where many of our clients start, and the receivables example comes from one of them, anonymized. The note on past tax years follows the IRS recordkeeping pages below.
Sources we opened and checked for this guide:
First published 2023. Rewritten and checked in September 2026. If something here is out of date, tell us and we will fix it.
