CFO dashboard playbook for home-service companies
A financial operating rhythm for the CFO or finance lead in a home-service business. Which metrics to own, how to review them daily and monthly, and how a live financial dashboard replaces the month-end scramble with real-time visibility.
Role playbook
Before and after: what financial clarity actually looks like
Before datacube, the typical home-service CFO spends the last week of every month reconstructing reality. QuickBooks exports get stitched into spreadsheets, department leads send in their own numbers, and by the time the picture is clear the month is already over. Decisions get made on vibes and gut checks, and the first real look at gross profit by trade often arrives 10 days after month-end. After: the financial dashboard refreshes throughout the day. Revenue, COGS, gross margin, labor percentage, and expense pacing are visible as the month unfolds, not after it closes. That shift does not just save reporting time. It changes the decisions you can make, the conversations you can have with the owner or the board, and how fast you can catch a margin problem before it compounds. This playbook is the operating rhythm that makes that visibility useful.
The short version
- Own gross profit by trade, labor percentage, expense pacing, and NOI. Each one points to a different operational lever, not just an accounting line.
- Run a daily revenue flash, a weekly profitability check, and a structured month-end close. The earlier you catch a margin miss, the more you can do about it.
- A live financial dashboard connected to QuickBooks and your CRM lets you spot when labor costs are running hot mid-month, not at the close meeting.
- The biggest financial leak in most home-service companies is not low revenue. It is high-volume work with thin margins disguised by top-line growth.
The financial KPIs a CFO should own
Each metric drives a different conversation with the owner, GM, or department heads. Targets vary by trade, business model, geography, and season. Set them against your own baseline and adjust as the business changes.
- Gross profit by trade or departmentDecision: which services are profitable and which are subsidizing the rest of the business.Good
- Current
- Live MTD by department
- Target
- Know your floor by trade
- Labor percentage of revenueDecision: are overtime, callbacks, or inefficient routing eroding the margin this month?Watch
- Current
- MTD and trending
- Target
- Watch against your model
- COGS and material costDecision: where material costs are running over estimate and whether pricing needs adjusting.Good
- Current
- By job category
- Target
- Aligned to job-costing model
- Net operating income (NOI)Decision: whether the business is on track to hit its profitability goal for the year.Good
- Current
- MTD vs. target
- Target
- Track against annual plan
- Expense pacing vs. budgetDecision: which expense categories are running ahead of plan and need a conversation now.Watch
- Current
- By category, MTD
- Target
- On or under budget by week
- Total revenue MTD and YTDDecision: is current revenue pace enough to hit the year, and which trade is dragging?Good
- Current
- Live from CRM
- Target
- On pace for annual target
- AR aging and cash positionDecision: which accounts need immediate follow-up to protect cash flow this week.Poor
- Current
- 30/60/90 day aging
- Target
- Minimize 60+ day receivables
| Metric | Current | Target | Status |
|---|---|---|---|
| Gross profit by trade or departmentDecision: which services are profitable and which are subsidizing the rest of the business. | Live MTD by department | Know your floor by trade | Good |
| Labor percentage of revenueDecision: are overtime, callbacks, or inefficient routing eroding the margin this month? | MTD and trending | Watch against your model | Watch |
| COGS and material costDecision: where material costs are running over estimate and whether pricing needs adjusting. | By job category | Aligned to job-costing model | Good |
| Net operating income (NOI)Decision: whether the business is on track to hit its profitability goal for the year. | MTD vs. target | Track against annual plan | Good |
| Expense pacing vs. budgetDecision: which expense categories are running ahead of plan and need a conversation now. | By category, MTD | On or under budget by week | Watch |
| Total revenue MTD and YTDDecision: is current revenue pace enough to hit the year, and which trade is dragging? | Live from CRM | On pace for annual target | Good |
| AR aging and cash positionDecision: which accounts need immediate follow-up to protect cash flow this week. | 30/60/90 day aging | Minimize 60+ day receivables | Poor |
Info
Data visibility gap: where most home-service CFOs lose margin without knowing it
Most home-service companies track revenue well. They track expenses poorly in real time. The gap sits in the middle: labor overruns that do not show up until payroll closes, material costs that drift above the estimate on a job type without triggering an alert, and overhead allocations that look fine in a spreadsheet but are quietly making one trade unprofitable. A financial dashboard that connects QuickBooks data with CRM revenue by job type closes that gap. You see labor percentage by department mid-month, COGS by category as invoices post, and expense pacing by budget line as the month runs, not 10 days after it ends.
CFO decision cadence: what to review, when, and why
| Review cadence | Key metric | Question it answers | Red flag to act on |
|---|---|---|---|
| Daily (5-minute flash) | Revenue MTD vs. pace | Are we on track to hit the month? | Revenue 10%+ below pace by mid-month |
| Weekly (profitability check) | Labor % and gross margin by trade | Is a department running over on labor this week? | Labor % climbing 3+ points above baseline |
| Monthly (close review) | NOI, COGS, expense pacing vs. budget | Did we hit profitability targets, and where did we miss? | Any trade with negative gross margin for the month |
| Quarterly (board or owner prep) | YTD revenue, margin trends, expense variance | Are we growing profitably, and what is the full-year projection? | Margin compression despite revenue growth |
| Ad hoc (spike investigation) | COGS by job type or AR aging | Why did margin drop on this job category? | Single job type with COGS above 60% of revenue |
Your financial review rhythm, built around the home-service calendar
01 Daily revenue flash (under 5 minutes)
Pull up the financial dashboard before the morning stand-up. Check revenue MTD against pace and flag any trade or department that is meaningfully behind. You do not need to investigate every day, but you need to know by 9am whether the month is on track or off. That visibility changes every conversation you have with the GM and department heads.
02 Weekly profitability check (30 minutes)
Review gross profit by trade and labor percentage versus your model. If HVAC is showing compressed margins this week, find out now whether it is callbacks, overtime, or a pricing problem before it becomes a close-month surprise. Share a one-page summary with the owner and GM so the conversation is grounded in current numbers, not intuition.
03 Month-end close review (structured)
With a live financial dashboard, the close review becomes a confirmation of what you already saw in real time, not a discovery session. Compare final NOI, COGS, expense lines, and revenue by department against budget. Document the key variances and set next month's targets. Because the numbers have been visible all month, you walk into the close conversation with the owner already knowing the story.
04 Board or owner reporting prep (quarterly)
Pull the YTD trend view: revenue against prior year, gross margin by trade, NOI against annual plan, and forecast for the remainder of the year. A dashboard with AI-assisted revenue trending gives you a projected end-of-year figure based on current pace, useful as a decision-support tool (not a guarantee) when you are presenting to owners or investors. Pair the numbers with context: what drove the best months, and what is the plan to protect margin in slower seasons.
What a CFO financial dashboard looks like in datacube
A web dashboard that gives you a real-time view of revenue, margins, and expenses across the whole business, sourced from QuickBooks and your CRM. Built for the CFO, not the tech team.
Figures are illustrative. A datacube financial dashboard is built around your QuickBooks chart of accounts, CRM data, and business structure. No two builds are identical.
Financial modules a home-service CFO gets in datacube
QuickBooks financial dashboard
Revenue, COGS, gross profit, net operating income, and labor percentage pulled directly from QuickBooks and displayed in real time alongside CRM revenue data.
Gross margin by trade or department
See profitability broken out by HVAC service, HVAC install, plumbing, electrical, or any other division you run, so you know which lines are pulling their weight.
Expense pacing and budget tracking
Track spending by category against your monthly budget as the month runs. Catch an overage in marketing spend or vehicle costs before it lands on the P&L.
Revenue trending and forecasting
The trending view projects full-year revenue from current pace, giving you a data-supported projection to share with the owner or board. Designed for decision support, not as a guarantee.
Month-to-date and year-to-date views
Every financial metric is available MTD and YTD so you can track monthly performance while keeping an eye on the full-year picture in the same view.
Goal and target tracking
Set revenue and profitability targets at the company, department, or trade level. Green when on track, red when off. The dashboard makes the gap visible in real time, not at close.
Warning
CFO red flag: revenue growing, margin shrinking
The most common trap in a growing home-service company is top-line revenue climbing while gross margin quietly compresses. It shows up as a great month on the sales board and a disappointing P&L at close. The cause is usually a shift in job mix (more low-margin work as volume grows), labor percentage climbing with overtime, or material costs running above the estimate on a fast-moving service category. If revenue and gross profit are trending in opposite directions on your dashboard mid-month, that is the moment to have the conversation with the GM and ops team, not after the month closes.
CFO dashboard playbook FAQs
See your financials live, not 10 days late
Datacube builds a custom financial dashboard for home-service CFOs, connecting QuickBooks with your CRM so gross profit, labor percentage, and expense pacing are visible throughout the month, not just at close. Schedule a live demo to see what your numbers look like in a live dashboard.
Keep exploring