Pricing estimates

Estimating software vs spreadsheets for plumbers

Spreadsheets, field service software and takeoff tools compared for plumbing service, replacement and construction estimating, with decision criteria.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing6 min read

On this page
  1. Three kinds of estimating
  2. How the tools compare
  3. What each kind of estimate needs from a tool
  4. Where spreadsheets still win
  5. Where software pays off
  6. Where the industry is with technology
  7. Decision criteria
  8. Make a spreadsheet estimate safe
  9. Move to software without chaos
  10. Questions to ask vendors
  11. Frequently asked questions
  12. References
Pricing estimates: Estimating software vs spreadsheets for plumbersArticle coverPRICING ESTIMATESEstimating software vsspreadsheets forplumbersAva for PlumbersInsightsPricing estimates: Estimating software vs spreadsheets for plumbersArticle coverPRICING ESTIMATESEstimating softwarevs spreadsheets forplumbersAva for Plumbers

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

Estimating tools by criterion. Features vary by product; check each vendor.
CriterionSpreadsheetField service softwareTakeoff and bid software
Best forSolo shops, occasional bids, custom jobsService and replacement work with several techsNew construction and larger commercial bids
Price book on every tabletHard to keep in syncBuilt inNot the focus
Good, better, best proposalsPossible with templatesBuilt in, with photos and signaturesLimited
Plan reading and fixture countsManualUsually notBuilt in
Customer signature and depositSeparate toolsBuilt inUsually separate
Cost to startLowMonthly subscription and setup timeSubscription plus training
Main riskBroken formulas and old copiesGarbage in, garbage out price bookUnderused 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].

US small businesses using generative AI
US small businesses using generative AIColumn chart. 2023: 23%; 2024: 40%; 2025: 58%.0%20%40%60%2023: 23%23%20232024: 40%40%20242025: 58%58%2025US small businesses using generative AIColumn chart. 2023: 23%; 2024: 40%; 2025: 58%.0%20%40%60%2023: 23%23%20232024: 40%40%20242025: 58%58%2025

Source: U.S. Chamber of Commerce Technology Engagement Center, 2025[2]

Show the data
ItemValue
202323%
202440%
202558%

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

  1. Count estimates per week by type: service, replacement and construction. The largest group decides your main tool.
  2. Count the people who price work. One person can keep a spreadsheet straight; three or more usually cannot.
  3. List what you need beyond the number: photos, signatures, deposits, financing, follow-up reminders.
  4. Check integrations with your scheduling, accounting and payment tools; double entry is where estimates go wrong.
  5. Estimate setup time for the price book and who will own it.
  6. 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

  1. Keep one cost tab

    Labor rates, markups and material costs live on one protected tab that every template reads from.

  2. Lock the formulas

    Protect every cell except the inputs. Estimators type quantities and choices, not prices.

  3. Use one master template

    Store it in a shared folder and make copies per job, so nobody edits the master by accident.

  4. Version and date it

    Put the price book date on every estimate, so you know which costs a quote used.

  5. 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

  1. Clean the price book first

    Remove duplicate tasks, update times and costs, and write plain descriptions before importing anything.

  2. Start with the top 50 tasks

    Load the jobs you do most and get them right. The long tail can follow.

  3. Pilot with two techs

    Run the new tool with your two most willing techs for a few weeks and fix what confuses them.

  4. Train everyone together

    One session for the whole team with real examples, then ride-alongs.

  5. 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

  1. U.S. Bureau of Labor Statistics (2025). Occupational Outlook Handbook: Plumbers, Pipefitters, and Steamfitters (opens in a new tab) โ†‘

  2. 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) โ†‘

  3. U.S. Census Bureau (2026). Business Trends and Outlook Survey (BTOS), response estimates by sector (opens in a new tab) โ†‘

  4. U.S. Census Bureau (2023). County Business Patterns 2023, U.S. national file (cbp23us) (opens in a new tab) โ†‘

Book a demo

See Ava handle your calls.

Book a short demo. Weโ€™ll walk through your calls and workflow, and agree what Ava should take care of.

Book a demo