Landscaping KPI Dashboard Template
Track revenue per man-hour, job cost variance, maintenance contract retention, and the other metrics that tell you whether your landscaping operation is running efficiently or leaving money on the table.
What's Inside This Landscaping KPI Dashboard Template
This template includes 5 worksheets, each designed for a specific part of your landscaping financial workflow:
KPI Dashboard
The main visual overview pulling your most important metrics into one screen. Pre-built charts display revenue per man-hour, gross margin by service type, maintenance contract retention rate, estimate close rate, and job cost variance — all with color-coded status indicators that turn red when a metric falls outside your target range. Whether you're reviewing the business weekly with a foreman or presenting to a lender, this tab gives the complete operational picture without opening a single other sheet. Everything updates automatically as you log jobs and contracts in the data sheets below.
Job Log
A structured log for recording each completed job — maintenance visits, installation projects, hardscaping work, tree service, and snow removal. Track job type, crew assigned, crew size, hours worked, materials cost, and billed amount for each job. Formulas automatically calculate revenue per man-hour, gross margin per job, and job cost variance (estimated vs. actual). Over time this sheet becomes your most detailed record of where each service type is profitable and where field costs are drifting from estimates. Most landscape companies find that a few jobs per week eat 80% of the margin variance, and this log is how you find them.
Monthly Scorecard
Set your targets for the month, then enter actuals as the period progresses. The scorecard covers 20 landscaping-specific KPIs: revenue per man-hour, gross margin by service type (maintenance, installation, hardscaping), maintenance contract retention rate, estimate close rate, job cost variance, labor as a percentage of revenue, materials as a percentage of revenue, active maintenance contracts, new contracts added, contracts cancelled, average job size, revenue per crew per day, equipment utilization rate, and net profit per month. Each metric shows your target, actual, variance, and a color-coded status indicator so you can see in 30 seconds which areas need attention and which are tracking as planned.
Service Mix Analysis
A breakdown of your revenue and margin by service type — recurring maintenance, landscape installation, hardscaping, tree service and irrigation, and snow removal. Each service type shows revenue, direct labor cost, materials cost, gross profit, and gross margin percentage for the period. This sheet answers the question most landscape operators can't answer off the top of their head: which service type is actually the most profitable per hour worked? Recurring maintenance often looks lower-margin per visit but produces higher revenue per man-hour due to route density. Installation projects look high-margin but frequently have estimate variances that compress actual margins. The comparison here removes the guesswork.
12-Month Trends
A rolling 12-month view of your most important KPIs plotted as line charts. See whether revenue per man-hour is improving as crews become more efficient, whether job cost variance is tightening as estimating accuracy improves, and whether your maintenance contract count is growing or shrinking over time. All charts update automatically when you complete each month's scorecard. This sheet is especially useful for understanding how seasonality actually affects your specific operation — the spring ramp-up in northern markets and the fall slowdown are obvious in a 12-month view but hard to plan around if you're only looking at the current month's numbers.
Landscaping KPI Dashboard Features
- 20 pre-loaded landscaping KPIs including revenue per man-hour and job cost variance
- Job log with per-job tracking for labor hours, materials, billings, and gross margin
- Service mix analysis — compares gross margin across maintenance, installation, and hardscaping
- Maintenance contract tracker — retention rate, new contracts, and cancellations per month
- Color-coded status indicators — green/yellow/red against your set monthly targets
- 12-month trend charts for revenue per man-hour, contract count, and gross margin by type
How to Use This Landscaping KPI Spreadsheet
Start with the Monthly Scorecard tab and set your targets before the period begins. If you're not sure what to use, the template includes benchmark ranges based on typical landscaping company performance: revenue per man-hour targets between $50–$70, gross margin targets by service type, and a maintenance retention rate target above 85%. Adjust any target that doesn't reflect your specific market or service mix. Setting the targets takes about 15 minutes and only needs to be revisited when your cost structure or service mix changes meaningfully.
After each job is completed, log it in the Job Log sheet. Enter the job type, crew size, hours worked, materials cost, and the amount billed. The formulas calculate revenue per man-hour, gross margin, and job cost variance automatically. For recurring maintenance routes, you can log the full route as a single entry or break it down by property — either works. The monthly totals feed the Scorecard and Service Mix Analysis tabs automatically, so your dashboard builds itself over the course of the month without any extra aggregation work.
Do a formal monthly review in the first week of the following month once all jobs are invoiced and logged. Open the KPI Dashboard and Monthly Scorecard side by side — the scorecard shows which KPIs hit target and which fell short, the dashboard gives the visual story. Use the Service Mix Analysis to see whether your margin by service type is moving in the right direction. The 12-Month Trends sheet is most valuable reviewed quarterly, when you can separate genuine performance improvement from seasonal noise and use the data to set the following season's pricing and staffing levels.
15 minutes from download to your first KPI review
Download the template, set your targets, and start tracking the metrics that determine whether your landscaping operation is actually profitable.
Why Every Landscaping Company Needs a KPI Dashboard
Landscaping companies typically operate at 8–15% net margins, which means inefficiencies in labor deployment or estimating accuracy hit the bottom line fast. The most common problem isn't that owners don't care about the numbers — it's that they're tracking revenue and expenses but not the operational ratios that drive profitability. Revenue per man-hour is the single most important metric for a field-service business: it tells you whether your crews are deployed efficiently, whether your pricing is right, and whether a particular service type is actually worth offering. Without a structured dashboard, most landscape companies only discover a service is underperforming at year-end, when it's too late to adjust.
Three areas drive profitability in landscaping more than anything else. First, job cost variance — the gap between what you estimated a job would cost and what it actually cost in labor and materials. In well-run operations this variance stays within 5–10%; in companies without systematic tracking, it often runs 15–25%, quietly erasing margins on every project. Second, maintenance contract retention — your recurring maintenance base is the most predictable and efficient revenue in the business, because route density keeps labor cost per visit low. A retention rate below 80% means you're spending heavily on sales and onboarding just to stay flat. Third, service mix — not all service types earn the same margin per hour, and shifting the mix toward higher-margin work is the highest-leverage thing most landscape companies can do to improve overall profitability without adding revenue.
The most effective way to use a KPI dashboard in a landscaping operation is as a weekly conversation between the owner and field supervisors, not just a monthly accounting exercise. Post the revenue per man-hour and job cost variance numbers where the crew leads can see them. Review the Service Mix Analysis monthly when deciding where to allocate equipment and crew capacity. Use the contract retention rate to flag at-risk accounts before they cancel — a customer who reduces service frequency or pushes back on a price increase is usually showing early warning signs. This template is designed to make those conversations data-driven: every metric on the dashboard traces back to actual jobs in the log, so there's a specific number behind every trend.
Landscaping Industry at a Glance
Financial templates built for landscaping companies — from lawn maintenance crews to full-service landscape design and installation firms. Pre-loaded with service categories, material line items, and project billing structures.
Revenue Drivers
- Recurring maintenance contracts
- Landscape installation projects
- Hardscaping (patios, walls, walkways)
- Tree services and irrigation
- Snow and ice removal
Key Cost Categories
- Plants and nursery materials
- Hardscape materials (pavers, stone, block)
- Crew labor (direct field wages)
- Equipment and vehicle fleet
- Payroll taxes and insurance
- Subcontractors
Typical Margins
Gross: 40-55% · Net: 8-15%
Seasonality
Strongly seasonal in northern markets — peak April through October, near-zero outdoor work in January and February. Year-round operations in southern and Pacific markets.
Key Performance Indicators
Landscaping KPI Dashboard FAQ
More Landscaping Templates
Landscaping Balance Sheet Template for Excel
$29
Landscaping Budget Template for Excel
$29
Landscaping Cash Flow Template for Excel
$29
Landscaping Expense Tracker Template for Excel
$29
Landscaping Financial Model Template for Excel
$29
Landscaping Income Statement Template for Excel
$29
Landscaping Invoice Template for Excel
$29
Landscaping P&L Template for Excel
$29
Landscaping Pro Forma Template for Excel
$29
Landscaping Project Budget Template for Excel
$29
Landscaping Sales Forecast Template for Excel
$29
Landscaping Business Valuation Template for Excel
$29
More KPI Dashboard Templates
Landscaping KPI Dashboard Template
$29