Catch-up is about books that are missing. Cleanup is about books that are there but wrong: the file looks maintained, yet the reports don’t hold up. If your numbers feel off but you can’t say why, this guide covers the seven signs your QuickBooks file needs a cleanup, a step-by-step way to fix it, a checklist to check the result, and how to tell when it’s worth getting help. The same jobs apply in Xero, under different menu names.
- Wrong books quietly distort tax, borrowing and day-to-day decisions, even when the file looks tidy.
- The usual culprits: unreconciled accounts, duplicates, miscategorized transactions and bad opening balances.
- A real cleanup is a diagnostic, not brute-force re-entry: find the few structural errors and fix those, in order.
- Once clean, a monthly routine keeps it that way; the mess only builds when no one is reconciling.
The 7 signs your QuickBooks needs a cleanup
- Your bank accounts don’t reconcile. If the balance in QuickBooks doesn’t match the statement, every report built on it is off. The fix: reconcile month by month from the last statement that does tie.
- Balances that make no sense, such as a vendor showing a negative payable, or inventory below zero. The fix: find the bill or payment entered twice, or applied to the wrong account.
- A bloated chart of accounts with near-duplicates like “Office Supplies” and “Office Supply”. The fix: merge true duplicates and make the rest inactive, so each cost has one home.
- An “Ask My Accountant” or Uncategorized pile that keeps growing and never gets cleared. The fix: code each item, then change the bank rule that sent it there.
- Revenue that looks too high, often deposits booked as sales with fees, refunds and sales tax buried inside. The fix: record gross sales, fees, refunds and sales tax separately.
- Duplicate transactions from bank feeds imported twice, inflating both income and expenses. The fix: match or exclude the feed copy so each item appears once.
- Opening balances that don’t tie out to the prior period or last year’s tax return. The fix: agree the starting balance sheet before touching anything else.
Why it matters more than it looks
Wrong books don’t just look untidy. They lead to overpaid or underpaid tax, decisions made on numbers that turn out to be fiction, and a nasty surprise the moment a lender, buyer or the IRS looks closely. A clean set of books is the difference between financials you can defend and a spreadsheet you have to apologize for.
How to clean up QuickBooks Online, step by step
Work in this order. Each step depends on the one before, so skipping ahead usually means doing the work twice. The names below are QuickBooks Online’s; Xero has the same jobs under its own menus.
- Record where you’re starting.Run a profit and loss, a balance sheet and the reconciliation history for each account, and save them. Note the last month each account was reconciled.
- Agree the opening balances.Compare the balance sheet at the start of the period you’re fixing with last year’s tax return or your accountant’s year-end figures. If they differ, settle that first: every later report rests on it.
- Tidy the chart of accounts.Make unused accounts inactive and merge true duplicates. In QuickBooks Online you merge by renaming one account to exactly match the other, with the same account type and detail type. Merging can’t be undone and the merged account loses its reconciliation history, so save its reconciliation reports first. Don’t merge an account that’s connected to a bank feed, or one QuickBooks created itself; Intuit says to contact support for those.
- Clear the bank feed and remove duplicates.Work through the transactions waiting for review. Match a feed item to a transaction already entered instead of adding it again, exclude true duplicates, and fix any bank rule that keeps sending items to the wrong account.
- Reconcile every account, oldest month first.Bank, credit card, loan and payout accounts, each to its statement, one month at a time. A difference you can’t explain in one month only grows in the next.
- Clear undeposited funds.Payments you record wait in Undeposited Funds (also called Payments to deposit in some QuickBooks files) until you group them into a bank deposit that matches the deposit on your statement. An old balance sitting there usually means deposits were entered twice: once from the feed, once as a payment.
- Empty Uncategorized and Ask My Accountant.Give every item in Uncategorized Income, Uncategorized Expense and Ask My Accountant a real category, so those accounts end at zero.
- Check receivables, payables and liabilities.Review the A/R and A/P aging reports: apply unapplied payments and credits, and write off invoices that will never be paid instead of deleting them. Tie sales tax and payroll liabilities to the returns actually filed.
- Re-run the reports and close the period.Compare the new reports with the ones you saved in step 1, and make sure every change has a reason. Then set a closing date with a password so nobody edits a finished month by accident.
Bookkeeping cleanup checklist
Use this to check your own file, or a cleanup someone did for you. Every line should be true before you trust the reports again.
Accounts
- Every bank, card, loan and payout account reconciled to its latest statement
- Reconciliation reports saved for each month
- No unexplained differences left in any reconciliation
Transactions
- No duplicates from the bank feed
- Uncategorized Income, Uncategorized Expense and Ask My Accountant at zero
- Undeposited Funds holds only payments not yet deposited
- Owner draws and contributions in equity, not in expenses or income
Balances
- Opening balances tie to last year’s tax return
- No negative customer or vendor balances without a reason
- Sales tax and payroll liabilities match the returns filed
- Loan balances match the lender’s statements
Structure
- One account for each kind of income and cost, no near-duplicates
- Bank rules checked, so the same mistake can’t come back
- A closing date set on the last clean month
Clean up yourself, or get help?
A cleanup you do yourself costs time; one you hand off costs money. Which is cheaper depends on how deep the problems go.
| Your situation | Clean it up yourself | Get help with the cleanup |
|---|---|---|
| A few months of errors in one or two accounts | Yes | Yes |
| Errors going back a year or more | PartlySlow, and easy to miss the cause | Yes |
| Payroll, inventory or sales tax involved | PartlyIf you know how each should post | Yes |
| Works without knowing debits and credits | No | Yes |
| What it costs you | Your evenings | A fixed price, quoted before work starts |
| Best when | The problems are recent, few, and you know the fix | The file is years deep, or you’d rather spend the time on the business |
If you hand it off, a good cleanup is a diagnostic first: open the file, find the few structural errors that make everything downstream wrong, and fix those. A proper cleanup will:
- Reconcile every account to its statement, month by month
- Correct miscategorized transactions and simplify the chart of accounts
- Remove duplicates and fix opening balances so the file starts from the truth
- Re-check the historical financial statements so prior reports are reliable
- Document how recurring items should be treated so the file stays clean
To let someone look, you give an accountant access to QuickBooks from your own account and remove them when you’re done. Our free books review starts the same way: within about 48 hours you get a written list of what’s misclassified or unreconciled, and nothing in your books changes.
Keeping it clean afterwards
Once a file is clean, keeping it clean is the easy part. Messes build up precisely when no one is reconciling every month, so a short month-end close checklist, or monthly bookkeeping, stops the same problems coming back. If your books are not just wrong but also behind, you may need a catch-up first. We’ll tell you which on a quick call.
Frequently asked questions
Can I clean up my QuickBooks Online myself?
Yes, if the problems are recent and you’re comfortable with reconciliations. Follow the steps above in order, save your reports before you start, and keep a list of every change you make. If the errors go back more than a year, or involve payroll, inventory or sales tax, the time and the risk of a wrong fix usually make help the cheaper option.
Can AI clean up my QuickBooks?
Not on its own. AI tools and bank rules can suggest categories and flag likely duplicates, which speeds up the routine part. They can’t know why you spent the money, can’t reconcile to statements they haven’t seen, and will repeat a past miscoding with confidence. Use them to go faster, and have a person check the result. More on what software can and can’t do in do I need a bookkeeper if I have QuickBooks?
How do I clear undeposited funds in QuickBooks Online?
Create a bank deposit, tick the payments that make up one real deposit on your bank statement, choose the bank account and the statement date, and save. Then match the bank feed’s deposit to it instead of adding the feed item again. If a payment was also recorded as a separate deposit, that’s a duplicate: remove one so the income isn’t counted twice.
How long does a QuickBooks cleanup take?
Most cleanups take days to a couple of weeks, depending on the number of accounts and how far back the errors go. We confirm a realistic schedule, and a fixed price, after looking at the file.
Can you clean up Xero too, not just QuickBooks?
Yes. The same principles apply to Xero or any cloud ledger: reconcile, recategorize, remove duplicates and fix opening balances.