Commission Calculation & Payable
Calculate agent, manager, referral and external-broker commissions from versioned plans once authoritative deal conditions are met, then move them through approval to payable with full trace, SoD and clawback control.
- Effective
- 01 Jan 2026 → open · versioned (v1 2024, v2 2025, v3 current)
- Trigger condition
- SPA signed and ≥10% collected on linked invoices
- Pool basis
- 2.00% of net sale value (tier 1 ≤ AED 2.0M)
- Tier 2
- 2.25% for value > AED 2.0M ≤ 5.0M · Tier 3: 2.50% > 5.0M
- Overrides
- Allowed on split % only, with reason + independent approval
- Clawback rule
- 100% if deal cancels < 90 days after payment; 50% < 180 days
| Role | Beneficiary rule | Share % |
|---|---|---|
| Listing / selling agent | Deal owner at SPA signature | 60.0 |
| Manager override | Owner's line manager | 10.0 |
| Referral | Registered referral source on lead | 5.0 |
| House | Al Manara Properties LLC | 25.0 |
| Total (must equal pool) | 100.0 | |
External co-broke deals substitute a 50/50 pool split with the partner broker before internal shares apply (e.g. Prime Link Realty agreements).
| # | Step | Input / rule | Result AED |
|---|---|---|---|
| 1 | Trigger check | SPA signed 30 Jun · collected AED 124,900.00 ≥ 10%? 10.03% ✓ on 16 Jul | — |
| 2 | Plan resolution | Residential Sales 2026 v3 · effective at trigger date | — |
| 3 | Pool | 2.00% × net sale 1,245,000.00 (tier 1) | 24,900.00 |
| 4 | Referral split | Prime Link Realty · registered on lead LD-2026-0977 · 5% | 1,245.00 |
| 5 | Agent split | Omar Haddad · deal owner · 60% | 14,940.00 |
| 6 | Manager override | Rashid Al Farsi · line manager · 10% | 2,490.00 |
| 7 | House share | Al Manara Properties LLC · 25% | 6,225.00 |
| 8 | Reconciliation | Σ splits 24,900.00 = approved pool 24,900.00 | Balanced ✓ |
| Pool total → posting Dr 7110 Commission expense / Cr 2210 Commission payable · linked to deal revenue JV-2026-05140 | 24,900.00 | ||
Source drill-down: Deal workspace · Receipt RCP-2026-00912 · SPA evidence.
Exception states Reversed and Disputed branch from any post-approval state and always keep the original record (FIN-06 separates calculated, approved, payable, paid, reversed and disputed).
| Ref | Deal / unit | Payee | Role | Amount AED | Plan ver. | State | Evidence |
|---|---|---|---|---|---|---|---|
| COM-2026-0512 16 Jul |
DEA-2026-0341 · PR-A-1203 | OH Omar Haddad | Agent 60% | 14,940.00 | v3 | Calculated | Trace #1–8 |
| COM-2026-0513 16 Jul |
DEA-2026-0341 · PR-A-1203 | RF Rashid Al Farsi | Manager 10% | 2,490.00 | v3 | Calculated | Routes to F. Rashid (SoD) |
| COM-2026-0514 16 Jul |
DEA-2026-0341 · PR-A-1203 | Prime Link Realty (external) | Referral 5% | 1,245.00 | v3 | Calculated | Paid via AP voucher, not payroll |
| COM-2026-0498 12 Jul |
DEA-2026-0329 · PR-B-1408 | LH Layla Hassan | Agent 60% | 21,600.00 | v3 | Approved | Batch CB-2026-07-A |
| COM-2026-0471 05 Jul |
DEA-2026-0301 · PR-A-2210 | OH Omar Haddad | Agent 55% (override ↓5) | 18,150.00 | v3 + OVR-114 | Payable | Override approved by F. Rashid, reason: co-listing |
| COM-2026-0442 28 Jun |
DEA-2026-0287 · PR-B-3204 | LH Layla Hassan | Agent 60% | 31,200.00 | v3 | Paid | Payrun PR-2026-06 · WPS |
| COM-2026-0431 22 Jun |
DEA-2026-0322 · PR-A-1807 | LH Layla Hassan | Agent split contested | 9,450.00 | v3 | Disputed | Case DSP-2026-07 · shared-lead attribution |
| COM-2026-0387 15 May · reversed 10 Jul |
DEA-2026-0244 · PR-B-0906 (cancelled) | OH Omar Haddad | Agent 60% · clawback | −8,400.00 | v3 | Reversed — clawback | Deal cancelled day 56 < 90 → 100% clawback |
| Net movement Jul 2026 (page) | 90,675.00 | ||||||
| Payee | Payable AED | Payment route |
|---|---|---|
| Omar Haddad | 33,090.00 | Payroll — payrun PR-2026-07 |
| Layla Hassan | 21,600.00 | Payroll — payrun PR-2026-07 |
| Rashid Al Farsi | 6,940.00 | Payroll — payrun PR-2026-07 |
| Prime Link Realty (external broker) | 3,745.00 | AP voucher + TRN invoice required |
| Total payable | 65,375.00 |
Commission postings link to deal revenue and payrun/payment evidence (FIN-06); statement export follows RPT-07 versioned-formula and SoD controls.
Consequence: 4 commission records (AED 61,430.00) become payable, post to 2210 Commission payable, and are handed to payroll PR-2026-07 / AP. This cannot be undone except by approved reversal.
- Pool reconciliation
- Σ splits = approved pools ✓
- Override check
- 1 override (OVR-114) · approved by non-beneficiary ✓
- SoD check
- Approver is not a beneficiary ✓
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: FIN-06. Related: Deal Workspace · Payroll & WPS · Vouchers & Payables · Commission Plan Studio.