How to Build a Flat Rate Price Book (Template Walkthrough)

How to Build a Flat Rate Price Book (Template Walkthrough)

A flat rate price book is the difference between a shop that quotes the same confident number every time and a shop where the price depends on which tech showed up and how the day is going. If you have been pricing in the driveway off the top of your head, building a real book is the single biggest upgrade you can make to your margin.

This is a practical walkthrough of how to build one from scratch: the structure, the math behind each line, and the realistic 2026 numbers to plug in. By the end you will know exactly what goes into a price book and roughly how long it takes to build by hand.

What a flat rate price book actually is

A flat rate price book is a master list of every service you offer, each one priced as a single fixed number the customer pays, regardless of how long the job actually takes. The customer buys an outcome, "replace the capacitor," not your hours. The price is calculated once, written down, and read off the page on every call.

Done right, it covers everything: diagnostics, repairs, installs, maintenance, indoor air quality, ductwork. A complete HVAC book runs a couple hundred line items. That sounds like a lot, and it is, which is exactly why building it is the work.

Step 1: Nail down your two core inputs

Every price in the book flows from two numbers, so get these right before you write a single line.

• Your fully-burdened hourly rate. Not the tech's wage, the real cost of putting a truck on the road plus the profit you want to keep. Add up wages and payroll taxes, truck and fuel and insurance, tools, office and software and overhead, then divide by your actual billable hours. Most shops land between $120 and $180 per hour in 2026.
• Your parts markup. The multiplier you apply to part cost to cover procurement, warranty, and risk. A normal range is 1.5x to 1.8x. We will use 1.7x here.

These two numbers should be the only things you ever have to change later. Build the book so everything keys off them.

Step 2: Use one formula on every line

The entire book is built on a single formula:

(labor hours x your hourly rate) + (part cost x your markup) = flat-rate price

That is it. Every line is just that calculation with different labor times and parts. The discipline is in being honest about labor hours, use realistic times for an average tech, not your fastest guy on his best day.

Step 3: Build out the line items

Now you write the list and run the formula on each. Here is a slice of what that looks like at $150 per hour with a 1.7x parts markup:

Notice the customer never sees the breakdown. They see one clean price. You see a protected margin on every line. You repeat this for every service you offer, and that repetition, a couple hundred times, is the real cost of building a book by hand.

Step 4: Add Good, Better, Best to each line

A single price frames the sale as yes or no. Three tiers turn it into "which one." For each line, build:

• Good: the straightforward fix.
• Better: the fix plus the obvious add-on or a longer warranty.
• Best: premium parts, longest warranty, related work bundled in.

This roughly triples your line-item work, because now every service needs three priced versions instead of one. But it is also where average ticket quietly climbs, so it is worth doing.

If steps 3 and 4 sound like weeks of spreadsheet work, that is an honest read. This is the exact grind the HVAC Flat Rate Price Book from TradeSystemTemplates is built to skip, 220-plus services already written and priced with all three tiers in place.

Step 5: Make it reprice itself

Here is the step most DIY books get wrong. If you type a hard number into every cell, then the day your insurance goes up or copper jumps, you are re-pricing two hundred lines by hand. Build it with formulas instead.

Put your hourly rate in one cell and your markup in another. Reference those two cells in every line's formula. Now when your rate moves from $150 to $165, you change one cell and the entire book updates itself. A price book that cannot reprice in one move is a price book you will quietly stop updating, which is how books drift out of date and back to guessing.

Step 6: Make it usable on the truck

A book nobody opens is worthless. Make it work where the work happens:

• Printable, so it can live in a binder in the truck for techs who do not want to scroll a phone.
• Digital, in Excel and Google Sheets, so the office and the field see the same prices.
• Organized by category, diagnostics, repairs, installs, maintenance, so a tech finds the line in seconds, not minutes.
• Locked down where it counts but editable where you need it, so a tech cannot fat-finger a formula but you can still add a new service.

How long this takes by hand

Realistically, building a complete, formula-driven, three-tier HVAC price book from scratch is 40 to 80 hours of focused work: writing every service, sourcing labor times, pricing parts, building the formulas, then testing and formatting it for the truck. That is a week or two of evenings, and it is genuinely valuable work if you have the time.

If you would rather have that week back, a done-for-you template gets you to the finish line in an afternoon of setting your own rate and reviewing the lines.

The bottom line

Building a flat rate price book comes down to six moves: lock in your hourly rate and markup, run one formula on every line, build out every service, layer in Good/Better/Best, wire it so it reprices from two cells, and format it to actually get used on the truck. Do it from scratch and you will spend a week or two. Do it once, correctly, and you stop leaving money in the driveway forever.

Don't want to spend two weeks building it? Grab the HVAC Flat Rate Price Book on Etsy for $79. It is 220-plus HVAC services already priced with Good/Better/Best, a built-in calculator that reprices the whole book from your rate and markup, Excel and Google Sheets, printable for the truck, instant download with lifetime updates, and fully unlocked so you can edit and rebrand it as your own.