Controller dashboard playbook

A practical operating rhythm for the person who owns the numbers in a home-service company. What a controller should review daily, weekly, and monthly, which financial KPIs to own, and how a live financial dashboard replaces the end-of-month scramble.

By Datacube content engineAutogeneratedJune 24, 2026

Here is the old version of the job. You pull QuickBooks at month-end. You reconcile the CRM job data against the accounting file. You find a $40,000 discrepancy somewhere between revenue and payroll, and you spend three days building spreadsheets to explain it to the owner. By the time the explanation lands, the month is already gone.

Here is the new version. Revenue, COGS, gross profit, labor percentage, and net operating income are visible in a live financial dashboard, updated throughout the day from both QuickBooks and the field-service CRM. You catch the labor overrun in week two, not week five. You give the owner a clean picture on the 25th instead of the 10th of next month.

This playbook covers what a controller in a home-service or skilled-trades company should review at each time horizon, which financial KPIs to own, and how a live financial dashboard changes the cadence from reactive reporting to proactive oversight.

The short version

  • Own gross profit percentage, labor percentage, COGS accuracy, and net operating income. Each one tells you whether the business is making money on the work it is actually doing.
  • A daily glance at revenue pacing and expense approvals beats a weekly catch-up. Problems compound inside the month if they go unseen.
  • The biggest source of controller error is not accounting; it is data scattered across a CRM, a payroll platform, and QuickBooks with no single live view reconciling them.
  • A live financial dashboard does not replace the close; it makes the close faster by eliminating surprises that only show up at month-end.

The financial KPIs a controller should own

Each metric is tied to a decision you make or an alert you escalate. Status colors are directional examples only. Real targets vary significantly by trade, seasonality, market, and company size, so calibrate against your own baseline rather than industry averages.

  • Gross profit percentageDecision: is the gap between revenue and COGS narrowing mid-month? If yes, escalate to the GM before the margin is gone.
    Good
    Current
    Live MTD
    Target
    Varies by trade and job mix
  • Labor percentage (labor cost / revenue)Decision: which department is running over labor budget, and is it overtime, underbooking, or a payroll-coding issue?
    Watch
    Current
    By department, live
    Target
    Company-specific baseline
  • COGS accuracy (parts, materials, subcontractors)Decision: are field costs being coded to the right cost center, or is the P&L distorted by a journal entry from last month?
    Watch
    Current
    Line-item by department
    Target
    Match job costing in the CRM
  • Net operating income (NOI)Decision: is the business generating real operating profit, or is revenue growth being consumed by overhead creep?
    Good
    Current
    MTD and YTD
    Target
    On pace for annual plan
  • Expense pacing vs. budgetDecision: which categories are trending over before the invoice stack hits at month-end?
    Watch
    Current
    Monthly budget vs. actual
    Target
    No category running more than 5 pts over
  • Revenue pacing (MTD vs. goal)Decision: if revenue is behind pace in week two, the owner and GM need to know now, not on the 1st.
    Good
    Current
    Daily, by department
    Target
    On pace for monthly goal
  • Accounts receivable agingDecision: which jobs have invoiced but not collected, and who needs a follow-up before the period closes?
    Poor
    Current
    Outstanding by bucket
    Target
    Minimize 60+ day exposure

Warning

Margin leak alert: where controllers lose ground mid-month

In home-service companies the most common margin leaks are not fraud or big errors. They are slow journal entries that let labor costs sit in the wrong period, parts costs coded to overhead instead of job COGS, and revenue recognized on jobs that have not yet been fully invoiced. None of these show up in a week-end summary. They accumulate across the month and turn a projected 28% gross margin into a realized 21%. A live financial dashboard that reconciles the CRM job data with QuickBooks catches the drift in real time so you can correct the coding before it sets.

Month-end close agenda: what to review and when

