Key takeaways
What this article covers, in order:
- What does "messy" actually look like?
- The 7-step clean-up plan at a glance
- Step 1: Pick a clean starting line
- Step 2: Collect every statement since then
- Step 3: Get every transaction in exactly once
- Step 4: Fix categories in batches, biggest dollars first
Messy books get fixed by working forward from a point you trust, not by poking at whatever looks wrong today. Choose a clean starting line, get every transaction in exactly once, fix categories in batches, reconcile month by month, sort out debtors and creditors, then lock the cleaned months. Here's how to clean up messy bookkeeping in seven steps, with the traps that catch people halfway through.
What does "messy" actually look like?
Ben and Kiri run a small joinery workshop in Bendigo. Their accountant finalised the books to 30 Jun 2026 and handed back a clean balance sheet. Then the busy season hit. By early Oct 2026, this is what their file looked like:
- A bank feed and a CSV import that overlapped for three weeks in Jul 2026, so dozens of transactions appeared twice
- About $14,000 of spending categorised as "General expenses" because it was quicker
- A suspense account holding $6,480 of "I'll sort it later"
- A receivables report showing $11,300 owing, when they were fairly sure customers owed about half that
- Bank balance in the books: $21,904.55. Bank balance at the bank: $18,377.10
If some of that sounds familiar, you're in good company. None of it is a disaster. It's just three months of shortcuts stacked on top of each other, and they come apart in the reverse order they went on.
The 7-step clean-up plan at a glance
| Step | What you do | Why it comes here |
|---|---|---|
| 1 | Pick a clean starting line | Everything else is measured from it |
| 2 | Collect every statement since then | You can't reconcile what you can't see |
| 3 | Get every transaction in once | Duplicates poison every later step |
| 4 | Fix categories in batches | Biggest dollars first, so the P&L is useful sooner |
| 5 | Reconcile month by month, oldest first | Each month's closing balance is next month's opening |
| 6 | Clean up debtors and creditors | Bank can tie while receivables are still wrong |
| 7 | Lock the cleaned months and set a routine | Stops it happening again |
Step 1: Pick a clean starting line
You need a date where you know the balances are right. For Ben and Kiri that's easy: 30 Jun 2026, the balance sheet their accountant finalised. For others it might be the last month you reconciled properly, or the day you opened the business account.
Check that the opening balances in your books match that point exactly: bank, card, loans, receivables, payables. If they don't, stop and talk to your accountant before going further. Never edit a year your accountant has already finalised without asking them first; their figures may already be relied on.
Step 2: Collect every statement since then
Download statements for every account from the starting line to today. Bank accounts, credit cards, loans, any payment platform that pays into your bank. Save them in one folder named by account and month. It's dull, but it's the only source of truth you've got for the clean-up.
Step 3: Get every transaction in exactly once
Duplicates are the single biggest reason clean-ups stall. They usually come from three places:
- Turning on a bank feed and also importing a CSV for the same dates
- Entering a transaction by hand, then the feed bringing in the same one
- Importing the same CSV twice
Sort the bank account by date and amount and look for identical pairs. Ben and Kiri found 41 duplicates, every one in the three-week overlap. Delete the extra copy rather than "reversing" it with another entry; a reversal leaves two wrong lines instead of one.
If you have accounts with no feed, import the statement CSV once and note the date range you imported, so nobody imports it again.
Step 4: Fix categories in batches, biggest dollars first
Don't go line by line from the oldest transaction. Instead:
- Filter to the junk categories ("General expenses", "Uncategorised", "Sundry").
- Sort by payee. Recategorise every transaction from one payee in one go.
- Sort what's left by amount, largest first.
A handful of big items usually explains most of the dollars. Ben and Kiri's $14,000 of general expenses turned out to be mostly a timber supplier ($8,900) and a machinery service ($2,300). Two decisions fixed four-fifths of the problem. The last few hundred dollars of small items can be done in one sitting later.
Keep GST coded correctly while you're there. If you're unsure about a code, note it for your BAS agent or accountant, who handles lodgement.
Step 5: Reconcile month by month, oldest first
Start with the first month after your clean starting line. Reconcile it to the statement closing balance, then move to the next month. Don't skip ahead to the current month: a closing balance only means something if the opening balance under it was right.
Once duplicates were gone, Ben and Kiri's Jul 2026 tied to the cent. Aug 2026 was out by $1,200, which turned out to be a transfer to their savings account that had been entered on the savings side but never taken out of the transaction account in the books. Sep 2026 tied first go. The $3,527.45 gap they started with was the duplicates plus that one transfer.
When a month won't tie, the difference is almost always in that month. Look there before blaming earlier months.
Step 6: Clean up debtors and creditors
Here's the step most clean-ups miss, because once the bank ties people assume they're done.
Ben and Kiri's receivables showed $11,300 owing. The problem: when customers paid, the deposits were coded straight to "Sales" instead of being matched to the invoice. So the invoice stayed open and the income was counted twice, once when invoiced and once when paid.
For one customer who paid $2,750 against invoice 1187, the correcting journal is:
| Account | Debit | Credit |
|---|---|---|
| Sales | $2,750.00 | |
| Accounts receivable | $2,750.00 | |
| Total | $2,750.00 | $2,750.00 |
In practice it's usually cleaner to recode the original deposit so it clears the invoice directly, which does the same thing and keeps the audit trail tidy. After working through them all, real receivables came to $5,640.
Do the same on the payables side: bills marked unpaid that were actually paid, and duplicate bills entered from both an email and a paper copy.
If you find genuinely uncollectable invoices, ask your accountant how they'd like bad debts written off before you touch them.
Step 7: Lock the cleaned months and set a routine
Once a month reconciles and debtors and creditors agree, lock it. That protects the work you've just done from a stray edit.
Then set a routine so you don't end up back here:
- Weekly (15 minutes): confirm the review list, send invoices for finished work
- Monthly (an hour or two): reconcile each account, check receivables and payables against the balance sheet, lock the month
Clean-up traps to avoid
- Forcing a balance. Posting a "reconciliation adjustment" for the whole difference hides the real errors. Leave unexplained amounts in suspense with notes.
- Working on the current month first. It feels urgent, but it's built on months that aren't right yet.
- Recategorising before removing duplicates. You'll fix the category on both copies, then delete one, and waste the time.
- Doing it all in one weekend. Three focused sessions beat one exhausting marathon where the errors start creeping back in.
How HelloBooks helps
In HelloBooks you can connect your bank account (most Australian banks and cards) and import CSV statements for anything you can't connect. Transactions land in a review list where you confirm or change categories. On the reconcile screen, each statement line comes with an AI match suggestion, a confidence score and the reason it picked that match, so you only deal with the exceptions; a wrong match can be unmatched in one click. Each reconciled period produces a report showing opening balance, cleared items, outstanding items and closing balance, exportable as PDF or CSV, and once signed off it can be locked, with any reopening logged. Aged receivables and payables reports help with step 6. See the full bookkeeping features or the bank reconciliation page.
If you're coming from another system and the clean-up feels like the moment to switch, we move your books for you. Pro (A$30/month) adds AI auto-categorisation, which helps keep things clean afterwards; more on automated bookkeeping.
FAQs
How long does a bookkeeping clean-up take?
It depends on how far back you go and how many accounts you have. Three months of one bank account might take a couple of sessions. A year across several accounts and cards is a bigger job, and that's often where a bookkeeper earns their fee.
Should I start again from scratch?
Rarely. If you have a trustworthy starting balance sheet, it's faster to fix forward from it. Starting from scratch only makes sense when the opening balances themselves are unknowable.
Can I just delete everything and reimport the bank?
You can delete duplicate bank transactions, but invoices, bills and payments matched to them carry information the bank doesn't have. Wiping everything usually creates more work than it saves.
What if I can't work out what a transaction was?
Put it in suspense with a note: date, amount, what you've checked. Ask the bank for details if it's large. An explained suspense balance is far better than a guess.
Should I tell my accountant I'm doing a clean-up?
Yes, before you start. They can confirm your starting line and tell you how they'd like corrections to prior periods handled.
Take it one month at a time and the mess shrinks faster than you'd think.
Start free, no card needed. Try HelloBooks Free
