Chart of Accounts Maintenance Checklist

Export the full COA from QBO, Xero, or NetSuite to CSV with account number, name, type, detail type, sub-account parent, and balance. Save a dated copy to the workpaper folder so changes during this run are reversible.

Run a transaction-detail-by-account report for the trailing 12 months. Accounts with zero activity and zero balance are merge or deactivate candidates. Accounts with activity but zero ending balance need a reason check before deactivation.

If the COA exceeds 250 accounts for an SMB or 600 for a mid-market entity, plan a structural cleanup pass — usually a sign that classes, locations, or customer dimensions are being misused as new GL accounts. Flag for partner discussion before line-item edits.

Identify near-duplicates ('Office Supplies' vs 'Office Expense', 'Meals' vs 'Meals & Entertainment'). Build a merge map: source account, target account, reason. QBO merge is irreversible — confirm history is acceptable in the surviving account before executing.

Departments, locations, and projects belong on classes, locations, or tags — not in the account name ('Travel - Sales', 'Travel - Engineering'). Move dimensional reporting off the COA to keep the trial balance scannable.

Make inactive (don't delete) any account with zero activity over 24 months and a zero balance. Inactivation preserves history for audit; deletion can break prior-period reports. Watch for accounts pinned to recurring bank rules — fix the rule first.

Walk every account and confirm it is correctly typed as Asset, Liability, Equity, Revenue, COGS, Expense, Other Income, or Other Expense. Common errors: credit-card liability typed as expense, deposits-held typed as revenue, sales-tax payable typed as expense.

QBO detail types drive cash-flow statement classification and tax-line mapping. A loan typed as 'Other Current Liability - Other' instead of 'Notes Payable' breaks the indirect cash flow. Fix detail types before close.

Use the standard block ranges: 1xxx assets, 2xxx liabilities, 3xxx equity, 4xxx revenue, 5xxx COGS, 6xxx-7xxx operating expense, 8xxx other income, 9xxx other expense. Renumber outliers and fill gaps consistently so reports sort cleanly.

One naming convention: title case, no abbreviations, parent-child format for sub-accounts. Add a description for every account explaining what posts there, with one or two example transactions. Future bookkeepers stop guessing.

Every balance-sheet account should tie to an external statement or roll-forward schedule: bank/credit-card recs, A/R aging, A/P aging, fixed-asset register, loan amortization, prepaid schedule, accrual schedule. Accounts without a tie-out are the highest audit risk.

Pull every transaction in 'Ask My Accountant', 'Uncategorized Income', and 'Uncategorized Expense'. Reclass each to its proper account; document the reason in the memo. Then update the bank-feed rule that sent it there so the same line doesn't reappear next month.

Every AJE for misclassification carries a memo with the source account, target account, dollar amount, and reason. No plug entries to retained earnings without partner sign-off — auditors and the next bookkeeper will need the trail.

In QBO, only Primary Admin and Company Admin should add or edit accounts. In NetSuite, restrict the Account record permission to controller-level roles. Staff who need to categorize transactions don't need rights to create new GL accounts.

Record date, account number, change type (add / rename / merge / deactivate), reason, and approver for every change made during this run. The register is your audit response when the next reviewer asks why account 6420 disappeared mid-year.

Controller reviews the change register, approves the merge map, and signs the final COA export. Distribute the approved COA to the close team so the next month-end works against the new structure.

Light quarterly review (60 minutes): suspense balance, new accounts added, any merges in flight. Full annual review at year-end before tax-line mapping. Put both on the practice-management calendar in Karbon or Canopy.

Save the approved COA, change register, and merge map to the client folder under 'Permanent File / COA / [Year]'. The next preparer or auditor expects the trail there, not in someone's email.