How we track commissions for 78 agents without a full-time bookkeeper
The actual commission-tracking system inside a multi-location brokerage: the ownership map, the weekly cadence, and the three-layer spreadsheet-to-scoreboard structure. Shown, not theorized.
Zack Petrocca
Operator · Active COO
Commission tracking is where real estate teams quietly bleed. Not because the math is hard, but because the math lives in one person’s head, reconciliation happens at month-end, and nobody but the founder can answer “what do we owe, to whom, and when?”
Here’s the system we run across a 78-agent, multi-location operation. It processes every closing without a full-time bookkeeper, and, more importantly, without me.
Screencast coming soon. A 6-minute screen recording of the live system (demo data) will sit here: the pipeline view, the split calculator, and the weekly reconciliation in action.
The problem with how most teams do it
The default evolution goes: spreadsheet → bigger spreadsheet → spreadsheet only the founder understands → founder is the commission department. Every deal that closes generates five questions (gross commission, splits, caps, referral fees, mentor fees), and in most teams every one of those questions routes to one person.
That’s not a tracking problem. It’s a Scoreboard problem: the pillar most teams build last and need first.
The three layers
Layer 1: Capture at contract, not at closing. The commission record is created the day a deal goes under contract, inside the transaction workflow: agent, gross commission, split table, referral obligations, cap status. By closing day the record is 95% complete and has been visible for weeks. Month-end archaeology disappears because nothing waits until month-end.
Layer 2: A split table that isn’t tribal knowledge. Every agent’s structure (splits, caps, mentor obligations, team-lead overrides) lives in one owned document with effective dates. When a cap rolls over or a split graduates, the table changes, and the calculation follows the table. Nobody “just remembers” anyone’s deal terms.
Layer 3: The weekly reconciliation cadence. Fifteen minutes, every week, owned by our operations coordinator. Not by me. Closings from the week are checked against the ledger, exceptions get flagged into the weekly meeting’s issue list, and the pacing dashboard updates. Fifty-two small reconciliations a year instead of twelve painful ones.
Who owns it (the part everyone skips)
The system works because every number has exactly one name on it: the ops coordinator owns record accuracy, each agent owns verifying their own statement, and I own precisely one thing: the monthly P&L review where commission expense meets the rest of the business.
That ownership map took an afternoon to define. It bought back roughly six hours of founder time a week and ended the “can you check my commission?” text thread forever.
What this looks like in your business
This is one system inside The Scoreboard, the pillar that turns managing-by-feel into managing-by-data. The packaged version, with the split-table templates, reconciliation cadence, and dashboard structure, ships as Finance, Data & Commission Tracking.
If you’re not sure the Scoreboard is your weakest pillar, take the Diagnostic. Three of its fifteen questions measure exactly this.