Excel Invoice Template for Plumbers
Plumbing is the trade where the customer is least likely to be shopping around. Water is coming through the ceiling, or there is no hot water, or the only toilet in the house is not working. They called whoever answered. That changes what the invoice has to do: nobody is comparing your number against two other bids, but everybody is going to read it closely afterward, when the panic has worn off and the bill is on the kitchen counter.
What a plumbing invoice needs that a generic template does not
After-hours rates have to be labeled as after-hours. A Saturday night call costs more than a Tuesday morning one, and that is not controversial as long as the invoice says so. What causes disputes is an unexplained hourly figure that happens to be higher than the number on your truck. Putting “after-hours rate” in the description does more for you than any amount of explaining afterward, and it means the same job at the same rate is billed the same way every time.
Flat-rate and hourly work end up on the same invoice. Plenty of plumbing shops price common jobs flat — a toilet reset, a disposal swap, a hose bib replacement — while billing troubleshooting and rough-in by the hour. Both approaches show up on one document, and a template that assumes everything is quantity times rate makes the flat-rate lines look strange. What matters is that a flat-priced line still carries a cost behind it, or you have no idea whether the flat rate is still right.
Diagnosis is work, even when nothing gets fixed. Camera inspections, leak location, running a line to find the blockage. Sometimes that ends in a repair the same day and sometimes it ends in a quote for something much larger. Either way it was hours of work with equipment, and if it disappears into a vague labor line it looks like padding to the customer and reads like nothing to you when you review the job later.
Three kinds of plumbing job, three different documents
Emergency and service calls
Burst supply lines, water heater failures, backed-up mains, running toilets that have run for a week. The customer wants it fixed now and asks about price second. These invoices need to be clear about the call-out charge, the rate that applied, and what was actually replaced — partly because that is fair, and partly because an emergency invoice with no detail is the one that gets questioned two days later.
Fixture and appliance replacement
Water heaters, toilets, faucets, disposals, sump pumps, softeners. These are often quoted before the work, and the customer is deciding between the unit you recommended and something cheaper they saw online. The quote is doing real selling: what the unit is, what the install includes, whether the old one gets hauled away, and what happens if it fails in a year.
Repipes, sewer lines, and remodel rough-in
Multi-day jobs with a deposit, progress billing, and often a permit and inspection in the middle. Remodel work adds a second problem, which is that rough-in happens early and trim-out happens weeks later after the tile and cabinets are in — one job, two billing events, with someone else’s schedule in between. Tracking what has been billed and what is still owed on a job that is not finished is not something a folder of separate template files does well.
Line items plumbers actually bill
- Call-out and labor — standard service call, after-hours and weekend call-out, emergency call-out, standard hourly, after-hours hourly, apprentice or helper rate, second-trip charge
- Diagnostic — camera inspection, leak location, line locating, drain cleaning by cable or jetter
- Water heaters — tank units by capacity and fuel, tankless units, expansion tanks, drain pans, flex connectors, gas and water shutoffs, haul-away and disposal
- Fixtures — toilets, lavatory and kitchen faucets, sinks, tub and shower valves, disposals, hose bibs, laundry boxes
- Supply and drain — PEX and copper by size, fittings, shutoff valves, PVC and ABS drain pipe, P-traps, cleanouts, closet flanges
- Flat-rate jobs — toilet reset, disposal replacement, faucet swap, hose bib replacement, angle stop replacement, water heater flush
Most shops work from a short list of jobs and parts that repeat constantly. The reason to have them saved is not typing speed. It is that the flat rate you set eighteen months ago is still the flat rate on today’s invoice, and when supply costs move you can see which of those flat rates no longer works.
What an after-hours water heater replacement looks like
A Saturday evening call, tank failure, replaced same night. 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-EMRG | Emergency call-out — after hours | 1 | 165.00 | 165.00 | ☐ | 60.00 | 105.00 |
| LBR-AH | Plumber labor — after-hours rate | 3 | 145.00 | 435.00 | ☐ | 68.00 | 231.00 |
| PLM-WH50 | 50 gal gas water heater, 6-yr warranty | 1 | 1,180.00 | 1,180.00 | ☑ | 785.00 | 395.00 |
| PLM-EXPT | Thermal expansion tank | 1 | 145.00 | 145.00 | ☑ | 78.00 | 67.00 |
| PLM-FLEX | Water and gas flex connector kit | 1 | 68.00 | 68.00 | ☑ | 31.00 | 37.00 |
| SVC-HAUL | Old unit removal and disposal | 1 | 75.00 | 75.00 | ☐ | 20.00 | 55.00 |
| Subtotal | 2,068.00 | — | 1,178.00 | 890.00 | |||
| Tax (6.5%, taxable lines only) | 90.55 | — | — | — | |||
| Total | 2,158.55 | Profit $890 (43.0%) | |||||
Existing 40 gal unit failed at tank seam, replaced with 50 gal. Expansion tank added per current code. Gas and water connections replaced. Old unit removed. Tank warranted 6 years by manufacturer; installation labor warranted 1 year.
Three things there that a generic template cannot do. The after-hours rate is named on the line rather than buried in an unexplained number. Tax applies only to the lines that should carry it, instead of one rate across the whole document. And the cost and margin sit beside every line where you can see them and the customer never will — including on the emergency call-out, which is where a lot of the money on a night job actually is.
Where the template approach breaks down
A template is fine for the invoice in front of you. It is the accumulation that hurts.
The same repeat customers get retyped. Your flat rates drift out of date because nothing tells you what they cost you now. A repipe quoted in February becomes an invoice in March and the whole document gets rebuilt to make that happen. A deposit lands and lives in your memory. And when you want to know whether emergency work is actually more profitable than scheduled work, the only honest answer is that the numbers are in three hundred separate files and nobody is going to add them up.
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 labor rates, flat-rate jobs, fixtures, and parts, so tonight’s water heater is priced the way the last one was. It converts a won quote into an invoice in one click, records deposits and partial payments against it, and shows your margin on every line 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 →
★★★★★
“Extremely responsive, quick and reliable. Amazing skills, exactly want we needed”
Consulting client · via Upwork, 2024
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →