Most small business owners make decisions on instinct. Not because they're flying blind by choice — they're often remarkably perceptive about what's happening in their business — but because getting the actual numbers requires pulling reports from three different systems, exporting them to spreadsheets, and spending hours reconciling data that doesn't want to reconcile. By the time you have a clear picture, the moment has passed.

So decisions get made on gut feel. Sometimes gut feel is right. But it can't tell you which service line has the best margins. It can't tell you which technicians are generating the most revenue per hour. It can't tell you whether your pricing kept pace with your costs over the last twelve months. For those answers, you need data — connected, current, and in one place.

This post is about what happens when a business finally gets that.

The starting point

We were working with a multi-trade service company that had been in business for decades. Solid operation, loyal customer base, experienced team. The owner was sharp and had good instincts about the business. But when we started the Operations Audit, we found something we see often: the data to answer the most important business questions was all there — it just lived in four different places and nobody had connected it.

Field service data was in their scheduling software. Financial data was in their accounting system. Labour hours were tracked in a separate timesheet tool. And a handful of critical numbers — pending invoices, outstanding estimates, technician utilization — lived in spreadsheets that someone updated manually, when they had time.

We built them a single automated dashboard. Every morning at 6am, it pulled data from each of those systems, ran the calculations, and delivered a consolidated report — current as of the previous day — to the owner and their operations manager. No manual work. No reconciliation. Just the numbers, clearly laid out, with the week and month in context.

Here's what the data revealed over the first six months.

Finding 1: Idle time was the biggest cost no one was tracking

What the data showed
Technicians were billable for an average of 58% of scheduled hours
The remaining 42% — drive time between jobs, waiting for parts, gaps between bookings — was costing roughly the equivalent of one full-time technician's annual wages in unbilled capacity every year.

The owner knew there was some idle time. Every trades business has it. What he didn't know was the scale, because it had never been measured consistently. When you're paying ten technicians and 42% of their scheduled hours aren't generating billable revenue, the dollar figure becomes confronting quickly.

The response wasn't to find new work — the business had plenty of demand. It was to look at scheduling efficiency: how jobs were sequenced geographically, how parts procurement was handled, how much buffer was being built into each booking slot. Small adjustments in each of those areas moved the utilization number meaningfully over the following quarter.

Finding 2: Gross margin varied dramatically by trade — and nobody knew

What the data showed
Electrical work ran at roughly 3× the gross margin of HVAC installation
When labour costs were accurately allocated by trade and job type, the margin differences between service lines were far larger than the owner had estimated. The business was inadvertently cross-subsidizing lower-margin work with higher-margin work — without knowing it.

This finding changed how the business thought about marketing and sales. Not by abandoning the lower-margin work — it had value for other reasons, including customer retention and technician utilization — but by being more intentional about where growth effort went. When you know which jobs make you money and which ones break even, you can make better decisions about pricing, capacity, and where to focus.

Finding 3: A pricing gap had opened up over several years

What the data showed
Labour rates for several service categories hadn't been updated in over two years
When the dashboard compared current pricing against current labour costs and material costs, it flagged several service categories where the margin had compressed significantly since the last rate review. The work was profitable — but less so than the owner believed.

This happens quietly in businesses that are busy. When you're fully booked and cash is coming in, pricing reviews get postponed. But costs don't wait for a convenient moment to increase. Labour market rates, material costs, fuel, insurance — all of these move. Pricing that made sense two years ago may be quietly eroding your margins today.

The dashboard didn't create these problems. They'd been building for years. It just made them visible at a moment when they could still be addressed before they became serious.

Finding 4: The AR picture was worse than it appeared

What the data showed
Over 20% of monthly invoice value was sitting past 30 days with no follow-up activity logged
The aging report in the accounting system showed the invoices. What it couldn't show — until we connected the systems — was that most of them had no corresponding follow-up communication. They were just sitting there.

We've written separately about AR automation and what systematic follow-up does to collection rates. This finding was what prompted that work for this client. The dashboard made the problem undeniable: a significant amount of revenue was earned, invoiced, and then essentially forgotten about until month end.

What changed after six months of clear data

↑ 11%
Technician billable utilization improved by 11 percentage points over six months — not through more aggressive scheduling, but through better job sequencing and parts procurement practices that the data made visible. Client operational data, anonymized

The owner told us something we hear often after these projects: the value wasn't just in the specific findings. It was in having a cadence of looking at the right numbers, consistently, with enough context to act on them. Before the dashboard, business review was a quarterly exercise that took half a day to prepare for. After, it was a five-minute morning scan with a weekly deeper look.

That rhythm — knowing what's happening in the business without having to work for the information — changes how decisions get made. Problems get caught earlier. Opportunities get noticed sooner. The owner stops reacting and starts steering.

The data was always there

This is the thing worth sitting with. Every finding in this post — the idle time, the margin differences, the pricing gap, the AR picture — was discoverable from data that already existed in systems the business was already paying for. Nothing new had to be tracked. Nobody had to do more work. The data just had to be connected and presented clearly.

That's what most small businesses are missing. Not more data. Not better software. A way to see what they already have.

If you're running a business on instinct and gut feel because getting the actual numbers is too hard, that's worth fixing. The Operations Audit is often where this starts — mapping what data exists, what decisions it could be informing, and what it would take to make it visible on a daily basis.