Cleaning up a messy chart of accounts

Every report a company produces depends on the chart of accounts. When it grows without a plan, with duplicate accounts, vague names, and accounts used differently by different people, every report built on top of it suffers. Cleaning it up is unglamorous work that makes everything else easier.

Signs it needs attention

• Hundreds of accounts, many with small or zero balances
• Several accounts that mean the same thing
• Names like "Misc," "Other," or a former employee's name
• Location or department detail built into account names instead of tracked separately
• Reports that need manual reclassification every month

Step 1: Map what exists

Export the full chart with balances and transaction counts. Group accounts by what they actually contain, not what their names say.

Step 2: Design the target structure

Define a clean structure with clear account ranges for each section of the statements, and track locations, departments, and projects as separate dimensions instead of separate accounts.

Step 3: Build the mapping

Map every old account to a new one. The same mapping lets you restate history so trends stay comparable after the change.

Step 4: Change at a clean break

Make the switch at the start of a month or year, after a clean close. Deactivate old accounts rather than deleting them so history stays intact.

Step 5: Write it down

A short coding guide with examples helps the team and outside bookkeepers post transactions consistently.

The result is reporting that comes straight out of the system without spreadsheets in between, and a foundation for budgeting, dashboards, and eventually a smooth audit or sale.