Three Shops, Three Charts of Accounts: Why Your MSO Can't Compare Its Own Locations

I started working with a very ambitious and very intelligent MSO owner recently. On our first working session, he asked me a question every multi-location owner asks eventually: which location is performing best?

It's a fair question. It should have a clear answer. In this case, it didn't.

The problem hiding in plain sight

Each of the owner's locations runs as its own operating entity. Separate EIN, separate QuickBooks file, separate bookkeeper. That structure is normal and fine. Plenty of MSOs operate this way for liability and tax reasons, and it works until you try to compare the locations to each other.

When I pulled up the P&Ls side by side, they looked similar at a glance. Same software, same general structure, same broad categories. But when I dug into the account-level detail, the charts of accounts had drifted apart over the years.

Where it shows up first: revenue classification

Calibration revenue was the first thing I noticed. At one shop, it shows up as its own line item. At a second shop, it's bucketed into a general "Scans" account. At another, it's not visible at all. It's probably getting categorized as sublet labor or general repair.

Same repair operation at every location. Different general ledger accounts at each one. That means if the owner runs a "calibration as a percent of revenue" report across his MSO, the numbers are meaningless.

Where it actually hurts: COGS classification

Revenue misclassification is annoying. COGS misclassification is dangerous.

At one location, production wages (the techs, the painters, the prep guys) sit in cost of goods sold. At another, those same wages sit in operating expense, below the gross profit line. That's not a small formatting difference. It's a fundamental question of how gross margin gets calculated.

The shop with production wages in COGS will report a lower gross margin than the shop with production wages below the line, even if the underlying economics are identical. When the owner looks at the P&Ls and says, "This location has the worst gross margin, we need to fix it," he might be chasing a ghost. That location might actually be the best performer. The numbers aren't telling him that because the numbers aren't comparable.

Why this happens

Nobody sets out to build inconsistent charts of accounts. It happens because books evolve independently.

A shop opens. A bookkeeper sets up QuickBooks. CCC ONE's account mapping tab gets configured once. A template gets imported from a prior shop but only partially cleaned up. A new bookkeeper takes over and adds their own accounts without retiring the old ones. Two years later, the chart of accounts is a layered history of every person who ever touched the file.

Then the owner buys a second shop. And a third. Each one has its own version of this story. Nobody's job was ever "make sure all the shops report on the same structure," because when the first shop was set up, nobody was thinking about multiple locations.

The fix

This isn't the kind of problem you solve in a weekend. But it's also not as hard as it sounds if you sequence it properly.

Phase one: standardize revenue. Build one master revenue structure that reflects how you actually want to see the business. Labor, parts, paint and materials, sublet, frame, calibration, and so on. Map every shop's existing revenue accounts to the new structure. Retire the old accounts. This is usually a four-week project.

Phase two: standardize COGS. Decide where production wages live. Decide where paint and materials live. Decide how parts flow through. Then rebuild COGS at every shop to match. This is the phase that actually gives you comparable gross margins.

Phase three: clean up operating expenses. This is the least urgent phase and the one most shops never get around to. It's fine to leave it for last.

You do not do all three phases at once. You do not rebuild the chart of accounts and migrate historical data in the same week you're trying to close the month. You phase it, you communicate it to the bookkeeper, and you accept that the first month after the transition will have some noise in it.

What to do this week

If you're running more than one location, pull up your most recent P&Ls side by side and look at two things.

First, does calibration show up as its own line at every shop? If not, that's a revenue classification drift.

Second, are production wages in the same place at every shop, either above or below the gross profit line? If not, your gross margins aren't comparable and any comparison you've been making is based on bad data.

You don't need to fix it this week. But you should know which direction the problem is hiding in. Most owners don't.

If you want help thinking through what a clean multi-shop reporting structure looks like, start by scheduling time with me.