Skip to the content.

Free Google Sheets Job Tracker

For an owner who wants every job from booked to paid on one list, with labor and materials, so the profit on each job is visible.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Jobs, no typing needed.
Jobs Columns Job ID, Customer, Phone, Service address, Service, Job date, Crew or technician, Status, Quoted amount and 9 more.
Settings Your own dropdown lists (job statuses, crew or technician and services), so the choices match how you work.

How to fill it in

  1. Add each job with customer, service, date and crew.
  2. Move Status along as the job is completed, invoiced and paid.
  3. Fill quoted and final amounts, materials cost and labor hours.
  4. Check Profit and the alerts for jobs finished but never invoiced.

A tip from the field

The alert for completed jobs that were never invoiced pays for itself. Look at it every Friday.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle flags finished jobs that were never invoiced and shows profit per job. See how it works on smarfle.com.

All free templates