Excavation Contractor KPI Scorecard in Google Sheets

The Excavation Contractor KPI Scorecard in Google Sheets tracks 10 excavation KPIs in 6 groups (Productivity, Safety, Financial, Equipment, Quality and Schedule) on one month-picker Scorecard page with red, amber and green lights, plus a KPI Trend page with two Actual vs Target vs PY charts. Pick a month, switch between MTD and YTD, and compare against Target or Prior Year from three dropdowns.

This listing is the KPI Scorecard template: 10 KPI cards, a month picker, a Scorecard page and a KPI Trend page. It is a different product from our Google Sheets KPI Dashboard line and from our analytical dashboards. It ships with a full sample year (10 KPIs, 12 months each) so every card works the moment you open your copy.

✅ Instant download · One-time payment · No subscription · No per-user fees · Your own editable copy in Google Drive

🔑 Key Features of the Excavation Contractor KPI Scorecard in Google Sheets

📅 Month picker with MTD/YTD and Target/PY switches – The Scorecard header carries three dropdowns: Select Month (January to December), MTD or YTD, and Target or PY. Change any of them and every card’s value, comparison value, change and arrow recalculates from the Input Data tab.

🚦 10 KPI cards with traffic lights – Each card shows the KPI name, the actual value, a colour light, the Target (or PY) value, the absolute change, the change % with an up or down arrow, and a 12-month mini bar strip. In the December sample, 4 cards are green, 3 amber and 3 red.

⬆️ Direction-aware scoring – Every KPI is typed UTB (upper the better) or LTB (lower the better) on the KPI Definition tab. Six KPIs are UTB and four are LTB, so a rise in Machine Downtime Hours or Cost per Cubic Yard shows amber or red rather than green.

📈 KPI Trend page – Choose any KPI from a dropdown to see its group, unit, type, formula and definition, together with Actual vs Target vs PY by Month charts for MTD and for YTD across all 12 months.

📘 KPI Definition sheet – All 10 KPIs are documented with group, unit, formula, a plain-English definition and type, so an owner, an estimator and a site superintendent read each number the same way.

☁️ Runs in the browser – No add-ons and no macros. Share the file by link with view or edit rights using Google Sheets’ own permissions.

📦 What’s Inside This Excavation KPI Scorecard

Your copy has 8 tabs: Read Me, Scorecard, KPI Trend, Input Data, KPI Definition, Color Settings, and two helper tabs (Support and Trend_Support) that hold the lookups behind the cards and charts. These are the 10 KPIs it ships with:

Page 1: Scorecard

The Scorecard page shows all 10 KPI cards in two rows of five under a header with the month, MTD/YTD and Target/PY dropdowns. With December, MTD and Target selected, Cubic Yards Excavated per Day reads 384.1 against a 330.3 target (+16.3%, green) and On-Schedule Job Completion reads 83.2 against 88.2 (-5.7%, red).

Page 2: KPI Trend

Select a KPI and this page fills in its KPI Group, Unit, Type, Formula and Definition, then plots Actual vs Target vs PY by Month for MTD and Actual vs Target vs PY by Month for YTD, January to December.

Page 3: KPI Definition

One row per KPI with #, KPI Group, KPI Name, Unit, Formula, Definition and Type (UTB or LTB). The Scorecard and KPI Trend pages read their names and types from here.

Page 4: Input Data

Ten blocks, KPI-1 to KPI-10, each with 12 month rows and six figures per month: MTD Actual, Target and PY, and YTD Actual, Target and PY. This is the only tab you type into each month.

📊 Excavation KPI Scorecard in Google Sheets vs. Excel vs. Construction Software

For excavation firms that want a monthly KPI review with traffic lights without paying for a construction platform, this scorecard sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Owners of small and mid-sized excavation, site-prep and earthmoving firms who run a month-end numbers review
• Operations and equipment managers watching utilization, downtime and fuel cost per operating hour
• Office and finance leads who report gross profit margin and cost per cubic yard to the owner
• Teams already working in Google Workspace who want one shared file instead of scattered spreadsheets

❌ This template is NOT for:

• Firms that need figures pulled automatically from telematics, machine control or accounting software; every number here is typed
• Anyone who needs daily or per-job tracking; the scorecard holds one set of monthly figures per KPI
• Anyone looking for a safety management, incident reporting, permit or compliance system; the two Safety KPIs are figures you enter and the sheet does not record incidents

⚙️ How to Use the Scorecard

