Plumbing Business KPI Dashboard in Excel

The Plumbing Business KPI Dashboard in Excel is a month-picker KPI scorecard that puts 15 plumbing KPIs across 6 KPI groups on one screen, with MTD and YTD actual, target, achievement, status and prior-year on every row. Pick a month from one dropdown and all 11 worksheets follow it. Every number is a plain worksheet formula – VLOOKUP, MATCH, INDEX and COUNTIF. There is no Power Query, no data model, no macro and no add-in, so it opens in Excel 2013 and later and in Excel for the web, and nothing has to be refreshed. Sample data for a full 2025 reporting year is already filled in, so you can see it working the moment it opens. Nothing is locked, hidden or password protected – if you can read a formula, you can change it.

Key Features of the Plumbing Business KPI Dashboard in Excel

• One month dropdown drives everything. Cell D6 on KPI Dashboard lists the twelve months of the reporting year. The scorecard, the seven summary cards and the whole KPI Analysis page recalculate from it.
• Seven summary cards. Total KPIs Tracked, On Target (YTD), At Risk (YTD), Missed (YTD), Improving vs PY (MTD), Avg Achievement (MTD) and Avg Achievement (YTD). In the shipped sample for September 2025 they read 15, 7, 6, 2, 10 of 15, 98.6% and 98.9%.
• Direction-aware scoring. Each KPI is flagged UTB (Upper The Better) or LTB (Lower The Better). Achievement is Actual divided by Target for UTB and Target divided by Actual for LTB, so beating a response-time or Days Sales Outstanding target scores above 100% instead of looking like a miss.
• Traffic-light status you can re-tune. On Target from 100%, At Risk 95-99%, Missed below 95%. The thresholds sit in ordinary formulas in columns L and U of KPI Dashboard – edit them there to match your own governance.
• Colour-aware movement arrows. The arrow shows the raw direction against the comparator; its colour shows whether that direction is good for that KPI, which is why a falling callback rate shows a green down-arrow.
• Add or rename KPIs without touching a formula. The sheets are wired for 22 KPI rows. Type a new KPI on KPI Definition and it flows straight through the three input sheets, the scorecard, the trend page and the analysis page.
• Re-base the whole year in one cell. Cell E3 on KPI Input – Actual is the first month of the reporting year. Change it and the Target sheet, the Prior Year sheet, the month dropdown and every sheet title move with it.

What’s Inside the Plumbing Business KPI Dashboard in Excel

Eleven worksheets, ten of which you will actually look at:

• Home – a navigation page with tiles for the dashboard pages, the input sheets and the reference pages.
• KPI Dashboard – the scorecard itself: month dropdown, seven summary cards, and one row per KPI carrying MTD and YTD actual, target, achievement, status, prior year and vs-PY movement.
• KPI Trend – one KPI at a time. Pick it in cell B4 and its attribute strip, formula, definition, twelve-month table and two combo charts (MTD Trend for First-Time Fix Rate and YTD Trend for First-Time Fix Rate in the shipped sample) all redraw.
• KPI Analysis – achievement rolled up by KPI group, an Average YTD Achievement by KPI Group bar chart, and the top five and bottom five KPIs for the year to date.
• KPI Input – Actual / Target / PY – the only three sheets you normally type in. Each holds an MTD and a YTD column for every month.
• KPI Definition – the master list: number, group, name, unit, formula, definition, type, owner, priority and frequency for all 15 KPIs. Every other sheet reads from here.
• Support – helper calculations behind the dropdowns, arrows, chart series and ranking. Nothing here needs editing.
• Read Me and Get More Templates – how the workbook is wired, and the rest of the NextGenTemplates catalogue.

The 15 KPIs, as shipped: First-Time Fix Rate, Average Emergency Response Time and Service Jobs Completed (Service Delivery); Technician Billable Utilisation, Revenue per Technician and Recordable Incident Rate (Workforce & Safety); Quote-to-Job Conversion Rate, Average Job Ticket Value and Service Plan Attachment Rate (Sales & Growth); Gross Margin on Completed Work, Days Sales Outstanding and Unbilled Work in Progress Days (Financial Health); Callback Rate Within 30 Days and Customer Net Promoter Score (Quality & Customer); and Truck Stock Inventory Turns (Inventory & Fleet).

Plumbing Business KPI Dashboard vs. Google Sheets vs. Paid Field-Service SaaS – Where This Fits

This is a reporting layer, not a field-service platform. If you already run a dispatch system, this is where the month’s numbers go to be read by an owner or a manager. If you do not, it is the cheapest way to start measuring the business at all.

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

