Water Treatment Services KPI Scorecard in Google Sheets

The Water Treatment Services KPI Scorecard in Google Sheets puts 10 water treatment KPIs from five groups on one page: three for water quality and compliance tracking, two for plant operations, two for service and response, two for customers and contracts, and one financial measure. Every KPI gets a traffic-light card with a 12-month mini chart, the KPI Trend page charts one KPI at a time against Target and prior year, and the sample file carries 120 monthly records.

This is the KPI Scorecard family (month picker, 10 cards, KPI Trend, KPI Definition, Input Data), not the larger KPI Dashboard line and not an analytical dashboard. It is a monthly reporting sheet for owners and operations managers of water treatment service companies, filled in by hand from the numbers your plant logs, service desk and accounts already produce.

🌍 NextGenTemplates builds one-time-purchase Excel, Google Sheets, Power BI and web app templates for small service businesses that would rather not pay per user per month.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Water Treatment Services KPI Scorecard in Google Sheets

🎛️ Three selectors on one page. Pick a month, switch between MTD and YTD, and compare against Target or PY. All 10 cards recalculate from the Input Data sheet with SUMIFS formulas. There are no scripts, add-ons or macros to authorise.

🚦 Direction-aware traffic lights. Eight KPIs are upper-the-better (UTB) and two are lower-the-better (LTB). For a UTB KPI, a result at or below the comparison is red, up to 10% above is amber and more than 10% above is green; LTB KPIs use the mirror rule, so a rising response time or cost turns red.

📇 Complete cards. Each card shows the value, the Target or PY value, the absolute change, the change %, an up or down arrow and a 12-month mini column chart with the selected month highlighted.

📈 KPI Trend page. Choose one KPI to see its group, unit, type, formula and definition, plus two charts of Actual vs Target vs PY by month, one for MTD and one for YTD.

📚 Documented metrics. The KPI Definition sheet lists the unit, formula, definition and UTB/LTB type for every KPI, so the whole team reads each number the same way.

✍️ Plain monthly input. Input Data holds ten blocks of 12 monthly rows with MTD and YTD Actual, Target and PY. YTD figures are typed, not calculated, so enter them from your own records.

The 10 KPIs

• 💧 Water Quality & Compliance: Regulatory Compliance Rate (%), Contaminant Removal Efficiency (%), Water Quality Test Pass Rate (%)
• 🏭 Plant Operations: Plant Uptime (%), Chemical Dosing Accuracy (%)
• 🛠️ Service & Response: Average Service Response Time (hrs, LTB), First-Time Fix Rate (%)
• 🤝 Customers & Contracts: Customer Satisfaction Score (pts), Contract Renewal Rate (%)
• 💵 Financial: Cost per 1000 Gallons Treated ($, LTB)

The quality and compliance KPIs are percentages you type in from your own sample and lab results. The sheet does not test water, store lab reports or show compliance with any drinking-water or discharge regulation.

📦 What’s Inside the Template

Page 1: Scorecard

Ten cards in two rows of five sit under a header with the Month, MTD/YTD and Target/PY selectors. With December, MTD and Target selected, the sample reads 4 green, 3 amber and 3 red: Plant Uptime is 97.9 against an 84.2 target (green, up 16.3%), Contract Renewal Rate is 92.3 against 88.6 (amber, up 4.2%), and Cost per 1000 Gallons Treated is 3.5 against 3.0 (red, up 16.7%, because lower is better).

Page 2: KPI Trend

Select a KPI and the page fills in KPI Group, Unit, Type, Formula and Definition, then plots Actual vs Target vs PY (MTD) by Month and Actual vs Target vs PY (YTD) by Month, with Actual and PY as columns and Target as a line. The sample shows Regulatory Compliance Rate, where every monthly actual sits between about 96 and 99 against a target near 83.

Page 3: KPI Definition

A table of the 10 KPIs with #, KPI Group, KPI Name, Unit, Formula, Definition and Type. For example, Contaminant Removal Efficiency = (Inlet Load – Outlet Load) / Inlet Load x 100, and Cost per 1000 Gallons Treated = Total Treatment Cost / Thousands of Gallons Treated.

Page 4: Input Data

Ten blocks labelled KPI-1 to KPI-10, each with 12 monthly rows and six figures per row: MTD Actual, Target and PY, then YTD Actual, Target and PY. This is the only sheet you update each month.

Behind these pages sit a Read Me tab, a Color Settings tab and two helper tabs, Support and Trend_Support, which do the lookups for the cards and charts.

⚠️ Known issues in the current build, with fixes

We exported and tested the live sheet before listing it. Four issues are present in this copy:

• 🗓️ June and July show blank cards. The month dropdown in Scorecard cell N1 offers “June” and “July”, but Input Data stores “Jun” and “Jul”, so all ten cards go blank for those two months. One-minute fix: select Scorecard cell N1, open Data > Data validation, change June to Jun and July to Jul in the list, save, then pick Jun again.
• 📄 The Read Me tab is empty. Use the How to Use steps below and the PDF guide in your download instead.
• 🎨 Color Settings is not connected. The tab shows a red, amber and green table, but no formula reads it. The live 0% and 10% bands are typed into the Support tab (cells Z4:Z6 for UTB and AD4:AD6 for LTB); change them there if you need different thresholds.
• 🔤 Selector text is hard to read. The Month, MTD/YTD and Target/PY choices in cells N1, Q1 and V1 are black text on the dark maroon header. Fix: select those three cells and set the text colour to white.

