What this job costing & quote calculator does for HVAC contractors
An Excel / Google Sheets tool built for HVAC contractors and heating & cooling technicians.
This spreadsheet turns your labor rates, burden, overhead, markup, and target margin into instant, accurate quotes: pick items from a pre-loaded price book, enter quantities, and the sheet prices the job, shows your true cost and margin, warns you when a job is under target, and logs actual vs. quoted results with a profit dashboard by category.
Most HVAC contractors price by habit or by what competitors charge. A job-costing workbook replaces that with arithmetic: what the job truly costs (labor plus burden plus overhead per hour, materials plus handling), what margin you need and therefore what to charge. Businesses that adopt it typically discover several underpriced job types within the first month.
The quote tab makes the math instant. Pick line items, enter quantities and the sheet prices the job, shows cost and margin and warns when the job falls below target. The job log then records what actually happened, so pricing improves over time.
What is inside the template
- Settings tab: labor rates, burden, overhead, markup, target margin, card fees, minimum job
- Price Book: pre-loaded HVAC services, parts and materials with unit cost and labor time
- Quote tab: select items, enter quantities, see price, cost, margin and warnings live
- Job Log: quoted vs. actual for every job with margin per job
- Dashboard: revenue, cost, profit and margin by category
- No macros or add-ins; works in Excel, Google Sheets, Numbers and LibreOffice
How to use it (step by step)
- Enter your real numbers in Settings: wages, payroll burden, monthly overhead, billable hours, target margin.
- Review the Price Book and adjust costs and labor times to your market.
- Build quotes on the Quote tab and copy the totals to the estimate template.
- Log each completed job with actual hours and materials; watch the Dashboard monthly.
Common mistakes this template helps you avoid
- Entering wage rates without burden and overhead, which understates cost by 30–50%.
- Never logging actuals, so the sheet cannot show where quotes are wrong.
- Ignoring the margin warning because 'the customer will not pay more'.
Expert tips from the field
- Set a minimum job price that covers a full hour plus drive time; small jobs are where margin disappears.
- Review the Dashboard by category each quarter and raise prices where margin is lowest.
- Use the Price Book as the source for your flat-rate book so every technician quotes identically.
Why HVAC contractors choose this over a generic template
Generic forms are written for nobody in particular. This one was written for HVAC, heating and cooling businesses: the fields, wording and clauses reflect real hvac work such as a no-cool call on a 12-year-old split system or a furnace tune-up before the first freeze. It uses plain language customers can read, it has a header block for your logo and license number, and it matches the other HVAC templates in the set so your intake, estimate, invoice and agreement documents look like one system.
Explore the full HVAC template collection and paperwork guide, or see how it fits with the related documents below.
