Real Estate Agent Commission Tracker Spreadsheet

The cheque at closing is never the cheque you keep. Split, brokerage fees, referral fees — this tracker shows your real take-home on any deal in about ten seconds, and keeps every deductible dollar logged for tax time.

The Commission Calculator works a deal from sale price to your pocket, including a suggested tax set-aside. The pipeline section turns your in-progress deals into an expected-GCI figure, so you can see next quarter coming. The Dashboard totals your year month by month.

WHAT'S INCLUDED

• Commission Calculator — sale price → GCI → after split, fees and referral → your take-home

• Pipeline — expected GCI from deals in progress, weighted by closing chance

• Income Log — every closing, by property and side

• Expense Log — MLS dues, listing marketing, signs & lockboxes, mileage, software, CE

• Money Dashboard — the whole year on one screen

• Annual Summary — tax-time totals by category

• Quick-Start PDF guide

FAQ

- My split is 70/30 with a cap — can it handle that? Enter your split % for the deal you're pricing; for capped plans, update the % once you pass the cap.

- Team leader? Log each closing in the Income Log; the calculator is per-deal.

- Sheets or Excel? Both, no macros.