Dashboard
What Belongs on an HVAC Financial Dashboard
The numbers an HVAC owner should see on a financial dashboard, and how to read it each morning before the first truck rolls.
Key takeaways
- A dashboard should answer three questions: cash, profitability, and drift, in under two minutes.
- Cash on hand, accounts receivable aging, and upcoming bills belong at the top.
- Gross margin by job type and payroll percentage should update weekly, not quarterly.
- Revenue per technician and close rate on estimates show operational health, not just financial health.
- A dashboard only works if someone reads it daily and acts on what it shows.
A good HVAC financial dashboard fits on one screen and answers three questions at a glance: is cash healthy, is the crew profitable this week, and is anything drifting out of range. It should take under two minutes to read every morning, not a spreadsheet you dread opening.
The problem with most owner dashboards
Plenty of HVAC owners have some version of a dashboard already, a spreadsheet, a report from their accounting software, or a dashboard bolted onto their job management system. Most of these fail for the same reason: they show too many numbers, updated too rarely, in a format built for an accountant rather than an owner standing in a truck bay at 6:30 a.m. with ten minutes before the day starts. A useful dashboard is the opposite: a small number of numbers, updated close to real time, in language that answers a decision rather than describing a transaction. The goal is not more data. The goal is a two-minute read that tells an owner whether today is a normal day or a day that needs attention.
Section 1: Cash, the top of the page
Cash belongs at the very top, because it is the number that determines whether the business survives a bad month, not just whether it looks profitable on paper. Show current cash on hand, accounts receivable aging (especially anything over 30 days), and upcoming known bills for the next two to four weeks: payroll, loan payments, insurance, and large supplier invoices. A single line comparing cash on hand to weeks of average operating expenses (targeting 4-6 weeks) turns a raw dollar figure into something an owner can judge instantly, without doing math in their head first thing in the morning.
- Cash on hand today
- Accounts receivable over 30 days past due
- Known bills due in the next two to four weeks
- Weeks of operating expenses covered by current cash
Section 2: Profitability by job type
Below cash, show gross margin broken out by service, install, and maintenance agreements, updated weekly, alongside net profit margin for the trailing month. This is where a blended, company-wide margin number actively hurts an owner, because it can mask a losing segment behind a profitable one. Seeing service margin sitting at 48 percent while install margin has slipped to 15 percent tells an owner exactly where to look, instead of a single 35 percent blended figure that tells them nothing actionable. This section is also where net profit margin should live, since it is the number that ultimately determines whether the business is building wealth or just staying busy.
Section 3: Payroll and utilization
Payroll as a percentage of revenue, revenue per technician, and current overtime hours belong together, because they tell the same story from three angles: are we running the right size crew, and are we using them efficiently. A payroll percentage drifting toward 38-40 percent, paired with revenue per technician sliding below $250,000, points clearly at a scheduling or demand problem rather than a payroll problem, and the dashboard should make that connection obvious rather than requiring the owner to piece it together from two different reports.
Section 4: Sales and pipeline
Close rate on estimates, average ticket size, and the value of open, unsold estimates round out the picture, because financial health and sales health are the same conversation viewed from different angles. A close rate that has dropped from 55 percent to 40 percent over two months is an early warning sign that will show up in revenue and payroll percentage a month later if nobody catches it now. Including it on the same dashboard as cash and margin keeps an owner from treating sales performance as a separate department's problem.
What to leave off the dashboard
A good dashboard is defined as much by what it excludes as what it includes. Detailed general ledger entries, full balance sheets, and line-item expense reports belong in a monthly review with a Virtual CFO, not on a daily screen. Vanity metrics, like total number of jobs completed with no context on profitability, tend to make an owner feel good without telling them anything useful. If a number does not change a decision an owner might make today or this week, it does not belong on the daily view; save it for the monthly deep dive.
How to actually read it each morning
Read top to bottom in under two minutes: check cash first, since it is the number that can force an emergency decision; check profitability by job type second, since it shows whether the work booked this week is worth doing; check payroll and utilization third, to catch scheduling drift early; check sales last, since it predicts next month's numbers rather than describing this week's. Look for anything colored outside its healthy range, not for a full re-read of every figure. Over time, the goal is pattern recognition: an owner who reads this every morning for a month starts noticing drift in days instead of months, which is the entire point of a Financial Command Center and a daily Morning Brief built for how owners actually run their day, not how accountants close their books.
Why a Virtual CFO changes what a dashboard can do
A dashboard alone shows numbers; it does not explain why a number moved or what to do about it. Pairing a daily dashboard with monthly Virtual CFO review closes that gap: the dashboard catches drift in real time, and the CFO conversation turns that drift into a decision, whether that is a price adjustment, a staffing change, or a look at a supplier contract. Owners who have both tend to make smaller, more frequent corrections instead of one large, stressful correction after a bad quarter finally forces the issue.
Questions people ask
What are the most important numbers on an HVAC financial dashboard?
Cash on hand, gross margin by job type, net profit margin, payroll percentage, and revenue per technician are the core numbers that belong at the top of any HVAC financial dashboard.
How often should the dashboard update?
Cash and sales pipeline numbers should update daily or near real time; margin and payroll figures update well weekly, since they change more slowly and are noisier at a daily level.
Should the dashboard include every number from my P&L?
No, a good dashboard is deliberately narrow; detailed line-item expenses belong in a monthly review, not a daily screen, or the dashboard becomes something owners avoid opening.
Can a dashboard replace a Virtual CFO?
No, a dashboard shows what is happening, while a Virtual CFO explains why it is happening and what to do about it; the two work best together, with the dashboard catching drift daily and the CFO conversation turning it into action monthly.
Want these numbers waiting for you every morning?
QuickBooks records your numbers. LedgerDude turns them into a simple daily brief: your cash, what happened yesterday, what is coming next, and what deserves your attention.
