Most window and door companies can tell you last month’s revenue and almost nothing else. How many in-home quotes actually went out, what share of them closed, how many installs hit the originally scheduled date, and how many of those came back as a warranty callback – that lives in a scheduler, a CRM and somebody’s head, and never in the same place at the same time. The Window and Door Installation KPI Scorecard in Excel is a one-page monthly answer to that: ten fenestration KPIs, a month picker, an MTD/YTD switch, and traffic lights that already know which direction is good.
It is 100% formulas. No macros, no Power Query, no add-ins, nothing to enable, and it opens on any Excel from 2016 onward. The sample file ships loaded with a full 2025 year, so the first thing you see is a real month rather than an empty grid: September 2025 reads 4 Green, 4 Amber and 2 Red across five KPI groups.
One thing to be clear about before anything else. NextGenTemplates ships three families with confusingly similar names, and this article is about exactly one of them. This is the KPI Scorecard line – a monthly reporting tile wall driven by a month picker. It is not the slicer-driven Excel KPI Dashboard line, and it is not an analytical Excel dashboard built over a transaction table. They are different products that answer different questions, and plenty of contractors own two of them.
Key Features of the Window and Door Installation KPI Scorecard in Excel
- Ten window and door KPIs on one page. Quoting, installation delivery, quality, energy performance and finance, each on its own tile with the value, the target, the change and a traffic light.
- A month picker that cannot drift. The Select Month dropdown is a form control whose linked cell is an index, not a text label, so the month you pick and the month stored on Input Data can never disagree. Pick Sep-2025 and every tile, both analysis pages and all four trend charts follow.
- MTD or YTD, against Target, PY or Prior Month. Three header controls, and the whole page repoints.
- Direction-aware scoring. Eight Upper-the-Better KPIs and two Lower-the-Better ones. Set any KPI to UTB or LTB from a dropdown on KPI Definition.
- A 12-month sparkline on every tile, so a good month inside a bad year is visible without opening another sheet.
- KPI Analysis and KPI Trend pages that both follow the same month.
- Room for 20 KPIs, ten already filled. The Scorecard shows ten at a time and a header picker switches between KPI 1-10 and KPI 11-20.
- Editable RAG bands on one sheet, separately for the two directions.
The Ten Window and Door KPIs, and Why They Are the Ten
A window and door business is really four businesses stacked on each other: getting quotes out, closing them, installing the work on time, and not having it come back. The ten KPIs in this file are grouped exactly that way.
| # | KPI | Group | Unit | Direction | Sep-2025 actual | Target | Light |
|---|---|---|---|---|---|---|---|
| 1 | Quotes Issued | Sales | Count | UTB | 141 | 166 | Red |
| 2 | Quote-to-Sale Rate | Sales | % | UTB | 38.1% | 37.0% | Green |
| 3 | Avg Contract Value | Sales | USD | UTB | $9,833 | $9,641 | Green |
| 4 | Installs Completed | Installation | Count | UTB | 121 | 127 | Amber |
| 5 | On-Time Install Rate | Installation | % | UTB | 85.6% | 89.2% | Amber |
| 6 | Install Cycle Time | Installation | Days | LTB | 20.3 | 20.9 | Green |
| 7 | Warranty Callback Rate | Quality | % | LTB | 6.6% | 6.3% | Amber |
| 8 | Customer Satisfaction | Quality | % | UTB | 95.2% | 94.3% | Green |
| 9 | Energy-Star Upgrade Rate | Energy | % | UTB | 49.8% | 59.3% | Red |
| 10 | Financing Uptake Rate | Finance | % | UTB | 34.9% | 37.6% | Amber |
The September story reads cleanly off that table. Quoting volume missed badly – 141 issued against a 166 target, 15.1% down, the worst KPI in the file after Energy-Star. But the quotes that did go out closed better than planned and at a higher average value, so the revenue side held. The install crew ran slightly short of plan on volume and on-time delivery, yet turned jobs around faster than target. The one that should worry an owner is Energy-Star Upgrade Rate at 49.8% against 59.3%, because that is the metric a manufacturer or a rebate-driven marketing programme will ask about.
Why the direction setting matters more than it sounds
Two of the ten are Lower-the-Better, and this is where scorecards usually go wrong. Install Cycle Time falls from a 20.9-day target to 20.3 days: that is good news, and the tile shows a green light with a green down-arrow. Warranty Callback Rate rises from 6.3% to 6.6%: that is bad news, and the tile shows an amber light with a red up-arrow. A scorecard that treated every increase as an improvement would have painted the callback rate green and told you the opposite of the truth. This one is wired for both directions, and I checked all ten tiles against the workbook rather than taking the artwork’s word for it.
The Nine Sheets, Page by Page
- Home – nine labelled cards, one per sheet, with a one-line description of each.
- Scorecard – the tile wall, plus the four header controls.
- KPI Analysis – the roll-up, covered below.
- KPI Trend – one KPI at a time in four charts: MTD vs Target, MTD vs PY, YTD vs Target and YTD vs PY, with the KPI’s unit, type, formula and definition printed above them.
- Input Data – twenty numbered blocks, twelve months each, MTD and YTD columns for Actual, Target and PY. This is the only sheet with numbers you type.
- KPI Definition – the ten rows that drive everything, plus a Check column that turns red on a duplicate KPI name.
- Color Settings – RAG bands for both directions, the report title and the reporting year.
- Read Me – nine short sections on how the file is wired.
- Get More Templates – the rest of the catalogue.
What the KPI Analysis page told us about September
The RAG strip reads Green 4, Amber 4, Red 2 against 10 KPIs – and yes, those add up, which is worth saying because it is the check most people never do. Achievement by group came out Sales 96.6% over three KPIs, Installation 98.1% over three, Quality 98.2% over two, Energy 84.0% over one and Finance 92.8% over one. Top 5 is led by Quote-to-Sale Rate and Install Cycle Time, both at 103.0%, then Avg Contract Value at 102.0%, Customer Satisfaction at 101.0% and On-Time Install Rate at 96.0%. Bottom 5 runs Energy-Star Upgrade Rate 84.0%, Quotes Issued 84.9%, Financing Uptake Rate 92.8%, Installs Completed 95.3% and Warranty Callback Rate 95.5%.
Because Energy is a single-KPI group, its 84.0% group achievement is just that one KPI, and it drags the group chart down in a way that looks worse than a one-metric miss really is. Worth knowing before you present it.
Excel Scorecard vs. Google Sheets vs. Contractor SaaS – Feature Comparison
| This Excel Scorecard | Google Sheets edition | Contractor SaaS (Buildertrend, Leap, improveit 360) | |
|---|---|---|---|
| Cost | One-off, under $20 | One-off, lower | $60-300+ per user per month |
| Offline | Yes | No | No |
| Share by link | No | Yes | Yes |
| Time to first report | Minutes | Minutes | Weeks |
| Pulls your job data | No – you type it | No | Yes |
| Rename every KPI | Yes, 20 slots | Yes | Usually paid customisation |
| Macros needed | No | No | N/A |
| Yours forever | Yes | Yes | No |
Who Should Use This Template
Replacement window and door companies, fenestration installers, glazing and patio-door specialists, retrofit and weatherisation crews, and dealers who report monthly numbers up to a manufacturer. Also the office manager who has to produce one performance page a month for an owner, a lender or a franchise head office and would rather not rebuild it from scratch every time.
Not for you if you want a live feed. Nothing in this file imports, syncs or connects. You type the finished monthly figures and it does the comparison, the ranking and the colour.
Real-World Use Cases
- The monthly owner review. Did we quote enough, close enough, install on time, and did it come back.
- Dealer reporting. Energy-Star Upgrade Rate and Avg Contract Value in the same view as install volume.
- Sales coaching. Quote-to-Sale Rate against target with the twelve-month sparkline underneath.
- Scheduling review. On-Time Install Rate and Install Cycle Time read together – the second usually explains the first.
- Warranty control. Callback rate scored as Lower-the-Better so a rise cannot read as a win.
- Lender or finance-partner reporting. Financing Uptake Rate against target, month by month.
Advantages of the Window and Door Installation KPI Scorecard
- The month picker is index-driven, so it cannot fall out of step with the month labels on Input Data. That is a genuine defect in some scorecard templates and it is absent here.
- The RAG bands are real: change 10% to 5% on Color Settings and every tile and both analysis pages follow.
- Every page looks a KPI up by name, so renaming a KPI repoints the whole workbook instead of breaking it.
- The Read Me is fully written, all nine sections – not the empty placeholder tab this line has sometimes shipped.
- No macros at all. It is an .xlsx, so there is no security prompt and nothing to trust.
Opportunities for Improvement
Four things I would tell a buyer before they open the file, all checked in the shipped workbook.
- The header title is clipped. The Scorecard header band prints “Window and Door Installation KPI” – the word “Scorecard” does not fit the header cell width. The full title is stored correctly on Color Settings; shorten it there if it bothers you.
- YTD is typed, not calculated. Deliberate, and the Read Me explains why (a sum is right for volumes, an average for rates), but it is the one thing people expect the file to do for them.
- The Color Settings callouts both read “Change these number as per your requirements” rather than “numbers”, and the right-hand one runs past the printable area in the page export.
- A small doc mismatch. The Read Me says the month picker reads “Sep-25”; it actually renders the full “Sep-2025”.
None of those affect a single figure. They are cosmetic, and I would rather say so than let you find them.
Best Practices
- Set the reporting year on Color Settings first. It feeds the month picker labels.
- Fill KPI Definition before Input Data. The Input Data block headers pull their KPI names from it.
- Write your YTD rule into the YTD Basis column the first time you use it, so whoever does month-end next fills it the same way.
- Keep KPI names unique. Two KPIs with the same name get added together, which is why the Check column exists.
- Move the RAG bands to match your own tolerance before you show anyone the first report. A 10% amber band is generous for an on-time rate and tight for a quote count.
- Fill all twelve months of the year you are reporting, even the future ones with targets only. The sparklines and the trend charts read the whole row.
Frequently Asked Questions
Does this connect to Buildertrend, JobNimbus, Leap or QuickBooks?
No. It is a reporting template with no import, no sync and no API. You type the monthly figures on Input Data.
Are macros required?
No. It is an .xlsx built entirely from formulas, conditional formatting, camera pictures and sparklines.
Can I change the KPI names to my own?
Yes, all twenty slots. Type the name on KPI Definition and fill the matching numbered block on Input Data.
Does it handle Lower-the-Better metrics correctly?
Yes, and it is worth checking on any scorecard you buy. Here Install Cycle Time and Warranty Callback Rate are LTB, and both score correctly in the sample month.
Does it calculate year-to-date for me?
No. You type YTD alongside MTD, because the right roll-up differs by KPI.
How many KPIs can it hold?
Twenty. Input Data runs to row 319 with twenty numbered blocks, and the Scorecard shows ten at a time.
Which Excel versions does it work on?
Excel 2016 and later on Windows, plus Microsoft 365. It uses camera pictures and sparklines, so treat it as a desktop-Excel file.
Is this the same as the Excel KPI Dashboard?
No. This is the month-picker Scorecard line. The Excel KPI Dashboard line is slicer-driven and sits at a higher price, and the analytical Excel Dashboard line is a third product again.
Does it prove compliance with an energy-rebate or building-code programme?
No. Energy-Star Upgrade Rate is a percentage you calculate and type. The workbook holds no homeowner records, no permit or inspection data and no product certification, files nothing with any programme, and satisfies no code, warranty-registration or rebate requirement.
Is there a Google Sheets version?
Yes, and it is already on sale – the Window and Door Installation KPI Scorecard in Google Sheets, the browser-based edition you can share with a link. The two editions come off different production lines, so check the Google Sheets listing’s own KPI table if the exact ten metrics matter to you.
Explore Relevant Templates
Same scorecard, other trades, all covered on this blog: Septic Tank Service KPI Scorecard in Excel, Swimming Pool Service KPI Scorecard in Excel, Fencing Contractor KPI Scorecard in Excel and Paving Contractor KPI Scorecard in Excel. If you want the interactive line instead, read up on the Drywall Contractor KPI Dashboard in Excel or the Concrete Contractor KPI Dashboard in Excel, and there is a Power BI edition of the same family in the Insulation Contractor KPI Dashboard in Power BI.
On the store side, the Window and Door Installation KPI Scorecard in Google Sheets is live now, and the whole KPI Dashboard category and MS Excel catalogue are worth a browse. A Garage Door Service KPI Scorecard in Excel is being prepared alongside this one and is not on sale yet.
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
If you install windows and doors and your monthly review is currently a revenue number and a feeling, this is the smallest thing that fixes it. Ten KPIs, one page, a month picker, and traffic lights that know a rising callback rate is bad news. Type your numbers once a month and you have a report you can hand to a partner, a lender or a manufacturer without rebuilding it.
Get the Window and Door Installation KPI Scorecard in Excel from NextGenTemplates – instant download, .xlsx plus the user manual PDF in one ZIP, and free lifetime updates to the file.
