Job Profitability Report Template for Home Services Businesses
A clear template for seeing which HVAC, plumbing, and electrical jobs actually make money, plus a way to have the report prepared from your job data each week.
Revenue tells you the business is busy. Profit per job tells you whether busy is worth it. Plenty of home services companies grow their top line while margin quietly leaks out through underpriced work, callbacks, and jobs that ran long. A job profitability report makes that visible while you can still do something about it.
The report is straightforward to run on a schedule once you decide what a "job" costs and where those numbers live. Then an assistant can prepare the first pass each week, and you can spend your time on the jobs and quotes it flags.
What belongs in a job profitability report
Keep it to a page you will read between calls:
- Job summary: jobs completed in the period, total revenue, and average revenue per job.
- Cost breakdown per job: labor hours, materials, and any subcontractor or equipment cost.
- Margin per job: revenue minus cost, shown in dollars and as a percentage.
- Outliers: the least profitable jobs, with the reason where your notes support it (underquoted, callback, travel, overtime).
- By job type or crew: margin grouped by service line (install vs. repair) or by crew, so patterns show.
Build a source map first
Every number needs a named home. This small table is what keeps the report honest instead of merely tidy.
| Report item | Source | Owner | Freshness rule |
|---|---|---|---|
| Job revenue | Invoicing / field-service software export | Office manager | Closed jobs through period end |
| Labor hours | Timesheets or dispatch log | Office manager | Reconciled weekly |
| Materials cost | Supplier invoices / purchase log | Owner | Matched to the job |
| Notes on overruns | Job notes or crew debrief | Lead tech | From the period's jobs |
The map also prevents the usual distortion, where a job looks profitable only because its material cost landed in a different week's numbers.
Set a cutoff and a definition of cost
Fix the period and cutoff — for example, "Cover last week's completed jobs, using invoices and timesheets entered by Monday 9 a.m." Then decide what counts in cost: labor at loaded rate, materials, subs, and whether you include truck or overhead. Write it down once. A consistent definition is what makes this week's margin comparable to last week's.
Separate the number from the explanation
A useful report distinguishes fact from cause so a thin job prompts a question, not a blame session:
- Fact: the Johnson install returned 12% margin against a 35% target.
- Documented explanation: job notes show a return trip for a part that was not on the truck.
- Open question: whether the original quote missed scope is not established by the notes.
Ask your assistant to label these. You decide whether to fix pricing, stocking, or scheduling.
A prompt for the report
Use this as a starting brief:
Prepare the weekly job profitability report using the invoicing export, timesheets, and materials log I select. For each completed job, show revenue, labor cost, materials, subs, and margin in dollars and percent. Rank the least profitable jobs and add one sentence of documented explanation where the notes support it. Group margin by service type. Never invent a cost or a cause. Deliver a one-page summary and a supporting spreadsheet to me for review.
Have it prepared in the inbox you already use
You do not need another dashboard to log into. Deck runs as a scheduled task and sends one consolidated email to you — the summary plus an attached spreadsheet — built fresh each week from the files you point it at. It reads those sources read-only and can attach Excel, PowerPoint, Word, PDF, or CSV.
The same assistant works from its own email address the rest of the week: forward it a supplier invoice or a customer thread and it comes back to you with a summary or a drafted reply in your voice, without ever logging into your mailbox. Larger teams can link several addresses to one assistant and run it on their own domain — office@yourcompany.com instead of the default @agent.hellodeck.ai — so the owner and the office both work with the same setup.
See business reporting automation for the recurring report workflow, and how the AI email assistant works for the day-to-day CC-and-forward side. The follow-up system that wins more trades jobs covers turning quotes into booked work, and the KPI scorecard template helps you keep the metric set small.
Get your Deck assistant and forward last week's invoices with the outline above. Your own job data is the fastest way to see where the margin really goes.
