Real Estate Agent Commission & GCI Tracker — Track Your Split, Cap, Net Commission & GCI Goal

🔥 Real Estate Agent Commission & GCI Tracker — Instant Download Template

Know your net on every deal, see how close you are to cap and work backward from your GCI goal.

A ready-to-use Excel workbook for real estate agents. It logs every deal with GCI, brokerage split, annual cap, team split, royalty and fees, then shows your net, cap progress, pending pipeline, business expenses and a GCI goal plan on a live Dashboard. Seven working tabs plus START HERE and Settings, in one file.

✨ What You Get Inside

- START HERE: step-by-step setup, a map of every tab and my contact email

- Settings: agent split, annual cap and cap anniversary date, team split, transaction fee, E&O fee, royalty % with a royalty cap, mileage rate, GCI goal and goal year, appointment-to-closing and lead-to-appointment rates, an optional average GCI override, working weeks and every dropdown list

- Transactions: GCI after referral fee, cap year, brokerage share before and after cap (counted in date order), team split, royalty with its cap, transaction and E&O fees, net to you and effective split (formulas and dropdowns filled down to row 500)

- Commission Calculator (printable): a one-deal what-if using your current cap-year totals or amounts you type, plus 5 price scenarios

- Cap & Fees: current cap year dates, paid toward cap, remaining, progress, status, GCI still needed to cap, royalty and fees paid, and a 12-month table

- Pending Pipeline: projected GCI, close probability by stage (editable on Settings), weighted GCI, days since contact, and Follow up / Update close date reminders (formulas and dropdowns filled down to row 500)

- Business Expenses: 8 expense categories, with miles converted at your Settings rate (formulas and dropdowns filled down to row 500)

- GCI Goal Planner: goal to closings to appointments to leads needed, targets per year, month and week, and monthly goal vs actual closed GCI with goal to date and ahead / behind

- Dashboard: 8 KPI cards and 3 charts (monthly GCI vs goal, closed GCI by lead source, cap progress)

💡 Who This Is For

- Agents on a brokerage split with an annual cap

- Agents at franchise brokerages who pay a royalty fee

- Team members who pay a team split

- Agents with a yearly GCI goal who want weekly lead and appointment targets

🔄 Before & After Using This Template

- Before: Not sure what you will actually take home / After: Net to you and effective split on every deal, after split, cap, royalty and fees

- Before: Losing track of your cap / After: Paid toward cap, cap remaining and GCI still needed to cap for the current cap year

- Before: A GCI goal with no plan behind it / After: Closings, appointments and leads needed per year, month and week

🏆 What Makes This Template Better

- Every deal you log updates your cap, goal progress and Dashboard, so you never copy numbers between sheets

- Live formulas throughout, so totals, flags and charts update as you type

- Every dropdown list lives on Settings, so you can rename items to fit your business

- Formula cells are pre-locked and shaded gray; sheet protection is off, so you can switch it on to prevent accidental edits

- Rows marked EXAMPLE DATA show how each tab works before you add your own numbers

- One ready .xlsx file: no zip to unpack

⚡ Get Results in Minutes

- Download instantly

- Open in Excel 2019 or later, Microsoft 365, or Google Sheets

- Enter your split, cap and fees on Settings and replace the EXAMPLE DATA rows

- Start using it immediately

Compatibility: Works in Excel 2019 or later, Microsoft 365, or Google Sheets. No macros.

Sample data is fictional. Replace it with yours.

🔒 Instant Access

Once you purchase, you get immediate access to your files.

Need it tailored? Get a Custom Build of this kit built around your business: https://payhip.com/b/Vs6m3

We’re a new store, but our digital tools are built to save you time, simplify your workflow, and help your business grow. Your trust matters — and every product is designed to deliver real results.

Thank you for supporting a growing brand.

— Kyle P. Herrick, Founder

✔️ Satisfaction Guarantee

If this template doesn’t help you save time or improve your workflow, message me and I’ll make it right. Your success matters.

💬 Need Help?

Message me anytime — I’m here to help you get the most out of your templates. You can also email herrickkyle87@outlook.com (the address is on the START HERE tab too).

🚀 Ready to Use This Template?

Click “Buy Now” to get instant access and start using it today.

Organization tool only; not tax, legal, accounting or financial advice.