Plumbing Business KPI Scorecard in Google Sheets

The Plumbing Business KPI Scorecard in Google Sheets puts 10 plumbing KPIs on one screen, scores each one against that month’s target with a green, amber or red light, and lets you flip the whole page from January to December with a single month picker. The December sample month shown in the screenshots reads 4 green, 3 amber and 3 red – the point of a scorecard is that you can see that split in two seconds instead of reading a report. Built and tested before release, delivered as a Google Sheets copy you own outright: no subscription, no add-on, no seat licence.

This is the scorecard line – a month-picker, target-versus-actual sheet with a KPI Trend page and a KPI Analysis page. It is deliberately not an analytics dashboard. If you want charts that slice jobs by technician, area and job type, the Plumbing Contractor Dashboard in Google Sheets is the template for that, and the two sit side by side happily.

Key Features of the Plumbing Business KPI Scorecard in Google Sheets

• 10 plumbing KPIs in 4 groups – Job Execution, Scheduling, Revenue and Customer, so field performance and money sit on the same page.
• One-click month picker – the header carries a Select Month control; changing it re-scores all 10 cards, both trend charts and every arrow.
• Traffic-light scoring – each card carries a green, amber or red dot against that month’s target value.
• Target, change and % move on every card – December’s First-Time Fix Rate reads 79.5 against a 68.4 target: +11.1, or +16.2%, with a green up arrow.
• 12-month mini bar chart inside each card – the year’s shape at a glance, with the selected month highlighted.
• UTB / LTB direction handling – lower-is-better metrics such as Average Job Completion Time, Emergency Callout Response Time, Debtor Days and Complaint Rate score correctly instead of being punished for falling.
• KPI Trend page – pick any KPI and read Actual vs Target vs prior year, MTD and YTD, on two 12-month charts.
• Every KPI documented – a KPI Definition sheet holds the group, unit, formula, plain-English definition and direction for all 10.
• Editable figures – the KPI Analysis sheet holds the monthly MTD and YTD numbers; type over the samples and the scorecard recalculates.
• Plain Google Sheets – opens in any browser, shares by link, works on a free Google account.

What’s Inside the Plumbing Business KPI Scorecard in Google Sheets

1. KPI Scorecard. The landing page. A dark header carries the template name, the Select Month picker (Dec in the sample) and the MTD Vs. Target labels. Below it sit 10 cards in two rows of five: First-Time Fix Rate, Average Job Completion Time, Jobs Completed per Technician, On-Time Arrival Rate, Emergency Callout Response Time, Average Invoice Value, Quote-to-Job Conversion Rate, Debtor Days, Customer Satisfaction Score and Complaint Rate. Each card shows the traffic light, the actual value, the target value, the absolute change, a direction arrow with the percentage move, and a 12-bar mini chart of the year.

2. KPI Trend. Choose a KPI from the Select KPI control and the page fills in its KPI Group, Unit, Type, Formula and Definition, then draws two charts: Actual vs Target vs PY (MTD) and Actual vs Target vs PY (YTD), January through December. Actual and prior-year appear as columns, target as a line, so a metric that is beating target but sliding against last year is obvious.

3. KPI Definition. A single reference table – number, KPI Group, KPI Name, Unit, Formula, Definition and Type – for all 10 KPIs. First-Time Fix Rate is defined as Jobs Fixed on First Visit / Total Jobs x 100, “share of callouts resolved without a return visit”, type UTB. Debtor Days is Accounts Receivable / Revenue x Days in Period, type LTB. Nobody has to guess what a number means in the Monday meeting.

4. KPI Analysis. The figures themselves, one block per KPI (KPI-1 to KPI-10). Every block is a 12-row month table with MTD Actual, Target and PY alongside YTD Actual, Target and PY. This is where you replace the sample year with your own.

Plumbing Business KPI Scorecard in Google Sheets vs. Excel vs. Paid Field-Service Software – Where This Fits

The honest summary: this is a reporting sheet, not an operations system. It does not dispatch engineers, raise invoices or connect to your accounting package. It takes the numbers those systems already produce and tells you, in one screen, whether the month is going well.

Who This Template Is For – and Who It’s Not For

A good fit if you run a plumbing firm with roughly 2-40 engineers, you already pull job counts, response times and invoice values out of a job book or a field-service tool, and you want a monthly management view without paying per seat. It also suits a plumbing division inside a larger facilities or property-maintenance business that has to report upward every month.

