Swimming Pool Service KPI Scorecard in Google Sheets

The Swimming Pool Service KPI Scorecard in Google Sheets puts ten pool-service numbers on one screen: pick a month at the top and every KPI shows its actual, its target, the gap in units and in percent, an up or down arrow, a red / amber / green traffic light and a twelve-month mini bar strip. In the December sample loaded in the file, four KPIs sit green, three amber and three red. It is built on a Scorecard page, a KPI Trend page, a KPI definitions page and a 120-row monthly data page, and everything except that data page is formula-driven, so replacing the sample figures is the only setup step. This is the KPI Scorecard line – a month-picker board – not the analytical dashboard family and not the KPI Dashboard family. One-time price, instant download, no subscription and nothing to install.Swimming Pool Service KPI Scorecard in Google Sheets

Key Features of the Swimming Pool Service KPI Scorecard in Google Sheets

• Ten pool-service KPIs in five groups – Route & Service Delivery (2), Water Chemistry & Quality (2), Equipment Repair (2), Customer Retention & Satisfaction (2) and Financial Performance (2).
• Three header pickers drive the whole page – a month cell (Dec in the sample), an MTD / YTD basis cell and a Target / PY comparison cell. Change any one and all ten cards, lights, arrows and change figures recalculate.
• MTD and YTD in the same file – every KPI carries a month-to-date and a year-to-date actual, target and prior-year figure, and the header cell switches which pair the cards read.Swimming Pool Service KPI Scorecard in Google Sheets
• Compare against target or against last year – the Vs. cell flips every card from “Target Value” to “PY Value” without touching a formula.
• Red / amber / green traffic lights – a coloured dot on each card, scored from that KPI’s own variance against target using the RAG band table on the Color Settings tab (upper-is-better: at or below 0% red, up to 10% amber, above 10% green; lower-is-better mirrored).
• Direction-aware scoring – seven KPIs are marked UTB (upper is better) and three LTB (lower is better), so Algae Remediation Callback Rate, Average Repair Turnaround Time and Chemical Cost per Pool Visit score correctly when they fall rather than rise.
• Change in units and in percent – each card shows the raw gap to target (for example +13.6) and the same gap as a percentage (+16.3%), with an up or down arrow.
• Twelve-month bar strip on every card – one small bar per month across the year, with the highest month picked out in dark green and the lowest marked in red, so a card shows shape as well as level.
• A KPI Trend page with its own picker – choose any KPI from a dropdown and the page fills in its group, unit, UTB/LTB type, formula and definition, then draws two clustered column charts: Actual vs Target vs PY on an MTD basis and the same on a YTD basis, twelve months across.
• A written formula and definition for all ten KPIs – one table row per metric, so an office manager and a route technician read the same number the same way.
• Editable monthly data table – 120 rows, one block of twelve months per KPI, with MTD Actual / Target / PY and YTD Actual / Target / PY side by side. This is the only sheet you type in.

What is Inside the Swimming Pool Service KPI Scorecard in Google Sheets

The download is a PDF that carries a “Make a copy” link. Click it and Google Drive creates your own editable copy of the sheet in your own Drive – there is nothing to install and no add-on to authorise.

Page 1 – Scorecard. The header holds the title, the Select Month cell, the MTD / YTD cell and the Vs. Target cell. Below it, ten cards in two rows of five. In the December sample: Scheduled Service Completion Rate 97.1 against an 83.5 target, Service Visit On-Time Arrival Rate 91.8 against 88.1, Water Chemistry Pass Rate 94.9 against 81.6, Algae Remediation Callback Rate 3.3 against 2.8, Pump & Filter Repair First-Time Fix Rate 82.4 against 70.9, Average Repair Turnaround Time 4.3 days against 4.1, Customer Retention Rate 94.1 against 90.3, Customer Satisfaction Score 4.5 against 3.9, Chemical Cost per Pool Visit 9.6 against 8.3, and Average Monthly Revenue per Pool Account 143.4 against 152.0.

Page 2 – KPI Trend. A Select KPI dropdown at the top left, then read-only fields for KPI Group, Unit and Type, and wider fields for Formula and Definition. With Scheduled Service Completion Rate selected the page reports the Route & Service Delivery group, a (%) unit, UTB type and the formula Pool Visits Completed / Pool Visits Scheduled x 100. Two clustered column charts sit underneath – Actual vs Target vs PY (MTD) and Actual vs Target vs PY (YTD) – each with Jan to Dec on the axis, Actual and PY bars and a Target line.

Page 3 – KPI Definition. One table, ten rows, with columns for #, KPI Group, KPI Name, Unit, Formula, Definition and Type. Units are (%) for seven metrics, (Days) for repair turnaround, (Score 1-5) for satisfaction and ($) for the two money metrics, so rate metrics and money metrics stay visibly separate. The Type column carries the UTB / LTB flag that drives the scoring direction.

