Skip to content

Chart of Accounts Cleanup

A messy chart of accounts is common when you take on a new client or inherit old books: three versions of "Office Supplies", accounts nobody has used in years, "Rent" typed as an asset. Cleanup finds these, shows exactly what it would change, and applies it only after someone approves it. Nothing is deleted, closed and locked periods are untouched, and the whole run can be undone.

What it looks for

  • Duplicates: accounts with near-identical names ("Office Supplies" and "Office Supply"). The account with the most activity, then the oldest, is kept and the other is merged into it.
  • Unused accounts: no activity for 12 months (you choose the window). They are inactivated, never deleted. Accounts that still carry a balance are left alone.
  • Wrong types: an account whose name says expense but is typed as an asset, or whose detail type does not fit.
  • Single-child parents: a parent account with one sub-account; the sub-account moves up a level.
  • Names: inconsistent capitalization, stray spacing or punctuation, and an account number typed into the name.
  • Unmapped accounts and numbering gaps are reported as findings only.

How to use it

  1. Open Chart of Accounts and choose Clean up chart of accounts in the assistant menu.
  2. Select Analyze. The panel lists the changes by kind. Switch off any you do not want.
  3. Review the Needs a person and Protected sections. These are never applied automatically.
  4. Select Review and file. This creates one proposed change in Proposed changes.
  5. Approve it. Every selected change runs as one automation run.
  6. To reverse it, open the panel again and choose Undo this run.

What is never changed automatically

  • Closed or locked periods. A merge or type change that would alter entries in one is listed under Needs a person.
  • Different account types. Two accounts of different types are not merged unless you allow that merge explicitly.
  • Protected accounts. Bank and card accounts linked to a bank feed or reconciled, system accounts, and accounts used by an active bank rule, a recurring template or an integration setting are listed with the reason and left alone.

Undo

Undo restores names, account types, active status, parents and merged postings exactly. An item is left as it is, with a reason, if someone changed it after the cleanup, if putting it back would touch a closed period, or if its name is now taken. A few merges cannot be split back exactly (for example, when budget lines were combined). These are marked in the plan, and the approval note must contain CONFIRM IRREVERSIBLE before they run.

Ask the assistant

"Analyze my chart of accounts for cleanup" lists what it would change without touching anything. "File the chart of accounts cleanup" sends it for approval.