Not a good fit if you need live job dispatch, engineer location tracking, automatic invoice sync or push notifications – none of that is here, and no spreadsheet does it well. It is also the wrong shape if you want to slice a job-level dataset by technician, area and job type; that is what the Plumbing Contractor Dashboard in Google Sheets does. And if your team lives in Excel rather than Google Workspace, buy the Plumbing Business KPI Scorecard in Excel instead – same structure, native workbook.

How to Use the Plumbing Business KPI Scorecard in Google Sheets

1. Open the PDF in your download and click the Make a copy link. The copy lands in your own Google Drive and is yours to edit.
2. Read the KPI Definition sheet first. Check the 10 formulas match how your business actually measures things, and note which are UTB (higher is better) and which are LTB.
3. Rename any KPI you do not track. Swap Debtor Days for Callback Rate, for example – change the name, unit, formula text and direction on the definition sheet.
4. Fill the KPI Analysis sheet. Put your 12 months of MTD Actual, Target and prior year into each KPI block. Start with last year if you have it; the prior-year columns are what make the trend page useful.
5. Set realistic targets. A scorecard where everything is green tells you nothing. The sample month deliberately shows three reds.
6. Pick your month on the KPI Scorecard header and review the lights. Take the reds to the KPI Trend page to see whether they are a one-month wobble or a slide.
7. Share the link with your office manager and lead engineers, view-only if you prefer, and repeat on the first working day of each month.

Real-World Use Cases

Dave, owner of a 9-engineer domestic plumbing firm. Dave’s December reads First-Time Fix Rate 79.5 green and Emergency Callout Response Time 2.4 hours green, but On-Time Arrival Rate 85.3 against a 90.4 target is red. The trend page shows arrival rate has been under target most of the year, so the problem is the scheduling window, not December. He widens the promised slots.

Priya, office manager for a commercial plumbing contractor. Her red is Debtor Days at 25.3 against a 21.8 target, +16.1% the wrong way, while Average Invoice Value is up to 340.2. Bigger jobs, slower payers. She uses the two cards together to justify staged invoicing on contracts over a set value.

Sam, operations lead at a property-maintenance group. Sam keeps one copy of this scorecard per trade division and reviews them side by side each month, because the 10 KPIs are stated the same way in every copy. Complaint Rate at 3.7 against a 3.2 target is the one he takes to the divisional meeting.

Frequently Asked Questions

Is this the same as the Plumbing Contractor Dashboard in Google Sheets?

No. This is the KPI scorecard – a month picker, traffic lights against targets, a trend page and a definition sheet. The dashboard is an analytical template that slices job-level data by category. Many customers own both.

Do I need a paid Google Workspace account?

No. A free personal Google account is enough. The download PDF carries a Make a copy link; clicking it creates your own copy in your Drive.

Can I change the KPIs to match my business?

Yes. All 10 are editable – name, group, unit, formula text and UTB/LTB direction all live on the KPI Definition sheet, and the figures sit on the KPI Analysis sheet.

Does it connect to my accounting or field-service software?

No. There is no import, sync or integration. You type or paste your monthly figures in. That is deliberate – it keeps the template working with whatever systems you already run.

Will it email or alert me when a KPI turns red?

No. The traffic lights are visual only; there is no notification or alerting built in.

How many months of history does it hold?

Twelve, plus a prior-year column for each month, on both an MTD and a YTD basis.

Is there an Excel version?

Yes – the Plumbing Business KPI Scorecard in Excel has the same 10 KPIs and the same page structure as a native workbook.

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.

Explore Related Templates

• Plumbing Business KPI Scorecard in Excel – the same scorecard as a native Excel workbook.
• Plumbing Contractor Dashboard in Google Sheets – the analytical companion, job-level slicing and charts.
• Plumbing Contractor Dashboard in Power BI – the same analysis for a Power BI stack.
• Equipment Maintenance Log Tracker in Google Sheets – keep vans, pumps and test gear serviced.
• Plumbing Maintenance Checklist in Google Sheets – a simple job-level checklist for routine visits.

Browse more in Google Sheets KPI Dashboards or the full Google Sheets catalogue.

Ready to see your month in one screen? Add the Plumbing Business KPI Scorecard in Google Sheets to your cart, open the PDF, click Make a copy and put your own numbers in. A walkthrough of the pages is on the blog: Plumbing Business KPI Scorecard in Google Sheets.

Watch the step-by-step video Demo:

Last updated: 23 August 2026.