RPT-07 Commission Statement
Certified report viewer — audience: Sales, Finance & HR · metric owner: Fatima Rashid (Finance Manager) · plans, splits, approvals and payments per close / payrun, versioned formula with SoD control.
RPT-07
FIN-06
§9.2
Report definition & certification — §9.2 header
Certified
Definition DEF-RPT-07 v3.2
- Report owner
- FRFatima Rashid — Finance Manager
- Business definition
- Commission entitlements per closed deal, split by beneficiary, reconciled to the approved pool per payrun
- Authoritative dataset
fin.commission_linesjoined tosales.deals&hr.payruns(posted only)- Refresh cadence
- Per close / payrun · this statement: payrun PR-2026-07
- Last refresh
- 17 Jul 2026 06:30 (payrun close snapshot) · next: payrun PR-2026-08
- Certification state
- Certified by Fatima Rashid · 17 Jul 2026 07:05
- Definition version
- DEF-RPT-07 v3.2 · effective 01 Apr 2026
- Governing policy versions
- Commission plan CP-2026-STD v4 · Authority matrix AM-2026 v7 · Export policy EXP-CTRL v2
- Reconciliation basis
- Σ lines = approved pool AED 286,650.00 · GL JV-2026-0905 (6200 / 2310)
- Currency / time zone
- AED (base) · Asia/Dubai · fiscal FY2026
Approved pool — PR-2026-07
AED 286,650.00
12 lines · reconciles to GL 6200
Paid via WPS
AED 62,650.00
3 lines settled 16 Jul 2026
Approved, awaiting payment
AED 105,300.00
+ AED 75,000.00 pending SoD approval
Disputed
AED 14,040.00
▼ 1 line split contested (DL-2026-0155)
Clawbacks this payrun
−AED 11,500.00
1 approved reversal (DL-2026-0128)
Commission by beneficiary — PR-2026-07Governed dimension: beneficiary
| Beneficiary | Lines | Commission (AED) |
|---|---|---|
| Team pool Q2 kicker — Dubai HQ | 1 | 75,000.00 |
| Layla Hassan (Agent B) | 3 | 73,210.00 |
| Prime Link Realty (external broker) | 1 | 60,000.00 |
| Rashid Al Farsi (Sales Manager) | 1 | 45,300.00 |
| Omar Haddad (Agent A, net of clawback) | 4 | 33,140.00 |
| Total — approved pool | 10 | 286,650.00 |
Lineage — source → transformation → report (§9.2)Lineage v3.2
sales.deals (closed)→
plan snapshot CP-2026-STD v4→
fin.commission_lines→
SoD approval (AM-2026 v7)→
payrun PR-2026-07→
RPT-07 certified extract
| Source | Snapshot | Rows | State |
|---|---|---|---|
sales.deals — closed in period | 17 Jul 2026 06:28 | 9 | Synced |
fin.commission_plans CP-2026-STD v4 | effective 01 Apr 2026 | 4 | Versioned |
fin.commission_lines | 17 Jul 2026 06:30 | 12 | Reconciled |
hr.payruns — PR-2026-07 | posted 16 Jul 2026 | 1 | Posted |
| GL posting JV-2026-0905 (6200 / 2310) | 17 Jul 2026 | 2 | Balanced |
Drill-down is permission-aware: HR sees payment lines, Sales sees own splits, Finance sees full pool. Working screen: Commission Calculation & Payable.
Statement lines — payrun PR-2026-07, Dubai HQ (10)
Certified 17 Jul 2026
| Line | Beneficiary | Deal / basis | Plan (version) | Split | Commission (AED) | State | Payment / evidence |
|---|---|---|---|---|---|---|---|
| CL-2607-001 | OHOmar Haddad |
DL-2026-0147 · PR-A-1103 sale Fee basis AED 37,000.00 · closed 30 Jun |
CP-2026-STD v4 | 60% | 22,200.00 | Paid | WPS batch PR-2026-07 IBAN AE07 0331 2●●● ●●●● ●●23 456 |
| CL-2607-002 | LHLayla Hassan |
DL-2026-0147 · PR-A-1103 sale Fee basis AED 37,000.00 · co-broke internal |
CP-2026-STD v4 | 40% | 14,800.00 | Paid | WPS batch PR-2026-07 IBAN AE44 0260 0●●● ●●●● ●●81 902 |
| CL-2607-003 | LHLayla Hassan |
DL-2026-0150 · PR-A-0904 sale Fee basis AED 28,500.00 · closed 02 Jul |
CP-2026-STD v4 | 90% | 25,650.00 | Paid | WPS batch PR-2026-07 IBAN AE44 0260 0●●● ●●●● ●●81 902 |
| CL-2607-004 | OHOmar Haddad |
DL-2026-0152 · PR-B-2106 lease One month fee AED 8,400.00 |
CP-2026-LEASE v2 | 100% | 8,400.00 | Payable | Queued for payrun PR-2026-08 |
| CL-2607-005 | RFRashid Al Farsi |
Manager override — Jun close batch 2% of team pool · 8 deals |
CP-2026-MGR v3 | 2% | 45,300.00 | Approved | Approved by Fatima Rashid SoD: approver ≠ beneficiary ✓ |
| CL-2607-006 | PLPrime Link Realty |
DL-2026-0149 · PR-B-1802 sale Referral 50% of AED 120,000.00 fee |
CP-2026-EXT v1 | 50% | 60,000.00 | Approved | Awaiting broker tax invoice · TRN verified |
| CL-2607-007 | LHLayla Hassan |
DL-2026-0155 · PR-B-3204 sale (Hessa Al Marri) AED 2,340,000.00 × 2% = AED 46,800.00 |
CP-2026-STD v4 | 70% | 32,760.00 | Calculated | Awaiting deal condition: receipt cleared |
| CL-2607-008 | OHOmar Haddad |
DL-2026-0155 · PR-B-3204 sale Split contested — referral claim raised 15 Jul |
CP-2026-STD v4 | 30% | 14,040.00 | Disputed | Case CM-0042 · resolver: Rashid Al Farsi |
| CL-2607-009 | OHOmar Haddad |
DL-2026-0128 · PR-A-2201 — deal rescinded Clawback per plan §7 · approved 14 Jul |
CP-2026-STD v3 prior version | — | −11,500.00 | Clawback | Reversal JV linked · deducted PR-2026-07 |
| CL-2607-010 | DXTeam pool — Dubai HQ |
Q2 kicker — target 110% achieved Distribution list held until approval |
CP-2026-KCK v1 | — | 75,000.00 | Pending SoD approval | Requires Fatima Rashid (plan owner excluded) |
| Total — reconciles to approved pool (GL 6200 / 2310, JV-2026-0905) | 286,650.00 | Difference: AED 0.00 Reconciled | |||||
Lines 1–10 of 12 · 2 Abu Dhabi Branch lines hidden by scope
Report definition of done — §9.2 checklist8 / 8 complete
| §9.2 requirement | Evidence on this report | Status |
|---|---|---|
| Named owner & business definition | Fatima Rashid · DEF-RPT-07 v3.2 | Complete |
| Authoritative dataset & lineage | fin.commission_lines · lineage panel above | Complete |
| Filters, dimensions, currency/time-zone | Payrun, branch, state · AED · Asia/Dubai | Complete |
| Refresh & certification state | Per payrun · Certified 17 Jul 2026 07:05 | Complete |
| Permission-aware drill-down | Agent sees own lines; Finance/HR branch scope | Complete |
| Controlled export with watermarking | Export (audited) — watermark + recipient stamp | Complete |
| Reconciliation totals & evidence | Σ = AED 286,650.00 = GL JV-2026-0905 · tolerance 0.00 | Complete |
| Accessible chart/table alternative · EN/AR labels | Bars + table above · AR label set v2 approved | Complete |
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: RPT-07 (Table 15 report catalogue) · §9.2 report definition of done · FIN-06.