Why are the hours, costs and prices blank?
Every shop has different labor rates, supplier costs, markup rules and discounts. Enter your own reviewed numbers instead of relying on made-up prices.
Free flat rate price book template for HVAC, plumbing and electrical
Start a flat rate price book with common HVAC, plumbing and electrical service tasks. Every labor hour, cost and price is blank because each shop has different labor rates and supplier costs.
Fill in your price book
Task names and categories are examples. All hours, costs and prices start blank. Your entries stay in this browser until you download a file.
Why use a price book instead of pricing by the hour on the job?
A price book lets the shop review a task and its assumptions before a technician is standing with a customer. The team can explain a defined service price consistently, while the owner can review labor and parts inputs separately. It still takes judgment: inspect the job, confirm the scope and update the task when the work or costs change.
When a spreadsheet stops working
Supplier price changes, several technicians, or member pricing can make a manually maintained sheet hard to keep consistent. TierMenu manages the shared price book and recalculates each task from your own pricing settings. See the TierMenu price book.
FAQ
What does the Excel price formula use?
It multiplies labor hours by labor rate, adds parts cost with markup, then rounds to the nearest dollar. Member price applies the member discount to that rounded price.
Do the Excel formulas fill in prices before I add inputs?
No. Formula cells stay blank until the labor hours, labor rate, parts cost and markup are entered. The sample row is labeled and also starts with blank numbers.
Can I change the task names and categories?
Yes. Treat the listed residential service tasks as a starting point and edit the downloaded Word or Excel file to fit the work your shop actually offers.
What is the sample row for?
The row named “Sample: use your own numbers” shows where to enter inputs and where the formulas calculate. It contains no suggested hours, costs or prices.
When should I use the TierMenu price book instead?
A spreadsheet can be harder to maintain when supplier costs change, several technicians use it, or member prices are needed. TierMenu manages those tasks and pricing rules in one price book.
Do this faster in TierMenu.
14-day free trial. No credit card. Up to 5 users on one plan.