A call comes in at 8 in the morning. Somebody wants a price on a job you've done a hundred times, and the person who answered the phone writes down the details and sets the slip on your desk, because you're the only one who knows what to charge. It sits there until you're back from the field.
That's the whole problem in one sentence. Your pricing lives in your head. While you're on a job the quote waits, and a customer who wanted a number today has called somebody else by Thursday.
Fixing this doesn't take fancy software. It takes a price book, a plain document that lists what you charge for the work you actually do, so an office person or a newer hire can put together a consistent estimate without guessing or texting you on a ladder. AI can help you build one fast from the invoices you've already sent. Here's how, and here's where it still needs your eyes.
What a price book actually is
Really it's just your prices, written down somewhere another person can use them. Not a spreadsheet full of formulas nobody understands. A clear list.
Every entry covers one piece of work. What it is, how you measure it, and what you charge. Some items have a firm price, most have a range, because a job is never exactly the same twice.
Good entries hold a few things:
- A plain description ("replace standard kitchen faucet, customer supplies fixture")
- The unit you price by (per job, per foot, per hour, per fixture)
- A typical price or a low-to-high range
- Common add-ons and what they cost
- A short note on what pushes the price up or down
Get that on paper for your top 30 or 40 jobs and you've covered most of what walks in the door.
Start with the invoices you already have
You don't build this from memory. You build it from history, and you've got years of it sitting in your invoicing.
Pull your last six to twelve months of invoices and estimates. Most of you can export these from QuickBooks, Jobber, Housecall Pro, or whatever you run, as a PDF or a spreadsheet. If they only live on paper, snap photos of a good stack.
Hand that pile to an AI chatbot that can read documents (the paid versions of the common ones do this) and ask it to pull every line item into one big list, with the description and the price from each job. What used to be a weekend of squinting at old paperwork now takes a few minutes.
One caution up front: strip out customer names, addresses, and phone numbers first, or use a tool your business already trusts with that data. No reason to hand a stranger your client list.
Turn the pile into line items and ranges
Now you've got a messy list of everything you've charged for. The next step is where AI earns its keep.
Ask it to group similar items together, then show you the low, the high, and the typical price for each group. "Water heater, 40 gallon gas" might show up eleven times at nine different prices, and the AI will lay that spread out so you can see it.
The spread is the useful part. It shows you where your pricing has been all over the map, which usually means you were guessing in the moment. Seeing the range is the first step to setting a real one.
Have it flag gaps too. Jobs you do all the time but rarely wrote up cleanly, categories with only one or two examples, add-ons that show up on some invoices and not others. The AI is good at noticing "you mentioned a disposal fee on four jobs but not the other twenty," which is exactly the kind of thing that slips through.
Handle add-ons, minimums, and the "it depends" work
Your base price is the easy part. The money you leave on the table is usually in the extras, so build those into the book on purpose.
List your common add-ons as their own line items with their own prices:
- Trip or fuel charge for jobs outside your normal radius
- Disposal or haul-away fees
- Old-house surprises (plaster walls in a Cambridge triple-decker, knob-and-tube wiring, a shutoff that hasn't turned since Dukakis was governor)
- After-hours or weekend rates
- Your minimum charge, so nobody quotes a 20-dollar job that costs you an hour of driving
Some work genuinely can't be booked without seeing it. That's fine, and your price book should say so plainly. Mark those jobs "site visit required" with a rough starting range, so your office person can set the right expectation ("figure somewhere north of X, we'll confirm on site") instead of freezing up on the phone.
Where you still set the real numbers
Here's the honest part, and it matters more than the rest. AI drafts the structure and catches the gaps. It does not know your business, and it should never set your prices.
It's averaging what you charged before. If you were underpricing that whole time, the average is an underpriced number wearing a confident face. The AI has no idea what your materials cost this spring, what you pay your crew, or what the shop across town gets for the same work.
So treat its output as a rough draft, not an answer. Walk through every line and set the number you actually want going forward, not the one you happened to charge last February. Pay special attention to anything the spread showed as all over the place, because that's where a real decision has been missing.
And keep the weird stuff off the assembly line. Big jobs, custom work, anything with a number that made you blink belongs in front of you, not a newer employee working off the book. A price book handles the bread-and-butter jobs so you're free to price the odd ones yourself.
Worth doing this week
There's no need to boil the ocean. A few hours gets you a working first draft.
- Export or photograph your last six months of invoices, and scrub the customer details.
- Have an AI chatbot pull every line item into one list, then group them and show the low, high, and typical for each.
- Pick your top 30 jobs and write a clean price or range for each, in your own numbers, not the averages.
- Add a short list of add-ons, your minimum charge, and which jobs always need a site visit.
- Hand it to one person, have them quote three real jobs from it this week, and fix whatever they trip over.
Do that and the 8 AM call gets a number before you've finished your coffee, whether you're in the office or already under somebody's sink. If you want a hand turning your invoices into a price book your whole crew can use, that's the kind of thing we set up with Massachusetts shops every week.