1. Download the PDF and click its Google Sheets link to make your own editable copy in Google Drive.
2. Open KPI Definition and adjust KPI names, units, formula text or UTB/LTB type to match how your company measures each one.
3. If you rename a KPI, use the identical name on its Input Data block; the cards match the two tabs by name.
4. On Input Data, type each month’s MTD Actual, Target and PY, and the YTD Actual, Target and PY.
5. On Scorecard, pick the month, choose MTD or YTD, and choose Target or PY.
6. Open KPI Trend and select a KPI to review its 12-month pattern, then share the file by link.

⚠️ Good to know before buying: in this build the Select Month dropdown lists “June” and “July” while Input Data stores “Jun” and “Jul”, so picking either of those two months leaves all ten cards blank. The other ten months work as shipped. The fix takes about a minute: select the month cell and edit its in-cell dropdown list so it reads Jun and Jul. The Read Me tab currently holds only the title, so use the steps above as your guide.

💼 Real-World Use Cases

Dana owns an excavation company running a mixed fleet of excavators and loaders. At month-end she picks the month, sets the view to MTD vs Target, and goes straight to the red cards. Machine Downtime Hours and Equipment Utilization Rate sit next to each other, so the conversation with her shop foreman starts from the same two numbers.

Marcus manages operations for a site-prep contractor. He flips the comparison to PY to see whether Cost per Cubic Yard and Fuel Cost per Operating Hour are better or worse than the same month last year, then opens KPI Trend to check whether a bad month is a one-off or a pattern.

Priya runs the office for a small earthmoving firm. She types the monthly figures into Input Data, switches the Scorecard to YTD for the owner’s quarterly review, and shares a view-only link so nobody edits the numbers during the meeting.

❓ Frequently Asked Questions

What KPIs does the Excavation Contractor KPI Scorecard in Google Sheets track?

It tracks 10 KPIs: Cubic Yards Excavated per Day, Equipment Utilization Rate, Total Recordable Incident Rate, Near-Miss Reports Closed On Time, Gross Profit Margin, Cost per Cubic Yard, Machine Downtime Hours, Fuel Cost per Operating Hour, Grading Accuracy Pass Rate and On-Schedule Job Completion, in six groups.

Is this the same product as an excavation KPI dashboard?

No. This is the KPI Scorecard family: 10 cards, a month picker and a KPI Trend page. Our KPI Dashboard templates are a separate family with a different layout. An Excel edition of this scorecard and an Excavation Contractor KPI Dashboard in Excel are in preparation.

How long does setup take?

Making your copy takes a minute. Reviewing the KPI list takes about ten more. Typing a full year of your own figures, six numbers per KPI per month, is the longest step; most firms can do it in one sitting from their month-end reports.

Can I change the traffic light thresholds?

Yes, but not on the Color Settings tab: that tab shows the band table, while the lights read a copy of it on the Support tab (cells Z4 to AE6). As shipped, an upper-the-better KPI turns green only when it beats target by more than 10% and red at or below target.

Does it replace safety or compliance software?

No. Total Recordable Incident Rate and Near-Miss Reports Closed On Time are monthly figures you type in. The scorecard does not record incidents, decide what counts as recordable, manage permits or prove compliance with any standard. Use your own safety program for that.

How does it compare to construction software like Procore or HCSS?

Construction platforms capture data automatically and run whole projects. This scorecard does one job: a monthly review of 10 KPIs with traffic lights, for a one-time $8.99. Firms often use a sheet like this before, or alongside, a larger platform.

👤 About the Author

Built by PK, with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, sharing tutorials across the YouTube channels @PKAnExcelExpert, @NextGenTemplates and @NeoTechNavigators. Every template is built and checked before release.

🔗 Explore Related Templates

🏗️ Concrete Contractor KPI Scorecard in Google Sheets – the same scorecard format for concrete pours, finishing and crew metrics.

🛣️ Paving Contractor KPI Scorecard in Google Sheets – a close neighbour for firms that grade and then pave.

🏗️ Crane Rental KPI Scorecard in Google Sheets and Equipment Rental Business KPI Scorecard in Google Sheets – for fleet-heavy businesses.

🧱 Scaffolding Services KPI Scorecard in Google Sheets – another site-services scorecard.

📊 Prefer the KPI Dashboard family? See the Paving Contractor KPI Dashboard in Google Sheets. Need a full job system? Try the Demolition Contractor Management System Web App.

📂 Browse every Google Sheets KPI template.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: September 2026