Page 4 – Input Data. One block per KPI headed KPI-1 to KPI-10, twelve rows each, with MTD Actual / Target / PY and YTD Actual / Target / PY in colour-coded column groups. 120 rows in total, and the only page you type into.

Behind those four: a Color Settings tab holding the RAG variance bands you can retune, and two calculation tabs (Support and Trend_Support) that feed the cards and the charts. There is also a Read Me tab, which ships empty in this build.

Swimming Pool Service KPI Scorecard vs. Excel vs. Paid Pool Service Software – Where This Fits

The honest summary: if you need routing, dispatch, chemical logging per stop and invoicing tied together, buy the software. If what you actually want is ten numbers reviewed once a month against target, this sheet does that for less than the price of a case of chlorine tablets.Swimming Pool Service KPI Scorecard in Google Sheets

How This Differs From the Excel Edition

There is a companion listing, the Swimming Pool Service KPI Scorecard in Excel. It is the same idea and the same review habit, but it is not the same file with a different extension – the two editions ship different KPI sets, and it is worth knowing that before you choose.

• Both ship ten KPIs in five groups, seven upper-is-better and three lower-is-better, a month picker, traffic lights, MTD and YTD, and a per-KPI trend view.Swimming Pool Service KPI Scorecard in Google Sheets
• Not one KPI name is shared. The Google Sheets edition runs Scheduled Service Completion Rate, Service Visit On-Time Arrival Rate, Water Chemistry Pass Rate, Algae Remediation Callback Rate, Pump & Filter Repair First-Time Fix Rate, Average Repair Turnaround Time, Customer Retention Rate, Customer Satisfaction Score, Chemical Cost per Pool Visit and Average Monthly Revenue per Pool Account. The Excel edition runs Pools Serviced, Route Density, Avg Response Time, First-Visit Fix Rate, Water Balance Compliance, Callback Rate, Technician Utilisation, Revenue per Pool, Chemical Cost per Pool and Customer Retention.
• The group names differ too. This edition groups by Route & Service Delivery, Water Chemistry & Quality, Equipment Repair, Customer Retention & Satisfaction and Financial Performance. The Excel edition groups by Operations, Service Quality, Workforce, Financial and Customer.Swimming Pool Service KPI Scorecard in Google Sheets
• Different emphasis. The Excel edition carries volume and workforce metrics this one does not – Pools Serviced, Route Density and Technician Utilisation – plus a Water Balance Compliance percentage. This edition instead carries scheduling and repair-desk metrics the Excel one does not – completion rate, on-time arrival, water chemistry pass rate, repair turnaround days and a 1-5 customer satisfaction score.Swimming Pool Service KPI Scorecard in Google Sheets
• Different shape. This edition is eight Google Sheets tabs with ten KPI card slots. The Excel edition is an eleven-sheet workbook with twenty KPI slots and works offline.Swimming Pool Service KPI Scorecard in Google Sheets

Neither edition has a safety or incident KPI. Buy the one that matches how you already talk about the business, or both if you want the widest coverage.

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

A good fit for: owner-operators and small-to-mid pool service and maintenance companies running weekly or fortnightly routes; office managers who assemble a monthly summary by hand every month; operations leads who want scheduling, water quality, repair-desk and money numbers on one page instead of four; and anyone who wants a simple board to run the first-Monday numbers meeting from.

Not a good fit if: you need live data pulled from your route, chemical-logging or accounting software – this sheet does not connect to anything and does not import; you want alerts, reminders or emails when a KPI turns red – it has none; you need per-technician, per-route or per-pool drilldown – it reports at company level by month; you need a water-quality, chemical-dosing or testing record for a health department or an inspector – the Water Chemistry Pass Rate here is a summary percentage you type in yourself and is not a test log, a compliance record or a certification of any kind; or you track more than ten KPIs and are unwilling to edit the sheet.

How to Use the Swimming Pool Service KPI Scorecard in Google Sheets

1. Open the PDF in your download and click the “Make a copy” link. Google Drive creates your own editable copy. A free Google account is enough.
2. Go to the Input Data page and replace the sample MTD and YTD figures with your own, one block per KPI, twelve months each.
3. Set your targets in the Target columns. They drive both the change figures and the traffic lights, so a soft target produces a green board that means nothing.
4. Rename any KPI you do not use on the KPI Definition page – change the KPI name, group, unit, formula text, definition and, importantly, the UTB / LTB type so the scoring direction follows the metric. Keep the row structure and the scorecard follows.
5. Keep the month labels consistent. The Scorecard’s month picker matches a month by its exact text against the Month column on the Input Data page, so the two must use the same spelling (the data page uses Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec). If a card ever goes blank after switching months, that mismatch is the reason.
6. Set the three header cells on the Scorecard page: the month you are reviewing, MTD or YTD, and whether you are comparing against Target or PY.
7. Use the KPI Trend page in the meeting – pick the one metric that turned red and show its twelve-month MTD and YTD charts against target and last year.
8. Retune the bands if you want on the Color Settings tab, where the amber and green variance thresholds live.
9. Share the sheet with your office manager and lead technician using Google Sheets’ own sharing, view-only if you only want them reading it.

