Key takeaways
- Service, replacement and construction estimating are different jobs, and the right tool differs for each.
- Spreadsheets are fine for a solo shop or occasional bids if formulas are locked and costs live in one place.
- Field service software pays off once several techs quote on site and you need one price book on every tablet.
- Takeoff and bid tools matter for new construction, where plan reading and per-fixture counts drive the number.
Three kinds of estimating
Preparing cost estimates is one of the core duties BLS lists for plumbers[1], but the work looks very different across the business. A service tech prices a repair on a tablet in a customer's kitchen in a few minutes. A replacement salesperson builds a proposal with two or three options for a water heater or a repipe. A construction estimator reads plans, counts fixtures and builds a bid that may be weeks in the making. Asking which tool is best only makes sense once you know which of these you do most.
How the tools compare
| Criterion | Spreadsheet | Field service software | Takeoff and bid software |
|---|---|---|---|
| Best for | Solo shops, occasional bids, custom jobs | Service and replacement work with several techs | New construction and larger commercial bids |
| Price book on every tablet | Hard to keep in sync | Built in | Not the focus |
| Good, better, best proposals | Possible with templates | Built in, with photos and signatures | Limited |
| Plan reading and fixture counts | Manual | Usually not | Built in |
| Customer signature and deposit | Separate tools | Built in | Usually separate |
| Cost to start | Low | Monthly subscription and setup time | Subscription plus training |
| Main risk | Broken formulas and old copies | Garbage in, garbage out price book | Underused if bids are rare |
Many shops end up with two tools: field service software for service and replacement, and a spreadsheet or takeoff tool for the occasional construction bid. That is fine, as long as both read labor and material costs from the same source.
What each kind of estimate needs from a tool
Service estimates need speed and consistency. The tech should pick a task, see the price and description, add photos and get approval in a couple of minutes. A spreadsheet can do this for one person who knows it by heart, but it struggles once several techs are quoting from different versions on different phones.
Replacement estimates need options and persuasion. A homeowner choosing between repairing a water heater, replacing it with a standard tank or converting to tankless wants to see the options side by side, with what each includes, the warranty and a monthly payment where financing is available. The tool should make building that page quick and should keep a record of which option was chosen.
Construction bids need counting and structure. The estimator reads plans, counts fixtures and lengths, applies labor units and builds a schedule of values for progress billing. Here the risk is missing an item on page twelve of the drawings, and the tool should help with takeoff, assemblies and checklists rather than with tablets and signatures.
- Service: task price book, photos, approvals, payment.
- Replacement: multi-option proposals, financing, signatures, deposits, follow-up reminders.
- Construction: takeoff, assemblies, labor units, alternates, schedule of values.
Where spreadsheets still win
- You are a solo plumber or a two-person shop and you write a handful of quotes a week.
- Your work is mostly custom: remodels, unusual commercial jobs or one-off projects where no price book fits.
- You need a quick model to test a pricing idea, such as a new minimum charge or a membership discount.
- You bid construction only occasionally and cannot justify a takeoff subscription.
The spreadsheet's strengths are flexibility and cost. Its weakness is control: anyone can type over a formula, and three versions of the same template can quietly drift apart.
Where software pays off
- Several techs price work on site and need the same prices, descriptions and photos.
- You present options to homeowners and want signatures, deposits and financing applications in one flow.
- You want to know close rates by tech, job type and option, which a spreadsheet will not tell you without a lot of manual work.
- Your price book changes several times a year and must update everywhere at once.
The cost is not only the subscription. Someone has to build and maintain the price book, train the team and fix the problems at the start. Budget that time honestly.
A useful test is to add up the hidden cost of the current setup for one month: estimates redone because someone used an old version, jobs underpriced because a cost was out of date, and office hours spent retyping quotes into invoices. If that monthly figure is larger than what a tool and its upkeep would cost, the switch is worth planning. If it is small, keep improving the spreadsheet and revisit the question when the team grows.
Where the industry is with technology
Small businesses are adopting new tools quickly. The U.S. Chamber of Commerce found that 58% of small businesses used generative AI in 2025, up from 40% in 2024 and 23% in 2023, and 84% planned to increase their use of technology platforms[2]. Construction is slower: Census survey data from October 2026 shows 17.1% of construction businesses using AI in a business function, against 24.2% of all businesses[3].
Source: U.S. Chamber of Commerce Technology Engagement Center, 2025[2]
Show the data
| Item | Value |
|---|---|
| 2023 | 23% |
| 2024 | 40% |
| 2025 | 58% |
For estimating, that gap is an opportunity rather than a reason to rush. Most of the value still comes from basics: one accurate price book, consistent proposals and data on what sells. Fancier features help only once those basics work.
Decision criteria
- Count estimates per week by type: service, replacement and construction. The largest group decides your main tool.
- Count the people who price work. One person can keep a spreadsheet straight; three or more usually cannot.
- List what you need beyond the number: photos, signatures, deposits, financing, follow-up reminders.
- Check integrations with your scheduling, accounting and payment tools; double entry is where estimates go wrong.
- Estimate setup time for the price book and who will own it.
- Decide what you need to measure, such as close rate by option or average ticket by tech, and confirm the tool reports it.
Small shops are the norm: about 77% of plumbing, heating and AC contractor establishments had fewer than ten employees in 2023[4]. For many of them, a well-built spreadsheet is the right answer for longer than vendors suggest.
Make a spreadsheet estimate safe
Keep one cost tab
Labor rates, markups and material costs live on one protected tab that every template reads from.
Lock the formulas
Protect every cell except the inputs. Estimators type quantities and choices, not prices.
Use one master template
Store it in a shared folder and make copies per job, so nobody edits the master by accident.
Version and date it
Put the price book date on every estimate, so you know which costs a quote used.
Check totals
Add a simple check, such as labor hours times the loaded rate, so a broken formula shows up before the quote goes out.
Move to software without chaos
Clean the price book first
Remove duplicate tasks, update times and costs, and write plain descriptions before importing anything.
Start with the top 50 tasks
Load the jobs you do most and get them right. The long tail can follow.
Pilot with two techs
Run the new tool with your two most willing techs for a few weeks and fix what confuses them.
Train everyone together
One session for the whole team with real examples, then ride-alongs.
Retire the old copies
Once live, remove old spreadsheets and printed price sheets so no one quotes from them.
Example (fictional): a six-tech service shop moves from a shared spreadsheet to field service software over two months. In the first weeks, quotes take longer and two techs keep using printed sheets. Once the old sheets are collected and the top 50 tasks are cleaned up, every tablet shows the same prices, proposals include photos and signatures, and the owner can finally see which options customers choose. The biggest gain is not speed but consistency.
Questions to ask vendors
- Can techs build multi-option proposals on site, with photos, signatures and deposits?
- How is the price book structured, and can we import our own tasks and times?
- How do price changes reach every device, and can we schedule them?
- What reports show close rates by tech, job type and option?
- What does setup support include, and who builds the first price book?
- How do we export our data if we leave?
Whichever tool you choose, the estimate is only as good as the costs behind it. Review those costs at least once a year, as covered in our guide to raising prices without losing loyal customers, and handle scope changes on site with a written change order.
Frequently asked questions
Is a spreadsheet good enough for a small plumbing shop?
Often yes, for a solo plumber or a small team, if costs live on one protected tab, formulas are locked and every estimate carries the price book date.
When should I switch to field service software?
When several people price work on site, you present options often and you need one price book on every tablet with signatures and deposits.
Do I need takeoff software for new construction?
If you bid construction regularly, yes. Plan reading and fixture counts take too long and are too error-prone by hand for frequent bids.
Can one tool do everything?
Rarely well. Many shops use field service software for service and replacement and a separate tool for construction bids, fed from the same costs.
References
U.S. Bureau of Labor Statistics (2025). Occupational Outlook Handbook: Plumbers, Pipefitters, and Steamfitters (opens in a new tab) โ
U.S. Chamber of Commerce Technology Engagement Center (2025). Empowering Small Business: The Impact of Technology on U.S. Small Business (2025) (opens in a new tab) โ
U.S. Census Bureau (2026). Business Trends and Outlook Survey (BTOS), response estimates by sector (opens in a new tab) โ
U.S. Census Bureau (2023). County Business Patterns 2023, U.S. national file (cbp23us) (opens in a new tab) โ