Download free commission tracker & split calculator template
A $15,000 commission rarely arrives whole. By the time a referral fee, a brokerage split and a team cut are subtracted, what lands in an agent's account can be hard to predict — this workbook does that math for every deal, automatically.
Download for free
What is the commission tracker & split calculator template
Picture a closed deal: $450,000 sale price, 3% commission, a 30% brokerage split, maybe a referral fee on top. Doing that math once is easy. Doing it correctly across twenty-five deals a year, for five different agents, with five different split arrangements, is where spreadsheets quietly fall apart and disputes start. This workbook exists to make sure they don't.
Open it and a Deal Log is already populated with twenty-five sample closings, each one carrying its sale price, referral percentage, brokerage cut and final agent payout calculated automatically. Replace the sample rows with real deals whenever it suits you, in Excel or in Google Sheets, and every downstream number — agent totals, brokerage revenue, payout accuracy — keeps recalculating on its own.
Why commission accuracy matters for real estate teams
An agent who closes eight deals a year and gets shortchanged on even one of them notices. They always notice. Commission is the one number nobody on a sales team is casual about, and a single payout error — a missed referral fee, a split applied to the wrong base — can do more damage to trust than a slow quarter ever would.
Brokerages feel the opposite version of the same problem: without a clean record of what was promised versus what was paid, year-end reporting turns into archaeology. Bank statements get cross-referenced against memory. Old emails get reopened. A tracker built around the actual split math removes that guesswork before it starts, for both sides of the check.
What is inside this free real estate template
| Tab / Tool | Purpose |
|---|---|
| Read me | A short orientation to each tab, written for someone opening the file for the first time. |
| Deal Log | Sale price in, net-to-agent out — referral fee, brokerage split and team split all calculated in between. |
| Split Calculator | Type in a hypothetical deal and see the full payout breakdown before that deal ever closes. |
| Agent Earnings Summary | Every agent's total commission, broken down by month and rolled up for the year. |
| Brokerage Revenue Summary | What the company actually kept across the team — by agent, and as a share of total commission. |
| Commission Discrepancy Checker | Expected payout next to actual payout, side by side, with anything that doesn't match flagged in red. |
| Benchmark Reference | A look at how commission splits typically work across the industry, for context when comparing your own numbers. |
Key commission concepts built into this template
| Concept | Why it matters |
|---|---|
| Gross commission | The full amount before anyone takes a cut — sale price multiplied by the agreed commission rate. |
| Referral fee | Comes off the top, before any split, whenever a deal originated through another agent or agency. |
| Brokerage split | The brokerage's share of what's left after a referral fee, however that percentage is structured. |
| Team or mentor split | A further cut for a team lead or mentor, calculated on the agent's share after the brokerage takes theirs. |
| Net to agent | What's actually left once every fee and split has been subtracted — the number on the paycheck. |
| Company dollar | The brokerage's retained revenue across every closed deal, the figure that funds tools, training and support. |
| Payout discrepancy | Any gap between what a deal's math says an agent should receive and what they were actually paid. |
| Cap structure | A ceiling on how much an agent pays the brokerage in a year, after which their split improves substantially. |
Wondering if last quarter's payouts actually added up?
Pull the free commission tracker and run the numbers yourself — every split, every fee, every agent, laid out in one place instead of scattered across statements and memory.
How to use this commission tracker & split calculator template
Log each deal as it closes — sale price, commission rate, agent name, and whatever referral or team split applies, and the payout calculates on its own.
Run uncertain deals through the Split Calculator first so nobody is surprised by the final number once the deal actually closes.
Pull agent and brokerage totals whenever reporting season comes around — both summaries update from the Deal Log without any extra work.
Run the Discrepancy Checker before payouts go out and catch a mismatched deal before it becomes an awkward conversation.
Check the Benchmark Reference tab when negotiating a new split to see how your structure compares with what's common across the industry.
Who is this template for
Solo agents who want a personal record of every commission earned, independent of whatever the brokerage's own books say.
Broker owners responsible for getting payouts right across a whole team, every single time, without exception.
Team leads running their own split structure on top of the brokerage's, who need the math to stay transparent for everyone underneath them.
Office administrators and bookkeepers tasked with reconciling commission statements against what was actually wired out.
What to verify before trusting your commission numbers
Is the split order actually correct for your brokerage?
- This workbook deducts referral fee, then brokerage split, then team split, in that order — confirm that matches how your brokerage's agreement is actually written.
Are caps and tiers being applied correctly?
- An agent who has already capped for the year should be paying a different rate than one who hasn't — check that the entered split reflects where each agent actually stands.
Are referral fees being entered consistently?
- Some deals carry a referral fee and most don't — make sure zero actually means zero and isn't a placeholder for a fee nobody got around to entering.
Does the recorded payout match what was actually wired?
- The Discrepancy Checker is only as useful as the "actual payout" figures entered into it — pull those from bank records, not from memory.
Have any split agreements changed recently?
- A renegotiated split or a new team arrangement should be reflected in new deals immediately, not carried over from an outdated default.
Why this template works
The math follows real split structures
- Referral fee, brokerage split, team split — applied in the order real brokerages actually use them, not a simplified version that breaks on a complicated deal.
It models a deal before it's final
- The Split Calculator answers "what would I actually take home" before a contract is even signed, not after.
It catches errors before they become disputes
- A discrepancy flagged before payday is a quick fix. The same discrepancy discovered after is a much harder conversation.
Reporting stops being a once-a-year scramble
- Agent and brokerage totals are always current, so year-end or quarterly reporting is a matter of opening a tab, not rebuilding one.
It scales from one agent to a full team
- The same Deal Log structure works whether it's tracking one person's commissions or twenty-five deals across five agents.
Common commission split structures used by real estate brokerages
Fixed percentage split
- A flat ratio agreed in advance — 50/50, 70/30, 80/20 — applied to every deal regardless of size or season.
Graduated or tiered split
- The agent's share climbs as production grows within the year, then typically resets at the next anniversary date.
Cap-based split
- The agent pays the brokerage up to a set dollar cap each year, then keeps close to 100% of commission for the rest of that year.
Flat-fee or 100% commission model
- The agent keeps the full commission and instead pays a fixed transaction or monthly fee to the brokerage.
Team-based split
- Commission divides three ways — brokerage, team lead, agent — usually in exchange for leads, mentorship or shared support.
Commission tracking checklist for real estate teams
| Checklist item | Why it should be reviewed |
|---|---|
| Sale price and commission rate | Everything downstream is built on these two numbers — get them wrong and every split that follows is wrong too. |
| Referral fee, if any | Easy to forget on a deal that closes months after the referral was made — worth a second look. |
| Brokerage split percentage | Should match the agent's current agreement, not a rate that applied before their last renegotiation. |
| Team or mentor split | Only applies where a team arrangement exists — confirm it's not being applied to independent agents by mistake. |
| Net payout to agent | The number that ends up on the paycheck — worth a manual sanity check on larger deals. |
| Actual amount paid out | Compared against the expected net, this is what the Discrepancy Checker is built to catch. |
| Monthly and year-to-date totals | Useful for spotting a slow month early, rather than discovering it at year-end. |
| Brokerage company dollar | The figure that ultimately funds tools, marketing support and agent training. |
Frequently asked questions (FAQ)
Twenty-five sample deals are already in the Deal Log when you open the file, each with its own sale price, splits and calculated payout. Delete them whenever you're ready for your own numbers — the formulas keep working the same way either way.
Closing date, agent name, sale price, commission rate, referral fee percentage, brokerage split percentage and team split percentage. Enter those seven fields and the gross commission, every deduction and the final net payout calculate without any further input.
Absolutely — many teams treat this as the working file where splits get modeled and double-checked, then carry the final figures into whatever CRM, accounting platform or payroll system handles the actual disbursement.
Referral fee comes off the gross commission first. The brokerage split is then taken from what's left. Any team or mentor split is calculated last, on the agent's remaining share — the same sequence used in both the Deal Log and the Split Calculator.
Both. A solo agent gets a clean personal commission record independent of brokerage paperwork, while a team of any size gets agent-by-agent totals and brokerage-wide reporting from the exact same Deal Log.
Not entirely. It won't calculate splits the instant a deal closes inside your CRM, and it won't flag a discrepancy automatically the way live commission software does. For that level of automation, a real estate commission management platform is the next step up from a manual tracker.
Fixed percentage splits, referral fees, and team or mentor splits are all built in. Cap-based and tiered structures can be modeled by simply adjusting the brokerage split percentage entered for a given deal or time period.
Treat it as a prompt to go back to the source — confirm the sale price, the splits entered and the amount actually paid, before the payout reaches an agent. Catching it here is almost always easier than untangling it after the fact.
Stop reconciling commissions by hand. Start tracking them properly.
This template handles the math. Retyn's commission management platform handles the rest — automatic split calculations the moment a deal closes, live discrepancy alerts, and reporting that never needs a manual rebuild.
