Case Study: How Streamlining an Overcrowded Chart of Accounts Restored Clarity to the P&L

A Chart of Accounts (COA) is basically your business’s financial backbone. It’s the master list of all the categories you use to track what your business owns, owes, earns and spends. The COA should give you a high-level view of your business, a way to see the big picture at a glance. But QuickBooks Online makes it so easy to add a new account that most businesses end up doing exactly that: adding one more account every time something doesn't quite fit, until the chart of accounts has grown into something unrecognizable. What starts as an organizing tool turns into clutter, and the P&L and balance sheet stop making sense.

For more in depth guide about simplifying your chart of accounts check out this guide. 

The Setup: Chart of Accounts

A service-based client came to me because they were stepping back from the day to day operations and handing over the reins to their son. After the two of them began looking at the books together, it quickly became apparent that the way the Chart of Accounts was set up and had morphed over the years, was not the way forward. 

The problem: cost of goods sold and other expenses

This client had somewhere between 20 and 30 separate cost of goods sold accounts scattered across the P&L including a separate account for every type of subcontractor they worked with. On top of the sheer number, these accounts weren't even classified correctly. They weren't set up as a cost of goods sold at all, which meant that while looking at the P&L, these accounts weren’t grouped together so that the owner could quickly calculate their gross profit margin. For any business this is arguably the single most important number for a business to track. Additionally, there were several duplicate accounts that were named basically the same thing, think Meals, Meal Expenses. 

The result was a P&L that was technically accurate but practically useless. You couldn't look at it and understand how the business was actually performing.

The problem: revenue

The same bloat tends to show up on the revenue side, too. Most businesses have multiple service lines or products, so it feels natural to want a separate income account for each one. But a chart of accounts really only needs a small handful of high-level revenue buckets, things like recurring revenue, project revenue, and discounts, if applicable. Anything more granular than that doesn't belong in the chart of accounts at all. It belongs in products and services, which is exactly what that tool is designed for.

This client had a revenue account for every type of work that was done, so rather than being able to see the month revenue for service type grouping, recurring, or project, this chart of accounts showed it in very granular detail. Again the P&L was technically correct but looking at the revenue that way was extremely overwhelming. 

The work

I exported the full chart of accounts into Excel and sorted it by name to spot duplicates and overlapping categories. From there, I built a plan to simplify and restructure the whole thing: consolidating accounts that didn't need to be separate, correctly classifying costs so gross profit margin was visible again, and cleanly separating true cost of goods sold from overhead.

Instead of cost of goods sold (COGS) for every type of subcontractor, we simplified this into 4 main COGS accounts. 

1. Internal Labor

2. Subcontractor Labor

3. Supplies and Materials

4. Other Job Costs

On the revenue side, we moved the granular detail out of the chart of accounts and into products and services instead. Each service line or product became its own product and service, which meant a simple sales-by-product-and-service report could show exactly where revenue was coming from and which service lines were actually profitable.

The real work happened in the mapping. Every product and service item was mapped to the correct chart of accounts account. For specific products and services, this meant mapping to the correct COGS account as well. What this does is automates the back end accounting.  Every time an invoice is generated or a bill gets added, the correct revenue account and expense account are affected. 

Nothing has to be remembered or double-checked, the structure does the work.

The result

The number of accounts on the COA was cut roughly in half. What used to be 20 to 30 overlapping COGS accounts became a much smaller, cleanly organized set, with the true cost of goods sold finally separated from overhead instead of sprinkled across the P&L. That one change, making sure COGS was actually classified as COGS, meant the business could see its gross profit margin clearly for the first time. It came in at 40%, a number the owner had never actually been able to verify before, because it had been hidden inside a P&L that lumped everything together.

The P&L finally told a clear story. Gross profit margin was visible at a glance, overhead was separated out, and revenue was organized into a handful of buckets instead of dozens. The business owner could look at a basic report and actually understand what it meant, without needing to be an accountant to interpret it. And because the detail didn't disappear, it just moved to the right place, in products and services instead of the chart of accounts, they never lost the ability to see exactly where their money was coming from or going, down to the service line level, and it all happened automatically instead of requiring manual tracking.

If your accounting operations feel clunky and unmanageable, let's chat to see how I can help streamline them. [Book a free Discovery call →]