TimingReview focusData sourceAction if something is off
Day 1-5 of monthPrior-month revenue reconciliation: CRM vs. QuickBooksCRM (ServiceTitan, Workiz, Housecall Pro) + QuickBooksFlag and journal any gap; confirm job types are mapped to the right revenue lines
Day 1-5 of monthLabor cost true-up: payroll export vs. CRM labor hoursPayroll system + CRMReclass any overtime coded to the wrong department
Week 1 of current monthExpense categories vs. prior-month budgetQuickBooks P&L by classSurface any category running 10%+ over and share with the GM
Week 2 of current monthRevenue pacing check: departments on pace for goal?Live financial dashboard (MTD)Alert the owner if any department is behind by more than 15% with two weeks left
Week 3 of current monthAR aging: open invoices past 30 daysQuickBooks AR aging reportEscalate any 60+ day account to the owner; kick off collections workflow
Week 4 of current monthNOI projection: will the month close at plan?Live financial dashboard (YTD trending)Give the owner a pre-close estimate so decisions can still be made before the month ends

Your daily, weekly, and monthly financial rhythm

  1. 01

    Daily (10 minutes, first thing)

    Glance at revenue pacing MTD against goal. Check if any large expenses posted overnight that need coding review. Confirm the prior day's CRM revenue matches what QuickBooks received. If there is a discrepancy of more than a few hundred dollars, flag it now before it snowballs into a month-end journal entry.

  2. 02

    Weekly (30-minute finance review)

    Pull gross profit and labor percentage by department for the week. Compare expense categories to the monthly budget line. Identify any vendor invoices sitting in AP that could affect the current-period COGS. Share a one-page snapshot with the GM and owner so they are not surprised at month-end. If the business uses a quarterly board review or investor report, this weekly rhythm is where you build the evidence.

  3. 03

    Monthly close and reporting

    The controller's most visible moment is the monthly P&L. Use the live dashboard's MTD and YTD trending to produce a close estimate before day 25. Reconcile CRM-to-QuickBooks revenue, finalize payroll coding, post any reclasses, and lock the period. Then deliver a one-page executive summary: revenue vs. plan, gross profit percentage, labor percentage, NOI, and top two variance drivers. The goal is to have this in the owner's hands by the 5th of the following month, not the 15th.

  4. 04

    Quarterly: trend analysis and forecast review

    At the end of each quarter, pull the trailing three-month trend for every major P&L line. Are gross margins improving or compressing? Is labor creeping as a percentage of revenue? Use the dashboard's year-over-year trending view to identify seasonal patterns and build a more accurate forecast for the next quarter. Share with the owner and, for multi-location companies, with each location GM so accountability is visible.

What a controller's financial dashboard looks like

A live web view that consolidates QuickBooks financials with CRM revenue data so you can track gross profit, labor, and NOI without toggling between systems.

Dashboard preview

Figures are illustrative. A datacube financial dashboard is configured around your QuickBooks chart of accounts, CRM data, departments, and company goals.

Warning

Escalation triggers: when the controller acts same-day, not at close

Most financial surprises are preventable if you catch the signal early enough. Escalate the same day when: labor percentage crosses 5 points over budget in any department (overtime is compounding); a large AP invoice posts to the wrong expense category and will distort the month-end P&L if left uncoded; revenue pacing drops more than 15% behind goal with less than two weeks remaining; or AR aging shows a significant account has passed 60 days with no payment plan. Each of these is recoverable mid-month. None of them is recoverable on the 30th.

Goals and budget vs. actual

Accountability that does not wait for the close

Where a live financial dashboard changes the controller's operating rhythm:

  • Department-level revenue goals visible daily so you can spot a department drifting behind in week two, not week five.
  • Labor and expense budgets tracked in real time, so overage conversations happen before the invoice stack arrives.
  • Year-over-year trending on gross profit and NOI to separate seasonal patterns from real margin compression.
  • Multi-location rollup so the controller for a company with several branches sees each location's P&L on one screen rather than consolidating spreadsheets.

Controller dashboard playbook FAQs

Stop closing blind. See your financials live

Datacube builds a custom financial dashboard for home-service controllers: QuickBooks-connected, CRM-reconciled, and live across revenue, gross profit, labor, and NOI. You catch the problems in week two, not on the 30th.