Plumbing Business KPI Dashboard in Google Sheets

Most plumbing companies measure exactly one thing every month: the bank balance. It is the worst possible KPI, because by the time it moves the cause is four to eight weeks old. The Plumbing Business KPI Dashboard in Google Sheets replaces that with fourteen numbers on one page – 14 KPIs across 5 groups, each reported Month-to-Date and Year-to-Date, each with a target, a prior-year comparison and a traffic light. Pick a month from one dropdown and the entire workbook re-reads itself. Nine tabs. No add-ons, no scripts, nothing to install.Plumbing Business KPI Dashboard in Google Sheets

In the sample month shipped with the file – September 2025 – the header cards read 14 KPIs tracked, 7 On Target, 4 At Risk, 3 Missed, 10 of 14 improving against prior year, 99.5% average achievement MTD and 98.4% YTD. That is the whole monthly review in one line, before you scroll.Plumbing Business KPI Dashboard in Google Sheets

Key Features of the Plumbing Business KPI Dashboard in Google Sheets

• Fourteen plumbing KPIs already defined – Jobs Completed, First-Time Fix Rate, On-Time Arrival Rate, Callback / Rework Rate, Emergency Response Time, Average Job Value, Revenue per Technician, Gross Margin, Accounts Receivable Days, Customer Satisfaction (CSAT), Net Promoter Score (NPS), Quote-to-Job Conversion, Service Plan Sign-ups and Technician Utilization.Plumbing Business KPI Dashboard in Google Sheets
• Five groups – Operations (5 KPIs), Financial (4), Customer Experience (2), Sales & Growth (2) and Workforce (1).Plumbing Business KPI Dashboard in Google Sheets
• One month picker for the whole file. Change it on the KPI Dashboard tab and the scorecard, the analysis page and every status colour follow. There is no refresh step and no query to run.Plumbing Business KPI Dashboard in Google Sheets
• MTD and YTD together. Each KPI row carries Actual, Target, Achievement %, Status, Prior Yr and vs PY for the month, then the same six for the year to date.
• Direction-aware achievement. Every KPI is typed UTB (upper the better) or LTB (lower the better). Achievement is Actual / Target for UTB and Target / Actual for LTB, so beating a cost or cycle-time target scores above 100% rather than below it. Callback / Rework Rate and Accounts Receivable Days are LTB in the shipped file; get them down and the light goes green.Plumbing Business KPI Dashboard in Google Sheets
• Editable thresholds. On Target from 100%, At Risk 95-99%, Missed under 95% – written into the Status formulas on the KPI Dashboard tab, not buried in conditional formatting.Plumbing Business KPI Dashboard in Google Sheets
• The KPI list is the master list. Add, rename or delete rows on KPI Definition and every other sheet follows automatically. No formula edits anywhere.Plumbing Business KPI Dashboard in Google Sheets
• Owner, priority and frequency per KPI – so a review meeting names a person, not just a number.

Dashboard Pages Explained

Home

A navigation page with three link groups – dashboard pages, the input sheets you edit, and reference – plus a three-step “get started” strip and three summary cards: 14 KPIs, MTD + YTD, 100% formula-driven.Plumbing Business KPI Dashboard in Google Sheets

KPI Dashboard

The scorecard. Seven header cards – Total KPIs Tracked, On Target (YTD), At Risk (YTD), Missed (YTD), Improving vs PY (MTD), Avg Achievement (MTD), Avg Achievement (YTD) – then one row per KPI with its number, group, name, unit and type, followed by the Month-to-Date block and the Year-to-Date block. A footnote spells out the UTB/LTB rule and the three thresholds, so nobody has to guess why a 90.0% score is red.Plumbing Business KPI Dashboard in Google Sheets

KPI Trend

Select one KPI from the yellow dropdown. The page shows its group, unit, type, owner, priority, frequency, formula and definition, then twelve rows – Jan-25 through Dec-25 – each with MTD actual, target, prior year, achievement and status, the same five for YTD, and two vs-prior-year columns. Two charts follow: MTD Trend for Jobs Completed, monthly actual bars against target and prior-year lines, and YTD Trend for Jobs Completed, the cumulative version. Both titles change with the KPI you select.

KPI Analysis

