Tree Care Services KPI Scorecard in Google Sheets

The Tree Care Services KPI Scorecard in Google Sheets tracks 10 KPIs in four groups (Operations & Productivity, Quality & Safety, Sales & Growth, Financial) on one Scorecard page. Pick a month, switch between MTD and YTD, and compare against Target or Prior Year (PY). Every card shows the actual value, the comparison value, the change, the change % with an arrow, a traffic light and a Jan to Dec mini trend, and a separate KPI Trend page charts Actual vs Target vs PY for any KPI.

This listing is the KPI scorecard line: a ten-card monthly review sheet. It is not one of our analytical Google Sheets dashboards and not the larger GS KPI Dashboard family. The sample file opens on December, MTD vs Target, with 4 green, 3 amber and 3 red lights. All figures in it are fictional sample data.

✅ Instant download · One-time payment · No subscription · No per-user fees

🔑 Key Features of the Tree Care Scorecard

📅 Three selectors, one page. The header holds a Select Month drop-down (Jan to Dec), an MTD/YTD switch and a Target/PY switch. Every card, light, change figure and mini trend recalculates from those three cells, so one sheet answers “how did December go against target?” and “is this year running ahead of last year?”.

🚦 Traffic lights that respect KPI direction. Six KPIs are upper-the-better (UTB) and four are lower-the-better (LTB). Equipment Downtime, Callback / Rework Rate, Safety Incident Rate and Debtor Days are scored as improving when they fall, so a rise in debtor days never shows up as good news.

📈 12-month mini trend on every card. Each of the ten cards carries a small column trend for Jan to Dec, with the highest month in green and the lowest in red, so a weak month stands out without opening another tab.

🧮 Formula and definition for each KPI. The KPI Definition sheet lists group, unit, formula, definition and UTB/LTB type, for example Revenue per Crew Day = Total Revenue / Total Crew Days Worked.

📦 What’s Inside the Tree Care Services KPI Scorecard in Google Sheets

Page 1: Scorecard

Ten KPI cards in two rows of five: Crew Utilisation Rate, Job Completion Rate, Equipment Downtime, Callback / Rework Rate, Safety Incident Rate, Estimate-to-Close Ratio, Customer Satisfaction Score, Average Job Value, Revenue per Crew Day and Debtor Days. In the December sample, Crew Utilisation Rate reads 71.9 against a target of 61.8 (green) while Revenue per Crew Day reads 2,531.7 against 2,683.6 (red).

Page 2: KPI Trend

Choose any KPI from a drop-down to see its group, unit, type, formula and definition, plus two charts: Actual vs Target vs PY (MTD) and Actual vs Target vs PY (YTD), each by month.

Page 3: KPI Definition

The master list of the 10 KPIs with KPI Group, Unit ((%), (per 100k hrs), (score), ($) and (days)), Formula, Definition and Type. The Scorecard and KPI Trend pages read their names and types from here.

Page 4: Input Data

One block per KPI (KPI-1 to KPI-10), twelve month rows each, with six typed numbers per month: MTD Actual, Target and PY, and YTD Actual, Target and PY. A full year is 120 rows.

The file also holds a Read Me tab, a Color Settings tab and two helper sheets (Support and Trend_Support) that do the lookups.

📊 Tree Care Scorecard vs. Excel Dashboard vs. Field Service Software: Where This Fits

For tree care companies that want a clear monthly KPI review without paying for a full operations platform, this scorecard sits in the sweet spot.

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

✅ Built for:

• Owners of small tree service companies who already keep monthly totals and want one page to review them
• Operations managers comparing crew utilisation, job completion and equipment downtime against target or last year
• Office and finance staff watching estimate conversion, average job value and debtor days

❌ Not for:

• Teams that need crew scheduling, quoting, GPS or invoicing; this sheet only reports numbers you type
• Anyone looking for a safety incident log or compliance record; Safety Incident Rate is a monthly figure you enter, not an incident register
• Per-crew or multi-branch roll-ups; the grain is one row per KPI per month

⚙️ How to Use the Scorecard

1. Open the PDF in your download and click the link to make your own copy in Google Drive.
2. Apply the two quick fixes listed below (June/July and the Equipment Downtime colour).
3. On KPI Definition, keep or rename the 10 KPIs and set each Type to UTB or LTB.
4. On Input Data, type the same KPI names and enter MTD and YTD Actual, Target and PY for each month.
5. On the Scorecard, choose the month, MTD or YTD, and Target or PY, then open KPI Trend to review any KPI by month.

