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.

Related

Request your spot

Month-to-month. No card needed today. Privacy