Description
Real Estate Agent Commission & GCI Tracker
A real estate agent commission and GCI tracker. Log every deal and it works out GCI, referral fee, brokerage share, transaction fee, net commission and days to close. The Goal Planner works back from your GCI goal to the deals, appointments and leads you need each month.
Who it’s for
Real estate agents, new and experienced, team leads tracking their own production, and agents who want a simple business plan for next year.
What’s inside
- Start Here – a 5-step quick-start guide inside the file
- Dashboard – KPI tiles, monthly GCI vs net, GCI by lead source and by buyer / seller side.
- Transactions – Every deal with GCI, referral fee, brokerage share, transaction fee, net commission and days to close.
- Goal Planner – Deals, appointments and leads you need to hit your GCI goal, per month.
- Expenses – Dues, marketing, photography, signs, software, insurance and mileage.
- Monthly Summary – Closings, volume, GCI, splits and fees, net commission, expenses and cumulative GCI.
- Settings – Your goal, default split, conversion rates and dropdown lists.
Features
- Transactions log with side, type, lead source, status, contract and close dates
- GCI, referral fee, brokerage share, transaction fee and net commission per deal
- Split entered per deal, so caps and team splits are easy to record
- Pending GCI from deals under contract
- GCI Goal Planner: deals, appointments and leads needed per month
- GCI by lead source and by buyer / seller side
- Monthly summary with closings, volume, GCI, splits, net, expenses and cumulative GCI
- Dashboard with 8 KPI tiles and 3 charts
How delivery works
- Instant download right after purchase: the .xlsx workbook plus a step-by-step Setup Guide PDF.
- Works in Microsoft Excel (Windows, Mac, Excel for the web) and Google Sheets (upload to Google Drive and open with Google Sheets, or File > Import).
- Comes with realistic sample data so you can see how it works, and clear instructions to remove it.
- No macros, no add-ons, no subscriptions. Pay once, use it for as long as you like.
FAQ
Does it handle a commission cap?
Enter your agent split on each deal. After you hit your cap, enter 100% on the next deals.
Is it a CRM?
No, it tracks deals and income. If you need lead follow-up, see our Real Estate CRM & Lead Pipeline Tracker.
Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets, or use File > Import. Formulas, dropdowns and charts carry over.
For tracking and planning only, not tax or legal advice.
This is a digital product. No physical item will be shipped.
Want your own store like this one? createdigitaltools.com runs on Hostinger WordPress hosting. Start your own shop with Hostinger, or try the no-code Hostinger Website Builder.
Affiliate links: I may earn a commission at no extra cost to you.