Detailing Shop Analytics: Numbers You Can Act On

Most shops track exactly one number: what's in the bank. It feels like enough right up until a busy month leaves you scraping, and you have no idea which service quietly bled you dry. I've lived that exact whiplash — bays full, phone ringing, everyone slammed for weeks — and then I sat down with the books and the profit was thin as a squeegee edge. Being busy and being profitable are not the same thing. The gap between them is margin, and most detailing shop analytics dashboards will never once show it to you.

Here's why: revenue is a big, happy number. It goes up when you're working hard, it feels like progress, and it makes for a good story at the end of a long week. So that's the number every dashboard leads with. But revenue is a vanity metric. It measures how much work came through the door, not how much money you kept when it left. You can run a record month on top-line and still lose ground if the volume was riding on a service that barely clears its own cost. Revenue tells you the shop was loud. It says nothing about whether the shop was healthy.

We're all installers before we're business owners, and this is one of the places that truth bites hardest. When your head is down in a bay ten hours a day, "how's business" is a feeling, not a figure — it's the vibe of a full schedule and a busy front desk. And a feeling is a terrible way to run a company, because the feeling is loudest exactly when you're too swamped to check whether it's lying to you. The fix isn't working harder or booking tighter. It's finally putting the real number on the screen, so a busy month and a profitable month stop being the same guess.

So what makes a profit number trustworthy instead of theater? It has to be costed from what a job actually consumed — not a tidy markup you typed in once and forgot. That's the whole design decision behind Service VIN's Reports & Analytics. Your revenue is what you billed. Your cost is drawn from the real film roll the job pulled from, at the price you actually paid for that roll. Subtract one from the other and you've got profit that reflects reality, not a spreadsheet assumption from eighteen months ago when film was cheaper.

This only works because the costing is wired straight into inventory. When you track your film to the foot— every roll, every linear foot it gives up on every job — the reports can cost each install against the material it genuinely burned. A full front end that ate more film than you quoted shows up as a thinner margin, because it was one. A job where you nested the panels tight and wasted almost nothing shows up fatter, because you earned that. Nobody's applying a flat 40% and calling it a day. The number moves with the film, which is the only version of profit a film shop should ever trust.

And it matters more than it sounds, because film cost is the biggest lever most PPF shops never actually watch. List price says one thing; the roll on your rack says another once you factor in what you paid, what you wasted, and what sat too long. A markup-based report smooths all of that away and hands you a comforting average. A consumption-based report hands you the truth, warts and all — including the jobs where your quoted material cost and your real material cost quietly drifted apart. That drift is money, and it's invisible until something costs it for you.

Once profit is honest, the single most useful view in the whole dashboard is margin by service. It takes your accepted quote lines, groups them by what you sell — full front, full body, ceramic, tint, wash and wax — and shows you the revenue, the cost, and the real profit under each one. Not the ticket size. The margin. And that's where the busy-but-broke mystery usually solves itself in about ten seconds.

Because there's almost always a loser hiding in plain sight. It's frequently the service you do all day — the bread-and-butter package you barely think about, the one that keeps the bays full and the schedule looking healthy. High volume can disguise a thin margin beautifully. You feel productive doing it, the revenue column looks fine, and all the while it's the lowest-margin work in the building, eating capacity you could be selling to something that actually pays. Rank your services by profit instead of by how often you do them, and the pecking order can flip in a way that genuinely stings the first time you see it.

The point isn't to kill the low-margin service on the spot — sometimes it's the loss leader that gets a customer in the door for the coating, and that's a fine strategy as long as you're choosing it on purpose. The point is that you finally get to choose. Once the margin's on the screen, your options are obvious: raise the price, tighten the material, bundle it with something fatter, or stop selling it and give those bay hours to work that earns. Any of those beats what you're doing now, which is running a service you secretly lose on because it feels busy.

Margin tells you what happens to the work you win. The funnels tell you how much work you're losing on the way in — and that's just as much money, it's only quieter about it. Reports & Analytics tracks two of them side by side. The lead funnel follows every lead from new, to contacted, to qualified, to quoted, to won. The quote funnel follows every quote from created to accepted, and puts your real close rate next to it. Together they show you exactly which stage is leaking booked jobs.

This is the difference between a decorative metric and one you can act on. If a hundred leads come in and only forty ever get contacted, your problem isn't marketing — you're drowning good leads in the inbox and no amount of ad spend fixes a follow-up problem. If leads get contacted fine but quotes stall before they're accepted, your problem is the quote itself, or the follow-up after it, and that's a completely different fix. The funnel doesn't just tell you deals are leaking. It tells you which valve, so you spend your energy on the stage that's actually costing you.