It fits owner-operators and 5-50 technician plumbing companies that already know their monthly numbers and want them scored consistently; service managers who report to a board or a private-equity owner; and multi-trade contractors who want one scorecard format across plumbing, HVAC and electrical divisions.

It does not fit anyone expecting the file to collect data. It has no job list, no customer table, no invoice register and no technician roster – you type fifteen numbers a month, per sheet, and the scorecard does the rest. It also does not dispatch, schedule or invoice, it is not accounting software, and it does not check or track licensing, permits, backflow certification, apprenticeship hours or plumbing code compliance. Those belong in your licensing authority’s records and your accounting or field-service system, not in a KPI scorecard.

How to Use the Plumbing Business KPI Dashboard in Excel

1. Open the workbook and read Read Me – it is the five-minute version of everything below.
2. Set cell E3 on KPI Input – Actual to the first month of your reporting year. Everything else re-bases.
3. Rename, add or delete KPIs on KPI Definition. All three input sheets and every dashboard page follow it immediately.
4. Replace the sample numbers on KPI Input – Actual, – Target and – PY. Each month has an MTD and a YTD column, so you keep control of how your own YTD is defined.
5. Pick a month on KPI Dashboard and read the scorecard. Adjust the On Target / At Risk / Missed cut-offs in columns L and U if your thresholds differ.
6. Use KPI Trend for the one KPI you are being asked about, and KPI Analysis for the group roll-up and the top / bottom five.

Real-World Use Cases

Dan, owner of an 18-van residential service company. He reviews the scorecard on the first Monday of the month. Callback Rate Within 30 Days and First-Time Fix Rate sit next to each other, so a callback spike and a fix-rate dip get discussed as one problem instead of two.

Priya, service manager at a commercial plumbing contractor. Her board pack needs one page. She prints KPI Dashboard for the month and KPI Trend for whichever KPI is trending badly – in the sample year that is Days Sales Outstanding, which sits bottom of the YTD ranking at 91.4%.

Marcus, finance controller across three trades. He runs the same workbook three times – plumbing, HVAC, electrical – because the KPI list is typed, not hard-coded, so the format is identical while the metrics differ.

Frequently Asked Questions

Does this template do dispatch, scheduling or invoicing?

No. It is a reporting scorecard. There is no job board, no calendar, no customer record and no invoice. It reads the numbers your other systems already produce.

Does it track licensing, permits, backflow certification or code compliance?

No, and it should not be relied on for any of that. There is no licence field, no permit register, no certification expiry tracker and no code reference anywhere in the workbook. Compliance records belong with your licensing authority and your own compliance system.

Is it accounting software?

No. Gross Margin on Completed Work, Days Sales Outstanding and Unbilled Work in Progress Days are figures you type in from your accounts, not figures the workbook derives from ledgers or invoices.

How many KPIs does it ship with?

Fifteen, listed on KPI Definition and counted by the Total KPIs Tracked card. Note that the Home page blurb and the Read Me capacity note still say “14” – that is stale label text from an earlier build of this template line; every sheet that calculates uses all 15 rows.

Do I need Power Query, Power Pivot or macros?

No. Every figure is a worksheet formula. The file is a plain .xlsx, so there are no macro warnings and nothing to enable.

Can I add my own KPIs?

Yes. The sheets are wired for 22 KPI rows and 15 are filled, so seven more need no formula work at all. Beyond 22, the Read Me explains the fill-down and range widening.

Are the numbers in the screenshots real?

No. The 2025 figures are generated sample data so the dashboard is populated on first open. Replace them with your own.

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

This is the KPI-scorecard family – month picker, traffic lights, KPI Trend and KPI Analysis. Two neighbours share the topic but are different products:

• Plumbing Business KPI Scorecard in Excel – the compact one-page scorecard from a separate line, with a different KPI set.
• Plumbing Contractor Dashboard in Excel – the analytical dashboard line: slicers, pivot-driven charts and record-level data rather than a monthly scorecard.
• Plumbing Contractor Dashboard in Power BI and in Google Sheets – the same analytical dashboard on other platforms.
• HVAC Contractor KPI Scorecard in Excel and Electrical Contractor KPI Scorecard in Excel – the same idea for the other trades.
• Browse the whole KPI Dashboard category or every MS Excel template.

The same Plumbing Business KPI Dashboard is also being prepared for Power BI and Google Sheets: Plumbing Business KPI Dashboard in Power BI and Plumbing Business KPI Dashboard in Google Sheets.

Download it, replace fifteen numbers, and you have your month scored. Instant download, lifetime access to the file you buy, and nothing in it is locked.

Last updated: 26 August 2026.

Watch the demo video: