Technology AI

Getting reliable reports out of your plumbing software

The weekly reports a plumbing owner should run, the data entry habits that make them accurate, how to check a report before trusting it, and benchmarks.

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

On this page
  1. Why plumbing reports go wrong
  2. The weekly report set
  3. What to look for in each report
  4. Data entry rules that make reports trustworthy
  5. Check a report before you act on it
  6. Benchmarks: useful for context, not targets
  7. Watch labor cost alongside revenue
  8. Who sees which report
  9. Exports and your own copy
  10. Example: the case of the falling average ticket
  11. Frequently asked questions
  12. References
Technology AI: Getting reliable reports out of your plumbing softwareArticle coverTECHNOLOGY AIGetting reliablereports out of yourplumbing softwareAva for PlumbersInsightsTechnology AI: Getting reliable reports out of your plumbing softwareArticle coverTECHNOLOGY AIGetting reliablereports out of yourplumbing softwareAva for Plumbers

Key takeaways

  • Reports are only as good as job types, statuses and close-out habits; fix data entry before adding reports.
  • Run a short weekly set: booked vs completed, revenue by tech and job type, open estimates, receivables, callbacks and lead sources.
  • Check each report against the bank, a few real jobs and its own definition before acting on it.
  • Use industry benchmarks for size, not targets; about 63% of plumbing, heating and AC firms had receipts under $1 million in 2022[1].

Why plumbing reports go wrong

Most field-service platforms can produce dozens of reports. Owners often stop trusting them within months, and the cause is rarely the software. It is how jobs are entered: a drain cleaning coded as a service call, a job left open for two weeks after the work was done, a second tech never added to a job they helped finish, a refund entered as a negative line on a different job. Every one of those quietly distorts revenue by tech, average ticket, close rates and callbacks.

The fix is a few firm data entry rules, a short weekly report set and a habit of checking reports against reality. None of it requires new software.

It helps to remember who reports are for. A report that only the owner reads at month-end changes little. A short set reviewed every week by the owner and the office manager, and shared in part with techs, changes behavior. Choose reports with that audience in mind and keep them few enough that each one is actually read. In most shops that audience is small: about 77% of plumbing, heating and AC contractor establishments had fewer than 10 employees in 2023[2], so the owner and one office person are often the entire reporting team. That is another reason to keep the set short and the definitions written down.

The weekly report set

A weekly report set for a plumbing company, with the data trap behind each.
ReportQuestion it answersCommon trap
Booked vs completed jobsIs the schedule turning into finished work?Jobs completed but never closed
Revenue by technicianWho is producing what?Helpers not attributed; split jobs credited to one tech
Revenue and average ticket by job typeWhich work is growing or shrinking?Inconsistent job type codes
Open estimatesWhat work is waiting on a decision?Expired or lost estimates never marked
Accounts receivable agingWho owes money, and for how long?Payments taken in the field not matched to invoices
Callbacks and warranty visitsWhere is quality slipping?Callbacks booked as new jobs
Lead sourceWhich marketing produces booked jobs?Source left blank or defaulted
Calls and bookingsAre calls being answered and booked?Phone data not linked to jobs

Eight reports fit on two screens and take about 20 minutes to review. Resist adding more until these are reliable. Our weekly scorecard guide shows how to turn them into one page.

What to look for in each report

Reading a report is a skill. For each one in the weekly set, decide in advance the one or two signals that would make you act:

  • Booked vs completed: a growing gap means jobs are being cancelled, rescheduled or left open. Check which before blaming the schedule.
  • Revenue by technician: compare each tech with their own last eight weeks, not only with each other; different techs get different work.
  • Revenue by job type: a sudden rise or fall in one type is often a coding change, so confirm with a spot-check.
  • Open estimates: sort by value and age, and make sure every estimate over a set amount has a follow-up date.
  • Receivables: focus on anything over 30 days and on property-manager accounts, which tend to drift.
  • Callbacks: look for the same tech, job type or part appearing repeatedly.
  • Lead source: compare booked jobs and revenue by source, not just calls, because some sources bring many calls and little work.
  • Calls and bookings: watch the share of calls that end in a booking, by hour of day, to find staffing gaps.

Data entry rules that make reports trustworthy

  1. A short, fixed list of job types

    Keep job types to a list the office can remember, such as drain, water heater, leak repair, fixture, sewer, repipe, estimate, maintenance and warranty. Lock the list so new types cannot be added casually.

  2. Status discipline

    Define each status in one sentence and use them the same way every time. A job is completed when the work is done and the tech has closed it on site, not when the invoice is paid.

  3. Close out within 24 hours

    Every job is closed, invoiced and noted by the end of the next working day. Run a daily list of jobs still open past their scheduled date.

  4. One customer, one record

    Search before creating a customer. Merge duplicates weekly. Duplicate records split history and distort repeat-customer figures.

  5. Attribute every tech

    Add every tech who worked on a job, with the split you use for pay or performance.

  6. Refunds and credits on the original job

    Enter refunds against the job they relate to, so that job's real revenue is visible.

  7. Lead source at booking

    Make lead source a required field, filled in when the job is booked, with a short list of options.

