Excavation Contractor KPI Scorecard in Google Sheets

The Excavation Contractor KPI Scorecard in Google Sheets puts 10 excavation KPIs in 6 groups on one Scorecard page, each with a red, amber or green light, a Target or Prior Year comparison, a change % with an arrow, and a 12-month mini bar strip. A month picker and two switches (MTD or YTD, Target or PY) re-score all ten cards, and a KPI Trend page charts any single KPI across the year.Excavation Contractor KPI Scorecard in Google Sheets

Most excavation firms already have the raw numbers: yards moved, machine hours, fuel receipts, job costs, grade checks and completion dates. What they lack is one place where those numbers are compared with a target every month, the same way, and where a slipping KPI is impossible to miss. This article walks through every tab of the template, shows what the sample data looks like, compares it with Excel and construction software, and is honest about the limits of the current build.Excavation Contractor KPI Scorecard in Google Sheets

This is the KPI Scorecard template family (10 KPI cards, month picker, Scorecard and KPI Trend pages). It is not the same product as our Google Sheets KPI Dashboard line or our analytical dashboards, which use different layouts.Excavation Contractor KPI Scorecard in Google Sheets

Key Features of the Excavation Contractor KPI Scorecard in Google Sheets

• 10 KPI cards on one page. The Scorecard shows two rows of five cards covering Productivity, Safety, Financial, Equipment, Quality and Schedule. Each card holds the actual value, a traffic light, the comparison value, the absolute change, the change % with an arrow, and a 12-month mini bar strip.Excavation Contractor KPI Scorecard in Google Sheets
• Three dropdowns drive everything. Select Month (January to December), MTD or YTD, and Target or PY. Every card reads its figures from the Input Data tab for the month and view you choose.Excavation Contractor KPI Scorecard in Google Sheets
• Direction-aware lights. Six KPIs are typed UTB (upper the better) and four are LTB (lower the better). A rise in Machine Downtime Hours, Cost per Cubic Yard, Fuel Cost per Operating Hour or Total Recordable Incident Rate is scored as a worse result, not a better one.Excavation Contractor KPI Scorecard in Google Sheets
• KPI Trend page. Pick one KPI and see its group, unit, type, formula and definition, with Actual vs Target vs PY by Month charts for MTD and YTD.
• Documented KPIs. The KPI Definition tab lists a formula and plain-English definition for all 10 KPIs, which keeps the office and the field reading the same numbers the same way.
• Sample year included. Twelve months of figures for all 10 KPIs, so the December view opens with 4 green, 3 amber and 3 red cards.

Template Structure: Every Tab Explained

Your copy contains 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. The screenshots below come from the shipped template.

Scorecard

The header holds the three dropdowns; below it sit the 10 cards. With December, MTD and Target selected, Cubic Yards Excavated per Day reads 384.1 against a 330.3 target (+16.3%, green), Equipment Utilization Rate reads 73.8 against 70.8 (+4.2%, amber), Total Recordable Incident Rate reads 2.3 against 2.0 (+15.0%, red) and On-Schedule Job Completion reads 83.2 against 88.2 (-5.7%, red).

KPI Trend

Select a KPI from the dropdown and the page fills in KPI Group, Unit, Type, Formula and Definition. Two charts follow: Actual vs Target vs PY by Month for MTD, and Actual vs Target vs PY by Month for YTD. Target is drawn as a line over Actual and PY columns, which makes a month that missed target easy to spot.

KPI Definition

One row per KPI with #, KPI Group, KPI Name, Unit, Formula, Definition and Type. The 10 KPIs shipped are listed below.

Input Data

Ten blocks, KPI-1 to KPI-10, each with twelve month rows (Jan to Dec). Every row takes six figures: MTD Actual, MTD Target, MTD PY, YTD Actual, YTD Target and YTD PY. This is the only tab you type into each month; the cards and charts read from it.

Read Me, Color Settings, Support and Trend_Support

Color Settings displays a RAG band table for upper-the-better and lower-the-better KPIs. Support and Trend_Support are helper tabs: Support looks up the selected month’s figures for each card and scores the lights, and Trend_Support feeds the two KPI Trend charts. The Read Me tab holds the title only in this build (see Opportunities for Improvement).

Excavation KPI Scorecard vs. Excel vs. Construction Software — Feature Comparison

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

Who Should Use This Template

Perfect for:

• Owners of small and mid-sized excavation, site-prep and earthmoving firms who hold a month-end numbers review
• Operations and equipment managers tracking utilization, downtime and fuel cost per operating hour
• Office and finance leads who report gross profit margin and cost per cubic yard
• Teams on Google Workspace who want one shared file instead of several disconnected spreadsheets

Not a fit if:

• You need figures pulled automatically from telematics, machine control or accounting software
• You need daily or per-job tracking; the template holds one set of monthly figures per KPI
• You are looking for safety management, incident reporting, permit or compliance software; the two Safety KPIs are numbers you type, and the sheet does not record incidents or decide what is recordable

Real-World Use Cases

Dana owns an excavation company with a mixed fleet of excavators and loaders. At month-end she selects the month, keeps the view on MTD vs Target and starts with the red cards. Machine Downtime Hours and Equipment Utilization Rate sit side by side, so her meeting with the shop foreman starts from the same two numbers instead of two different spreadsheets.

Marcus runs operations for a site-prep contractor. He switches the comparison to PY to see whether Cost per Cubic Yard and Fuel Cost per Operating Hour beat the same month last year. When a card turns amber he opens KPI Trend to check whether it is a one-month blip or a steady drift across the MTD chart.

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

