Plumbing Invoice Template (Free) Excel
An Excel plumbing invoice is the shop's calculator: hours × rate for labor, cost × markup for materials, and the trip, permit, and after-hours fees all adding themselves. Start from the free plumbing invoice template generator to define the lines, then mirror the formulas in your workbook.
Get the free plumbing invoice Excel layout
Use the browser generator to validate your pricing structure, then build the same columns in Excel with live formulas and a job log.
Why Excel wins for hourly labor and material math
A plumbing job is a mix of measured inputs: hours on the truck, parts from the supplier, fixture costs, and fees. Excel keeps that arithmetic honest. The invoice sheet computes labor from hours × rate, materials from cost × markup, and adds the trip and permit lines — so the total you print matches the total in the workbook every time.
Excel also gives the shop a job log almost for free. One row per job, columns for labor, materials, fees, and the total, then a monthly summary of revenue and outstanding balances. Owners who bill multiple techs can even add a tech column and see each employee's monthly production.
The one discipline that keeps the workbook clean: keep cost and sale price separate. The invoice sheet shows what the customer pays; a hidden cost column preserves your markup for quotes and negotiations without cluttering the printed page.
Excel columns for a plumbing invoice
| Column | Formula / purpose |
|---|---|
| Service line | Service call, drain, faucet, toilet, water heater, leak — one row each |
| Qty & Rate | =Qty*Rate; hours × $75–150/hr for labor |
| Material markup | =cost * (1 + markup%); 15–50% over cost |
| Fees | Trip charge, after-hours, permit fee, old-part removal — separate rows |
| Job log | One row per job with date, tech, service, total for monthly summaries |
| Warranty note | Parts & labor warranty terms printed on the invoice |
Real scenario: emergency drain cleaning with after-hours fee
A homeowner calls at 8:30 PM for an emergency drain cleaning. The Excel invoice:
| Line | Qty | Rate | Amount |
|---|---|---|---|
| Service call (trip charge) | 1 | $95 | $95.00 |
| Drain cleaning labor (per hour) | 1 | $150 | $150.00 |
| After-hours surcharge (call after 6 PM) | 1 | $75 | $75.00 |
| Cable, bits, consumables (marked up 30%) | 1 | $28 | $28.00 |
Total $348.00, due on completion. The after-hours line shows the customer exactly what the evening call cost, and the Excel workbook logs the job for the monthly summary.
How to set up the Excel invoice
Build the columns
Service, Qty, Rate, Amount with =Qty*Rate, plus a material markup cell and fee rows.
Add the summary block
Subtotal =SUM(Amount), markup references, and the final balance rows with trip / permit / after-hours lines.
Export and log
Print to PDF per client, then copy the job total into the job log sheet for month-end reporting.
Plumbing invoice Excel questions
How do the Excel formulas work on a plumbing invoice?
Each line multiplies Qty by Rate — hours × hourly rate for labor, cost × (1 + markup %) for materials. The subtotal sums lines, then trip charge, after-hours and permit fees are added. Change any rate and totals recalculate.
How do I apply a material markup automatically in Excel?
Store parts at cost in one column and the markup % in its own cell, then compute the sale price: =cost * (1 + markup%). The invoice shows the customer price while the workbook keeps your cost.
How do I track plumbing jobs in Excel?
Keep a job log sheet with one row per job (date, customer, service, labor, materials, fees, total) and a monthly summary that sums revenue and outstanding balances.
Can I bill after-hours or emergency work in Excel?
Yes. Add a line for the after-hours surcharge ($75–150 typical) or use a rate multiplier on labor hours — for example 1.5× or 2× for emergency calls — and note the call time.
Is this plumbing invoice Excel template really free?
Yes. No account, no signup, no export limit. You can replicate the formulas in any spreadsheet, or check totals with the free browser generator.