Reporting and Dashboards: The Five Numbers a Service Owner Should See Weekly

5 numbers describe a service business well enough to run it, and 3 of them are about the parts chain rather than about technicians. A dashboard with 20 tiles is read once, which is why the count matters as much as the choice.

The short version

Most dashboards in this trade show what the software found easy to count: jobs completed, revenue, technician hours, call volume.

Those describe activity. A busy week and a profitable week look identical on them, which is why owners stop opening the page after a month.

The five below describe whether the work was worth doing. Three concern parts and money, because that is where margin actually goes in equipment service, and it goes quietly.

The 5 numbers

Number	What it tells you	Bad sign
Jobs closed with a piece of equipment attached	Whether your records are real	Below 90 percent
Unmatched supplier bills	Whether job costs are true	Anything above a handful
Repeat visits within 30 days	Diagnosis and parts quality	Rising, whatever the level
Value of open quotes over 14 days	Revenue sitting still	Growing week on week
Unbilled completed work	Cash you have earned and not asked for	Older than 7 days

The last two are the ones that convert into cash fastest when acted on, and they are usually the ones nobody is looking at.

Number 1 is the one everything else depends on

Jobs closed with a piece of equipment attached, as a percentage.

Every other useful report is downstream of it. Failure patterns, replacement recommendations, warranty position, parts cost by model, contract profitability. All of them need the job to name the equipment.

Where the figure sits at 60 percent, roughly two in five of your jobs are invisible to every analysis you would want to run, and the reports built on the rest are quietly unrepresentative.

Roopairs holds equipment asset records with jobs attached to the equipment rather than the address, which is what makes this measurable at all.

It is also the fastest number to move. It is a capture habit, not a project, and it usually responds within a two weeks of somebody actually watching it.

Unmatched supplier bills is the margin number in disguise

Count them weekly and the number should be near zero.

A supplier bill that cannot be attached to the job it came from means that job's cost is an estimate. A pile of them means your margin is an assumption across the whole month.

It is a count rather than a value deliberately, because a small unmatched bill is the same process failure as a large one and the count is harder to rationalize away.

Roopairs holds purchase orders against work orders with accounts payable in the same place and a QuickBooks integration that syncs on Online or Desktop, which is the chain that keeps this number low.

Where the number is persistently high, the cause is nearly always that parts are ordered outside the system by whoever is nearest a phone.

Repeat visits is the only quality measure that survives scrutiny

Same equipment, same fault, inside thirty days.

Customer satisfaction scores in this trade measure how the day went. First-time fix rates measure whatever the person closing the job decided to record.

A repeat visit is a fact. It has a cost you can calculate, and it points at one of three causes: the diagnosis, the part, or a quote that was declined and should have been argued harder.

Watch the direction rather than the level. Every business has a rate and comparing yours to somebody else's is meaningless, while yours rising over six weeks is information.

2 numbers about money that is already yours

Open quotes and unbilled work, both aged.

Quotes over fourteen days old with no answer are usually not being considered, they are forgotten. A weekly list and one phone call converts a meaningful share of them, and almost nobody makes the call.

Unbilled completed work is worse, because the work is done, the cost is spent, and the invoice has not gone out. Anything older than a week is a process problem rather than a workload problem.

Both are lists rather than charts. The value is in the rows, because each row is an action, and a chart of the same data produces agreement rather than phone calls.

4 popular metrics worth ignoring

1. Jobs completed. Activity, not outcome. Rises when work is split and when work is rushed
2. Technician utilization. Punishes the person who spends twenty minutes doing a job properly
3. Average job value. Moves for a dozen reasons and tells you which one afterwards
4. Response time alone. Without the repeat-visit number, it rewards arriving fast and fixing nothing

None of the four is wrong as information. They are wrong as the weekly view, because they invite a reaction that makes the underlying business worse.

How to make the five actually get read

One page, one time, one person.

Same morning each week, same five numbers, with last week beside this week. Five is small enough to read standing up, which is the only condition under which it happens every week rather than for a month.

And nominate an owner per number. A metric everybody can see and nobody owns changes nothing, and the two list-shaped ones need somebody who will make the calls.

The pain starts around your third or fourth technician, which is where an owner stops knowing these figures by walking through the workshop and starts needing them written down.

Roopairs runs a product tour where you can see equipment records, purchase orders and the job data these numbers come from.

What service companies in the trade say

“I have used many apps in my career as a service technician. Roopairs is the best I have used so far. The interface is intuitive and designed for use on a mobile device.” — Minh Pham

Also worth reading

• Reporting to a Facilities Manager: The Numbers
• Accounts Payable for Service Companies
• Is equipment leasing worth it

Frequently asked questions

What should a service owner see every week?

Five numbers: jobs closed with a piece of equipment attached, unmatched supplier bills, repeat visits within thirty days, the value of open quotes over fourteen days, and unbilled completed work.

Why is "jobs with a piece of equipment attached" first?

Because every other useful report is downstream of it. Failure patterns, warranty position, parts cost by model and contract profitability all need the job to name the equipment, and it is also the fastest number to improve.

Why count unmatched supplier bills rather than value them?

Because a small unmatched bill is the same process failure as a large one, and a count is harder to rationalize away. A pile of them means your margin is an assumption for the whole month.

Why is repeat visits the best quality measure?

Because it is a fact rather than an opinion, it has a calculable cost, and it points at one of three causes: the diagnosis, the part, or a declined quote that should have been argued harder.

Which metrics should be left off?

Jobs completed, technician utilization, average job value and response time on its own. All four invite a reaction that makes the underlying business worse when they are the weekly view.

How do you make a dashboard get read?

One page, the same morning each week, five numbers with last week beside this week, and a named owner per number. Five is small enough to read standing up, which is why it survives past the first month.