Plumbing Business Profit Tracker

Plumbing Business Profit Tracker Excel for your plumbing business — service pricing, jobs, fixtures and parts inventory, and a monthly P and L dashboard. Know what every install and repair actually costs, what every job actually made, and which fixture is about to run out.

Built for plumbers, plumbing contractors, and small plumbing companies who need to know, job by job and service by service, whether the price covers the materials, the labor, and the truck — without accounting software. If a faucet install barely clears 30 percent margin, or a tankless heater is about to run out, this workbook shows it before the next job.

WHAT'S INCLUDED (6 sheets):

- Services and Pricing — labor hours, materials cost, labor cost at 85 per hour, price, and margin in dollars and percent for every service. Change a materials price and every job profit updates by formula.

- Jobs — date, customer, job type, service, quantity, price, revenue, cost per job pulled from the service sheet, profit per job, and margin. Log installs, repairs, emergency call-outs, and maintenance in one place.

- Fixtures and Parts Inventory — fixture or part, unit, quantity on hand, reorder point, cost per unit, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you reorder before the next job.

- Monthly P and L — revenue, materials and labor cost, plumber wages, vehicle and fuel, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and materials and labor cost are formulas from the Jobs sheet.

- Dashboard — total revenue, jobs, average job value, gross and net profit and margin, best service by margin dollars and by margin percent, best-selling service, best job and best job type, costs by category, and low stock count.

- Cover and How to Use — start here. Yellow cells are the only ones you edit.

EXAMPLE DATA (October 2026 — replace with your own numbers):

- Total revenue 18,910 from 20 jobs and 21 jobs performed; average job value 945.50.

- Materials and labor cost 10,926; gross profit 7,984; gross margin 42.2 percent.

- Plumber wages 4,600, vehicle and fuel 900, other expenses 1,050 (insurance, permits, software); total expenses 17,476; net profit 1,434; net margin 7.6 percent.

- Revenue by job type: Install 14,535 (best), Repair 3,300, Emergency 750, Maintenance 325.

- Best service by margin per service: Bathroom Repipe, margin 1,600. Best service by margin percent: Emergency Call-Out, 56.0 percent (cost 110, price 250).

- Best-selling service: Toilet Install, 3 performed (tied with Emergency Call-Out at 3). Next: Water Heater Install - Tank, Leak Repair - Pipe, Drain Clearing - Main Line, Faucet Install - Kitchen, and Garbage Disposal Install, 2 each.

- Best job: H. Kim, October 9, Bathroom Repipe — revenue 3,400, profit 1,600.

- Inventory example: stock value 5,204, with 3 items at or below their reorder point — Tankless Water Heaters, Bath Faucets, and Pipe Fittings Kit.

HOW IT WORKS:

1. Download the Excel file instantly after purchase.

2. On sheet 1, enter each service's labor hours, materials cost, labor cost, and price. Total cost and margin fill in by formula. Labor is costed at 85 per hour in the example — change the labor cost column to your own rate.

3. On sheet 2, log every job: date, customer, job type, service (spelled exactly as on sheet 1), quantity, and price. Revenue, cost per job, and profit fill in by formula.

4. On sheet 3, keep quantities on hand current and set a reorder point for each fixture and part. Buy more of anything flagged LOW STOCK before the next job.

5. On sheet 4, enter plumber wages, vehicle and fuel, and other expenses each month, then check gross and net profit on the Dashboard.

HOW THE NUMBERS WORK:

Total cost per service is materials cost plus labor cost. Margin per service is price minus total cost. Margin percent is margin divided by price. Gross profit is revenue minus materials and labor cost; net profit is revenue minus materials and labor cost, plumber wages, vehicle and fuel, and other expenses. One completed job is one unit.

WHO IT'S FOR:

Plumbers, plumbing contractors, and small plumbing companies who want service pricing, job profit, fixtures inventory, and a monthly P and L in one workbook — without accounting software.

PLEASE NOTE:

- This is a digital download. No physical item will be shipped.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data for October 2026 is included (12 services, 20 jobs, 21 jobs performed, 14 fixtures and parts). Replace it with your own numbers.

- The example is simplified: labor is costed at 85 per hour, and the owner's own time is not costed separately. Change the labor cost column to your own rate and add your own expense lines on sheet 4 as needed.

- This is a bookkeeping and planning tool only, not tax, legal, or CPA advice.

- Due to the nature of digital downloads, refunds are not available. Message me before buying if you have a question.

Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.