Can I use it for maintenance contracts?

Yes. Treat a season as the job, the contract value as the revenue, and the visits as your labor category.

How do I handle change orders?

Add them to the contract value and to the actuals. A job that grew by $4,000 of extras is not the job you estimated.

Does this work in Excel and Google Sheets?

Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.

Should I measure margin against the estimate or the actual?

Always the actual. Measuring against the estimate tells you how good your forecast was, which is useful, but it is not profit.

I'm not confident with spreadsheets. Will I manage?

Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

Home → Tools → Landscaping Job Profit Tracker

Landscaping Job Profit Tracker

The yard got finished, the invoice got paid, and you still don't know what the job earned.

Compare what a landscaping job was estimated at against what it actually cost, and find which part of the yard ate the margin.

$39 USD · one-time

Buy on Etsy · $39Gumroad coming soon

Instant download · Excel & Google Sheets · works on Mac and Windows · on Etsy today, Gumroad soon

Landscaping Job Profit Tracker dashboard

Who it's for

Made for the way you actually work.

Landscapers who price the next yard off what the last one really cost
Crews whose labor hours grow between the estimate and the invoice
Grounds contractors running installs and maintenance seasons side by side
Solo operators who can name their revenue but not their profit

What's included

Everything in one file.

Dashboard: True margin, variance and cumulative profit. Read-only.
Start Here: Five steps from opening the file to a real number on screen.
Job Costing: Where you close out one job. The main working sheet.
Job Log: Every job you have closed, and cumulative profit across them.
Settings: Your target margin and the cost categories you track.
Instructions: What each sheet does, and what to do if a number looks off.
About: Version, license and support.
PDF Quick-Start Guide: two pages, first result in five minutes

How it works

Three steps to a number you trust.

Open Settings. Set the margin a job is supposed to earn, and edit the cost categories to match how you break one down.
Open Job Costing. Name the job, enter the Contract value excluding tax, and the date it completed.
Enter your estimate for each category, the numbers you worked from before you started.

A look inside

The screens you'll be working in.

List of the eight sheets in the landscaping job profit tracker

Job Costing sheet comparing estimated and actual cost by category

Job Log sheet with every closed job and cumulative profit

Settings sheet with target margin and cost categories

Three steps: enter the estimate, enter the actuals, read the margin

Compatibility: works in Google Sheets and Microsoft Excel 365

Questions

Good to know.

Can I use it for maintenance contracts?: Yes. Treat a season as the job, the contract value as the revenue, and the visits as your labor category.
How do I handle change orders?: Add them to the contract value and to the actuals. A job that grew by $4,000 of extras is not the job you estimated.
Does this work in Excel and Google Sheets?: Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.
Should I measure margin against the estimate or the actual?: Always the actual. Measuring against the estimate tells you how good your forecast was, which is useful, but it is not profit.
I'm not confident with spreadsheets. Will I manage?: Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

One mispriced job costs more than this.

$39 once, and it's yours to keep. It pays for itself the first time it stops you underpricing a job or leaving margin on the table. No subscription, no login, just a file that does the maths.

Buy on Etsy · $39Gumroad coming soon

Related tools