Ask ten paving contractors how the season went and you will get ten stories about weather, liquid AC prices and one bad municipal job. Ask for the numbers and most reach for a stack of job costings, a plant ticket file and a bank balance. The Paving Contractor KPI Scorecard in Google Sheets replaces that with one screen: ten paving-specific KPIs, each with an actual, a target, the gap in units and in percent, a red / amber / green light and a twelve-month mini bar strip. In the December sample that ships with the file, four KPIs are green, three amber and three red – and the three reds are the ones that cost money.Paving Contractor KPI Scorecard in Google Sheets
It is a month-picker scorecard built on four working pages plus 120 rows of editable monthly data. It is not an analytics dashboard with slicers and pivot pages, and it is not the KPI Dashboard family – a distinction worth making, because near-identical names exist across all three lines and a Paving Contractor KPI Dashboard in Excel is a genuinely different product. This post walks through what is actually on each page, where the sheet stops, and how to run a monthly numbers meeting off it.
Key Features of the Paving Contractor KPI Scorecard
- Ten KPIs in five groups – Bidding & Sales (2), Paving Production (2), Quality & Compaction (2), Financial (2) and Fleet & Safety (2).
- Three header dropdowns drive every card: a month picker, an Actual Type switch for MTD or YTD, and a Vs. switch for Target or PY.
- MTD and YTD in parallel – each KPI carries a month-to-date and a year-to-date actual, target and prior-year value in the data page.Paving Contractor KPI Scorecard in Google Sheets
- Direction-aware scoring – seven KPIs are typed UTB (upper is better), three are LTB (lower is better).Paving Contractor KPI Scorecard in Google Sheets
- Traffic lights per card, scored against that KPI’s own target rather than a single global rule.Paving Contractor KPI Scorecard in Google Sheets
- Editable RAG bands on a Color Settings tab – 0% and 10% variance thresholds sitting in plain cells, mirrored for LTB metrics.Paving Contractor KPI Scorecard in Google Sheets
- A twelve-month spark strip on every card, with the selected month highlighted.
- A KPI Trend page with its own KPI picker and two Actual vs Target vs PY charts, one MTD and one YTD.
- A written formula and definition for all ten metrics.
- An open data page – one block per KPI, twelve months each, six value columns.
The Four Pages, Explained
Page 1 – the KPI Scorecard
The header carries the title, the month picker (Dec in the sample), the MTD / YTD switch and the Target / PY switch. Below it sit ten cards in two rows of five, each with a coloured dot, the value, the target, the change in units, the change in percent with an arrow, and the twelve-month bar strip. The December sample reads:Paving Contractor KPI Scorecard in Google Sheets
- Bid Win Rate 31.6% against a 27.2% target – up 4.4 points, +16.2%, green.
- Takeoff to Proposal Turnaround 3.7 days against 4.0 – down 0.3 days, -7.5%, green (it is lower-is-better).Paving Contractor KPI Scorecard in Google Sheets
- Asphalt Tons Laid per Crew Day 398.4 against 382.5 – up 15.9, +4.2%, amber.
- Square Feet Sealcoated per Crew Day 24,764.9 against 26,250.8 – down 1,485.9, -5.7%, red.
- Mat Density Compliance Rate 90.1% against 77.5% – up 12.6 points, +16.3%, green.
- Mix Laydown Temperature Compliance 96.3% against 92.4% – up 3.9 points, +4.2%, amber.
- Gross Margin per Paving Job 27.4% against 23.6% – up 3.8 points, +16.1%, green.
- Asphalt Material Cost per Ton $82.1 against $70.6 – up $11.5, +16.3%, red (lower-is-better, so over target is bad).
- Paver and Roller Fleet Uptime 91.0% against 87.4% – up 3.6 points, +4.1%, amber.
- Recordable Safety Incident Rate 1.5 TRIR against 1.3 – up 0.2, +15.4%, red.
The light is not a mood. It comes from a variance band you control: for an upper-is-better KPI, a variance at or below 0% is red, at or below 10% amber and above 10% green, with the mirror image for lower-is-better metrics. That is why 31.6% beating a 27.2% target reads green while 398.4 beating 382.5 only reads amber – the second one beat target by 4.2%, not 16%.
Page 2 – KPI Trend
One dropdown, one KPI at a time. Pick a metric and the page fills in its KPI Group, Unit and Type, then its Formula and Definition in two full-width boxes. With Bid Win Rate selected it reports the Bidding & Sales group, a (%) unit, UTB type, the formula Bid Win Rate = Paving Bids Won / Total Paving Bids Submitted x 100 and the definition “Share of submitted parking lot, roadway and sealcoat bids that convert into signed contracts.”
Underneath sit two combination charts – Actual vs Target vs PY (MTD) and Actual vs Target vs PY (YTD). Each carries twelve months on the axis, an Actual column, a prior-year column and a Target line. The YTD chart is the one worth watching in a meeting: it smooths the month-to-month noise, so a metric that looks volatile on MTD often turns out to be a flat line that has been drifting all year.
Page 3 – the KPI definitions
One table, ten rows, columns for #, KPI Group, KPI Name, Unit, Formula, Definition and Type. Units run (%), (Days), (Tons), (Sq Ft), ($) and (TRIR). This page is the sheet’s contract with itself: the scorecard and the trend page both look their labels, groups, units and UTB / LTB types up from here, so editing a KPI here changes it everywhere. It is also the page that stops two people arguing about whether “density compliance” counts cores or gauge readings – the definition column says.
Page 4 – the monthly data
Ten blocks labelled KPI-1 to KPI-10, twelve rows each, with MTD Actual / Target / PY and YTD Actual / Target / PY in colour-coded column groups. Every number on the other three pages is a SUMIFS lookup into this table, matched on KPI name and month. This is the only page you type in, and it is completely open – no protection, no hidden columns, no macros.
Paving Contractor KPI Scorecard vs. Excel vs. Paid Construction SaaS – Feature Comparison
| This Google Sheets scorecard | An Excel KPI workbook | Paid construction SaaS | |
|---|---|---|---|
| Cost | One-time 13.99 (8.99 on sale) | One-time purchase | Roughly 300-1,500 per month |
| Setup | Copy the sheet, replace 120 rows | Open the workbook, replace the data | Weeks of configuration |
| Works on a phone | Yes, Google Sheets app | Limited | Yes |
| Share with a link | Yes | No | Per-seat login |
| MTD / YTD switch | Yes, one dropdown | Depends on the workbook | Yes |
| Compare to prior year | Yes, a Vs. dropdown | Depends on the workbook | Usually yes |
| Edit the KPIs themselves | Yes, every name, formula and direction flag is a cell | Yes | Only inside the vendor’s model |
| Pulls data from accounting or dispatch | No | No | Yes |
| Alerts when a KPI turns red | No | No | Usually yes |
Who Should Use This Template
Owner-operators and small-to-mid asphalt and sealcoat contractors – parking lots, driveways, overlays, municipal roadway work. Estimators who want bid conversion and takeoff turnaround sitting next to production output rather than in a different file. Superintendents and operations managers who hold a monthly numbers meeting and are tired of rebuilding the same summary by hand. And anyone running more than one trade who already owns one of the other scorecards in this line and wants the paving crew on the same board format.
It is the wrong tool if you need per-job or per-crew drilldown, live data from your estimating or dispatch software, or a compliance record. It reports at company level, by month, from numbers you type.
Real-World Use Cases
A sealcoat crew that was quietly losing days. On the December board, Square Feet Sealcoated per Crew Day is the deepest red on the page – 24,764.9 against a 26,250.8 target – while Asphalt Tons Laid per Crew Day is still above target and amber. Two adjacent cards separate a product-line problem from a season problem in about four seconds, which is the whole point of putting them on one screen.
An estimator defending her pricing. Bid Win Rate at 31.6% against a 27.2% target next to Takeoff to Proposal Turnaround at 3.7 days against a 4.0-day target is an argument: the shop won more work while getting proposals out faster, not by cutting numbers. One card alone would not make that case.
A plant and safety review in the same meeting. Asphalt Material Cost per Ton at $82.1 against $70.6 and Recordable Safety Incident Rate at 1.5 against 1.3 both score red – and both are typed lower-is-better, so the sheet marks the increase as bad instead of rewarding it. Getting that direction flag right is the difference between a scorecard and a decoration.
Advantages of the Paving Contractor KPI Scorecard
- The KPIs are actually paving KPIs. Mat density compliance, laydown temperature compliance, tons per crew day and square feet sealcoated per crew day are not generic construction metrics with the labels changed.
- Direction is explicit. Every KPI is stamped UTB or LTB on the definitions page, and the scoring formula reads that stamp. Change a metric’s direction and the lights follow.
- Nothing is locked. No macros, no protected ranges, no add-on to authorise. If you can read a SUMIFS you can see exactly how every card is computed.
- The thresholds are yours. The 0% / 10% RAG bands sit in cells on the Color Settings tab, not inside conditional-formatting rules you have to hunt for.
- It shares like a Google Sheet. View-only link for the crew leads, edit access for whoever owns the numbers.
Opportunities for Improvement
Three things worth knowing before you buy, all of them small and none of them hidden:
- The Read Me tab ships blank. The file has a Read Me sheet, but there is no text on it. The KPI definitions page does the documenting instead.
- The month dropdown lists “June” and “July” in full while the data page stores those months as “Jun” and “Jul”. Pick either of those two months and the cards come back empty until you correct the two entries in the dropdown’s list (Data > Data validation on the month cell) – a ten-second edit, but do it before your first review.
- One card in the shipped screenshots looks miscoloured. Asphalt Tons Laid per Crew Day shows its +15.9 / +4.2% and its arrow in red although it is upper-is-better and above target. The sheet’s own calculation tab scores that cell green, and the two other cards at the same +4.2% render green, so this is a stale image rather than a scoring fault in the live file.
Beyond those: there are no alerts, no integrations and no drilldown. Ten KPIs is the shipped set, and adding an eleventh means adding a block on the data page and a row on the definitions page yourself.
Best Practices
- Set honest targets first. The traffic lights are only as useful as the target column – a soft target produces a green board that tells you nothing.
- Fix the UTB / LTB flag whenever you rename a KPI. It is the one edit people forget, and getting it wrong makes rising costs or rising incidents look like wins.
- Review MTD in the meeting, YTD for the trend. Switch the header dropdown rather than arguing about which month was unusual.
- Use the Vs. switch against prior year once a quarter. Beating target while trailing last year is a different conversation from beating both.
- Keep one copy per year. The data page holds twelve months; start a fresh copy in January rather than overwriting the season you just finished.
- Fill in the definitions before you share it. If two people compute “mat density compliance” differently, the number is worse than useless.
Explore Relevant Templates
- Concrete Contractor KPI Scorecard in Google Sheets – the same board for flatwork, foundations and slabs.
- Masonry Contractor KPI Scorecard in Google Sheets and Roofing Contractor KPI Scorecard in Google Sheets – two more trades in the same format.
- Heavy Machinery Dashboard in Google Sheets – the analytical view of the plant and fleet behind the paving crew.
- Road and Highway Construction Dashboard in Excel – project-level analysis for larger roadway work.
- Civil Contractor Job Management System Web App – a full job, crew and billing system, if a monthly scorecard is no longer enough.
Frequently Asked Questions
Is this the KPI Scorecard, the KPI Dashboard, or the analytical paving dashboard?
This is the KPI Scorecard line – a month-picker board with ten KPI cards, traffic lights, a KPI Trend page and a KPI definitions page. It is not the KPI Dashboard family and not the analytical dashboard family with slicers and pivot pages. The separate Paving Contractor KPI Dashboard in Excel is a different product with a different layout, not a copy of this one.
Does it connect to my accounting, estimating or dispatch software?
No. There are no integrations, no imports and no API. You type or paste the monthly values into the data page. That is the trade-off that keeps it a 13.99 sheet instead of a subscription.
Will it alert me when a KPI goes red?
No. The lights are visual only, on the sheet. There are no emails, notifications or scheduled reminders.
Can I swap in my own KPIs?
Yes. Name, group, unit, formula text, definition and UTB / LTB type are all editable cells on the definitions page, with a matching block per KPI on the data page. Keep the row structure and the scorecard, trend page and lights all follow.
Is the safety KPI an OSHA record?
No, and this is worth being blunt about: Recordable Safety Incident Rate is a TRIR figure you calculate and type in. This is not an OSHA recordkeeping system, not an OSHA 300 log, and not an incident-reporting tool. The same goes for the density and laydown temperature KPIs – they are management summaries, not core reports, gauge printouts or certified QC documentation.
Do I need a paid Google Workspace account?
No. A free Google account is enough. The PDF in the download carries a “Make a copy” link that creates the sheet in your own Drive.
How long does setup take?
Copying the sheet takes seconds. Replacing the sample data is the real work: 120 rows across ten KPI blocks, plus your targets. Most people do it in an evening with last year’s job costings open beside them.
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
A paving business does not fail on one number. It fails on a slow drift in cost per ton, a crew that quietly stops hitting output, a rework rate nobody adds up until the season closes. The Paving Contractor KPI Scorecard in Google Sheets exists to make that drift visible once a month, on one screen, against targets you set – ten KPIs, three dropdowns, a trend page and a definitions page, with nothing locked and nothing to install.
Get the Paving Contractor KPI Scorecard in Google Sheets – one-time payment, instant download, no subscription. Open the PDF, click the copy link, and the board is yours in under five minutes.
