Most masonry firms measure exactly two things well: what they invoiced, and whether the crew turned up. Everything in between – bricks laid per mason-day, mortar that went off before it was used, the gap between the square metres you priced and the square metres you actually built – lives in someone’s head or in a spreadsheet that gets rebuilt from scratch every month. The Masonry Contractor KPI Dashboard in Google Sheets replaces that monthly rebuild with a permanent scorecard: 15 masonry KPIs in 5 groups, each one carrying a target, an achievement percentage, a traffic light and a prior-year comparison, shown for month-to-date and year-to-date at the same time. Eleven tabs, one month dropdown, plain worksheet formulas, and twelve months of sample data (January to December 2025) already inside.
One thing to settle before anything else, because the names are close enough to cause a mis-purchase. NextGenTemplates ships three separate masonry KPI products. This article is about the KPI Dashboard – the month-picker scorecard with a traffic-light grid, three input sheets and dedicated KPI Trend and KPI Analysis pages. The Masonry Contractor KPI Scorecard in Google Sheets is a different template with a different layout, and the analytical Google Sheets dashboards are different again. They are not duplicates of each other, and buying one does not give you the others.
Key Features of the Masonry Contractor KPI Dashboard in Google Sheets
- 15 KPIs across 5 groups. Production (4), Quality & Materials (3), Cost & Margin (3), Sales & Cash (2) and Workforce & Safety (3).
- Seven summary cards along the top of the scorecard: 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 September 2025 sample those read 15, 5, 8, 2, 6 of 15, 97.2% and 98.6%.
- A single month dropdown. Cell D6 on the KPI Dashboard sheet lists the twelve months of the reporting year. Pick one and the scorecard and the KPI Analysis page both follow it – there is no refresh step and no query to run.
- MTD and YTD in parallel. Each half of the grid carries Actual, Target, Ach %, Status, Prior Yr and vs PY, so a KPI shows twelve numbers on one row.
- Correct maths for lower-is-better KPIs. Every KPI is typed UTB (upper-the-better) or LTB (lower-the-better). Achievement is Actual ÷ Target for UTB and Target ÷ Actual for LTB, so coming in under a cost or waste target scores above 100%. Seven of the fifteen shipped KPIs are LTB.
- Traffic lights you can re-band. On Target from 100%, At Risk 95% to 99%, Missed below 95%. The thresholds are written into the Status formulas on the KPI Dashboard sheet, so you can move them to match your own governance.
- Wired for 22 KPIs, 15 filled. The seven spare rows are already live, so adding a KPI is a typing job on one sheet.
- No add-ons at all. No Apps Script, no macros, no installs, no subscription. Nothing is locked or hidden.
Dashboard Pages Explanation
Home
Three coverage cards (15 KPIs, MTD + YTD, formula-driven), a link block for every sheet in the file, and a three-step start guide: enter your data, pick a month, read the scorecard.
KPI Dashboard – the scorecard
The main page. Seven summary cards, the month dropdown, then one row per KPI: KPI number, group, name, unit and type, followed by the month-to-date block (Actual, Target, Ach %, Status, Prior Yr, vs PY) and the year-to-date block with the same six columns. The vs PY arrow shows the raw direction the number moved; its colour shows whether that direction is good for that particular KPI, which is why a falling cost shows a green down-arrow.
KPI Trend – one KPI, twelve months
Choose any KPI from a dropdown and the whole page re-points at it: an attribute strip (group, unit, type, owner, priority, frequency), its formula and plain-English definition, a twelve-month table with MTD and YTD figures plus vs-prior-year columns, and two charts – MTD Trend and YTD Trend – each plotting Actual as columns against a Target line and a Prior Year line.
KPI Analysis – group roll-up and rankings
Performance by KPI Group in a seven-column table (group, KPI count, On Target, At Risk, Missed, Avg Ach % MTD, Avg Ach % YTD), an Average YTD Achievement by KPI Group bar chart, and Top 5 and Bottom 5 performing KPIs ranked on year-to-date achievement. Because the ranking uses achievement rather than raw value, a lower-is-better KPI that beats its target ranks near the top where it belongs.
The three input sheets
KPI Input – Actual, KPI Input – Target and KPI Input – PY. Each holds an MTD and a YTD column for all twelve months, in yellow cells. Cell E3 on the Actual sheet sets the first month of the reporting year; change it and the other input sheets, the month dropdown and every sheet title re-base automatically.
KPI Definition, Support, Read Me and Get More Templates
KPI Definition is the master list – number, group, name, unit, formula, definition, UTB/LTB type, owner, priority and frequency – and every other sheet follows it. Support holds the helper calculations behind the month picker, the chart series and the rankings. Read Me explains how the workbook is wired, including why volumes accumulate through the year while rates and per-unit costs run as averages. Get More Templates links out to the rest of the catalogue.
The 15 KPIs, as shipped
Bricks per Mason-Day, Blocks per Mason-Day, Wall Area Built and Output vs Estimate under Production; Mortar Waste, Rework & Callback Rate and Off-Spec Mortar Batches under Quality & Materials; Job Gross Margin, Cost per Sq M of Wall and Material Cost Variance under Cost & Margin; Quote-to-Win Rate and Days Sales Outstanding under Sales & Cash; Crew Utilisation, Scaffold Utilisation and Recordable Injury Rate under Workforce & Safety. Each carries a named owner – Site Foreman, Contracts Manager, Materials Controller, Quality Supervisor, Commercial Manager, Estimator, Buyer, Finance Manager, Operations Manager, Plant Coordinator or Safety Officer – and a Critical, High or Medium priority.
Masonry Contractor KPI Dashboard vs. Excel vs. Paid Construction SaaS – Feature Comparison
| This template (Google Sheets) | Excel KPI dashboard | Paid construction management SaaS | |
|---|---|---|---|
| Cost | One-off purchase, lifetime access | One-off purchase, lifetime access | Typically $99-$499 per month |
| Platform | Any browser with a Google account | Microsoft Excel on desktop | Vendor cloud plus mobile app |
| Setup time | Minutes – paste figures into three input sheets | Minutes | Days to weeks of onboarding |
| Real-time team collaboration | Yes, native to Google Sheets | Only via OneDrive co-authoring | Yes |
| Mobile access | Google Sheets mobile app | Excel mobile app | Yes |
| Customisable KPIs | Yes – 22 rows wired, 15 used, edited on one sheet | Yes | Usually fixed to the vendor’s metric set |
| Share with a link | Yes | File send or cloud link | Per-seat login |
| Year-1 cost at 5 users | The purchase price, once | The purchase price, once | Commonly $5,000+ |
| MTD and YTD side by side | Yes, on every KPI row | Depends on the file | Usually separate reports |
| Lower-is-better KPIs scored correctly | Yes – UTB/LTB flag per KPI | Depends on the file | Varies |
Who Should Use This Template
Owner-operated masonry and bricklaying firms running roughly 5 to 60 crew, where the director wants one page a month rather than a stack of reports. Contracts and commercial managers who currently rebuild a summary by hand. Site foremen who want bricks and blocks per mason-day tracked against what was priced. Estimators watching quote-to-win rate and cost per square metre drift away from the estimate. And any firm that has KPIs written down somewhere but no consistent place to see them month after month.
It is not the right tool if you need job-by-job or site-by-site reporting – this is a company-level monthly scorecard with no per-contract breakdown. It is not the right tool if you expect live connections to accounting, ERP or timesheet systems, because every figure is typed or pasted. And it is not a health-and-safety recordkeeping system: Recordable Injury Rate is tracked as a management KPI so safety sits alongside production and cost, but the template does not maintain incident logs or OSHA 300/300A records, is not evidence of compliance with any standard or regulation, and is not a substitute for professional safety advice.
Real-World Use Cases
The monthly directors’ pack. A 22-mason firm enters one column of figures per input sheet, picks the month, and screenshots the scorecard straight into the pack. The seven cards carry the headline; the traffic-light column carries the detail.
Estimate discipline. A contracts manager watches Output vs Estimate against Cost per Sq M of Wall. Because both carry a direction flag, an over-target cost renders red and an under-target cost renders green – nobody has to remember which way a given number is supposed to move.
The quality conversation. A quality supervisor owns Mortar Waste, Rework & Callback Rate and Off-Spec Mortar Batches on the KPI Definition sheet. Before the site meeting she opens KPI Trend, picks Rework & Callback Rate, and reads twelve months against target and last year on a single chart.
Advantages of the Masonry Contractor KPI Dashboard in Google Sheets
- It opens. No add-on to authorise, no macro warning, no install. Anyone you share the link with can read it in a browser.
- The formulas are readable. Every number is a worksheet formula you can click into, trace and extend.
- Adding a KPI costs nothing. Seven spare rows are already wired through every sheet, so a sixteenth KPI needs no formula edits.
- MTD and YTD stay under your control. Both are stored in the input sheets rather than derived, so your definition of year-to-date is the one that appears.
- Ownership is explicit. Each KPI names an owner and a priority, which turns the review meeting from “who knows about this one” into a list of names.
- Sample data ships inside – a full 2025 with September selected – so you can see every chart, card and threshold behaving before you type anything.
Opportunities for Improvement
Being straight about the edges is more useful than a feature list. The reporting cadence is monthly, so a weekly-planning firm will need to rework the input sheets. There is no per-job or per-site dimension. Data entry is manual – if your figures live in an accounting package, you will be copying them across each month, or building your own import. Cost per Sq M of Wall is labelled USD while areas are in square metres, so a firm working in imperial units will want to relabel that pair on the KPI Definition sheet. And a single reporting year is in view at a time; multi-year comparison means keeping a copy per year. None of these are defects, but they are worth knowing before you buy.
Best Practices
- Fix the KPI list before you load data. Rename and prune on KPI Definition first; every other sheet follows that list, so late changes are cheap but early ones are cheaper.
- Set the direction flag deliberately. The UTB/LTB column is what makes a cost target score above 100% when you beat it. Get it right for every row before your first review.
- Enter targets for all twelve months up front. Achievement, status and the summary cards all depend on a target being there.
- Re-band the thresholds to match your business. A 95% floor for “At Risk” is a starting point, not a rule. Edit the Status formulas on the KPI Dashboard sheet.
- Use the dropdown, not a copy per month. Duplicating the file monthly loses the twelve-month trend charts that make the KPI Trend page worth opening.
- Protect the input ranges when you share. Google Sheets lets you restrict editing per range – see the official guide to protecting sheets and ranges – so reviewers can read the scorecard without touching the yellow cells.
Explore Relevant Templates
- Masonry Contractor KPI Dashboard in Google Sheets – the template described in this article.
- Masonry Contractor KPI Dashboard in Excel and in Power BI – the same scorecard for teams on those tools.Masonry Contractor KPI Dashboard in Google Sheets
- Masonry Contractor KPI Scorecard in Google Sheets – a related but different masonry template.Masonry Contractor KPI Dashboard in Google Sheets
- Painting Contractor, Roofing Contractor and Electrical Contractor KPI Dashboards in Google Sheets – the same build for neighbouring trades.Masonry Contractor KPI Dashboard in Google Sheets
Frequently Asked Questions
Is this the same file as the Masonry Contractor KPI Scorecard in Google Sheets?
No. Two different templates with similar names. This is the KPI Dashboard – month dropdown, traffic-light grid, three input sheets, plus KPI Trend and KPI Analysis pages. The KPI Scorecard is laid out differently. Compare the page images on each product listing before you buy.Masonry Contractor KPI Dashboard in Google Sheets
What do I actually download?
A PDF that carries the “Make a copy” link for the live Google Sheet. One click puts a fully editable copy in your own Google Drive. Nothing to install, nothing to enable.Masonry Contractor KPI Dashboard in Google Sheets
Can I add my own KPIs?
Yes. The sheets are wired for 22 KPIs and 15 are used, so the spare rows are already live. Fill in the next empty row on KPI Definition – number, group, name, unit, formula, definition, type, owner, priority, frequency – and the three input sheets pick the name up immediately.Masonry Contractor KPI Dashboard in Google Sheets
How does achievement work for a cost or waste KPI?
Achievement is Actual ÷ Target for a UTB KPI and Target ÷ Actual for an LTB KPI, so beating a cost, waste or days-outstanding target scores above 100% exactly the way beating a revenue target does.
Can I change the traffic-light bands?
Yes. On Target from 100%, At Risk 95-99% and Missed below 95% live in the Status formulas on the KPI Dashboard sheet. Change them there and the summary cards and the KPI Analysis page follow.Masonry Contractor KPI Dashboard in Google Sheets
Does it break results down by job or site?
No. It is a company-level monthly scorecard. There is no per-contract or per-site dimension and no connection to accounting, ERP or timesheet systems.
Does it handle safety compliance?
No. Recordable Injury Rate is included as a management KPI only. The template is not an OSHA recordkeeping tool, does not maintain 300/300A logs, certifies nothing, and offers no legal or regulatory advice.Masonry Contractor KPI Dashboard in Google Sheets
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.Masonry Contractor KPI Dashboard in Google Sheets
Conclusion
A masonry business does not fail because nobody knows the numbers; it fails because the numbers arrive too late and in a different shape every month. The Masonry Contractor KPI Dashboard in Google Sheets fixes the shape: 15 KPIs, 5 groups, MTD and YTD together, one dropdown, three input sheets, and traffic lights that mean the same thing every time you look at them. Set it up once, spend ten minutes a month on it, and the directors’ pack writes itself. For walkthroughs of this and other Google Sheets builds, visit youtube.com/@NeoTechNavigators.Masonry Contractor KPI Dashboard in Google Sheets
