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 — $99

Instant 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)LaborMaterialsOther costsExample 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 replacement1.25 hrs$110$0$274
Shower valve cartridge replacement1.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 line2.5 hrs$20$0$277
Camera inspection, sewer line1.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 replacement1 hr$45$0$161
T&P valve replacement0.75 hr$25$0$109
Tankless water heater descaling1.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 replacement1.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 replacement2.5 hrs$220$0$547
Condenser fan motor replacement2 hrs$180$0$443
Contactor replacement0.75 hr$30$0$116
Refrigerant leak search (electronic)2 hrs$25$0$234
Furnace igniter replacement1 hr$45$0$161
Smart thermostat install & setup1 hr$180$0$343
Condensate pump replacement1 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 replacement0.5 hr$18$0$74
Dimmer switch replacement0.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 kit2 hrs$90$0$322
Electrical — panels, breakers & circuits
Breaker replacement (single-pole)0.75 hr$25$0$109
GFCI breaker replacement1 hr$55$0$174
Panel replacement, 200A8 hrs$650$120$1,798
Whole-home surge protector install1.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 visit2 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.

Screenshot of the Price Book tab of the Price-Book Template spreadsheet, showing the 11 worked example lines with labor hours, material costs, and calculated flat-rate prices
Price-Book Template (XLSX) — the Price Book tab, exactly as it ships. The 11 worked example lines from the template; the table above extends them with the same formula and settings.
Screenshot of the Rate Setup tab of the Price-Book Template spreadsheet, showing the example shop labor rate of $100 per hour and 35 percent material markup
Price-Book Template (XLSX) — the Rate Setup tab. Two numbers drive every price in the book: your labor rate and your material markup. The $100/hr and 35% shown are the labeled example settings used for every price on this page.

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.

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 calculator

Covered by the 30-day money-back guarantee — full refund within 30 days, one email to support@getflatratekit.com, refunded via Gumroad.