Most QuickBooks Online problems are not data entry mistakes. They are structure problems: a chart of accounts that grew without a plan, bank rules that miscategorize silently, and no lock on prior periods. Fix the structure and the data stays cleaner. This is a software-focused checklist. For the tax-season version, see how to fix messy QuickBooks records before tax season. Menu names change as Intuit updates the product, so treat the labels below as a guide.
Phase 1: Back up and plan
- 1Export key reports (profit and loss, balance sheet, trial balance, general ledger) for the periods you plan to touch, so you can compare before and after.
- 2Write down the date through which you trust the books.
- 3Gather statements for every bank, card, and loan account.
- 4Decide who will approve changes and who has edit access.
Phase 2: Fix the chart of accounts
- Merge duplicate accounts and rename unclear ones.
- Make accounts inactive when they are unused, rather than deleting them when history exists.
- Make sure expense accounts map cleanly to tax return lines. Fewer, clearer accounts are better than dozens of near-duplicates.
- Use sub-accounts sparingly and consistently.
- Separate owner equity accounts for contributions, draws or distributions, and retained earnings.
Phase 3: Clean up lists and items
- Customers and vendors: merge duplicates, add missing tax information for vendors who need a 1099, and remove stale entries.
- Products and services: make sure each item posts to the right income account and, for inventory, the right cost and asset accounts.
- Classes or locations: use them only if you will report on them, and apply them consistently.
Phase 4: Bank feeds and reconciliation
- 1Work through the For Review queue so every feed transaction is matched, added, or excluded deliberately.
- 2Remove duplicates created when a feed and a manual entry both exist.
- 3Reconcile each account starting with the oldest unreconciled period.
- 4If a reconciliation will not balance, see bank reconciliation problems.
- 5Run the reconciliation discrepancy report to see changes made to previously reconciled transactions.
Phase 5: Clear the holding accounts
- Undeposited Funds: match payments to deposits so the balance reflects only money not yet deposited.
- Uncategorized Income and Expense, and Ask My Accountant balances: review each item and move it.
- Opening Balance Equity: it should be zero in a properly set up company. Investigate any balance.
- Suspense or clearing accounts: identify and resolve.
Phase 6: Review liabilities and receivables
- Accounts receivable and payable aging: find and resolve stale items.
- Sales tax payable and payroll liabilities: tie them to filings and payments.
- Loans and credit lines: split principal and interest correctly.
- Customer deposits and gift cards as liabilities until earned or redeemed.
Phase 7: Add guardrails
- 1Review bank rules. Delete or tighten rules that auto-categorize too broadly.
- 2Set a closing date with a password once a period is reviewed, so prior periods cannot change silently.
- 3Set user permissions by role, and remove access for former staff or old providers.
- 4Turn on the audit log review as part of your monthly routine to see who changed what.
- 5Use recurring transactions for predictable bills.
Phase 8: Sanity-check the reports
- Profit and loss: compare to the prior year and your expectations by category.
- Balance sheet: bank balances match statements on the report date, with no negative cash or odd equity.
- Payroll totals tie to payroll reports and filings.
- Look for large round numbers, one-off journal entries, and accounts used once.
When to stop and get help
If opening balances are wrong, reconciliations will not clear after reasonable effort, or the company file mixes years of errors, a professional cleanup is usually faster and cheaper than continued guessing. See bookkeeping cleanup services and fixing negative balances and duplicate transactions in QuickBooks.
Our bookkeeping service includes QuickBooks Online review and cleanup. To discuss your bookkeeping cleanup, tell us the periods affected and which accounts will not reconcile.
