Plumbing · Excel workbook

Plumbing job costing spreadsheet for repipes, remodels and water heaters

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 plumbers 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: master plumber
$42.00 wage × 1.20 taxes & comp + $5.00 benefits = $55.40 per hour

See it on a real-looking job

The kit comes with a filled-in example: Whole-house PEX repipe + water heater. These are the estimate lines from that file.

Cost codeLineLine cost
General conditionsWalkthrough, layout, scheduling$202
Permits & feesPlumbing permit$240
Demolition & accessOpen walls and ceilings for runs$238
Water supply pipingPEX-A home runs, manifold, fittings$2,938
Water supply pipingApprentice support on repipe$670
Water heaters50-gal gas water heater, expansion tank$1,757
Fixtures & trimNew shutoffs and supply lines, 9 fixtures$482
Gas pipingReconnect water heater gas, new valve$138
Patching & fire stopDrywall patching after repipe$1,850
Testing & inspectionPressure test and inspection visit$166
Cleanup & disposalHaul old pipe and heater$166
Total job cost incl. 5% contingency$9,289
Markup from the company's overhead and profit target44.7%
Price to client$13,444
Gross margin, needed 30.9%30.9% ✓

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

Built for Plumbing

Cost codes in the example
General conditionsPermits & feesDemolition & accessWater supply pipingWater heatersFixtures & trimGas pipingPatching & fire stopTesting & inspectionCleanup & disposalChange 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

Plumbing contractors with 1 to 10 people who bid repipes, remodel rough-ins and water heater jobs. 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.

Plumbing Job Costing Kit

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