HVAC · Excel workbook

HVAC job costing spreadsheet for install and replacement jobs

Know what an hour of your crew really costs, price every job to the margin you need, and see whether it is making money while it is still running.

$39 one-time · instant download
FormatExcel (.xlsx), no macros
IncludesBlank workbook, filled example, quick-start guide
LicenseOne business, your own jobs
Checkout opening soon

The number most HVAC contractors price wrong

A crew member's wage is not what their hour costs you. Payroll taxes, workers' comp and benefits sit on top of it. Price on the wage and the difference comes out of your profit on every job.

From the example file: lead installer
$36.00 wage × 1.22 taxes & comp + $5.00 benefits = $48.92 per hour

See it on a real-looking job

The kit comes with a filled-in example: Furnace + AC replacement. These are the estimate lines from that file.

Cost codeLineLine cost
General conditionsLoad calc, site visit, scheduling$202
Permits & feesMechanical permit$185
Removal & disposalRemove old furnace and condenser, recover refrigerant$228
Equipment96% AFUE furnace, 80k BTU$2,744
Equipment3-ton condenser + matched coil$4,383
EquipmentCondenser pad$95
Refrigerant & line setsLine set 25 ft, brazing, evacuation$735
Gas pipingReconnect gas, new shutoff and drip leg$163
Venting & fluePVC intake and exhaust$277
DuctworkNew plenum and transitions$591
ElectricalDisconnect, whip, new circuit$650
Controls & thermostatsSmart thermostat$249
Startup & testingStartup, charge check, combustion test$147
Total job cost incl. 5% contingency$11,180
Markup from the company's overhead and profit target38.3%
Price to client$15,465
Gross margin, needed 27.7%27.7% ✓

Fictional example numbers. Your wages, overhead and supplier prices set your real price.

Built for HVAC

Cost codes in the example
General conditionsPermits & feesRemoval & disposalEquipmentRefrigerant & line setsGas pipingVenting & flueDuctworkElectricalControls & thermostatsStartup & testingChange order work

What's in the workbook

Company Setup

Turns your yearly overhead and profit target into the markup you need. Explains margin vs. markup.

Labor Rates

True loaded cost per hour for every crew role.

Estimate

Material, labor hours, subs and equipment per line. Warns you before a price below your margin goes out.

Client Quote

A clean price summary for the customer. Never shows your costs or markup.

Change Orders

Priced with your markup, with approval and signature tracking.

Cost Log, Job Cost & Dashboard

Budget vs. actual by cost code, projected final cost, margin fade, and what needs attention.

Who it's for

Residential HVAC contractors running 1 to 3 install crews who price changeouts and new installs. If you price by gut feel and find out at the end whether a job made money, this is for you.

Built by Wrench & Ledger, a two-partner team that has owned and run a 13-person trades company and managed commercial and residential construction projects.

Questions

What do I need to open it?

Microsoft Excel (2016 or newer, Windows or Mac). We test every file in Excel. It has no macros and no locked sheets.

Is this one file per job?

Yes. Set up your company numbers and labor rates once, then save a copy of the blank workbook for each job you price.

Where do the example numbers come from?

They are fictional numbers for a sample job so you can see every tab working. Replace them with your own wages, workers' comp rates and costs.

Is this accounting or tax software?

No. It is a pricing and job-tracking tool. Keep using your bookkeeping software and your accountant for taxes.

What if a file won't open or a formula is broken?

Email us within 14 days of purchase and we will fix it or refund you.

HVAC Job Costing Kit

$39 one-time
Checkout opening soon See the other trades