Real-World Use Cases

Nina runs 340 residential accounts with four routes. Her recurring argument was whether the crew was actually finishing the week. Scheduled Service Completion Rate at 97.1 against an 83.5 target settled it – the visits were getting done. What was red on the same board was Average Monthly Revenue per Pool Account, 143.4 against a 152.0 target and down 5.7% on the arrow, which pointed her at pricing rather than at the crew.

Marcos runs the repair desk. Pump & Filter Repair First-Time Fix Rate sat green at 82.4 against 70.9, but Average Repair Turnaround Time was amber at 4.3 days against a 4.1 target and rising. Because the two live next to each other in the Equipment Repair group, the read was obvious: the fixes were right first time, the wait to get there was the problem, so he changed how repair jobs were slotted into the route rather than retraining anyone.

Priya reviews the money side monthly. Chemical Cost per Pool Visit came in at 9.6 against an 8.3 target – red, up 15.7% – in the same month the Water Chemistry Pass Rate was green at 94.9. She used the KPI Trend page to show the twelve-month line rather than one bad month, and the conversation moved from “someone is over-dosing” to a supplier price review.

Frequently Asked Questions

Is this the KPI Scorecard, the KPI Dashboard or the analytical Dashboard?

This is the KPI Scorecard line. It is a month-picker board: ten KPI cards with traffic lights, a KPI Trend page, a KPI definitions page and a typed monthly data page. It is not the analytical Dashboard family, which is chart-and-slicer driven, and it is not the KPI Dashboard family, which is a different template with its own layout. The three lines carry near-identical names in the shop, so check the title before you buy – this one ends in KPI Scorecard in Google Sheets.

Does it connect to my route, chemical-logging or accounting software?

No. There are no integrations, no imports, no API and no sync. You type or paste the monthly values into the Input Data page. That is the deliberate trade-off that keeps it a 13.99 sheet rather than a monthly subscription.

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

No. There are no alerts, notifications or scheduled reminders of any kind. The traffic lights are visual only, on the sheet, while you are looking at it.

Is the Water Chemistry Pass Rate a compliance or testing record?

No, and please do not use it as one. It is a management summary percentage that you calculate and type in yourself. It is not a chemical log, not a test record, not evidence for a health department or inspector, and this template gives no dosing, testing, water-safety or public-health guidance whatsoever. Keep whatever testing and record-keeping your local rules require exactly as you keep it today.

Can I change the ten KPIs to my own?

Yes. Every KPI name, group, unit, formula text, definition and UTB / LTB type is an editable cell on the KPI Definition page, and the Input Data page has a matching twelve-month block per KPI. The Scorecard page has ten card slots, so ten is the number it shows.

Does it handle both MTD and YTD?

Yes. The Input Data page stores both bases for every KPI and every month – actual, target and prior year for each – and the header cell on the Scorecard switches which pair the cards display. The KPI Trend page charts both bases at once.

Do I need a paid Google Workspace account?

No. A free Google account is enough. The PDF’s copy link creates the sheet in your own Drive and it stays yours, with no expiry and no seat count.

Is there an Excel version?

Yes – the Swimming Pool Service KPI Scorecard in Excel. Read the “How This Differs From the Excel Edition” section above first: the two editions ship completely different KPI names and groups, so they are companions rather than duplicates.

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

• Swimming Pool Service KPI Scorecard in Excel – the companion edition, with its own ten KPIs and twenty KPI slots, for teams that live in Excel.
• Pool Maintenance Checklist in Google Sheets – the per-visit list that feeds the numbers this scorecard reports.
• Pool Maintenance Checklist in Excel – the same checklist on the Excel side.
• Plumbing Business KPI Scorecard in Google Sheets – the closest service-trade neighbour, same board, different trade.
• HVAC Contractor KPI Scorecard in Google Sheets and Roofing Contractor KPI Scorecard in Google Sheets – useful if you run more than one service line.
• Browse the whole Google Sheets catalogue or the KPI Dashboard category for more scorecards.

Get the Swimming Pool Service KPI Scorecard in Google Sheets today – one-time payment, instant download, no subscription. Open the PDF, click the copy link, and you have ten pool-service KPIs on one screen in under five minutes. A full walkthrough is on the NeoTechNavigators blog.

Watch the step-by-step video Demo:

Last updated: 2 September 2026.