I've inherited dozens of messy QuickBooks files. Whether it's a startup that grew faster than its bookkeeping or a small business that's been winging it for years, the same five problems show up every time.
First, the chart of accounts. Most files have 200+ accounts where 40 would do the job. Excess accounts mean transactions get miscategorized, reports become noise, and nobody — including your CPA — can tell what's happening. Merge duplicates. Delete unused accounts. Keep it simple.
Second, bank reconciliations. Unreconciled accounts go back months or years. You can't trust your numbers until every bank and credit card account is reconciled through the last statement. This is tedious work, but it's step one.
Third, undeposited funds. That balance sitting in 'Undeposited Funds' from 2019? It's throwing off your cash reporting and probably hiding transactions that never got deposited. Clear it out and close the loop on all outstanding items.
Fourth, accounts receivable and payable aging. If your A/R aging shows invoices from 2 years ago that nobody's collected, or your A/P has bills you've already paid but never marked, your P&L is wrong. Reconcile both thoroughly.
Fifth, inventory (if applicable). Inventory adjustments, uncategorized COGS, and quantity-on-hand mismatches are the silent killers of small business financials. If you carry inventory, reconcile it to a physical count at least quarterly.
Cleanup projects aren't glamorous, but they're the foundation. Without clean books, your tax return is a guess, your financial decisions are blind, and your investors or lenders won't take you seriously. If your QuickBooks file needs a reset, start with these five items — or find someone who can.
This post is for general educational purposes only and does not constitute tax, legal, accounting, or investment advice. Consult a qualified professional for your specific situation. Content reflects the author's understanding as of the publication date; rules, rates, and interpretations may change.