Cleanup

Cleanup Checklist for QuickBooks Online: 11 Steps to a Clean File

I fix messy QuickBooks files for a living. Almost every one follows the same path. This is the checklist I work through when a file lands on my desk with reports that make no sense or a bank balance that matches nothing. Print it and work down the list in order, because each step makes the next one easier.

Step by step cleanup checklist

1. Gather your source documents. Bank statements, credit card statements, loan statements, payroll reports if you have employees, and your most recent tax return. It goes a lot faster when you work from real documents instead of memory.
2. Tie your beginning balances to the last tax return. Pull the year-end balances off your most recent return and compare them to the beginning balances for the year that follows. Adjust whatever doesn’t match. You never want to start a new year without accurate beginning balances.
3. Review the chart of accounts. Merge duplicate accounts, rename the vague ones, and make unused accounts inactive. A shorter, plainer chart makes every report easier to read.
4. Reconcile every bank account. Tie each account to its statement, month by month. When a balance won’t match, look for missing entries, duplicates, and transfers recorded on only one side. My bank reconciliation guide walks through it.
5. Reconcile the credit cards too. Cards get skipped more often than bank accounts. They hide just as many duplicates and missed charges.
6. Fix the big miscategorizations first. Large expenses, owner draws and contributions, loan payments, transfers, and merchant deposits throw the reports off the most. Fix those before you fuss over small stuff.
7. Clear out Undeposited Funds. Money that’s been sitting in that account for months usually means a deposit got recorded twice or never matched to the bank.
8. Review old invoices and unpaid bills. Correct receivables you already collected, write off the ones nobody’s ever going to pay, and clear bills that were paid. What’s left should be what people actually owe you and what you actually owe.
9. Check the rest of the balance sheet. Stale loan balances, suspense accounts, and numbers that never move deserve a hard look. Leave them alone and the profit and loss can still come out wrong after everything else is fixed.
10. Rerun the reports and compare. Pull a fresh Profit and Loss and Balance Sheet, then compare them to your statements and to your own sense of how the year went. If a number still looks wrong, keep going.
11. Set a monthly routine so it stays clean. A light month-end close keeps the file from sliding back. My month-end close checklist covers that routine.

If months are missing entirely

A cleanup fixes what got entered wrong. Catching up fills in what never got entered at all. Most files need both, and I quote them as one project either way. If yours is behind as well as messy, run this checklist alongside my catch-up bookkeeping guide.

When to bring in help

If you can’t tell where the errors started, or a reconciliation is off by more than you can explain, or you’ve got several years stacked on top of each other, hiring it out is usually faster and safer than trial and error.

That’s what my bookkeeping cleanup service is. I look at your file for free, tell you straight what shape it’s in, and put a fixed price in writing before I touch anything. Files that are several years behind are right up my alley, and the free call is where you find out what yours would take. I work in QuickBooks Online over Zoom, so it makes no difference whether you’re down the road from me in Missouri or across the country. When the file’s clean, you get a reconciled, tax-ready set of books, and your CPA can work from them straight away.

I’m a bookkeeper, not a tax preparer or attorney. For tax and legal questions, confirm the details with your CPA. I keep the books that make their job easier.