What belongs on a job costing spreadsheet template for HVAC service?
By the Truceipts team · Published · Updated
A job costing spreadsheet template for HVAC service is one row per closed ticket. Put invoiced revenue, labor hours times your burdened rate, materials from the supply house and from truck stock, equipment, subs, permits, and callbacks. Gross profit is revenue minus those costs. Margin is that profit divided by revenue.
This is the sheet for a 5-to-15 tech HVAC shop on Jobber, Housecall Pro, or Workiz. There is no file to download. Type the headers into Excel or Google Sheets. A markup chart prices the next job. This sheet costs the one you already ran.
The columns on the sheet
One row per job. Installs and service calls use the same columns. Keep them as separate rows. A blended average hides both.
| Column | What you type | Where it comes from |
|---|---|---|
| Job | Ticket or job number | The field-service app’s job record |
| Customer | Address or name | Same job record |
| Tech | Who ran it | The job record or the timesheet |
| Date | Closed date | The job record |
| Revenue invoiced | Pre-tax total on the invoice | The invoice in the field-service app |
| Labor hours | Clock hours, including drive | The timesheet |
| Burdened rate | Cost per hour for that tech | Your fully burdened labor sheet |
| Labor cost | Hours times rate | Formula |
| Supply-house materials | Line set, pad, disconnect, fittings on a PO | The supplier invoice |
| Truck stock | Capacitor, filter, drier, fittings off the van | A same-day van log |
| Equipment | Condenser, furnace, coil, air handler | The supplier invoice |
| Subs | Electrical hookup, crane, drywall patch | The sub’s invoice |
| Permits | Inspection fee | The permit receipt |
| Callbacks | Later hours and parts, no new revenue | A $0 visit in the field-service app |
| Total cost | Sum of the cost columns | Formula |
| Gross profit | Revenue minus total cost | Formula |
| Margin | Gross profit divided by revenue | Formula |
Shop rent, the CSR, software, and marketing stay off this sheet. Recover them in the price book. The tech’s truck, fuel, and tools already live in the burdened rate.
Where each number comes from
HVAC costs arrive through several doors.
| Source | What it looks like | How it lands on the row |
|---|---|---|
| Field-service job | Ticket, address, tech, invoice total | Copy job, customer, tech, date, revenue |
| Timesheet | On-site time plus windshield time | Hours, including drive |
| Supply-house special | Condenser, furnace, coil on a PO | Equipment, plus materials that rode that invoice |
| Counter pickup | Extra fittings, a filter, more refrigerant | Supply-house materials, if the ticket names the job |
| Card swipe | After-hours run at a box store | Split the receipt if it covered two jobs |
| Truck stock | Capacitor or drier that never hit a PO | Truck-stock column, same day |
| Sub or permit | Electrician, crane, inspection | Subs or permits |
| Warranty visit | $0 invoice, a second truck roll | Callbacks, on the original job |
Technicians on r/HVAC flag the wage-only shortcut: the labor rate on the sheet has to carry burden, not the paycheck rate. Drive time is paid. If you log only the hour on the roof, you undercost every outlying service call.
Truck stock is the usual hole on short tickets. How to track material costs per job is the same leak on parts. Fold tape and small fittings into markup. Still cost the capacitor.
The formulas to type
Put headers in row 1. First job in row 2. In words:
- Labor cost = labor hours × burdened rate
- Total cost = labor cost + supply-house materials + truck stock + equipment + subs + permits + callbacks
- Gross profit = revenue invoiced − total cost
- Margin = gross profit ÷ revenue invoiced
If those columns sit in E through N as revenue, hours, rate, labor cost, supply-house, truck stock, equipment, subs, permits, callbacks, then:
- Labor cost:
=F2*G2 - Total cost:
=H2+I2+J2+K2+L2+M2+N2 - Gross profit:
=E2-O2 - Margin:
=P2/E2, formatted as a percent
Two techs on one call do not share a rate. Cost Luis at Luis’s rate times Luis’s hours, Sam at Sam’s. Add those two labor dollars into the labor-cost cell. Do not average $60 and $48 into $54.
A typed example
These dollars are worksheet numbers, not market rates. Replace every figure with the invoice, the timesheet, and the supplier PDF.
| Line | Service call | Install |
|---|---|---|
| Job | 1842, Elm Street, no-cool | 1847, Oak Avenue, changeout |
| Tech | Luis | Luis and Sam |
| Revenue invoiced | $485.00 | $8,400.00 |
| Labor hours | 2.5, including drive | 16.0 |
| Burdened rate (typed) | $60.00 | $60.00 |
| Labor cost | $150.00 | $960.00 |
| Supply-house materials | $0.00 | $420.00 |
| Truck stock | $18.00 capacitor | $85.00 fittings |
| Equipment | $0.00 | $3,850.00 |
| Subs | $0.00 | $275.00 electrical |
| Permits | $0.00 | $125.00 |
| Callbacks | $0.00 | $0.00 |
| Total cost | $168.00 | $5,715.00 |
| Gross profit | $317.00 | $2,685.00 |
| Margin | 65.4% | 32.0% |
2.5 × $60 = $150. $150 + $18 = $168. $485 − $168 = $317. $317 ÷ $485 = 65.4%.
16 × $60 = $960. $960 + $420 + $85 + $3,850 + $275 + $125 = $5,715. $8,400 − $5,715 = $2,685. $2,685 ÷ $8,400 = 32.0%.
The install uses one $60 rate so the arithmetic is visible. On a real crew, cost each tech at that tech’s rate.
A Saturday callback on job 1842 still belongs on 1842. Add 1.5 hours and a $12 part: labor becomes $240, truck stock becomes $30, total cost $270, gross profit $215, margin 44.3%. The original ticket kept a 65.4% bar until someone put the return visit back on the row.
Where the spreadsheet breaks
The columns are honest. The inputs often are not.
Receipts that never reach the sheet. A Ferguson PDF sits in the inbox. A Home Depot swipe covers Elm Street and Oak Avenue. Until someone splits it and types it, both jobs are wrong.
Truck stock. The capacitor never had a PO. Skip the van log and the service call looks fat. The truck empties.
Callbacks. A no-charge return visit is a second job with no revenue in the field-service app. If it never hits the original row, the install still looks like 32%.
Wage-only labor. Payroll tax, workers’ compensation, and the van sit in the burdened rate, or they sit nowhere. How to calculate the fully burdened labor rate is that sheet.
Friday-night re-keying. You are copying the field-service app, the timesheets, the supplier PDFs, and the card feed into one grid. The sheet is only as current as the last evening someone sat down with it.
Jobber’s job costing (updated 2026-09-17) can replace the sheet on Grow and Plus when timesheets, unit costs, and expenses are on the job. The profit bar is revenue minus those three. Truck stock still needs a quantity used. Does Jobber have job costing? is the click path.
Housecall Pro’s job costing setup (updated 2026-07-22) multiplies a fully loaded rate by time on the job, including travel, and has material job inputs for van parts on flat-rate work. Empty unit costs still leave the report as a quote. Housecall Pro reports is the export.
How to do job costing in QuickBooks Online is the same math in the books: one project per job, every bill tagged. An FSM sync that dumps every ticket onto one customer leaves that report empty.
Software that matches card swipes, supply-house bills, timecards, and sub invoices to a job from the field-service app can fill the hole where the sheet never got the receipt. We make Truceipts, which does this, so weigh that suggestion accordingly.
How to tell this week
You know the sheet is working when last week’s closed jobs show supply-house bills and van parts, drive is in the hours, and a $0 callback sits on the original row. If the job shows revenue and almost no cost, the columns are there and the inputs are not.
Pull last week’s ten closed jobs from Jobber, Housecall Pro, or Workiz. Lay each one next to the timesheets, the supplier PDFs, the card charges in QuickBooks, and what came off the van. Type those four sources into the columns. Those files already exist.
Frequently asked questions
Should shop rent and dispatch sit on each HVAC job cost row?
No. Shop rent, dispatch, software, and marketing are overhead. Recover them in the price book by holding a gross-margin target. The tech's truck, fuel, and tools already sit in the burdened labor rate. Dumping rent onto every ticket makes long jobs look worse for a reason that has nothing to do with that ticket.
Do I cost HVAC labor at the technician's wage or a burdened rate?
A burdened rate. Wage-only labor leaves payroll tax, workers' compensation, benefits, and that tech's van off the job, so every ticket looks fatter than it was. Multiply clock hours, including drive, by the rate from the fully burdened labor sheet. Two techs on one call get two rates, not a blend.
How do I cost a capacitor that came off the van?
Log quantity used the same day as truck stock, at what you paid, not the price-book sell. Housecall Pro's material job inputs are built for van parts on flat-rate work. If nobody records it, the job looks fat and the truck empties. Fold tape and small fittings into markup. Still keep a cost number on the sheet.
Should a warranty callback be a new row or a cost on the original job?
Put the callback hours and parts back on the original job, or add a $0-revenue row and look at the pair. A no-charge return visit still costs labor and a part. Leaving it off the original ticket keeps a profit bar that is wrong. Pull last week's $0 invoices from the field-service app.
Can Jobber or Housecall Pro replace this spreadsheet?
Yes, when timesheets, unit costs, and expenses actually sit on the job. Jobber's Grow and Plus plans show a profit bar from timesheets, line-item costs, and logged expenses. Housecall Pro's job costing breakdown does the same, including travel time when time tracking is on. Empty unit costs still leave both reports as a quote.