Skip to content
ClientPlot

Free Customer Tracker Template

If you say customers, jobs, and callbacks, this is the sheet. It is built for service businesses that keep a customer list in Excel: who they are, what job is open, when you last spoke, and who needs a call back.

Download ExcelDownload CSVOpen This as a Dashboard

Excel and CSV included. For Google Sheets, download CSV and use File > Import, or click Open Google Sheets and upload the file.

Example

Sample rows so you can see how the tracker is meant to be used.

Free Customer Tracker Template sample data
CustomerCompanyEmailPhoneJobStatusLast ContactNext Follow-UpDue DateAssigned ToNotes
Elena RuizRuiz Residenceelena@email.com(555) 310-1001Deck stainingScheduled2026-08-182026-08-232026-08-27ChrisWater shutoff at the side yard. Dog is friendly.
Tom HaleHale HVACtom@halehvac.com(555) 310-1002Office mini-split installQuoted2026-08-142026-08-212026-09-04ChrisQuote 4412. Waiting on their landlord approval.
Priya ShahShah Household(555) 310-1003Fence repairWaiting2026-08-092026-08-222026-08-26DeeWaiting on lumber delivery.
Metro DeliMetro Delimgr@metrodeli.com(555) 310-1004Walk-in cooler serviceIn progress2026-08-202026-08-212026-08-21DeeAfter close, 8pm start. Rear alley access.
Jonah LeeLee Rentaljonah@email.com(555) 310-1005Unit 2 turnover paintActive2026-08-162026-08-242026-08-30ChrisNeeds to be rent-ready before Sept 1.

Your spreadsheet stores the data. ClientPlot helps you work from it.

Import this tracker into ClientPlot and see clients, follow-ups, deadlines, tasks, and upcoming work in one dashboard.

Dashboard preview

This is the workspace shape, not a chart wall.

5
Active clients
5
Open jobs
0
Tasks due
1
Waiting
5
Upcoming dates
2
Team members

Upcoming schedule

  • 2026-08-21 · Office mini-split install · Tom Hale
  • 2026-08-21 · Walk-in cooler service · Metro Deli
  • 2026-08-22 · Fence repair · Priya Shah
  • 2026-08-23 · Deck staining · Elena Ruiz
  • 2026-08-24 · Unit 2 turnover paint · Jonah Lee
Turn This Spreadsheet Into a DashboardImport my own file

What is in the template

Customer, company, contact info, job, status, last contact, next date, assigned technician or owner, and notes such as gate codes or site details.

Customer

The person you talk to.

Company

Business or household name.

Email

Email if you have one.

Phone

Best number to call back.

Job

The current job or service.

Status

Quoted, scheduled, in progress, waiting, done.

Last Contact

Last call, visit, or text.

Next Follow-Up

Callback or check-in date.

Due Date

When the job should be finished or started.

Assigned To

Technician, lead, or owner.

Notes

Site details, quotes, preferences.

Who it is for

Contractors, shops, and small service teams that have outgrown a notebook but are not trying to install a full CRM.

How to use it

  1. 1. One row per customer, not per invoice

    Repeat jobs stay on the same row. Put the current job name in the Job column and update it when the next one starts.

  2. 2. Put callbacks in Next Follow-Up

    A quote you never called back on is a job you donated to a competitor.

  3. 3. Keep site notes in Notes

    Dogs, lockboxes, and 'use the side gate' belong here, not in a group text.

When a spreadsheet starts becoming difficult

  • Callbacks live in voicemail
  • The job details are in one person's phone
  • You cannot see which customers have gone quiet
  • Quotes sit in a folder with no chase date

Customer pages with the job attached

ClientPlot stores the customer once and lets jobs and tasks hang off that record.

A calendar of scheduled work

Due dates and follow-ups show up on a calendar instead of a buried column.

Assignment that is visible

Who owns the customer or the job is a field you can work from, not a highlight color.

Frequently asked questions

Is a customer tracker the same as a client tracker?

Same idea, different language. Use this version if your business talks about customers and jobs. Import either sheet into ClientPlot the same way.

Can I track more than one job per customer?

In the spreadsheet, keep the current job on the row and move finished jobs to notes. In ClientPlot, add multiple jobs under the same customer.

Does this do invoicing?

No. It tracks the operational side: who, what job, when, and who is assigned. Attach invoices in whatever you already bill from.

Related resources