You already know it’s bad. The question is whether it’s fixable and how much time it’s going to take. It’s fixable, and here’s the actual order to do it in.
Do these out of order and you’ll redo work. That’s the main thing people get wrong.
1. Get current first
Before touching history, get current. Connect the accounts that aren’t connected. Make sure everything from today forward is landing somewhere.
If you clean up old months while new ones keep piling up, you can work for a month and still be behind.
2. Pick your starting line
You need one date where the books were last correct, or a point you’re willing to treat as the beginning.
Usually that’s the last month you reconciled, or the start of a tax year. Everything before it gets left alone. Everything after it gets rebuilt. Without this line, “clean up my books” has no end and you’ll feel like you’re failing the whole time.
3. Reconcile forward, one month at a time
This is the real work and there’s no shortcut.
Take the first month after your starting line. Match every transaction in QuickBooks against the actual bank statement until the ending balance agrees to the penny. Then the next month. Then the next.
Do not skip a month because it looks close. A small unexplained difference in March is still there in November, and by then you’ve built eight months of work on a number that was wrong from the start.
4. Fix categories inside the same pass
While you’re in each month, put things in the right place. Owner draws are not expenses. Transfers between your own accounts are not income. A loan payment splits between principal and interest.
Those four mistakes account for most of what I find in messy books.
5. Deal with the pile you can’t identify
There will be transactions nobody can explain. Everyone has them.
Make a list, go through it once with whatever records you can find, and then make a decision about the rest so none of them are left floating. An honest, documented best guess is worth more than a blank you’ll rediscover next year.
6. Close it and don’t reopen it
When a month reconciles, close it. Lock it if your software allows. Then keep the current month current, so you don’t do this again.
What to know before you start
If you’re three months behind and the file was set up right, this is usually a manageable job to take on yourself, and the steps above are the order I’d do it in.
What’s worth knowing is that it compounds. Catch-up work is priced by how far back it goes, so the same mess costs more every month you leave it. And if the file was set up wrong at the start, every month after that copies the mistake forward, which is what turns a small job into a big one.
Being behind is the smaller problem. The bigger one is making decisions all year off a number that was already wrong.
I quote catch-up work as a flat fee after looking at the actual file, so you know the number before anything starts. If you just want to find out how far back it really goes, the first conversation is free.
Not sure how bad yours is? The free 12-question quiz takes two minutes and gives you a clear answer.
Take the free Books Health Quiz