Search for a flat rate price book and a lot of people type PDF on the end of it. That makes sense. What you picture is a clean printed book, tabs down the side, something you hand a tech or set on the customer's counter.

The format you picture is the output. The problem is that most people go looking for the output and buy it directly, and then discover what a PDF price book actually is: a set of prices frozen on the day somebody made it, with no way to move them.

What a PDF price book does well

It is not a bad format. It is a bad source.

It prints properly. Page breaks land where they should, the formatting holds, and it looks the same on every machine. An Excel file printed by someone who has not set the print area is a mess of cut columns across nine pages.

It works on a phone or tablet in a crawl space. No app, no recalculation, no accidentally fat fingering a cell.

Nobody can change it. If you have three techs in the field, that is the whole point. The price is the price, and no one is negotiating with the spreadsheet in the driveway.

It looks finished. Handing a customer a printed page from a bound book reads differently than turning a laptop around.

What a PDF price book cannot do

It cannot change when your costs change. This is the one that matters and it is not a small thing.

A flat rate price is built on three inputs: your hourly rate, your material cost, and the labor time for the task. All three move. Copper moves weekly. Your loaded labor rate changes every time you give a raise, your workers comp modifier shifts, or your health contribution goes up. Your overhead rate changes when you add a truck.

When any of those move, every price in the book is wrong. In Excel you change one cell and 250 prices recalculate. In a PDF you have 250 wrong numbers and no way to fix them except buying a new book.

PDFExcel
Recalculates to your hourly rateNoYes
Adjusts when material costs moveNoYes
Prints cleanlyYesYes, if the print area is set
Works offline on a tabletYesYes
Techs cannot edit itYesOnly if you lock it
Add your own tasksNoYes
Good, better, best tiers that move togetherFrozenRecalculate

The generic rate problem

There is a second issue with buying a finished PDF, and it is worse than the first.

Whoever built it used an hourly rate. Not yours. Theirs, or a national average, or whatever made the numbers look reasonable.

If that book was built on $125 an hour and your true loaded rate is $158, every price in it is roughly twenty percent low. You will win more jobs, which will feel like the book working, and you will lose money on all of them.

Run your own number before you evaluate any price book, PDF or not. The true cost of an employee calculator and how to calculate your true hourly rate cover it. If the book you are looking at does not let you enter that number, it is not priced for your business.

The answer is both, in the right order

Excel is the source. PDF is the output. You want a spreadsheet that holds the math and a printed book that comes out of it.

That way the rate change takes one cell, and the thing you hand the customer is still a clean printed page.

The workflow is three steps and takes about five minutes:

  1. Set your hourly rate and material markup once, at the top of the workbook. Every price recalculates.
  2. Print to PDF. On Windows that is Microsoft Print to PDF, on a Mac it is the PDF button in the print dialog. Set the print area first so pages break between sections instead of mid table.
  3. Put the PDF on the tech's tablet and print the sections you actually quote from.

Redo it when something real changes: a raise, a new truck, a copper swing, or the annual rate review. Twice a year is enough for most shops, four times if you are in a volatile material market.

When a locked PDF is genuinely the right call

Once you have more than two techs quoting, send the PDF and keep the Excel. Not because they will cheat, but because a spreadsheet invites adjustment and a printed price does not. The conversation you want in the driveway is about scope, not about whether the number is negotiable.

Keep the workbook on your machine. Techs get the output.

Short version

If you are searching for a flat rate price book PDF, what you actually want is a book you can print. Those are not the same thing. Buy the file that holds the math, then make the PDF yourself, every time your costs move.

For what is actually in one of these books, see what is inside an electrician flat rate price book.

Frequently Asked Questions

Is a flat rate price book better as a PDF or an Excel file?
Excel as the source, PDF as the output. Excel lets you set your own hourly rate and material markup once and recalculate every price, which matters because labor rates and copper prices move constantly. PDF prints cleanly and cannot be edited by a tech in the field. Keep the workbook, print the PDF whenever your costs change.
Why do flat rate price book PDFs go out of date so fast?
Because every price in them is built on three moving inputs: your hourly rate, material cost, and labor time per task. Copper moves weekly, loaded labor rates change with every raise or insurance adjustment, and overhead shifts when you add a truck. A PDF freezes all three on the day it was made, and there is no way to update the numbers inside it.
Can I convert an Excel price book to PDF myself?
Yes, and it takes about a minute. Set the print area so pages break between sections rather than mid table, then use Microsoft Print to PDF on Windows or the PDF option in the Mac print dialog. A well built price book ships with the print areas already configured, so you just print.
What hourly rate are prebuilt price books based on?
Usually a national average or whatever rate the author's own shop used. That is the core problem with buying a finished PDF. If the book was built at a rate lower than your true loaded rate, every price in it is too low, and you will win more work while losing money on it. Always run your own loaded rate first and make sure the book lets you enter it.
Should my techs get the Excel file or just the PDF?
Give techs the PDF and keep the workbook yourself. A spreadsheet invites adjustment in the driveway, and the conversation you want with a customer is about scope, not about whether the number is negotiable. It also prevents accidental edits to a formula cell, which is easier to do on a phone than people think.
How often should I regenerate the PDF from the Excel book?
Whenever a real input moves: a raise, a new truck or insurance change, a significant material swing, or your annual rate review. For most shops twice a year is enough. In a volatile material market, quarterly. The point is that regenerating costs you five minutes, so there is no reason to run on stale prices.