Cleaning Up a Messy Chart of Accounts

Ask five employees at the same company what to call a $40 charge for printer paper, and you might get five different answers: office supplies, general expenses, miscellaneous, admin costs, or a category someone invented two years ago and never used again. Each answer could be defensible on its own. That flexibility is the problem.

The chart of accounts is the list of categories your accounting software uses to sort every transaction, organized into a handful of broad types: assets, liabilities, equity, income, and expenses, as QuickBooks describes it. It is not something most owners think about often, because it works quietly in the background. Every report you pull, a profit and loss statement, a balance sheet, a year-over-year comparison, is built directly on top of it: the account types you assign determine which report each transaction ends up on, as QuickBooks explains. When the chart of accounts is inconsistent, the reports built from it are too, even if every individual transaction was entered correctly.

How a Chart of Accounts Gets Messy

A disorganized chart of accounts usually builds up gradually, one reasonable-seeming decision at a time.

A new expense doesn’t fit any existing category, so someone creates a new one instead of asking whether an existing account would work. A bookkeeper leaves and their replacement doesn’t inherit any documentation about how things were categorized, so they start making their own judgment calls. An owner wants more detail on a specific cost, adds a dozen new accounts to get it, and six months later can’t remember what half of them were for.

The result tends to show up in a few recognizable patterns:

Duplicate accounts that mean the same thing. “Software,” “Software Subscriptions,” and “SaaS Expenses” all sitting in the list, each catching a portion of what should be one category.
A catch-all account absorbing everything. “Miscellaneous” or “Other Expenses” growing every month because it’s the path of least resistance when nobody is sure where something belongs.
Categories that no longer reflect the business. Accounts left over from a service line the business stopped offering two years ago, still cluttering the list and inviting misclassified transactions.
Too much granularity to be useful. A separate account for every vendor instead of every expense type, which turns a simple P&L into a page of line items nobody reads closely.

None of these individually breaks anything. Together, they make it harder to trust a report at a glance, which is often the entire point of having one.

A Composite Situation

Consider a small service business that has used the same accounting software for four years, with two bookkeepers and one owner-entered batch of transactions in between. By year four, the chart of accounts has around 90 active accounts. A handful, “Supplies,” “Office Supplies,” and “Supplies - Misc,” are functionally the same category, and nobody currently on the team remembers why there were ever three. The owner pulls a P&L to compare marketing spend year over year and finds the number split across four separate marketing-related accounts, none of which add up to a total anywhere on the report. Getting a real answer means exporting a general ledger and adding line items by hand.

That is a structure problem, and it is the kind of thing a cleanup catches before it costs someone an afternoon every time they want a real number.

Cleaning It Up Without Starting Over

A messy chart of accounts usually just needs to be edited down.

Start with a full export. Pull every account, active and inactive, so you can see the whole picture rather than scrolling through pages in the software.

Group accounts that mean the same thing. For duplicates like the “Supplies” example above, pick the account name to keep and move the others’ historical transactions into it, as QuickBooks details, or set the redundant ones to inactive so new transactions can’t be coded there, as QuickBooks confirms. Under QuickBooks Online’s account rules, an account can’t actually be deleted, only made inactive or merged into another account, and the transactions stay on your financial reports either way.

Use subaccounts for added detail. If marketing spend needs to be broken out, a parent “Marketing” account with subaccounts for advertising, events, and content keeps the detail available without cluttering the main report view, an approach QuickBooks recommends for adding granularity without expanding the account list itself.

Aim for a manageable total. Xero’s glossary puts a straightforward list of 30 to 50 accounts as usually enough to capture day-to-day activity for a small business and still produce a report someone can read in one pass. The right number depends on the business, but if you’re well past that range, it’s worth asking whether every account is earning its place.

Retire what the business no longer does. An account tied to a discontinued service line can stay in your history while its status changes to inactive, closing it off from new transactions.

Keep New Messes From Starting

A cleanup that isn’t followed by any change in habit tends to drift back toward where it started.

A short internal reference, even a single page, that lists the accounts your business actually uses and gives a one-line example of what belongs in each one solves most of the drift. Xero’s glossary recommends creating a brief guide explaining which account to use for common transactions, to keep different people from coding the same expense to different accounts. It matters more when more than one person touches the books, but it’s useful even for a solo owner who wants to categorize the same way in December that they did in January.

Why the Structure Is Worth Maintaining

A chart of accounts stays invisible while it’s working. It becomes noticeable in the form of a report that doesn’t add up cleanly or a category nobody can explain. Treating it as a structure worth periodically reviewing keeps the reports built on top of it worth trusting.

At Bat City Books, a chart of accounts review is part of getting a new client’s books current, because a report is only as reliable as the structure underneath it. If your chart of accounts has grown past the point anyone can explain it, let’s talk.