Skip to content
Client Tracker cover: a sample sheet with active clients, monthly fees and renewals in 60 days and a bar chart, beside the Dashboard and Clients tabs

Client Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Account managers and small agencies use the Client Tracker to keep every retainer client in one place. On the Clients tab each client has an account owner, service, monthly fee, start date, renewal date, health (Healthy, Watch, At risk or Churned) and last contact date. The Dashboard totals monthly fees from clients who have not churned, counts renewals due in the next 60 days and breaks fees down by service.

Enter each client once, then update the health column after every check-in. Set renewal dates early enough that the dashboard flags them with weeks to spare. Churned clients stay on the list for your records, but they drop out of the fee totals. Review the At risk rows each week with the account owner.

Useful for

  • Watch monthly fees across a retainer client base
  • Plan renewal calls ahead of each contract date
  • Spot clients whose health has slipped

What's included

  • 3 tabs: Dashboard, Clients, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Clients: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Clients tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How should I score client health?

Agree a simple rule with your team. Healthy means the client is paying and engaged, Watch means an issue is open, At risk means they have raised concerns or gone quiet, and Churned means they have left. Keep the rule in your team notes so everyone uses it the same way.

Why keep churned clients on the list?

Keeping them lets you review past work, spot patterns and check what happened before a client left. The fee and renewal totals skip them, so the dashboard shows only what you earn now.

How do I add a service type?

Type the service name into the Service dropdown on the Clients tab, and list it in the Fees by service breakdown on the Dashboard. Without that step, its fees will not reach the chart.

  • #crm
  • #client-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More crm templates

See all 9

Also in Sales

All sales templates
Get this template

Preparing your template…