An HVAC owner dashboard is a one-page list of about twelve numbers, reviewed every month, that shows whether the company is earning, producing and collecting the way it should. This guide gives you the full checklist, how to calculate each line from data you already have, and the mistakes that make dashboards useless. You can build it yourself in a spreadsheet; you do not need us for this.
A note before starting: this is an operating tool, not accounting. Your own CPA keeps the books and prepares statements and tax filings. The dashboard should agree with their totals, but it answers different questions.
How to set the page up
Use one row per KPI and one column per month. For each line, add three columns at the right: the same month last year, the target, and a one-line note.
Three rules keep it useful:
- Write each definition down once, at the bottom of the page, and do not change it without noting the date.
- Compare with the same month last year, not just last month. HVAC is too seasonal for month-to-month comparisons to mean much.
- Set a target for every line, from your own history. A number without a target is just a fact.
Section 1: revenue and margin
- ☐ Revenue by job type. Total invoiced revenue split into replacements, repairs, maintenance visits and add-ons. Source: invoice report from your field-service software, filtered by job type or category. Watch for: job types that are growing faster than the rest, which will shift your blended margin.
- ☐ Gross margin by job type. (Revenue − direct costs) ÷ revenue for each type. Direct costs are equipment, parts, burdened field labour, permits, disposal and subcontractors. Source: job costing reports, or invoices plus purchase orders and timesheets. Watch for: install margin drifting down as crews take longer or equipment prices rise.
- ☐ Average ticket on service calls. Service revenue ÷ number of service calls completed. Watch for: a falling ticket in peak season, which often means rushed diagnostics.
Example check: if repairs brought in $48,600 from 270 calls, your average ticket is $180. If last October it was $205, ask what changed before assuming it is the market.
The gross margin by job type page explains how to agree on job types and direct costs.
Section 2: labour
- ☐ Revenue per paid technician-hour. Field revenue ÷ total paid technician hours, including drive, wait and training time. Source: payroll or timesheet totals, plus the invoice report. Watch for: the gap between this and revenue per billed hour.
- ☐ Utilisation. Billed hours ÷ paid hours. Watch for: a drop when service zones widen or when parts supply is poor.
- ☐ Callback rate. Return visits on work completed in the last 30 days ÷ jobs completed in that period. Watch for: a rising rate after a new hire or a new equipment line.
Example check: 6 technicians paid 1,010 hours in a month, billing 640 hours and $132,000. Revenue per paid hour is about $131, and utilisation is about 63%. The full worksheet is in the technician-hour maths guide.
Section 3: agreements
- ☐ Active members and net change. Members at month-end, and new members minus lapsed members. Source: your agreement list or membership report.
- ☐ Renewal rate. Members who renewed this month ÷ members due to renew this month. Watch for: manual renewals lagging auto-renewals, which usually points to follow-up rather than price.
Example check: 64 plans came due and 47 renewed, so the renewal rate is about 73%. If 17 lapsed and 22 joined, net change is +5, which looks healthy until you notice the lapse count rising each month.
Section 4: marketing and sales
- ☐ Marketing cost per booked job, by channel. All marketing costs for the channel (spend, fees, tools) ÷ jobs from that channel that reached the schedule. Source: ad accounts, vendor invoices and your booking records with source codes.
- ☐ Booking rate. Booked jobs ÷ inbound calls and messages. Source: call tracking or phone system reports plus the schedule. Watch for: a falling rate during peak weeks, when calls go unanswered.
- ☐ Replacement close rate. Sold replacements ÷ in-home estimates run. Watch for: a rate that differs sharply between salespeople or technicians.
Example check: 412 inbound calls and messages produced 236 booked jobs, a booking rate of about 57%. Every point of booking rate you recover lowers your marketing cost per booked job without spending a dollar more. More detail on the cost per booked job page.
Section 5: cash
- ☐ Weeks of fixed cost in the bank, and receivables over 60 days. Month-end bank balance ÷ weekly fixed costs, with the total of invoices unpaid after 60 days beside it. Weekly fixed cost is your monthly wages, leases, rent, insurance and software divided by about 4.3. Watch for: the figure falling below your agreed floor in the shoulder months.
Example check: $118,000 in the bank against $88,000 a month of fixed costs is about 5.8 weeks. If your floor is six weeks and April is coming, that is a line to act on now. The cash-flow calendar guide shows how to project it forward.
Running the monthly review
Once the page is filled in, the review itself should take under half an hour:
- ☐ Check that dashboard revenue roughly matches your accounting software for the month.
- ☐ Circle every line more than your agreed tolerance away from target.
- ☐ For each circled line, write one likely cause, using the other lines as evidence.
- ☐ For each cause, write one action, one name and one date.
- ☐ Start next month's review by checking last month's actions.
Common mistakes
- Adding lines until nobody reads it. If a number never triggers a decision, drop it.
- Mixing definitions. Utilisation calculated two ways in two months cannot be compared.
- Treating the dashboard as a scorecard for staff. Most red lines are caused by systems, schedules and supply, not by one person.
- Skipping the lean months. The dashboard matters most in April and May, exactly when owners are tempted to stop looking.
When to get help
Many owners run this checklist on their own for years. Others want someone outside the business to prepare it, challenge the numbers and hold the monthly review. That is our monthly owner dashboard service, quoted in writing. Either way, the definitions above are yours to use.
Frequently asked questions
How long does it take to fill in the checklist each month?
The first time, an afternoon, mostly spent finding reports. After two or three months, an office manager can usually complete it in an hour or two.
Do I need special software?
No. A spreadsheet with one column per month is enough. Your field-service and accounting software already hold most of the data.
What if my numbers don't match my accountant's statements?
Small gaps are normal because of timing. Large gaps usually mean jobs coded to the wrong type or revenue counted in a different month. Ask your CPA how they record revenue, and match your dashboard to that rule.
Which line matters most?
It depends on the company, but weeks of cash on hand is the one that most often turns a bad month into a crisis. Check it first.