Three blocks. Performance by KPI Group counts KPIs, On Target, At Risk and Missed per group and averages achievement MTD and YTD – in the sample, Operations averages 99.7% YTD and Financial 96.0%. Top 5 and Bottom 5 Performing KPIs (YTD) rank every KPI with its group and status. A bar chart plots Average YTD Achievement by KPI Group. A How to Read This Page box explains that a lower-is-better KPI beating its target ranks near the top, and where to change the thresholds.Plumbing Business KPI Dashboard in Google Sheets

KPI Input – Actual, Target and PY

Three identical yellow grids: this year’s actual, this year’s target, and last year’s result. KPI rows down the side, Jan through Dec across the top, MTD and YTD columns for each month. Cell E3 on the Actual sheet holds the first month of the reporting year – change it and the entire workbook re-bases, so an April-to-March or July-to-June year works without touching a formula.

KPI Definition

The master list: KPI Number, Group, Name, Unit, Formula, Definition, Type, Owner, Priority and Frequency. Formulas are written in plain English – First-Time Fix Rate is “Jobs Resolved on First Visit / Total Jobs x 100”; Technician Utilization is “Billable Hours / Available Hours x 100”. Owners run from Service Manager and Dispatch Lead through to Finance Manager and Sales Lead. Every KPI here is Monthly.

A Read Me tab explains the wiring and a Get More Templates tab links to the rest of the range.

Plumbing KPI Dashboard vs. Excel vs. Paid Field-Service Software – Feature Comparison

Who Should Use This Template

It fits an owner or operations manager of a plumbing company with roughly 2-40 technicians who already has the monthly figures somewhere – a job book, an invoicing app, an accounting package – and wants one page that says which of fourteen numbers went the wrong way. If you run a monthly review and currently rebuild the same slide by hand, this is the file.

It does not fit you if you expect the sheet to pull data automatically; it will not. It does not fit job-by-job tracking – there is no work-order list, no customer table and no per-job record anywhere in it. It does not fit daily or weekly management, because every KPI is defined as Monthly. And if you have never set a target for any of these fourteen measures, budget an evening for that before the traffic lights mean anything at all.

Real-World Use Cases

An 11-van residential plumbing firm

The owner types eleven figures on the first Monday of the month and opens KPI Analysis. In the sample data the Financial group averages 96.0% YTD against Operations at 99.7%, and Accounts Receivable Days sits at the very bottom of the Bottom 5 at 90.3%. That points at collections, not at technicians – and it takes about ninety seconds to see.

A commercial plumbing contractor

The operations manager watches two numbers: First-Time Fix Rate and Callback / Rework Rate. Because Callback / Rework Rate is typed LTB, a move from 6.06 to 6.20 drops achievement to 90.0% and turns the light red – the correct direction of alarm for a lower-is-better measure. The KPI Trend page for that single KPI is what she brings to supervisor one-to-ones.

A two-partner emergency call-out business

They deleted eight of the fourteen KPIs from the KPI Definition tab and kept six. Emergency Response Time and On-Time Arrival Rate are the two they quote to commercial clients, and the twelve-month chart is what they show a landlord who asks how fast they really turn up.

Advantages of the Plumbing Business KPI Dashboard in Google Sheets

• Nothing to install or authorise. Plain spreadsheet formulas and built-in Google Sheets charts. No add-on, no Apps Script, no permission prompt, no third-party account.
• The KPI list is data, not code. Most KPI templates hard-wire their metrics. Here you edit one tab and every downstream sheet follows, which means the file survives your business changing shape.
• Lower-is-better KPIs are handled correctly. This is where a lot of home-made scorecards quietly go wrong – a reduced callback rate showing as underperformance. The Type column fixes it.
• MTD and YTD in one view. A bad month inside a good year and a good month inside a bad year look different at a glance, which is the point.
• Shareable by link, and free to run. A five-person management team costs the same as one person: nothing beyond the one-off price.
• Any reporting year. One cell sets the first month, so a non-calendar financial year needs no rebuild.

Opportunities for Improvement

Being straight about the limits is more useful than a feature list:

