Windshield Repair and Replacement KPI Scorecard in Google Sheets

The Windshield Repair and Replacement KPI Scorecard in Google Sheets tracks 10 windshield repair KPIs in three groups (Service Mix, ADAS & Install Quality and Claims & Revenue) on one page of traffic-light cards, each with a 12-month mini chart. A KPI Trend page charts any KPI against Target and prior year (PY), and the sample file ships with 120 monthly records.

This is the KPI scorecard edition: a month-picker scorecard plus a KPI Trend page, a different product from our analytical Google Sheets dashboards and the KPI Dashboard line. You buy it once and own the file.

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

🔑 Key Features of the Windshield Repair and Replacement KPI Scorecard

🎯 Three selectors on one page. Month (Jan to Dec), MTD or YTD, and Target or PY. Every card recalculates from the Input Data tab with ordinary formulas, with no scripts, macros or add-ons.

🚦 Direction-aware traffic lights. Seven KPIs are upper-the-better (UTB) and three are lower-the-better (LTB): Leak and Wind-Noise Comebacks, Glass Breakage During Install and Insurance Claim Turnaround. For UTB, a variance at or below 0% is red, up to 10% amber and above 10% green; LTB uses the mirror rule.

📈 Full detail on every card. Value, Target or PY, change, change %, an arrow and a 12-month mini column chart with the selected month highlighted in green.

📊 KPI Trend page. Pick a KPI to see its group, unit, type, formula, definition and two charts: Actual vs Target vs PY (MTD) by Month and Actual vs Target vs PY (YTD) by Month.

✏️ Simple monthly data entry. Input Data holds MTD and YTD Actual, Target and PY for each month of each KPI. YTD is typed, not calculated.

📦 What’s Inside the Windshield Repair and Replacement KPI Scorecard in Google Sheets

• 🔧 Service Mix: Chip Repair Share (%), Mobile Service Share (%), Same-Day Replacement Rate (%)
• 🚗 ADAS & Install Quality: ADAS Recalibration Completion (%), Safe Drive-Away Compliance (%), Leak and Wind-Noise Comebacks (%, LTB), Glass Breakage During Install (%, LTB)
• 💰 Claims & Revenue: Insurance Claim Turnaround (hours, LTB), OEM Glass Share (%), Average Replacement Ticket ($)

Every KPI is a figure you type in each month. The scorecard does not measure, perform or verify any repair, camera recalibration, adhesive cure or insurance claim; it only colours the numbers you enter against your own targets.

Page 1: Scorecard

Ten cards in two rows of five. With December, MTD and Target selected, the sample shows 4 green, 3 amber and 3 red lights: Chip Repair Share reads 37.1 against 31.9 (green, up 16.3%), Insurance Claim Turnaround 5.1 hours against 4.9 (amber, because lower is better) and OEM Glass Share 33.1 against 35.1 (red, down 5.7%).

Page 2: KPI Trend

Select KPI, KPI Group, Unit, Type, Formula and Definition boxes sit above the MTD and YTD charts. The sample shows Chip Repair Share across all 12 months.

Page 3: KPI Definition

All 10 KPIs with KPI Group, Unit, Formula, Definition and Type, for example Average Replacement Ticket = Windshield Replacement Revenue / Replacements Invoiced.

Page 4: Input Data

Ten blocks, KPI-1 to KPI-10, each with 12 monthly rows. This is the only sheet you type into.

The file also has a Read Me tab with setup notes, plus Color Settings, Support and Trend_Support tabs.

⚠️ Known issues in this build: the Month drop-down lists “June” and “July” while Input Data uses “Jun” and “Jul”, so those two months show blank or zero cards until you edit the drop-down (step 2 below). Color Settings is not linked to the lights, even though the Read Me says the thresholds live there; the bands the lights actually use are in the Support tab (Z4:AE6).

📊 Google Sheets Scorecard vs. Excel vs. Auto Glass Shop Software

For an auto glass shop that wants a clear monthly KPI review without paying for a shop management platform, this Google Sheets KPI scorecard sits in the sweet spot.

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

✅ Built for: owners and operations managers of windshield repair and auto glass shops who hold a monthly review, and office or mobile-fleet managers who want service mix, comeback and ticket figures on one shared page.

❌ Not for: shops that need work orders, glass ordering, quoting, invoicing or insurance billing, or several years of history in one file. It is not a calibration record, a safety or quality-assurance record, or an insurance claims system, and it makes no claim about calibration, safety or regulatory standards; it only reports the percentages and hours you enter.

⚙️ How to Use the Scorecard

1. Open the PDF in your download, click the Google Sheets link and choose Make a copy.
2. On the Scorecard tab select cell N1, open Data > Data validation and change “June” and “July” to “Jun” and “Jul”.
3. Edit the KPI Definition sheet to match your shop, keeping KPI names identical in Input Data.
4. Replace the sample MTD and YTD Actual, Target and PY figures with your own.
5. Pick a month, MTD or YTD and Target or PY, then open KPI Trend for any KPI’s history.

💼 Real-World Use Cases

Carlos runs a three-van mobile windshield service. At month end he flips between Target and PY to check Mobile Service Share and Chip Repair Share, then shares the link with his lead technician so both see the same lights.

Priya manages the office of a busy auto glass shop. When Insurance Claim Turnaround turns amber she opens KPI Trend to see which months slipped and compares them with Average Replacement Ticket.

❓ Frequently Asked Questions

What windshield repair KPIs does it track?

Ten: Chip Repair Share, Mobile Service Share, Same-Day Replacement Rate, ADAS Recalibration Completion, Safe Drive-Away Compliance, Leak and Wind-Noise Comebacks, Glass Breakage During Install, Insurance Claim Turnaround, OEM Glass Share and Average Replacement Ticket, each with a unit, formula and direction.

Is this the KPI Scorecard or the KPI Dashboard?

The Google Sheets KPI Scorecard: 10 traffic-light cards, a month picker and a KPI Trend page. KPI Dashboards are separate products with different layouts.

How long does setup take?

A minute to copy, a minute for the June/July fix, then as long as it takes to enter 12 months of figures for 10 KPIs.

Can I change the traffic-light thresholds?

Yes, in the Support tab RAG table (Z4:AE6). The Color Settings tab is not linked in this build.

Does it check ADAS calibration or safe drive-away times?

No. Those two KPIs are simply percentages you type in from your own records. The template does not perform, verify or certify any calibration, cure time or installation, and the supplied figures are fictional sample data.

👤 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 (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

🪟 For glazing contractors, see the Glass Installation KPI Scorecard in Google Sheets and the Glass Installation KPI Dashboard in Google Sheets.

🚗 Same scorecard layout for other automotive trades: Auto Repair Shop KPI Scorecard in Google Sheets and Auto Body Shop KPI Scorecard in Google Sheets.

🧰 For deeper workshop analysis, try the Auto Repair Dashboard in Google Sheets or the Fleet Maintenance Calendar in Google Sheets.

📂 Browse every Google Sheets KPI template.

📘 Google’s guide explains how to edit a drop-down list in Google Sheets.

📖 Click here to read the Detailed Blog Post

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

👉 YouTube.com/@NextGenTemplates

📅 Last updated: September 2026