⚠️ Known Limitations and One-Minute Fixes

We exported the live sheet and checked its formulas before listing it. Five points to know:

• June and July break the cards. The Select Month list offers “June” and “July” while Input Data stores “Jun” and “Jul”, and the card lookups match the exact text, so all ten cards show zeros and broken lights for those two months. Fix: click Scorecard cell N1, open Data > Data validation, and change June to Jun and July to Jul.
• Equipment Downtime change colour. Both colour rules on that card use red, so its change figure and arrow stay red even when downtime falls. In the sample, -0.3 against target is an improvement but prints red. Fix: in Format > Conditional formatting on N6:N7 and M7, set the “Green” rule’s text to green.
• Color Settings is not connected. The traffic-light bands are hardcoded on the Support sheet (Z4:AA6 for upper-the-better, AC4:AD6 for lower-the-better). By default an upper-the-better KPI is red at or below its comparison value, amber up to 10% above it and green only beyond 10%; a lower-the-better KPI is green at or below, amber up to 10% above and red beyond. Edit Support, not Color Settings, to change them.
• Read Me is empty, and YTD values are typed rather than calculated from the MTD rows.
• Header selector text is hard to read. The month, MTD/YTD and Target/PY values print in dark text on the navy header; select N1, Q1 and V1 and set the font to white.

💼 Real-World Use Cases

Tom runs three crews for a residential tree service. At month end he types the totals, sets the scorecard to MTD vs Target and checks Crew Utilisation Rate and Revenue per Crew Day first, because together they show whether paid crew days turned into billable work.

Elena manages the office for a commercial tree care contractor. She switches to YTD vs PY to see whether Estimate-to-Close Ratio and Average Job Value are ahead of last year, then opens KPI Trend to show the owner which months slipped.

Raj looks after cash collection. He keeps an eye on the Debtor Days card; when it turns red he chases overdue invoices before the next busy season.

❓ Frequently Asked Questions

What KPIs does this tree care scorecard track?

It tracks ten: Crew Utilisation Rate, Job Completion Rate, Equipment Downtime, Callback / Rework Rate, Safety Incident Rate, Estimate-to-Close Ratio, Customer Satisfaction Score, Average Job Value, Revenue per Crew Day and Debtor Days, in four groups with a formula and definition for each.

How long does setup take?

Copying the sheet takes a minute and the two fixes take another. The real work is data entry: 10 KPIs times 12 months is 120 rows, each with six numbers. Once those are in, every card, light and chart updates on its own.

Why do the cards show zeros when I pick June or July?

The month list spells them June and July while the data uses Jun and Jul. Open Data > Data validation on Scorecard cell N1 and change the two entries to Jun and Jul; the cards fill immediately. The KPI Trend page is not affected.

How does this compare to Jobber or SingleOps?

Those tools run scheduling, quoting and invoicing on a subscription. The Tree Care Services KPI Scorecard in Google Sheets does none of that; it is a one-time purchase for reviewing monthly KPIs you already collect, and it can sit alongside such software.

Does it cover safety standards, certification or insurance reporting?

No. Safety Incident Rate and Callback / Rework Rate are simply numbers you enter and compare to target. The template makes no safety-standard, certification, licensing or insurance claim, and the sample figures are fictional.

Is there an Excel version?

Separate Excel editions of the tree care scorecard and the tree care KPI dashboard are in preparation. They are different builds, not a download of this Google Sheets file.

👤 About the Author

Built by PK, with 15+ years of Excel, Google Sheets and Power BI experience and founder of NextGenTemplates. Tutorials on YouTube: @PKAnExcelExpert, @NextGenTemplates and @NeoTechNavigators. Google’s own help pages explain the two features this sheet relies on: in-cell drop-down lists and conditional formatting rules.

🔗 Explore Related Templates

More ten-KPI scorecards for outdoor and field trades in the same format: Fencing Contractor KPI Scorecard in Google Sheets, Excavation Contractor KPI Scorecard in Google Sheets, Demolition Services KPI Scorecard in Google Sheets, Equipment Rental Business KPI Scorecard in Google Sheets and Garage Door Service KPI Scorecard in Google Sheets.

Need charts and slicers instead of KPI cards? The analytical Landscaping Dashboard in Google Sheets is a different product family. Browse all Google Sheets KPI templates or every Google Sheets 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