The reason those close-rate numbers are worth trusting is that nobody's typing them in. They come out of the same system that runs your leads and quotes, so the funnel is a byproduct of doing the work, not a report somebody has to remember to update. That's the only kind of conversion number I'd bet a pricing decision on — the kind that would be a hassle to fake, because it's just counting what really happened.

Two more numbers round out the picture, and they're the ones owners feel in their gut long before they can name them. The first is capacity: booked hours per bay and per installer. It shows you where the shop is actually bottlenecked — which bay is carrying the week at ninety-plus percent while another coasts, which installer is buried while the board makes it look balanced. You can't fix a bottleneck you can't see, and "the shop feels jammed" isn't a diagnosis. Load per bay is.

The second is A/R aging — the money you've already earned but haven't collected. Reports & Analytics reads your invoices and buckets the outstanding balances by how overdue they are, so the sixty-day invoice that's about to go cold isn't buried under the fresh ones. This is the cash sitting in completed work, and in a trade where a single install can be a few thousand dollars, a couple of forgotten invoices is a real dent in a month. Seeing it aged and sorted is the difference between chasing it while it's collectible and writing it off because you lost track.

Put capacity next to cash and you've got the two levers a busy shop forgets to pull. You stop overselling the bottleneck bay because you can finally see it filling. You stop letting good money age out because it's sorted in front of you instead of scattered across a pile of invoices. Neither of these is glamorous. Both of them are the kind of quiet leak that a vanity dashboard would never surface — which is exactly why they belong on the same screen as your margin.

Here's a thing I care about as the person who built this: the dashboard only shows numbers it can actually compute from your data. No invented KPIs. No fake precision to make a screen look impressive. Every figure traces back to something real in the system — roll consumption for cost, accepted quote lines for margin, jobs for capacity, invoices for A/R. If it can't be computed from your real activity, it doesn't get a tile. That's a deliberate constraint, and it's the reason you can trust the thing enough to reprice a service off it.

The flip side of honest is portable. One click exports a clean CSV of your KPIs, revenue and profit by service, the trend, and your sources, so the exact numbers on the screen can go straight to your bookkeeper or into a spreadsheet without you rebuilding a single report by hand. And because the reporting is manager-only, your installers never see shop revenue, margin, or pricing — they get their own focused work view. The money picture stays where it belongs, and the people who need it get it without a monthly night of copy-pasting.

I'll be straight about where the numbers stop and the guesses would start. The dashboard reports what your shop did. It won't tell you the "average detailing-shop margin" or hand you an industry benchmark, because I don't have a trustworthy source for those and I won't make one up to fill a slot. Your numbers are the benchmark that matters. Compare this quarter to last quarter, this service to that one, and let your own trend line be the thing you're chasing.

A report is only worth the time it takes to read if it ends in a decision. That's the whole test. Margin by service says raise this price or drop that package. The funnel says fix your follow-up before you buy another ad. Capacity says add a Saturday or protect the bottleneck bay. A/R says make three phone calls before Friday. If you're looking at a chart and it doesn't change what you do on Monday, it's decoration — and I built this to be the opposite of decoration. When you spot a thin-margin service, the natural next move is repricing it properly; our guide to pricing a PPF job walks through turning that margin number into a quote that actually holds.

The metric tiles — revenue, profit, margin by service, the funnels, capacity, A/R, the CSV export — ship from the Essentials plan at $79/mo CAD. That's on purpose: knowing whether you made money shouldn't be an upsell. What sits one tier up, on Growth at $199/mo CAD, is the AI Business Advisor, which reads these same numbers and gives you a plain-language weekly read — the shifts worth noticing and the moves worth making — so you don't have to remember to go digging. I'd rather tell you where that line sits here than have you find it at checkout. Every plan starts with a 14-day trial on the full product, so you can load a real month and see your own margin before you decide anything — start one from the signup page, or compare the tiers first on the pricing page.

This climate is brutal on paint — gravel season and road salt see to that — and the shops that last through a few winters here aren't the busiest ones. They're the ones that know their numbers. Not because numbers are exciting. Because a shop run on margin instead of vibes gets to make the small, boring, correct decisions before they turn into a bad month. Raise the price. Kill the loser. Chase the invoice. That's the point of all of this. Not a prettier chart. A better-run shop.