A QuickBooks Online file usually breaks slowly — a duplicate bank feed here, a miscoded transfer there — until one day nobody trusts a single report. Here's how to fix the file for good, in the order that works.
1. Diagnose before you touch anything
- Run the Balance Sheet for all dates. Negative balances, accounts you don't recognize, and a swollen "Opening Balance Equity" are your problem list.
- Run the Reconciliation Reports — which accounts have never been reconciled, and since when?
- Check Uncategorized Income / Expense and Ask My Accountant — this is where the guesses live.
2. Fix duplicates at the source
- Duplicate transactions usually come from a bank feed added on top of manually entered items, or an account connected twice. Find the pattern before deleting anything one-by-one.
- Undeposited Funds piled up? Sales receipts were never matched to deposits — match them, don't re-add income.
- Transfers between your own accounts coded as income or expense inflate both sides of the P&L. Re-code them as transfers.
3. Repair opening balances
"Opening Balance Equity" should be zero in a healthy file. Work each item back to where it belongs — with prior-year balances verified against tax returns and bank statements, so the file agrees with what was actually filed.
4. Rebuild the chart of accounts
- Merge duplicates ("Meals," "Meals & Entertainment," "Food") and deactivate what's unused.
- Structure accounts to match how you run the business — service lines, locations, or product categories — not the software's defaults.
- Use sub-accounts sparingly and classes/locations for real dimensions.
5. Reconcile everything, then lock it
Reconcile every bank, credit card, and loan account through the cleanup date, verify the balance sheet against source documents one more time, then set a close date with a password. The mess you just fixed can't creep back into closed periods.
Reality check: a file that's 6–12 months behind typically takes two to four weeks to clean properly. Lemoti does this as a fixed-fee cleanup project — books rebuilt, reconciled, and tax-ready.