Skip to content
Real Estate Client Tracker cover: a sample sheet with open clients and under contract and a stacked chart, beside the Dashboard and Clients tabs

Real Estate Client Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

Agents and brokerages use the Real Estate Client Tracker to follow each buyer, seller and renter from the first call to closing. The Clients tab records a person's type, area, budget or asking price, stage, agent and follow-up date. The Dashboard shows open clients, the buyer and seller value under contract, your win rate, and how the clients spread across stages and areas.

Enter budgets as the top of the price range for buyers, the asking price for sellers and the monthly rent for renters. Move each client along as the deal progresses. Rows go red when a follow-up date slips past while the client is still open, so you can call before interest fades. Renters are kept out of the value totals, because a rent figure should not be added to purchase prices.

Useful for

  • Track buyers and sellers from viewing to closing
  • Follow up with renters before their lease decision
  • Report win rate and contract value to the team

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 is the win rate worked out?

Win rate is closed clients divided by closed plus lost clients. Open clients do not count yet, so the rate reads zero until you close or lose at least one client. Apply the same rule across the team so the figures compare fairly.

Why are renters left out of the value totals?

Renters record a monthly rent rather than a price, so adding it to purchase budgets would mislead. The value figures include only buyers and sellers. Track rent totals separately if you need them.

How do I add an area?

Type the new area into the Area dropdown on the Clients tab, then include it in the Buyer and seller value by area table on the Dashboard. Clients in that area will then appear in the totals.

  • #crm
  • #real-estate-crm
  • #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…