An excavation contractor already has every number this page needs. Cubic yards moved come off the haul tickets, milestone dates off the job schedule, machine hours off the equipment log, cost and margin out of job costing, dig damage out of the field reports and unpaid invoices out of accounts. What most earthmoving firms lack is one page that lines those figures up the same way every month, so a slipping month is obvious at a glance instead of after an evening in five spreadsheets.
The Excavation Contractor KPI Scorecard in Excel is that page: 10 excavation KPIs in 5 groups, a month picker, an MTD / YTD switch and direction-aware traffic lights, spread across 9 visible sheets. It ships with a complete 2025 sample year. Left on Aug-2025 with MTD and Vs. Target selected, it reads 4 Green, 4 Amber and 2 Red: Cost per 1,000 CY is $4,552.6 against a $4,693.4 target, while Project Gross Margin is 20.1% against 22.8%. It is a plain .xlsx built from formulas only – no macros, no Power Query, no add-ins.
Which product this is. NextGenTemplates ships several templates with near-identical names. This listing belongs to the KPI Scorecard family: ten KPIs on a tile-based monthly management page driven by numbers you type. It is not the separate Excavation Contractor KPI Dashboard in Excel, which belongs to the KPI Dashboard family with a larger 15-KPI set, a table-style dashboard and ten pages, and it is not a slicer-driven analytics dashboard built on transaction records.
Instant download – One-time payment – No subscription – No per-user fees – Lifetime access
Key Features of the Excavation Contractor KPI Scorecard in Excel
- Ten excavation KPIs on one page – Cubic Yards Excavated (000s), Jobs on Schedule %, Equipment Utilisation %, Machine Downtime %, Cost per 1,000 CY, Project Gross Margin %, Recordable Incident Rate, Utility Strikes per 10k, Bid Win Rate % and DSO Days. Every tile shows the value, the comparison value, the change, an arrow and a 12-month sparkline.
- Month picker with an MTD / YTD switch – choose any month of the reporting year from the header dropdown and flip the whole page between month-to-date and year-to-date without touching a formula.
- Three comparison bases – measure against Target, against the same period last year (PY) or against the Prior Month. Tiles, arrows and traffic lights all follow the choice.
- Direction-aware traffic lights – five KPIs are upper-the-better and five are lower-the-better (Machine Downtime, Cost per 1,000 CY, Recordable Incident Rate, Utility Strikes and DSO Days), so a falling cost or downtime figure turns green instead of red.
- Thresholds you own – the green / amber / red bands are ordinary cells on Color Settings. By default amber means within 10% of the comparison value; change it and every page re-flags itself.
- KPI Analysis page – Green / Amber / Red counts, achievement by KPI group with a column chart, and automatic Top 5 and Bottom 5 KPI tables for the selected month.
- KPI Trend page – one KPI at a time in four charts: MTD Actual vs Target, MTD Actual vs PY, YTD Actual vs Target and YTD Actual vs PY, with the KPI’s formula and definition printed above.
- Room for 20 KPIs – the Scorecard shows ten at a time and a set picker switches between KPI 1-10 and KPI 11-20.
What’s Inside the Workbook
The Excavation Contractor KPI Scorecard in Excel has eleven sheets in total: nine visible pages and two hidden calculation sheets. Only two of them, Input Data and KPI Definition, ever need your typing.
Page 1: Home
A navigation menu with a one-line description of all eight working pages, so a new user knows where to start.
Page 2: Scorecard
Ten KPI tiles for the selected month. In the sample, Project Gross Margin (20.1% vs 22.8%, -11.8%) and Recordable Incident Rate (2.3 vs 2.0, +15.0% on a lower-the-better KPI) are red, while Utility Strikes per 10k (17.3 vs 18.0) and Bid Win Rate (34.9% vs 33.9%) are green. The header holds Select Month, MTD / YTD, Vs. and the KPI set picker.
Page 3: KPI Analysis
The reporting month and basis, a 4 Green / 4 Amber / 2 Red / 10 KPIs counter strip, Achievement by KPI Group (Production 99.0%, Equipment 95.1%, Financials 95.6%, Safety 95.5% and Schedule 99.5%, all Amber) with its chart, plus Top 5 KPIs led by Utility Strikes per 10k at 104.0% and Bottom 5 KPIs led by Recordable Incident Rate at 87.0%.
Page 4: KPI Trend
Pick one KPI to see its group, unit, type, formula and definition, then four monthly charts against Target and PY. Cubic Yards Excavated peaks at 22.9 thousand in July and closes 2025 at 216.8 thousand year-to-date against a 213.8 target and 204.8 the year before.
Page 5: Input Data
One numbered block per KPI with twelve month rows and six columns: MTD Actual, Target and PY, then YTD Actual, Target and PY. This is the only sheet that holds numbers.
Page 6: KPI Definition
Group, name, unit, formula, definition, UTB / LTB type and YTD basis for every KPI, with a Check column that flags duplicate names. Cost per 1,000 CY, for example, is defined as Total Excavation Cost / (Cubic Yards / 1000).
Page 7: Color Settings
The RAG bands for upper-the-better and lower-the-better KPIs, the report title and the reporting year that feeds the month picker.
Page 8: Read Me
Nine short sections: what you type, why MTD and YTD are both typed, UTB and LTB, traffic lights, adding a KPI, unique names, the header controls, reporting year and title, and why there are no macros.
Page 9: Get More Templates
Pointers to the other NextGenTemplates product lines and a contact line for customisation requests.
The ten KPIs it ships with
| # | KPI | Group | Unit | Direction | Aug-2025 MTD vs Target |
|---|---|---|---|---|---|
| 1 | Cubic Yards Exc. (000s) | Production | Count | Upper the better | 21.3 vs 20.5 – Green |
| 2 | Jobs on Schedule % | Production | % | Upper the better | 88.9% vs 94.5% – Amber |
| 3 | Equipment Utilisation % | Equipment | % | Upper the better | 81.1% vs 85.4% – Amber |
| 4 | Machine Downtime % | Equipment | % | Lower the better | 8.5% vs 8.1% – Amber |
| 5 | Cost per 1,000 CY | Financials | USD | Lower the better | $4,552.6 vs $4,693.4 – Green |
| 6 | Project Gross Margin % | Financials | % | Upper the better | 20.1% vs 22.8% – Red |
| 7 | Recordable Incident Rate | Safety | per 200k hrs | Lower the better | 2.3 vs 2.0 – Red |
| 8 | Utility Strikes per 10k | Safety | per 10k locates | Lower the better | 17.3 vs 18.0 – Green |
| 9 | Bid Win Rate % | Schedule | % | Upper the better | 34.9% vs 33.9% – Green |
| 10 | DSO Days | Schedule | Days | Lower the better | 54.3 vs 52.2 – Amber |
Every name, group and unit is editable. Each page looks a KPI up by name, so renaming Cubic Yards Exc. (000s) to Bank Cubic Metres on KPI Definition carries through the tiles, the trend charts and the analysis tables.
A note on the safety KPIs. Recordable Incident Rate and Utility Strikes per 10k are numbers you type from your own records. The scorecard does not record incidents, locate utilities, check trench or permit requirements, or produce any report for a regulator, and it makes no safety or compliance claim.
Excel Scorecard vs. Google Sheets vs. Contractor Management Software – Where This Fits
| Feature | This Excel KPI scorecard | A Google Sheets scorecard | Construction management SaaS |
|---|---|---|---|
| Cost | $9.99 one-time (sale price) | One-time template price | Recurring monthly subscription |
| Platform | Excel 2016 or later, Microsoft 365 | Web browser | Vendor web app |
| Setup time | Minutes – type numbers, rename KPIs | Minutes | Onboarding and data integration |
| Works offline | Yes | No | No |
| Real-time team collaboration | No – share the file | Yes | Yes |
| Pulls numbers automatically | No – you type them monthly | No | Yes, once connected |
| Change a KPI or threshold | Type over a cell | Type over a cell | Admin settings or vendor support |
| Year-1 cost at 5 users | One purchase | One purchase | Twelve months of per-user fees |
| Monthly one-page management report | Ready on day one | Ready on day one | Often needs a custom report |
For excavation owners who want a board-ready monthly page without paying for a platform, the Excavation Contractor KPI Scorecard in Excel sits in the sweet spot.
Who This Template Is For – and Who It’s Not For
This template is built for:
- Excavation, site preparation and earthmoving contractors that want one monthly performance page for the whole business.
- Operations managers and superintendents who report production, machine utilisation and schedule performance to owners.
- Accountants and consultants preparing a monthly pack for a civil or site-works client.
This template is NOT for:
- Firms needing job-level costing, telematics or per-machine tracking – it reports business-level monthly figures.
- Anyone looking for estimating, dispatch, timesheets or invoicing – it reports on those systems rather than replacing them.
- Safety or compliance record-keeping – it is a performance report, not an incident log or a permit register.
How to Use It
- Open the workbook in desktop Excel. There are no macros, so there is no security prompt.
- Set the report title and reporting year on Color Settings; the year makes the month picker read Aug-2025 rather than Aug.
- Rename the KPIs on KPI Definition and set each group, unit, formula text, definition, UTB / LTB direction and YTD basis.
- Replace the sample numbers on Input Data: MTD Actual, Target and PY, then the YTD equivalents for each month.
- Adjust the bands on Color Settings if 10% is the wrong amber width for your business.
- Read the month on the Scorecard, then use KPI Analysis and KPI Trend to explain anything that moved.
If you want to understand the sparklines behind each tile, Microsoft’s Excel help and learning site covers them, although day to day you only type numbers and names.
Real-World Use Cases
Maria runs operations for a 30-machine site-works contractor. Each month she types ten numbers, prints the Scorecard and KPI Analysis pages, and walks the owners through the Bottom 5 table. Equipment Utilisation at 81.1% next to Machine Downtime at 8.5% tells her idle iron is partly a workshop problem, not only a sales one.
Dan owns a residential excavation firm and prices his own bids. He watches Bid Win Rate and Project Gross Margin together, because a rising win rate beside a falling margin usually means the jobs are being won on price.
Priya is a bookkeeper with three civil clients. She keeps one copy of the workbook per client, switches the Vs. control to PY for the year-end meeting, and uses the KPI Trend page to show whether a slow winter was seasonal.
Frequently Asked Questions
Does this connect to my job costing or fleet software?
No. You type the monthly figures on the Input Data sheet. That keeps the workbook portable, offline and free of connections that break, and filling ten KPIs for a month takes a few minutes once your source reports are to hand.
Are macros required?
No. It is a plain .xlsx built from formulas, conditional formatting, camera pictures and sparklines. There is nothing to enable, and it opens in Excel 2016 or later and Microsoft 365.
How long does setup take?
Most buyers load the Excavation Contractor KPI Scorecard in Excel in under half an hour: set the year on Color Settings, rename or keep the ten KPIs, then paste twelve months of MTD and YTD figures into Input Data.
Does it calculate year-to-date for me?
No, deliberately. The right roll-up differs by KPI – cubic yards are summed, percentages and rates are averaged – so you type the finished YTD figure and record the rule in the YTD Basis column on KPI Definition.
Is it a safety or compliance tool?
No. The two safety tiles display figures you enter. The workbook does not log incidents, manage utility locates, trench inspections or permits, and it is not a substitute for your own safety programme.
Is this the same as the Excavation Contractor KPI Dashboard?
No. That is a different template family with 15 KPIs and its own pages. This is the KPI Scorecard line: ten KPIs, nine sheets and a tile-based monthly page.
What is in the download?
A ZIP holding the Excavation Contractor KPI Scorecard in Excel workbook (.xlsx) and a PDF user manual for the Excel KPI Scorecard line.
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
- Concrete Contractor KPI Scorecard in Excel – the same scorecard engine for concrete work.
- Masonry Contractor KPI Scorecard in Excel – another trade scorecard on the same layout.
- Construction Safety KPI Scorecard in Excel – a scorecard focused on safety performance measures.
- Paving Contractor KPI Dashboard in Excel – a KPI dashboard for a neighbouring civil trade.
- Civil Contractor Job Management System Web App – if you need jobs managed, not just reported.
- Heavy Machinery Dashboard in Google Sheets – machine-level analytics in Google Sheets.
Browse every scorecard and KPI template in the Excel KPI templates category.
Read the detailed blog post on this excavation KPI scorecard
Visit our YouTube channel for step-by-step video tutorials
Last updated: September 2026
Reviews
There are no reviews yet.