Flat rate price book builder for HVAC, plumbing and electrical

Start from a trade list or paste your own tasks, and get a flat rate, a member price and the margin for every task, ready to import into Housecall Pro, Jobber or QuickBooks.

Free tool · Hvac · Housecall Pro · Updated

1Start from a trade list or bring your own

Starter hours and parts costs are examples. Replace them with times and costs from your own jobs.

Columns: task, labor hours, parts cost. Code and category are optional.

2Set your rates

No shop rate yet? Work it out in the shop rate calculator and it shows up here.

$

What you charge per labor hour.

$

Tech wage plus burden, or your break-even rate to include overhead.

%
$

Leave at 0 for no minimum.

%

Set to 0 for no member price.

Sliding scale: markup by what the part costs you

Parts up to
Parts from $25 to
Parts from $100 to
Parts over $500

The starting rates are examples. Use your own.

3Your flat rate price book

Average margin
46.3%
Tasks priced
14
Average member margin
36.3%
Tasks to check
5 of 14

Lowest margin: Replace inducer motor at 39.9%.

CodeTaskCategoryLabor hoursParts costFlat rateMemberMarginRemove
$119$9951.3%
$119$9947.9%
$469$39940.3%Under 45% margin
$639$53940.5%Under 45% margin
$699$59939.9%Under 45% margin
$299$25944.8%Under 45% margin
$189$15947.1%
$109$8949.5%
$199$16947.2%
$129$10949.6%
$279$23946.2%
$179$14949.7%
$179$14949.7%
$819$69943.8%Under 45% margin
Margin = (price − cost) ÷ price. Cost = hours × your cost per hour + parts.

4Download or print

Required on every service. Use an industry from Housecall Pro's own list.

Housecall Pro: Settings > Price Book > Services > Upload file, then confirm each column.

Want this done on your whole Housecall Pro? We fix price books that drift out of step with your costs across field software and QuickBooks on your real data, tested with you.

Walk us through your price book

How do you calculate a flat rate price?

Multiply the labor hours by your billed hourly rate, then add the parts cost with your markup.

Flat rate = (labor hours × hourly rate) + (parts cost × (1 + markup))

Margin = (flat rate − cost) ÷ flat rate, where cost is labor hours × your cost per hour, plus parts.

Example: a condenser fan motor takes 1.5 hours at 150 dollars, so labor is 225 dollars. The motor costs 160 dollars, and a 50% markup makes it 240 dollars. The flat rate is 465 dollars, rounded up to 469. If a tech hour costs you 80 dollars, the cost is 280 dollars and the margin is 40.3%.

To price by margin instead, divide cost by (1 − target margin). At 50%, 280 dollars of cost becomes 560 dollars.

What hourly rate should a flat rate price book use?

Use your shop rate: a year of labor cost and overhead, divided by the hours you bill, plus your profit margin.

Shop rate = (labor cost + overhead) ÷ billable hours ÷ (1 − profit margin)

Example: 249,600 dollars of labor and 150,000 dollars of overhead over 4,368 billable hours is a break-even of 91.48 dollars. At a 15% margin, the shop rate is 107.63 dollars.

Work yours out in the shop rate calculator. This builder picks it up on the same browser. Use the break-even rate as your cost per hour to see margin after overhead.

What goes in an HVAC, plumbing or electrical price book?

One line per repair you do often, each with a code, a category, the labor hours and the parts cost.

  • HVAC: capacitors, contactors, motors, igniters, thermostats, drains, tune-ups.
  • Plumbing: toilet repairs, faucets, valves, drain clearing, water heaters.
  • Electrical: devices, fixtures, breakers, surge protection, new circuits.
  • Handyman: mounting, drywall patches, doors, caulking, assembly.

The starter lists in the tool are examples. Time each task from your own job history before you use the prices.

Example: “H-101 Replace run capacitor, Electrical, 0.5 hours, 18 dollars of parts” is one row.

How do you set member prices?

Take a percentage off the flat rate, then check the member margin still covers your cost.

Member price = flat rate × (1 − member discount)

Example: a 15% discount on a 469 dollar flat rate is 398.65 dollars, rounded to the nearest price ending in 9, which is 399. With 280 dollars of cost, the member margin is 29.8%.

Member prices round to the nearest step, so the discount stays close to the percentage you set. The tool can also apply the discount to the labor part only, so parts keep their full markup.

How do I import a price book into Housecall Pro, Jobber or QuickBooks?

Download the CSV for your software, then upload it from the price book or products screen and match the columns.

  • Housecall Pro: Settings > Price Book > Services > Upload file. Industry, Category and Name are required, and the industry must be one from Housecall Pro’s list.
  • Jobber: import on the Products & Services list. Category is Service or Product, and Taxable and Active take TRUE or FALSE. Unit cost is on select plans only.
  • QuickBooks Online: Settings > Import data > Products and Services. It takes 1,000 rows at a time, so long lists download in parts.

Example: 1,450 tasks for QuickBooks download as two files, one of 1,000 rows and one of 450.

Questions

Is my price list uploaded anywhere?

No. Everything runs in your browser, and your list and rates are saved only in this browser.

Can I reprice the whole book when parts costs go up?

Yes. Paste the new parts costs or change the markup, and every flat rate and member price updates at once.

Where do the starter hours come from?

They are examples to edit. Replace them with the times your techs record on real jobs.

How many tasks can it price at once?

Every row you paste or drop is priced at once. The table shows the first 400 to edit, and the download has them all.

Sources

Lines of light running into one large blue period

Walk us through one problem.

We’ll tell you what we’d fix first.

Walk us through one problem

Free. 30 minutes. A one-page note within two business days.