Find out which jobs actually made money

A Google Sheets tracker for landscaping, cleaning and handyman crews. Log what you budgeted and what a job actually cost, and it flags the moment one runs over.

$19 Not on sale yet. The storefront opens shortly.

The sheet as it ships, with 8 sample jobs already in it. Every column from Total Actual Cost on is a live formula.

Before and after

If a quote is the last time anyone looks at a job's numbers, you find out it lost money only when the bank balance looks thin at the end of the month, long after the crew that ran it has moved on to the next one.

Now

A job runs long or over on materials and nobody notices.
Profit per job is a guess, not a number.
The same pricing mistake repeats on the next similar job.
Margin is only checked when the month already looks bad.

With this sheet

Actual cost, profit and margin total themselves per job.
A Status column flags Over Budget the moment it happens.
A summary shows total profit and average margin at a glance.
Next quote gets priced off what a job actually cost, not memory.

What is inside

Job Costing Tracker tab: a job log of client, job description, quoted price, budgeted and actual labor, budgeted and actual materials. Total Actual Cost, Profit, Margin % and a Status column all fill in on their own as live formulas.
Job Summary block: total quoted, total actual cost, total profit, average margin and how many jobs are currently over budget, rolled up from the log automatically.
Instructions tab: a six step quickstart, done in under five minutes.
Sample data included: 8 realistic jobs across a landscaping, cleaning and handyman client mix, split between jobs that came in on budget and jobs that ran over, so the Status column shows real variety the moment you open it.

Who it is for

Owner-operators and office managers at 2 to 20 person service businesses: landscaping crews, cleaning companies, handyman and trade contractors who quote a job, then never check whether it actually made money once labor ran long or materials cost more than planned.

Questions

Do I need Google Sheets or Excel?

Google Sheets, free with any Google account, is the primary format. The formulas also work in Excel.

Will this work for a trade that is not landscaping?

Yes. The job log columns are generic to any job based service business.

Can I add more jobs?

Yes. Insert rows inside the job log block, not below the summary, and copy the Total Actual Cost, Profit, Margin % and Status formulas down. The summary picks them up.

Does this replace my quoting sheet?

No. It is built to sit next to the Job Quote Calculator template, so what you quoted a job for traces straight through to what it actually cost.

Try it free first

A free, 3 job cut of this tracker, with the same live Total Actual Cost, Profit, Margin % and Status formulas as the full version. The full version above covers 8-plus jobs and adds the Job Summary rollup and the instructions tab.

Email capture for the free file is not wired up yet. Check back soon, or buy the full Job Costing Tracker below.