How to clean up messy books without redoing the same month twice
Clean up books in this order: collect every statement, set opening balances from the last period your accountant signed off, then reconcile each account one month at a time, oldest first. Only once a month ties do you pair transfers, remove duplicates, place uncategorized lines and move owner spending out. A different order means categorizing lines you later delete.
The worked figures below belong to a fictional design studio whose books stopped being kept in February. They are illustrative only.
What has to happen before any categorizing?
Step 1: Build a statement grid
Accounts down the side, months across the top. Tick a cell when you hold that month's statement as a PDF from the bank. Our studio has checking, savings and one card across eight months, so the grid has 24 cells. Any blank cell is a month you can't prove yet, so request it today. Activity downloads don't count, because they don't print an opening and closing balance.
Step 2: Fix the start date and opening balances
Start the day after the last year end your accountant signed off. Each account's opening balance must equal that day's statement balance. Leave the signed-off year untouched, and list anything odd you find in it for the accountant.
How do you reconcile without going in circles?
Step 3: One account, one month
A month ties when its lines add up from the printed opening to the printed closing, its opening matches last month's closing, and the ledger agrees with the closing on the last day. Stay on a month until all three hold.
| Account | Months | Tied | First month off | Gap |
|---|---|---|---|---|
| Checking 6610 | 8 | 6 | May | 214.00 |
| Savings 6618 | 8 | 8 | 0.00 | |
| Business card 4402 | 8 | 5 | April | 1,050.00 |
Fictional cleanup status. A gap equal to one line's amount usually means that line is missing; twice a line usually means a wrong sign.
A gap that stays the same every month points to one old mistake. A gap that grows points to a rule repeating one.
What comes after the months tie?
Step 4: Pair transfers and strip duplicates
Money moving between the studio's own accounts is a transfer on both sides. A card payment is a transfer too. A deposit typed in by hand and imported again from the statement stays once.
Step 5: Place the uncategorized lines
Give each one a real account. The ones no document explains, like a cash withdrawal or a payment to a person, go on one list for the owner, answered in one sitting.
Step 6: Move owner spending
Personal charges on the business card go to owner draws. Profit usually goes up when this is done, which is worth knowing before tax time.
Step 7: Review, then lock
Read each month's profit and loss against what you know. A month with no rent or two months of payroll is a flag. Once that read-through is done, lock the cleaned months against accidental edits.
Key takeaways
- Get every statement as a PDF first. A month without one can't be proven.
- Opening balances come from the last signed-off year end, which stays untouched.
- Reconcile oldest month first and don't move on until it ties to the cent.
- Categorize only after the months tie, then lock them.
FAQ
How long does a bookkeeping cleanup take?
Mostly as long as it takes to collect the statements. Months with every statement in hand move quickly. A bank that needs weeks to send an old statement sets the pace.
Should a cleanup change a year that was already filed?
No. Leave it as filed and write down anything you find for your accountant to decide.
Is a cleanup the same as catch-up bookkeeping?
They overlap. Catch-up fills months that were never done. Cleanup also fixes months that were done wrongly, which is why each one is reconciled again.
The full order of work, with a worked nine-month example, is in the ZeraBooks guide to bookkeeping cleanup.
Disclosure: I'm the founder of ZeraBooks. We quote cleanups after a free call and prove every month against its statement before it's finalized. Ongoing ZeraBooks bookkeeping starts from $150 a month in U.S. dollars, with a read-only login and an upload portal.
Comments
Post a Comment