Skip to the content.

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

  1. List regular clients with their main service, visit interval and assigned employee.
  2. Log each completed visit on Service History.
  3. Check Next service due and Days overdue, then work through the Retention tab.
  4. 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.

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.

All free templates