Advantages of This Excavation KPI Scorecard

• Low cost, no subscription. A one-time $8.99 replaces an ad-hoc monthly spreadsheet without adding a recurring software bill.
• Balanced view. Productivity, safety, financial, equipment, quality and schedule KPIs sit on one page, so a good margin month cannot hide rising downtime.
• Fast month-end review. Traffic lights and arrows let a manager triage ten KPIs in under a minute and spend the meeting on the red ones.
• Two comparisons in one file. The Target/PY switch answers both “did we hit plan?” and “are we better than last year?”.
• Easy to share. A Google Sheets link works for the owner, the estimator and the bookkeeper without installing anything.

Opportunities for Improvement

We tested the live sheet tab by tab before writing this article. These are the limits and defects of the current build, so you can decide with full information:

• June and July blank the Scorecard. The Select Month dropdown offers “June” and “July”, while Input Data stores “Jun” and “Jul”. The card lookups match the month text exactly, so choosing June or July leaves all ten cards empty. The KPI Trend page is not affected. The fix is quick: edit the month cell’s in-cell dropdown list to read Jun and Jul.
• The Read Me tab is empty apart from the title. Setup steps are not inside the file yet; use the How to Use steps on the product page and the Best Practices below.
• Color Settings does not drive the lights. The tab shows the RAG band table, but the lights read their own copy of it on the Support tab (Z4 to AE6). Editing Color Settings changes nothing; to change the bands, edit the Support cells. The Scorecard colours themselves use conditional formatting rules keyed on those light values.
• Strict bands. As shipped, an upper-the-better KPI turns green only when it beats target by more than 10%, amber from 0% to 10% above, and red at or below target, so a KPI landing exactly on target shows red. Lower-the-better KPIs mirror this.
• YTD figures are typed, not calculated. Input Data holds no formulas, so YTD Actual, Target and PY must be entered alongside the MTD figures.
• One year, monthly totals. Each file covers twelve month rows per KPI; there is no per-job, per-crew or per-machine breakdown.
• Names must match. Cards match Input Data to KPI Definition by KPI name, so a KPI renamed in one tab must be renamed identically in the other.

Best Practices

• Fix the June/July dropdown entries in your copy before you enter your first month of data.
• Agree the formula for each KPI with your team before typing figures, especially how working days, available machine hours and direct job cost are counted.
• Enter targets for all twelve months at the start of the year so the lights mean the same thing every month.
• Review MTD vs Target monthly and YTD vs PY quarterly; the two views answer different questions.
• Use your own safety program’s definitions for recordable incidents and near-misses; the sheet only scores the numbers you enter.
• Keep one file per year, and share it view-only for review meetings.

Explore Relevant Templates

If you run a related trade, these published scorecards on this blog use the same format: the Concrete Contractor KPI Scorecard, the Paving Contractor KPI Scorecard, the Crane Rental KPI Scorecard, the Equipment Rental Business KPI Scorecard and the Scaffolding Services KPI Scorecard.

On NextGenTemplates you can buy the Concrete Contractor KPI Scorecard in Google Sheets, the Paving Contractor KPI Dashboard in Google Sheets (a KPI Dashboard family product) or the Demolition Contractor Management System Web App, or browse all Google Sheets KPI templates. An Excel edition of this scorecard and an Excavation Contractor KPI Dashboard in Excel are in preparation.

Frequently Asked Questions

What KPIs are in the Excavation Contractor KPI Scorecard in Google Sheets?

It ships with 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.

How long does setup take?

Copying the file takes a minute and reviewing the KPI list about ten more. Typing a year of your own figures, six numbers per KPI per month, takes longest; most firms can do it in one sitting from their month-end reports. Fix the June and July dropdown entries first.

Can I rename KPIs or add my own?

You can rename any of the 10 KPIs, change the unit, the formula text and the UTB or LTB type on KPI Definition. Rename the matching Input Data block identically, because the cards match the two tabs by name. The Scorecard layout has exactly ten cards.

How does this compare to Procore or HCSS?

Construction platforms capture field data automatically and manage whole projects on a subscription. This scorecard does one focused job, a monthly review of 10 KPIs with traffic lights, for a one-time $8.99. Many smaller firms start here before, or alongside, a larger platform.

Does the scorecard handle safety compliance?

No. Total Recordable Incident Rate and Near-Miss Reports Closed On Time are figures you type in each month. The sheet does not log incidents, decide what counts as recordable, manage permits or show compliance with any standard. Use your own safety program for those tasks.Excavation Contractor KPI Scorecard in Google Sheets

Do I need Microsoft Excel?

No. It runs in Google Sheets with a free Google account in any modern browser. After purchase, open the PDF in your download and click its link to make your own editable copy in Google Drive.Excavation Contractor KPI Scorecard in Google Sheets

About the Author

Built by PK, with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, sharing tutorials on YouTube. Every template is built and checked before release.Excavation Contractor KPI Scorecard in Google Sheets

Conclusion

A monthly excavation review works best when ten numbers are compared with a target the same way every month, and a red light cannot be overlooked. This scorecard does that in Google Sheets for a one-time price. Fix the two month entries, type your year, and your month-end review starts from one page.Excavation Contractor KPI Scorecard in Google Sheets

👉 Click here to Purchase the Excavation Contractor KPI Scorecard in Google Sheets

✅ Instant download · One-time payment · No subscriptionExcavation Contractor KPI Scorecard in Google Sheets

🎥 Watch more tutorials: Youtube.com/@NeoTechNavigators

Last updated: September 2026Excavation Contractor KPI Scorecard in Google Sheets