The change-colour rules on all ten cards are correct in this build: improvements show green and deteriorations red, including the two lower-the-better KPIs.

📊 Google Sheets Scorecard vs. Excel Workbook vs. Operations Software: Where This Fits

For water treatment service owners who want one monthly view of plant uptime, service response, contract renewals and treatment cost without buying a full operations platform, this scorecard sits in the sweet spot.

👥 Who This Template Is For, and Who It’s Not For

✅ This template is built for:

• Owners of water treatment service companies that run treatment systems and service contracts for commercial, industrial or residential clients
• Operations or service managers who prepare a month-end KPI review
• Consultants and bookkeepers who report performance to water treatment clients

❌ This template is NOT for:

• Teams that need work orders, dispatch, SCADA or sensor feeds, which this sheet does not do
• Anyone who needs a compliance record, lab information system or regulator reporting; every figure is typed in and the sheet certifies nothing
• Anyone looking for an automatic feed from accounting or field service software

⚙️ How to Use the Scorecard

1. Open the PDF guide in your download and click the link to make your own copy in Google Drive.
2. Fix the June and July dropdown in Scorecard cell N1, and set the selector text to white, as described above.
3. On KPI Definition, rename KPIs, units, formulas and UTB/LTB types to match your business.
4. On Input Data, replace the sample MTD and YTD Actual, Target and PY figures for each month.
5. On the Scorecard, choose the month, MTD or YTD, and Target or PY.
6. Open KPI Trend and pick a KPI to review its 12-month pattern before your monthly meeting.

💼 Real-World Use Cases

Elena owns a water treatment service firm with six technicians. At month end she types in service calls, response hours, first-visit fixes and survey scores. Average Service Response Time and First-Time Fix Rate show her when the team is stretched, and the KPI Trend page tells her whether an extra on-call shift actually helped.

Rahul manages operations for a company running treatment units on client sites. He reviews Plant Uptime, Chemical Dosing Accuracy and Cost per 1000 Gallons Treated in the YTD view against PY, so the quarterly review starts with the red cards rather than a stack of separate reports.

Grace is a bookkeeper serving two water treatment contractors. She keeps one copy per client, shares it view-only and walks each owner through Contract Renewal Rate and treatment cost, the two numbers that usually explain next year’s revenue and margin.

❓ Frequently Asked Questions

What KPIs does the water treatment services scorecard track?

The Water Treatment Services KPI Scorecard in Google Sheets tracks 10 KPIs: Regulatory Compliance Rate, Contaminant Removal Efficiency, Water Quality Test Pass Rate, Plant Uptime, Chemical Dosing Accuracy, Average Service Response Time, First-Time Fix Rate, Customer Satisfaction Score, Contract Renewal Rate and Cost per 1000 Gallons Treated.

Is this the KPI Scorecard or the KPI Dashboard?

This listing is the KPI Scorecard: one page of 10 traffic-light cards with a month picker, plus KPI Trend, KPI Definition and Input Data. The KPI Dashboard line is a separate, larger build. Excel editions of a Water Treatment Services KPI Scorecard and KPI Dashboard are being prepared as separate builds.

Does it prove regulatory compliance?

No. Regulatory Compliance Rate and Water Quality Test Pass Rate are simply percentages you type in from your own results. The sheet performs no testing, holds no lab certificates and makes no claim about compliance with drinking-water, discharge or any other regulation.

How long does setup take?

Making the copy takes a minute and the two small fixes another two. Typing twelve months of figures for 10 KPIs is 120 rows, so most owners finish in under an hour from existing reports.

Can I change the red, amber and green thresholds?

Yes, but not from the Color Settings tab, which no formula reads in this build. The live bands are typed into the Support tab: cells Z4:Z6 for upper-the-better KPIs and AD4:AD6 for lower-the-better KPIs, currently 0% and 10%.

Does it use real company data?

No. All figures in the Water Treatment Services KPI Scorecard in Google Sheets are fictional sample data for demonstration. Replace them with your own numbers.

👤 About the Author

Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience, and founder of NextGenTemplates. Tutorials run on YouTube at @PKAnExcelExpert, @NextGenTemplates and @NeoTechNavigators. Every template is built and tested before release, and the known issues above come from that testing.

🔗 Explore Related Templates

💧 Other water-service scorecards in the same family: Swimming Pool Service KPI Scorecard in Google Sheets and Septic Tank Service KPI Scorecard in Google Sheets.

🏭 Working on the utility side instead? See the Water Supply KPI Scorecard in Excel, the Water Utilities KPI Dashboard in Excel and the Sewage Treatment KPI Dashboard in Power BI. These are different builds with their own KPIs, not versions of this scorecard.

📂 Browse every Google Sheets KPI Dashboard and Scorecard template. Need help editing the month list? See Google’s guide to creating dropdown lists in Google Sheets.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

Watch the step-by-step video Demo:

📅 Last updated: September 2026