Housecall Pro will hand you the columns. It won’t hand you the line items. If you opened the price book import wizard and realized you still have to invent 60 services, prices, and costs from scratch, start from one of these instead — every template below is a CSV in HCP’s import format with tasks, categories, prices, and costs already filled in.
Pick your trade
Same structure across all five, different task lists. Each is priced at a 60% target gross margin on a $45/hr loaded labor rate, with a cost on every line so margin tracking works the day you import.
What a Housecall Pro price book template actually is
A price book template is just a CSV whose header row matches the fields Housecall Pro’s import wizard expects. There’s no proprietary file type and no API involved — CSV import and export work on every HCP plan. Here are the service columns and what each one does for you.
Column
Required?
What it does
Industry
Required
Has to match an industry that already exists in your account (HVAC, Plumbing, and so on).
Category
Required
Top-level grouping. Every row needs one — a blank here is a classic failed row.
Name
Required
The service name your techs see in the app.
Subcategory_1 … _N
Optional
Nesting under the category. Three or four levels deep is plenty.
Description
Optional
What the customer sees on the estimate. Worth filling in — it sells the price.
Price
Optional
Defaults to $0.00 if you leave it blank, which is how shops end up with free work in the book.
Cost
Optional
Optional to Housecall Pro, mandatory if you ever want to know your margin.
Taxable
Optional
true or false. Defaults to false.
unit_of_measure
Optional
Defaults to “each.”
Materials use the same columns minus Industry, plus a markup flag that lets HCP calculate the sell price for you. Because materials need their own structure, they’re usually a separate file from your services.
Before you import anything, export your current price book (Settings → Price Book → Services tab → Export). The CSV gets emailed to your account address rather than downloaded, so check your inbox. That export is both your backup and a sample of the exact headers your account uses.
Making the template yours
A template you import unchanged is a template that prices your jobs at someone else’s cost structure. Three edits do most of the work:
Set your real labor rate. Not what you wish you charged, and not what the shop down the road charges — your wages plus taxes plus shop costs divided by the hours you actually bill.
Update the costs. Parts prices moved since we generated these. Your supplier invoices are the source of truth, and every price in the book is only as good as the cost under it.
Delete what you don’t sell. A 30-task book your techs use beats a 60-task book they scroll past.
If re-pricing every row by hand sounds like a lost Saturday, upload the template (or your own export) to the free Margin Leak Finder. Enter your labor rate, overhead, and target margin, and it flags every line priced under target and hands back a corrected, import-ready file. It runs entirely in your browser — your pricing never gets uploaded anywhere.
Then import it
Save as CSV rather than XLSX, keep prices as plain numbers, and leave the header row alone. The full walkthrough, including what the wizard’s result screen is telling you, is in the price book import guide. If rows come back red, the import errors guide covers the specific causes. The rest of the Housecall Pro price book guides cover exporting and bulk price updates.
Why the Cost column is the one to get right
Housecall Pro treats Costas optional, so most shops skip it and lose the ability to answer “did that job make money?” In one real 86-service book we audited, 83 services had no cost recorded at all, the worst item was priced at a -20% gross margin, and the estimated undercharge came to $71,888 a year from just the 3 items that had cost data, at 12 sales each per year. None of that was visible from inside the app, because there was nothing to measure against (the full audit). Fill the column in.
Frequently asked questions
Does Housecall Pro give you a price book template?
Not a populated one. HCP gives you the structure — export your price book and you get a CSV with the right headers — but the rows are yours to write. If your book is empty, that export is essentially a blank header row. That’s the gap these templates fill.
What columns does a Housecall Pro price book template need?
For services: Industry, Category, Name, Price, Cost, Taxable, and unit_of_measure, plus optional Description and Subcategory_1 through Subcategory_N for nesting. Materials use the same set minus Industry. The import wizard lets you correct the header mapping, so having every required column present matters more than exact spelling.
Can I use the HVAC template if I run a plumbing shop?
You can, but you’d be deleting most of it. The task lists are trade-specific — the plumbing template covers drain cleaning, water heaters, and repipes, not condenser coils. Start from your own trade and you keep far more rows.
Do I have to fill in the Cost column?
Housecall Pro doesn’t require it, and skipping it is the main reason shops can’t tell which jobs make money. Every template here ships with costs filled in — leave them in and update them from your supplier invoices.
Will importing a template wipe out my existing price book?
Rows that match existing items typically update them and new rows get added, but the behavior depends on how your file is structured. Export your current book first so you have something to restore from.
Or start from a book that’s already priced for you
Templates get you a structure. If you’d rather not spend a weekend setting rates row by row, The Margin-Right Rebuild is a $249one-time service: we take your Housecall Pro export, rebuild every price at your target margins, and hand back a file that’s verified to import clean.