Check a report before you act on it

Before making a decision from a report, run three quick checks. First, reconcile: does revenue for the month roughly match deposits in the bank, after card processing and timing differences? Second, spot-check: open five jobs from the report and confirm each is coded, dated and attributed correctly. Third, read the definition: what exactly does the software count as completed, revenue or a callback? Many arguments about numbers end once everyone reads the same definition.

If a report surprises you, assume a data problem first and a business problem second. Check five jobs before calling a meeting.

Benchmarks: useful for context, not targets

Owners often want to know how their numbers compare. Government data gives some context on size. In 2022, about 17% of plumbing, heating and air-conditioning contractor firms had annual receipts under $100,000, about 63% had receipts under $1 million, and about 28% had receipts between $1 million and $5 million[1]. Average receipts per firm were about $2.9 million, pulled up by larger companies, and receipts per employee were about $260,000[3].

Plumbing, heating and AC contractor firms by annual receipts, 2022Share of all firms with employees. The first two bars overlap: under $1 million includes under $100,000.
Plumbing, heating and AC contractor firms by annual receipts, 2022Bar chart. Under $100,000: 17%; Under $1 million: 63%; $1 million to $5 million: 28%.Under $100,000Under $100,000: 17%17%Under $1 millionUnder $1 million: 63%63%$1 million to $5 million$1 million to $5 million: 28%28%Plumbing, heating and AC contractor firms by annual receipts, 2022Bar chart. Under $100,000: 17%; Under $1 million: 63%; $1 million to $5 million: 28%.Under $100,000Under $100,000: 17%17%Under $1 millionUnder $1 million: 63%63%$1 million to $5 million$1 million to $5 million: 28%28%

Source: U.S. Census Bureau, 2022[1]

Show the data
ItemValue
Under $100,00017%
Under $1 million63%
$1 million to $5 million28%

These figures combine plumbing with heating and air-conditioning contractors and include commercial firms, so treat them as context, not targets. Payroll equalled about 27% of receipts across the industry in 2022[3]; if your own payroll share is far from that, check first that both numbers are measured the same way before drawing conclusions.

Watch labor cost alongside revenue

Revenue reports alone can hide a squeeze. Average hourly earnings at plumbing, heating and AC contractors rose from $39.30 in January 2025 to $42.65 in August 2026[4]. If your revenue per tech is flat while wages rise at a similar pace, margins are shrinking. Add a monthly report of labor cost as a share of revenue, using payroll from your accounting system rather than estimated labor in the field-service app.

Who sees which report

Share reports according to who can act on them. The owner and office manager see the full weekly set. Each technician sees their own revenue, average ticket and callbacks, compared with their own history, in a short one-to-one conversation rather than a league table pinned to the wall. The dispatcher sees booked vs completed and calls and bookings. The bookkeeper sees receivables and the monthly reconciliation. Keeping each audience to the numbers it can change makes the conversations shorter and more useful.

Exports and your own copy

  • Export the weekly set to a spreadsheet each week, so you can see trends the software's screens do not show.
  • Keep a quarterly full export of customers, jobs, invoices and estimates in storage you control.
  • Name exports consistently with the date, so they can be compared.
  • Remove customer names before sharing exports with anyone outside the business, including AI tools.
  • If you change software, compare the last month's reports from both systems before switching off the old one.

Example: the case of the falling average ticket

Example: an owner sees the average ticket for water heater jobs fall sharply over two months and suspects techs are discounting. Spot-checking five jobs shows three were not water heater replacements at all but thermostat and anode visits, coded as water heater because that was the closest option on the list. The office adds a separate code for water heater repairs, recodes the last two months and reruns the report. The replacement ticket is steady; the repair work, now visible, turns out to be a growing line worth marketing.

Frequently asked questions

Which plumbing software reports matter most?

A weekly set of booked vs completed jobs, revenue by tech and job type, open estimates, receivables aging, callbacks, lead source, and calls and bookings.

Why don't my software's numbers match my bank?

Usually timing, card fees, refunds entered on other jobs, or jobs completed but not invoiced. Reconcile monthly and fix the data habits behind each difference.

How many job types should we have?

Few enough that the office uses them consistently, often under fifteen. Lock the list so new types are added only by decision.

Are industry benchmarks useful?

For context on size and structure, yes. Combined plumbing and HVAC data from the Census Bureau covers many kinds of firms, so compare carefully and track your own trends first.

References

  1. U.S. Census Bureau (2022). Statistics of U.S. Businesses 2022: Firms by industry and enterprise receipts size (opens in a new tab) โ†‘

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

  3. U.S. Census Bureau (2022). Statistics of U.S. Businesses 2022: U.S. and states, 6-digit NAICS (opens in a new tab) โ†‘

  4. U.S. Bureau of Labor Statistics, Current Employment Statistics (2026). Average hourly earnings of all employees, plumbing, heating, and air-conditioning contractors, not seasonally adjusted (CEU2023822003) (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