Product · 9 min read
Network commission engines done right: lessons from real estate
Multi-level agent networks live or die on payout accuracy. We share the data model and rules we use to calculate sponsor-tree commissions that are fast, auditable and dispute-free.
Karan Sethi · 7 May 2026
Why commission logic gets messy
Real estate agent networks often pay commission not only to the agent who closes a sale but to several levels of sponsors above them. Rates depend on rank, ranks depend on cumulative business, and payment is released as the buyer pays instalments. When this lives in spreadsheets, every edge case becomes a dispute.
A good engine makes three things explicit: the structure of the network, the rules that turn a sale into commission, and the timing of when commission becomes payable.
Modelling the sponsor tree
The simplest representation stores a sponsor ID on each agent, but walking up the tree with recursive queries for every booking becomes slow as the network grows. We maintain a closure table alongside it: one row for every ancestor-descendant pair with the depth between them. Finding all uplines of an agent, or all downlines of a leader, becomes a single indexed query.
Sponsor changes are rare but do happen. Because the closure table is derived, it can be rebuilt for the affected subtree, and historical commissions are unaffected because they are calculated against a snapshot of the uplines at booking time.
Slab-based rates per square foot
Many real estate networks pay a rate per square foot that increases as an agent's cumulative business crosses thresholds. Each agent's rank is determined by their own and their team's total sold area. Upline agents earn the difference between their rate and the rate of the agent below them, so total payout on a sale is capped at the top rate.
Store slab definitions as versioned data rather than code, with effective dates. When management revises rates, new bookings use the new version while past bookings remain reproducible.
- Slab table: min sq ft, max sq ft, rate per sq ft, effective from, effective to
- Differential payout: upline earns its rate minus the highest rate already paid below it
- Snapshot the applicable slab and upline chain onto each booking
Accrual versus release
Paying full commission on booking is risky because buyers cancel. We accrue the full commission at booking but release it in proportion to the payments the buyer has cleared. If a buyer has paid 30 percent of the sale value, 30 percent of the commission becomes payable.
Cancellations create reversing entries for any unreleased commission, and, where policy permits, recover released amounts from future payouts. Recording all of this in a ledger rather than overwriting figures means every agent's statement can be explained line by line.
Transparency prevents disputes
The most effective dispute reduction tool is visibility. Agents should see each booking that contributed to their earnings, the slab applied, the buyer payments cleared and the amount released. When the calculation is visible, most questions answer themselves.
Finally, keep the business compliant. Commission should be earned on genuine sales of real property, not on recruitment. Structures that reward joining fees over sales can fall foul of consumer protection rules governing direct selling and prize chit schemes, and they are not something we build.