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
- Add each job with customer, service, date and crew.
- Move Status along as the job is completed, invoiced and paid.
- Fill quoted and final amounts, materials cost and labor hours.
- 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.
- Jobs (6 sample rows)
Related templates
- Free Google Sheets Work Order Template
- Free Google Sheets Invoice Tracker
- Free Google Sheets Dispatch Schedule
When you outgrow it
Smarfle flags finished jobs that were never invoiced and shows profit per job. See how it works on smarfle.com.