Excel Invoice Template for HVAC Contractors
Most HVAC invoices start life as a generic template someone downloaded, then get bent into shape one job at a time. It works until you are doing it at 9pm after a full day of service calls, retyping the same customer address for the third time this season, trying to remember whether you charged that diagnostic fee separately or rolled it into labor.
The problem is not Excel. It is that a blank invoice template does not know anything about how HVAC work gets billed.
What an HVAC invoice needs that a generic template does not
Three things separate an HVAC invoice from the generic one that came with your spreadsheet software.
The diagnostic fee is its own line. Most service calls start with a trip and diagnosis charge that exists whether or not the customer approves the repair. Burying it in labor makes the invoice harder to defend when a customer questions it, and it makes your own numbers murky when you look back at what a service call actually earns.
Equipment and parts need model and serial detail. “Condenser” on an invoice is a problem two years later when the same customer calls about the same unit and nobody can tell which system was worked on. Warranty claims need it. Repeat service needs it. A generic template gives you a description field and expects you to remember.
Labor and materials frequently get taxed differently. Depending on the state, materials may be taxable while labor is not, or the whole job may be treated as a real property improvement and taxed differently again. A generic template applies one rate to the whole invoice and leaves you to work around it. What you actually need is control per line: this item is taxable, this one is not. Worth confirming how your own state treats it, because the rules vary more than people expect.
The three kinds of HVAC job, and why one template cannot handle all three
Service calls
Diagnostic fee plus repair. Short, frequent, often billed the same day. The invoice needs to move fast and read clearly for a homeowner who is deciding whether the charge was fair.
Maintenance agreements
These bill on a schedule rather than per visit, often with a spring and fall visit included. The invoice looks different because it covers a period, not an event, and the line items are inspection tasks rather than parts. Customers on an agreement usually also get a discounted rate on any repairs found during the visit, which means the invoice has to show both the standard rate and what they actually paid. Otherwise the discount is invisible and unappreciated.
Installs and replacements
These are quotes first. The customer is comparing you against two other bids, and the document they are holding is doing your selling. Equipment specs, efficiency ratings, warranty terms, and what is included in the labor all matter. This is the one where a scrappy-looking document costs you the job.
Line items HVAC contractors actually bill
The ones worth having saved so you are not retyping them:
- Diagnostic and trip — service call diagnostic, after-hours diagnostic, second-trip charge, emergency call-out
- Labor — standard hourly, after-hours or weekend rate, apprentice or helper rate, installation labor quoted flat
- Refrigerant — recovery, evacuation, per-pound recharge for R-410A and whatever you are still servicing on older systems
- Common parts — capacitors, contactors, blower motors, condenser fan motors, filters by size, thermostats, float switches, drain pans, TXVs
- Maintenance tasks — coil cleaning, drain line clearing, condensate treatment, filter replacement, system inspection
- Equipment — condensers, air handlers, package units, mini-split heads, line sets, disconnects, pads
Most shops bill from a list of thirty to sixty items over and over. The point of having them saved is not speed alone, it is consistency: the same repair priced the same way every time, so you can look at a year of work and see what you actually earned on it.
What an HVAC service invoice looks like
A typical residential service call, itemized the way it should be. The five columns on the left are what the customer receives. The three on the right stay in your workbook and never print.
| SKU | Description | Qty | Price | Amount | Taxable | Cost | Margin |
|---|---|---|---|---|---|---|---|
| SVC-DIAG | Service call — diagnostic (residential) | 1 | 95.00 | 95.00 | ☐ | 40.00 | 55.00 |
| LBR-STD | Labor — standard rate | 1.5 | 110.00 | 165.00 | ☐ | 52.00 | 87.00 |
| HVAC-CAP45 | Dual run capacitor, 45/5 MFD 440V | 1 | 68.00 | 68.00 | ☑ | 22.00 | 46.00 |
| HVAC-CONT30 | Contactor, 30A 2-pole | 1 | 42.00 | 42.00 | ☑ | 14.00 | 28.00 |
| REF-410A | Refrigerant R-410A — recharge | 2 | 65.00 | 130.00 | ☑ | 38.00 | 54.00 |
| Subtotal | 500.00 | — | 230.00 | 270.00 | |||
| Tax (6.5%, taxable lines only) | 15.60 | — | — | — | |||
| Total | 515.60 | Profit $270 (54.0%) | |||||
System: Carrier 24ABC6, S/N 4218E90372. Capacitor tested at 31 MFD, replaced. System charged and verified at manufacturer spec. Parts warranted 1 year, labor 90 days.
Two things there that a generic template cannot do. Tax applies per line — parts and refrigerant carry it, the diagnostic fee and labor do not — so you are not applying one blanket rate to a document where it does not belong. And the cost and margin sit alongside every line, visible to you and absent from anything the customer receives. You can price a line directly, mark it up by a percentage, or work backward from a target margin, and the invoice looks identical either way.
Where the template approach breaks down
A template handles the first invoice fine. The trouble is the hundredth.
Your customers repeat. Your parts repeat. Your rates repeat. But a template file has no memory: every job starts from an empty sheet, and every customer’s address gets typed again. Then quoting a system replacement means building a document, and when the customer says yes, building it again as an invoice. Then it is March and someone asks what you did for revenue last year, and the answer is in ninety separate files.
What we built instead
EG Quote & Invoice is a macro-enabled Excel workbook that turns Excel into an actual quoting and invoicing application. It keeps a client list and a priced catalog of your services and parts, so a service call invoice is a few clicks rather than a retype. It converts a won quote into an invoice in one click, tracks what has been paid and what is overdue, and shows your margin on every job before you send it.
It runs on your own PC. No account, no cloud, no subscription. The free edition has no limit on how many quotes or invoices you create and does not expire.
See EG Quote & InvoiceFree edition · Windows Excel · 32-bit and 64-bit
Other trades: Browse all invoice templates by trade →
★★★★★
“David was awesome! Very flexible, and responsive. Would definitely work with him again.”
Wholesale price book client · via Upwork, 2020
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →