Flat rate price book — template
Build your flat rate price book
A price book is the list of your most common jobs, each with one flat price built from your own costs — so quoting is a lookup, not an invention. Below: exactly what's inside the FlatRateKit price book, sample lines with their prices shown, and a free starter sheet with 10 lines you can use today.
The full price book is in the Kit
$89 one-time
The Price-Book Template comes with the full Flat-Rate Pricing + SOP Kit — calculator, job-costing sheet, SOP library, and quote scripts included. Or get it with the Hiring & Onboarding Pack in the bundle for $99 ($118 bought separately).
Get the Kit — $89 Get the Bundle — $99Instant download. Excel + Google Sheets. 30-day money-back guarantee: full refund within 30 days — one email to support@getflatratekit.com, refunded via Gumroad.
Sample price book — 49 worked example lines, prices shown
Every price below is a worked example, computed with the template's own formula — (labor hours × your rate) + materials with markup + other costs — on the template's labeled example settings: a $100/hr labor rate and a 35% material markup. The lines marked † are the worked examples that ship inside the template itself; the rest are additional worked examples in the template's build-out categories — drains, water heaters, fixtures, leak repair, motors, panels, breakers, and lighting — computed the same way for this page so you can see the range of jobs the book is built to hold. They are illustrations of the math, not recommended prices: your prices come from your own costs. Change the rate on the Rate Setup tab and every price in the book rebuilds itself.
| Job (example line) | Labor | Materials | Other costs | Example flat-rate price |
|---|---|---|---|---|
| Plumbing — fixtures & repairs | ||||
| Faucet repair (single handle) † | 1 hr | $40 | $0 | $154 |
| Toilet rebuild (tank parts) † | 1.25 hrs | $35 | $0 | $172 |
| Faucet installation, kitchen (new fixture) | 1.5 hrs | $120 | $0 | $312 |
| Toilet installation (replace, standard) | 2 hrs | $180 | $15 | $458 |
| Garbage disposal replacement | 1.25 hrs | $110 | $0 | $274 |
| Shower valve cartridge replacement | 1.25 hrs | $55 | $0 | $199 |
| Hose bibb replacement (exterior) | 1 hr | $35 | $0 | $147 |
| Plumbing — drains | ||||
| Drain clearing, one line (snake) † | 1 hr | $10 | $0 | $114 |
| Drain clearing, main line (power auger) | 2 hrs | $15 | $0 | $220 |
| Hydro jetting, residential line | 2.5 hrs | $20 | $0 | $277 |
| Camera inspection, sewer line | 1.5 hrs | $0 | $0 | $150 |
| Toilet clog clearing (auger) | 0.75 hr | $5 | $0 | $82 |
| Plumbing — water heaters | ||||
| Water heater flush & check † | 1.5 hrs | $15 | $0 | $170 |
| Water heater replacement, 40–50 gal (like-for-like) | 4 hrs | $650 | $45 | $1,323 |
| Water heater anode rod replacement | 1 hr | $45 | $0 | $161 |
| T&P valve replacement | 0.75 hr | $25 | $0 | $109 |
| Tankless water heater descaling | 1.5 hrs | $30 | $0 | $191 |
| Plumbing — leak repair | ||||
| Leak detection, one area (electronic) | 1.5 hrs | $0 | $0 | $150 |
| Pipe repair, accessible copper (one joint) | 1.5 hrs | $30 | $0 | $191 |
| Repipe one fixture supply (PEX) | 2 hrs | $60 | $0 | $281 |
| Sump pump replacement | 1.5 hrs | $160 | $0 | $366 |
| HVAC | ||||
| A/C tune-up / maintenance visit † | 1.5 hrs | $20 | $0 | $177 |
| Thermostat replacement (standard) † | 0.75 hr | $60 | $0 | $156 |
| Capacitor replacement † | 0.75 hr | $25 | $0 | $109 |
| Blower motor replacement | 2.5 hrs | $220 | $0 | $547 |
| Condenser fan motor replacement | 2 hrs | $180 | $0 | $443 |
| Contactor replacement | 0.75 hr | $30 | $0 | $116 |
| Refrigerant leak search (electronic) | 2 hrs | $25 | $0 | $234 |
| Furnace igniter replacement | 1 hr | $45 | $0 | $161 |
| Smart thermostat install & setup | 1 hr | $180 | $0 | $343 |
| Condensate pump replacement | 1 hr | $55 | $0 | $174 |
| Ductless mini-split cleaning (one head) | 1.5 hrs | $15 | $0 | $170 |
| Electrical — outlets, switches & lighting | ||||
| Outlet / receptacle replacement † | 0.5 hr | $12 | $0 | $66 |
| Ceiling fan install (existing box) † | 1.5 hrs | $20 | $0 | $177 |
| Smoke / CO detector replacement † | 0.5 hr | $30 | $0 | $91 |
| GFCI outlet replacement | 0.5 hr | $18 | $0 | $74 |
| Dimmer switch replacement | 0.5 hr | $22 | $0 | $80 |
| Light fixture replacement (customer-supplied fixture) | 0.75 hr | $0 | $0 | $75 |
| Recessed light install (each, existing ceiling) | 1 hr | $45 | $0 | $161 |
| LED retrofit, 4-fixture kit | 2 hrs | $90 | $0 | $322 |
| Electrical — panels, breakers & circuits | ||||
| Breaker replacement (single-pole) | 0.75 hr | $25 | $0 | $109 |
| GFCI breaker replacement | 1 hr | $55 | $0 | $174 |
| Panel replacement, 200A | 8 hrs | $650 | $120 | $1,798 |
| Whole-home surge protector install | 1.5 hrs | $140 | $0 | $339 |
| Subpanel install, 60A (garage) | 6 hrs | $380 | $75 | $1,188 |
| Dedicated circuit, 20A (one run) | 3 hrs | $95 | $0 | $428 |
| EV charger circuit, 240V (up to 25 ft) | 4 hrs | $210 | $0 | $684 |
| General | ||||
| Diagnostic / service call (first hour) † | 1 hr | $0 | $0 | $100 |
| Whole-home plumbing inspection visit | 2 hrs | $10 | $0 | $214 |
Every line also carries a task code, a customer-facing description of what's included, an "other costs" column for permit/disposal/trip charges, and a notes column — the parts that stop "I thought that was included" at payment time.
Anatomy of one line
- Task code — a short ID (like EX-P-01) so the book, the quote, and the invoice all reference the same job.
- Description — what's included — written for the customer, not the tech: the parts, the testing, the cleanup. This sentence is what makes a flat price defensible.
- Labor hours — your honest average for the job, setup and cleanup in.
- Materials at your cost, plus your markup — both visible, so you can see what the markup is doing.
- Your flat-rate price — calculated, never typed: change your rate or your costs and the book updates itself.
Get the free starter sheet
The 10 starter lines from the template — its core worked examples — in a working spreadsheet: the Rate Setup tab, the formulas, and 6 blank rows for your own jobs. Enter your email and the download appears right here, instantly — nothing to wait for in your inbox. It's a trimmed excerpt of the full template: useful on its own, and the fastest way to see whether the full book fits how you work.
Download the Price-Book Starter Sheet (XLSX) — it opens in Excel or Google Sheets. Start on the "Start Here" tab; it takes about 15 minutes to make it yours.
Why 20–30 lines beat 500
Commercial price books brag about thousands of lines. A small shop needs the opposite: the 20–30 jobs it runs every week, priced right. Twenty honest lines cover the large majority of a service shop's tickets, take an evening or two to build, and — because there are only twenty — actually get reviewed when costs change. A 500-line book you don't trust is worse than a 20-line book you do. Start with the jobs you ran last month; the pricing method guide shows how each line gets its number, trade by trade: HVAC and electrical included.
How the full template extends the starter
- The complete worked example set — every example line from the starter, plus the ones held back, each with its description and notes filled in.
- 20 blank job rows with the formulas built in — type hours and material cost; the price calculates. Room for your whole top-30 without touching a formula.
- Build-out categories for your trade — plumbing: drains, water heaters, fixtures, leak repair · HVAC: tune-ups, thermostats, capacitors, motors · electrical: outlets, breakers, fans, lighting, detectors · general: diagnostic calls, maintenance plans.
- The rest of the kit around it — the pricing calculator spreadsheet that sets your rate, the job-costing tracker that tells you which lines are lying, the SOP library, and the quote scripts that present the book's prices without flinching.
Not sure whether to switch from hourly billing at all? Read flat rate vs. time and materials — the same job priced both ways, with the losses itemized. Or run one job through the free flat-rate pricing calculator and compare it with what you billed last time.
Price book questions
What format is the price book in?
A spreadsheet that works in both Microsoft Excel and Google Sheets. The free starter sheet and the full template use the same layout: a Rate Setup tab for your numbers, and the Price Book tab with your jobs and calculated prices. Print the Price Book tab or save it as a PDF for the truck.
Does the price book tell me what to charge?
No — and be wary of anything that does. Prices that work in Phoenix lose money in Portland. The template gives you the structure and the formulas; you enter your labor rate, material markup, and job costs, and it builds prices from your real numbers. The example lines use round, made-up numbers to show the math — they are not prices for your area.
How much spreadsheet skill do I need?
Almost none. You type in the yellow cells only — your rate, hours, and material costs. Everything else is a formula that's already built. If you can fill in a form, you can run this price book.
Which trades does it cover?
Plumbing, HVAC, and electrical, plus a general section for diagnostic calls and maintenance plans. The categories are starting points — the rows are yours to rename, extend, or delete for the work your shop actually runs.
What's the guarantee?
The full template is part of the Flat-Rate Pricing + SOP Kit, which carries a 30-day money-back guarantee. Use the kit for up to 30 days after purchase; if it's not working for your shop, email support@getflatratekit.com for a full refund, refunded through Gumroad. One email, no forms, no retention script.
Start with 10 free lines. Build the book when you're ready.
The starter sheet is free above. The full template — with the calculator, job-costing tracker, SOP library, and quote scripts — is the $89 kit: five files, one payment, yours forever.
Get the Kit — $89 Try the free calculatorCovered by the 30-day money-back guarantee — full refund within 30 days, one email to support@getflatratekit.com, refunded via Gumroad.