Real Estate Agent Tracker | Commission, GCI & Deal Pipeline CRM Spreadsheet | Google Sheets, Excel

Description

Real Estate Agent Tracker — Run your real estate business like a business. This tracker gives you a deal pipeline that calculates your commission and net on every deal, a leads tracker, and live progress toward your annual GCI goal – all in one file.

What’s inside your Real Estate Agent Tracker

Editable in Google Sheets and Microsoft Excel. Change a deal’s status or price and your whole dashboard updates.

What It Does

• Dashboard: your closed GCI year-to-date, your pipeline GCI, how many deals you’ve closed, your percent to goal, and your net income after split and expenses – with charts
• Deals: your pipeline from Lead to Active to Under Contract to Closed. Enter the sale price, your commission rate and your split; GCI and your net are calculated for each deal
• Leads: every contact, their source, stage and next follow-up – so nothing slips
• Goals and Expenses: your annual GCI target and your business costs, so you track net income, not just gross
• How to Use: GCI vs net vs income, and why your pipeline is your future paycheck

Calculates

• GCI per deal – sale price times your commission rate
• Your net per deal – GCI times your brokerage split
• Closed GCI (year-to-date) and pipeline GCI, by status
• Percent to your annual goal, and net income after expenses (cross-checked two ways)

Built for how commissions work now: since the 2024 NAR settlement, commissions are negotiated per deal, not fixed. The commission rate is fully editable on every deal, so your numbers match your actual agreements.

Your pipeline is your future income: closed GCI is the past; your active and under-contract deals are next quarter’s paycheck. This tracker keeps both in view, so you always know your number.

Who it’s for

New agents getting organized, top producers keeping the pipeline full, team leads who want one clear view, and any goal-driven agent who wants every deal to move them toward their target.

Explore more in our Real Estate Calculators collection, or open it in Google Sheets.

Frequently asked questions

How is it delivered?
Instant download in Google Sheets, Excel & PDF — available right after checkout, with lifetime access.

Is it ready to use?
Yes — the formulas are built in. Enter your own numbers and it calculates automatically.