• Manual data entry. Fourteen KPIs times three sheets times twelve months is real typing. There is no import, no connector and no API.
• Monthly only. Every KPI carries Frequency = Monthly. A weekly cadence would mean rebuilding the input grids.
• No drill-down below the KPI. You can see that Callback / Rework Rate missed; you cannot see which jobs caused it, because job-level data is not in the file.
• KPI Trend shows one KPI at a time. There is no side-by-side comparison of two KPIs on one chart.
• No benchmarks. The file ships no industry comparison data. Every status colour reflects targets you set yourself.
• Not a compliance or safety record. It does not track or verify licensing, permits, backflow-prevention certification, apprenticeship hours or plumbing code, and it ships no safety KPI. If you add one – a recordable incident rate, say – it is a number you typed, with no OSHA or regulatory calculation behind it, and it evidences nothing on its own. It is also not accounting or invoicing software: Gross Margin and Accounts Receivable Days are figures you work out elsewhere and type in. It does no dispatching and no scheduling.
• Sample figures are invented. The September 2025 data is demonstration data, so every page shows its behaviour before you clear it.

Best Practices

1. Enter prior year first. Without KPI Input – PY the vs-PY columns and half of each trend chart are empty, and the header card “Improving vs PY” is meaningless.
2. Set targets before you set colours. A traffic light against a target you invented on the spot is decoration. Use last year’s actual plus a defensible improvement.
3. Trim the KPI list. Fourteen is a starting point, not a requirement. Six KPIs that get discussed beat fourteen that get skimmed.
4. Check the Type column when you add a KPI. Getting UTB/LTB wrong inverts the meaning of the whole row – the single most common way to break a scorecard.
5. Read YTD before MTD. One month is noise. The Bottom 5 list ranks on YTD achievement for exactly this reason.
6. Protect the calculated sheets. Only the yellow cells on the three input sheets should be editable. Google’s guide to protecting sheets and ranges covers how.
7. Name an owner and use it. The Owner column exists so that a red light has an address.

Explore Relevant Templates

• HVAC Contractor KPI Dashboard in Google Sheets – the same dashboard structure for an HVAC service business.
• Plumbing Business KPI Scorecard in Google Sheets – the card-and-RAG-light sibling with a comparison switch and a single monthly data sheet.
• Plumbing Business KPI Scorecard in Excel – the Excel edition of that scorecard.
• Plumbing Contractor Dashboard in Google Sheets – analytical dashboard over job-level data with slicers.
• Plumbing Maintenance Checklist in Google Sheets – the task-level companion.
• Every Google Sheets KPI dashboard in the range.

The same dashboard is also built natively for Microsoft Excel and Power BI – same fourteen KPIs, same five groups.

Frequently Asked Questions

Is this the same as the Plumbing Business KPI Scorecard?

No. This is the KPI Dashboard family – a month-picker scorecard with MTD and YTD side by side, three input sheets, a per-KPI trend page and a group analysis page. The KPI Scorecard is a different template: KPI cards with RAG lights and a comparison-switch dropdown over one monthly data sheet. Same industry, different structure.

Is it the same as the Plumbing Contractor Dashboard?

No. That one is an analytical dashboard built over a job-level data table with slicers and pivot-style charts. This file holds no job-level data at all – you enter fourteen monthly totals.

Do I need a paid Google Workspace account?

No. A free personal Google account is enough. Open the PDF in your download, click the copy link, and Google creates your own editable copy in your Drive.

Can I add or remove KPIs?

Yes, and it is designed for that. Edit the KPI Definition tab and the scorecard, trend page and analysis page all follow. Just set the Type column correctly for each new KPI.

Can I change the On Target / At Risk / Missed thresholds?

Yes. They live in the Status formulas on the KPI Dashboard tab – 100% and above, 95-99%, and below 95% as shipped.

Does it connect to my job-management or invoicing software?

No. There is no connector or import. You type the monthly totals, which is also why it needs no add-on and no authorisation prompt.

Does it work if my financial year does not start in January?

Yes. Cell E3 on KPI Input – Actual sets the first month of the reporting year and the whole workbook re-bases from it.

About the Author

Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Conclusion

The Plumbing Business KPI Dashboard in Google Sheets does one job well: it turns a month of plumbing figures into a fourteen-line scorecard with targets, prior-year comparison and traffic lights, with a trend page and a group analysis sitting behind it. It will not dispatch a van, raise an invoice or fetch a single number for you, and it tracks nothing about licences, permits or code. What it will do is make the monthly review a fifteen-minute routine instead of an afternoon of spreadsheet archaeology.

If you would rather have the KPI-card layout with RAG lights and a comparison switch, take the Plumbing Business KPI Scorecard in Google Sheets instead. Otherwise, get the Plumbing Business KPI Dashboard in Google Sheets and make your own copy today.

For more Google Sheets walkthroughs, subscribe at youtube.com/@NeoTechNavigators.