Real Estate Agent Commission & Expense Tracker

KNOW WHAT EVERY DEAL REALLY PAYS YOU.

WHY THIS ONE

• The cap math done right: your brokerage split stops exactly at your cap, and a deal that crosses the cap only pays up to it. Franchise royalty works the same way with its own cap.
• Everything in one file: every deal from lead to close, GCI, split, royalty, fees, net, expenses, mileage, tax set-aside and lead-source results. No add-ons to buy.
• Built for real use: gray cells are the only place you type, and formulas are protected so nothing breaks.
• Buy once: no subscription, no app, no monthly fee.

For real estate agents and realtors on any split, with or without a cap: buyer side, listing side, both sides, leases and referrals.

WHAT IT DOES

• Settings: your split (70/30, 80/20...), cap per cap year and your cap anniversary date, franchise royalty % and royalty cap, transaction fee and E&O fee per deal, tax set-aside %, net income goal and the 2026 mileage rates.
• Deals: client, address, side, stage (lead, showing, under contract, closed, fell through), lead source, price and commission % or a flat fee, close date and referral fee. GCI, referral paid, brokerage split, royalty, fees and NET TO YOU fill in.
• Pending deals use what's left of your cap, so pending net is real.
• Expenses: MLS + board dues, desk fees, marketing, photos + signs, client gifts, licensing, E&O, CRM and more.
• Mileage: showings and appointments with the IRS rate by date.
• Monthly: closed deals, volume, GCI, split + royalty, fees, NET COMMISSION, expenses, mileage, profit and tax set-aside, every month.
• Cap progress, left until you cap, pending GCI and net, net goal progress, and which lead sources actually close.
• Overview dashboard with a net-by-month chart.
• A Start Here tab with step-by-step instructions.

WHAT THIS IS NOT (no surprises)

• Not a CRM or transaction-management system.
• Not tax advice: the set-aside is an estimate. Check splits and fees against your brokerage agreement.

Works In: Google Sheets (free Google account) on a computer or phone, AND Microsoft Excel: a tested Excel version (.xlsx) is included for Excel 365, Excel 2021 or newer, and free Excel for the web.

What You Get: a PDF with a link to make your own copy in your Google Drive, plus a download link for the Excel version. Digital product.

Great for: Realtor Tracker, Real Estate Agent, Commission Tracker, GCI Tracker, Realtor Spreadsheet, Brokerage Split, Commission Cap, Agent Business Plan, Realtor Expenses, Real Estate Leads, Mileage Log, Realtor Gift, Google Sheets