Real Estate Agent Tracker Spreadsheet | Commission Calculator, Listing Pipeline and Follow-Up Log for Realtors

Listings in one place, buyer searches in another, commission math on a sticky note, follow-ups in your head. This tracker puts your own pipeline in one Google Sheet: every listing and buyer deal by stage, every commission figured the same way every time, your expenses and miles logged by month, and every follow-up with a next step and a due date.

This is an organization and calculator tool. It tracks what you enter and calculates commissions from the percentages and fees you type in. It does not find clients, and it makes no promise about sales or income — it simply keeps your numbers organized and your math consistent.

A DIFFERENT TOOL, A DIFFERENT JOB — This is not our Real Estate Transaction Tracker, and it does a different job. That tracker follows a single transaction — its paperwork and closing costs from contract to close. This one follows you: your whole pipeline, your splits and referral fees, your net on every deal, your goals and your follow-ups. Some agents run both.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

THE 6 TABS

Start Here — plain-English quick start, the commission method in full, and your settings: the mileage rate used on the Expenses tab, your annual net commission goal, your annual closed-deals goal, and your tax set-aside %

Dashboard — pipeline counts and list volume by stage, closed volume, net commission received, expected commission from pending deals, goal progress against the annual goals you set, your tax set-aside figure at your own percentage, this month's expenses and mileage, and open follow-ups — all formula-driven

Listings & Pipeline — one row per listing or buyer search: address, city, side (Seller or Buyer), stage (Active, Under Contract, Pending Close, Closed, Expired), list date, list price, contract date, expected close and actual close

Commission Log — one row per deal: sale price, gross commission %, agent split % and the fees taken out of your share. Gross commission, your share and net to agent figure themselves out; mark each deal Paid or Pending

Expenses & Mileage — log what you spend and the miles you drive; mileage value uses your rate from Start Here, and the monthly summary totals each month by itself

Contacts & Follow-Up — one row per person: name, type (past client, seller lead, buyer lead, referral partner, vendor), last contact, next step, due date and status (Open or Done)••••••

HOW COMMISSION IS FIGURED — ONE METHOD, NO HIDDEN MATH

Gross Commission = Sale Price × Gross Commission %. Agent Share = Gross Commission × Agent Split %. Net to Agent = Agent Share − Fees, where the Fees column is every amount taken out of your share on that deal: the brokerage / transaction fee and any referral fee you paid on it. Worked sample in the sheet: a $678,000 sale at 2.50% is $16,950 gross; at an 80% split your share is $13,560; less $495 in fees, net is $13,065. Change any percentage or fee on a row and that row's numbers follow it.

GOALS AND TAX SET-ASIDE

Set an annual net commission goal and an annual closed-deals goal on Start Here (samples: $150,000 and 12) and the Dashboard shows what percentage of each your Paid deals have reached — the samples sit at 41.9% of the net goal. The Dashboard also shows a tax set-aside figure: your net received times a percentage you choose (sample: 25%). It is a simple planning percentage, not a tax calculation, and this sheet is not tax or financial advice — for anything tax-related, ask your accountant.

THE SAMPLE DATA

It comes loaded with fictional samples — 12 invented listings, 6 commission deals, sample goals and a sample tax set-aside, a September–October expense and mileage log, and 10 contacts with fictional 555 phone numbers — so you can watch every formula work before you delete the samples and type your own. Formulas are pre-filled down the columns — 30 pipeline rows, 20 commission rows, 20 expense rows and 20 contact rows, ready to go.

FINISHED FILE

This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and it works on your phone or computer.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.