ScheduledHVAC
    Analytics

    HVAC Service and Install Reporting: Two Columns, Better Decisions

    Tony Delgado sees $250,000 at the top of a worked revenue report. "If the total is growing, both departments are doing their job." That is a reasonable first reaction when one company pays one payroll. A growing total can hide a department that needs a different decision.

    Tony is an illustrative owner, not a client case study. His twelve-technician business has three install crews and an approximate 40/60 service-install revenue mix. Those percentages describe dollars. They do not describe technician hours or next week's available capacity.

    His recurring origin story starts with a six-week install backlog and service technicians sent home early. The marketing report had one line item. It could not explain why one side was unavailable while the other needed work.

    The answer is not another dashboard of totals. It is a small report with the right units kept apart.

    Which three views keep the report honest?

    Separate the forward operating plan, acquisition cohorts, and completed-work financials. They answer different questions and use different dates.

    The forward plan asks what the team can sell and deliver next. The cohort view follows inquiries first received in a defined period through their later outcomes. The completed-work view matches revenue and direct costs to jobs performed during the accounting period.

    Do not judge this month's replacement marketing solely by installations completed this month. Some of those customers first inquired earlier. Equally, do not use an intake-cohort report as a substitute for next week's dispatch plan.

    The inquiry-to-invoice tracking process explains how the records connect. This operating report uses those records to make decisions. It does not require rebuilding the tracking system every Monday.

    Assign an owner for each source: dispatch supplies usable capacity and commitments, intake supplies inquiry outcomes, sales supplies proposal status, and the financial record supplies completed-job amounts and costs. State the cutoff date on every view.

    Tony can keep the $250,000 headline. He now asks which view produced it before using it to explain another problem. The same month label does not make unlike records comparable.

    What belongs in the forward capacity columns?

    Use separate units for the two departments. For service, report available appointment capacity or usable hours with the job-duration assumptions. For install, report usable crew-days and the project types those days can support.

    Here is a separate weekly example, not Tony's actual board:

    Forward planServiceInstall
    Usable capacity after reserve60 appointments12 crew-days
    Already committed48 appointments10 crew-days
    Remaining12 appointments2 crew-days

    Do not add twelve appointments and two crew-days and call the result fourteen jobs. If a particular replacement needs two crew-days, the install gap can support one such project. Different project durations change that answer.

    Include agreement work and known follow-up obligations before calculating the remainder. Tony's roughly 1,100 active agreements are current commitments to model, not an automatic percentage of the schedule.

    Service and install capacity should be based on the actual people assigned. If a worker moves between departments, remove the time from one board before adding it to the other.

    Tony's original one-line report concealed the empty service afternoon. The forward columns make it impossible to explain that opening with a distant install backlog. The units themselves force the useful question.

    What does the completed-work comparison reveal?

    Use a hypothetical completed-work period with $100,000 in service revenue and $150,000 in install revenue. Assume associated direct delivery costs of $60,000 and $105,000. These are modeled amounts, not Tony's financial results or industry margins.

    Completed-work viewServiceInstall
    Revenue from included jobs$100,000$150,000
    Matched direct delivery cost$60,000$105,000
    Contribution before marketing$40,000$45,000

    Install has 60% of modeled revenue, but $45,000 of the combined $85,000 contribution before marketing, about 52.9%. The revenue split did not describe the contribution split.

    Define direct costs consistently. If job labor is already included here, do not charge that same labor again as an unallocated operating expense. Keep the distinction between job contribution and net company profit clear.

    The SBA's finance guidance describes analyzing business segments and categorizing revenue and expenses. The exact departmental worksheet is your operating choice; its usefulness depends on consistent underlying records.

    Tony's larger tickets still matter. The second column shows why ticket size alone cannot decide which department deserves more marketing. Costs and available work are part of that decision too.

    How should shared marketing costs be split?

    Trace costs directly where practical. Assign a service campaign to service and an install campaign to install. For genuinely shared work, state a reasonable driver and retain an unallocated line if there is no defensible basis yet.

    Continue the hypothetical period. Suppose directly traced marketing costs are $3,500 for service and $4,500 for install. A $2,000 shared support bill is allocated 60% to service and 40% to install based on documented support workload in this example, not revenue share.

    Service receives $1,200 of shared support, for total marketing cost of $4,700. Install receives $800, for $5,300. Together they reconcile to $10,000, the actual modeled marketing total.

    Contribution after these marketing costs is $35,300 for service and $39,700 for install, or $75,000 combined. That amount remains available for fixed overhead and profit. It is not net profit.

    Keep the allocation rule visible. A different justified driver will change departmental figures without changing the company's $10,000 total. Do not use the apparent precision of a spreadsheet to hide that judgment.

    For acquisition efficiency, still use appropriate intake cohorts and a stated spend scope. This completed-work allocation does not automatically prove a cost per newly acquired customer. The marketing budget allocation process uses both the forward gap and the economics before committing new spend.

    Tony has two cost columns now, but the original bill must still be counted once. Splitting the report should expose an assumption, not create a second copy of an expense.

    Where do crossovers, cancellations and unpaid invoices go?

    Preserve the difference between initial inquiry intent and final job type. A repair inquiry that produces a replacement can appear as a service-origin opportunity while its install revenue belongs to the actual installation job. Do not turn it into two newly acquired customers.

    Use unique job and invoice records when totaling money. If one service invoice and one later install invoice belong to the same customer, include each real invoice once. Assisted channels do not receive duplicate copies of the revenue.

    Show cancellations and future commitments separately from completed work. A proposal viewed or accepted is not an installation performed. The install proposal follow-up process needs those open stages without promoting them to revenue.

    Keep invoice status and cash receipts visible too. An invoice issued is not necessarily collected. Choose the accounting basis with the person responsible for your books and do not combine a receipts numerator with a completed-work cost basis without explaining it.

    Record changes rather than silently rewriting old totals. Corrections, credits, reschedules, and late invoices should be understandable at the next review.

    Tony's one line item used to make all movement look like growth. The split shows which movement is a new inquiry, a future promise, delivered work, or cash actually received.

    What should the weekly meeting decide?

    Keep the review short enough to run. Start with available capacity and lead time, then the oldest unresolved opportunities, then mature outcomes and completed-work economics. Agree which view supports each decision.

    If service appointments are open, inspect eligible demand and booking. If installs are sold but undated, inspect scheduling. If revenue rises while contribution falls, inspect direct cost and acquisition scope before demanding more volume.

    Assign one action, a responsible person, and a date to check it. A report nobody acts on is another administrative task. A report that changes definitions each week is not a reliable comparison.

    Use the larger-company marketing model when the next question is how staffing, inquiry needs, and contribution fit together at your scale.

    Two columns are useful when they lead to two decisions the single total could not support.

    In Tony's illustrative review, the headline remains. Under it, the dispatcher can name service openings, the sales manager can name install commitments, and the financial record can explain what each side leaves after its costs.

    He finally has a report that can disagree with his first impression, and a way to use the disagreement.