Free Google Sheets Client Tracker
For recurring service businesses, lawn, pest, pool and cleaning, where revenue depends on knowing which regular clients are due, overdue or quietly slipping away.
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 Clients and Service History, no typing needed. |
| Clients | Columns Client ID, Client name, Phone, Email, Service address, Service area, Main service, Recurring interval, Custom days and 9 more. |
| Service History | Columns Visit ID, Client ID, Visit date, Service, Employee ID, Amount charged, Completed and Notes. |
| Retention | Totals and views built from Clients and Service History, no typing needed. |
| Settings | Your own dropdown lists (recurring interval, unit, interval value, employee id and employee name), so the choices match how you work. |
How to fill it in
- List regular clients with their main service, visit interval and assigned employee.
- Log each completed visit on Service History.
- Check Next service due and Days overdue, then work through the Retention tab.
- Use the Service message column to tell a client their visit is due.
A tip from the field
Record a cancel reason when a client stops. After a season you will see whether you lose people to price, timing or quality.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Clients (8 sample rows)
- Service History (12 sample rows)
Related templates
- Free Google Sheets CRM Template
- Free Google Sheets Scheduling Template
- Free Service Contract Template
When you outgrow it
Smarfle sends maintenance reminders and creates recurring visits, so due clients never depend on someone checking a sheet. See how it works on smarfle.com.