Commission, Payroll, Leave & Gratuity Studio
Configure workforce calculations as controlled, versioned policy packs — commission bases, tiers, splits and clawbacks; payroll calendars and elements; leave accrual; end-of-service/gratuity — with scenario simulation, expected-result fixtures, dual approval, effective dating and transaction-level policy snapshots. Used by HR, payroll, finance, sales operations and auditors.
| Plan / version | Basis | Tiers | Split / referral | Clawback | Earning event · settlement | Effective | State |
|---|---|---|---|---|---|---|---|
CP-RES-STD v4Residential sales — standard | % of gross commission income | 3 bands (see detail) | 60/40 lead/co-agent · referral 10% | 100% if deal cancels < 90 days | Offer acceptance · on receipt ≥ 95% | 01 Jan 2026 → | Active |
CP-RES-STD v5Adds 2.25% band > AED 10M | % of gross commission income | 4 bands | 60/40 · referral 10% | 100% < 90 days | Offer acceptance · on receipt ≥ 95% | 01 Aug 2026 (window 00:00) | Scheduled — dual approval complete |
CP-RES-STD v3FY2025 rates | % of gross commission income | 3 bands | 55/45 · referral 8% | 100% < 60 days | Offer acceptance · on receipt ≥ 90% | 01 Jan 2025 → 31 Dec 2025 | Superseded |
CP-OFFPLAN-DEV v2Off-plan — Noor Development Group projects | % of unit price (developer-funded) | Flat 3.00% | 70/30 · no external referral | Pro-rata on payment-plan default | SPA signature · milestone collections | 01 Mar 2026 → | Active |
CP-REF-EXT v1External referral — Prime Link Realty | % of received commission | Flat 15.00% | External broker payee | Mirror of primary deal clawback | Receipt clearance · monthly batch | 01 Feb 2026 → | Active |
CP-LEASE-STD v6 draftLeasing — proposes uncapped tier; guardrail max 50% of fee | % of annual rent fee | 2 bands + kicker | 100% lead agent | 50% if tenant exits < 6 months | Lease contract release · on receipt | — | Draft — guardrail violation |
sha256:2b90…6641| Band (gross commission income, FYTD) | Rate to agent | Notes |
|---|---|---|
| ≤ AED 2,000,000.00 | 1.25% | of unit sale price equivalent |
| AED 2,000,000.01 – 5,000,000.00 | 1.60% | retroactive from band entry |
| > AED 5,000,000.00 | 2.00% | manager approval on payout > AED 150,000.00 |
- Split
- Lead agent 60% · co-agent 40% (Omar Haddad / Layla Hassan on DL-2026-0142)
- Referral
- 10% of agent share, internal referrer
- Eligibility
- KYC complete · contract released · no active AML hold
- Clawback
- 100% if deal cancelled < 90 days from earning event
- Settlement
- Payable created when receipts ≥ 95% of invoice — Commission payable
- Maker
- Rashid Al Farsi (Sales Manager)
- SoD note
- Rashid Al Farsi is in the beneficiary population of this plan — final approval must come from outside Sales (Fatima Rashid, Finance)
- Next action
- Edit tier → re-validate → dual approval (HR/Payroll + Finance)
- Cycle
- Monthly (calendar month)
- Attendance cutoff
- 25th of month — Attendance & Shifts
- Pay date
- 28th (previous working day if holiday)
- WPS/SIF profile
WPS-2026-01· schema per Resolution 340/2026 floor · agent bank ENBD- Emirati wage floor
- AED 6,000.00 private-sector minimum (2026) — eligibility checks active (HR-06)
- Rounding
- Truncate per SIF schema, AED 0.01
- Off-cycle runs
- Final settlement + commission-only run (dual approval)
Adds element ALW-REMOTE (remote-work allowance). Maker: Vikram Nair. Dual approval required: HR/Payroll owner and Fatima Rashid (Finance Manager). Material payroll rule change — activation only at scheduled effective date 01 Aug 2026; prior version stays reproducible (CFG-03 acceptance).
| Code | Element | Type | Calculation basis | WPS/SIF mapping | GL account | State |
|---|---|---|---|---|---|---|
BASIC | Basic salary | Earning | Contract monthly basic | Fixed — basic | 52100 | Active |
ALW-HOUS | Housing allowance | Earning | 25% of basic | Fixed — allowance | 52210 | Active |
ALW-TRANS | Transport allowance | Earning | Flat AED 500.00 | Fixed — allowance | 52220 | Active |
OT-125 | Overtime 1.25× | Earning | Hourly basic × 1.25 × approved hours | Variable | 52310 | Active |
OT-150 | Overtime 1.5× (rest day / night) | Earning | Hourly basic × 1.50 × approved hours | Variable | 52310 | Active |
COMM | Commission pass-through | Earning | Approved payable from commission engine (plan version pinned) | Variable | 51200 → 21400 | Active |
DED-LOP | Unpaid leave (loss of pay) | Deduction | Daily rate × unpaid days | Variable — deduction | 52100 contra | Active |
DED-ADV | Salary advance recovery | Deduction | Fixed schedule, max 25% of net | Variable — deduction | 13400 | Active |
GRAT-ACCR | Gratuity accrual (provision) | Employer provision | EOS pack v2 monthly accrual — not paid via WPS | Excluded | 21800 | Active |
ALW-FUEL | Fuel allowance (legacy) Referenced by 6 payruns — deletion blocked; end-dated 30 Jun 2026 | Earning | Flat AED 300.00 | Fixed — allowance | 52230 | End-dated |
| Leave type | Entitlement | Accrual | Carryover / encashment | Floor | State |
|---|---|---|---|---|---|
| Annual leave | 30 calendar days / year | 2.5 days per completed month | Carry max 10 to 31 Mar · encash on basic salary | Statutory floor — locked | Active |
| Sick leave | 90 days / year | Eligibility after probation | 15 days full pay · 30 half · 45 unpaid | Statutory floor — locked | Active |
| Maternity | 60 days | — | 45 full + 15 half pay | Statutory floor — locked | Active |
| Parental | 5 working days (within 6 months) | — | No carryover | Statutory floor — locked | Active |
| Hajj leave | 30 days unpaid, once per service | — | — | Statutory floor — locked | Active |
| Study leave | 10 working days / year (2+ yrs service) | — | No carryover | — | Active |
| Annual leave — enhanced | 32 calendar days / year More favourable than floor — permitted | 2.67 days / month | Carry max 10 | Above floor | Scheduled 01 Jan 2027 |
| Pack / cohort | Wage & service basis | Accrual formula | Caps & settlement | Effective | State |
|---|---|---|---|---|---|
EOS-PACK v2 — Traditional statutoryAll employees hired before 01 Jan 2027 | Last basic wage · continuous service ≥ 1 year | 21 days basic / year (first 5 yrs) · 30 days / year thereafter · pro-rata parts of year | Cap 24 months' wage · settle within 14 days of end of service | 01 Jan 2026 → | Active |
EOS-PACK v3 draftCorrects > 5 yrs split rounding | Last basic wage | 21/30-day split — day-count basis 30.4167 | Cap 24 months' wage | proposed 01 Sep 2026 | Draft — golden fixture GC-EOS-007 failing |
EOS-SAVE v1 — Savings Scheme (alternative)Phase 2 · voluntary cohort election | Monthly employer contribution to approved fund | 5.83% of basic (< 5 yrs) · 8.33% (≥ 5 yrs) | Frozen accrual at election date preserved under traditional rules | — | Draft — Phase 2 |
EOS-PACK v1FY2025 rules | Last basic wage | 21/30-day split — day-count basis 30 | Cap 24 months' wage | 01 Jan 2025 → 31 Dec 2025 | Superseded |
- Headcount in scope
- 84 employees (AMRE-DXB + AMAD)
- Accrued gratuity liability
- AED 1,842,300.00 (GL 21800, as of 30 Jun 2026)
- Leave encashment provision
- AED 412,760.00 (GL 21810)
- Valuation policy version
EOS-PACK v2· snapshotsha256:9ce1…24b8- Next revaluation
- 31 Jul 2026 month-end run
- Maker
- Vikram Nair (Configuration Administrator)
- Required approvers
- HR/Payroll owner + Fatima Rashid (Finance) · Legal review: Mariam Al Suwaidi
- Recovery path
- Draft remains editable; validation evidence retained per attempt
| Fixture | Policy pack / version | Input hash | Expected (approved golden) | Actual (simulation) | Variance | Result |
|---|---|---|---|---|---|---|
| GC-COM-003 Sale AED 1,850,000.00 · band 1 · 60/40 split | CP-RES-STD v4 | 74b2…e0c9 | AED 23,125.00 | AED 23,125.00 | 0.00 | Pass |
| GC-COM-007 Clawback — cancellation day 62 of 90 | CP-RES-STD v4 | 81aa…37f2 | AED −23,125.00 | AED −23,125.00 | 0.00 | Pass |
| GC-COM-011 Earning-event pinning: booked Jul, settled Aug (v5 active) | CP-RES-STD v4 (pinned) | 90cd…be11 | v4 rates apply | v4 rates apply | — | Pass — CFG-06 acceptance |
| GC-PAY-001 Monthly: basic 12,000.00 + housing + OT 6 h @1.25 | PAY-ELEM v9 | a3e7…5510 | AED 16,004.81 | AED 16,004.81 | 0.00 | Pass |
| GC-PAY-006 Mid-month joiner proration (joined 11 Jun) | PAY-ELEM v9 + PAY-CAL v2 | b911…08dc | AED 8,400.00 | AED 8,400.00 | 0.00 | Pass |
| GC-WPS-001 SIF file checksum + record counts (84 employees) | WPS-2026-01 | c4f0…6a27 | Checksum match | Checksum match | — | Pass |
| GC-LVE-002 Carryover cap at 31 Mar (14 days accrued) | LVE-PACK v4 | d270…91b3 | 10 carried · 4 lapsed-or-encashed | 10 carried · 4 lapsed-or-encashed | — | Pass |
| GC-EOS-004 Gratuity — 4 yrs 7 months, basic AED 14,000.00 | EOS-PACK v2 | e58c…2df4 | AED 44,912.28 | AED 44,912.28 | 0.00 | Pass |
| GC-EOS-007 Gratuity — 7 yrs 3 months, 21/30-day split | EOS-PACK v3 (draft) | f7a1…c063 | AED 98,466.67 | AED 98,594.88 | 128.21 | Fail — blocking |
| GC-EMI-001 Emirati wage floor — AED 6,000.00 minimum check | PAY-ELEM v9 + HR-06 floor | 08b4…77e5 | Below-floor run rejected | Below-floor run rejected | — | Pass — negative test |
| Pack | Pass | Fail | Blocking? |
|---|---|---|---|
| Commission (CP-*) | 3 | 0 | — |
| Payroll (PAY-ELEM / WPS) | 3 | 0 | — |
| Leave (LVE-PACK) | 2 | 0 | — |
| Gratuity (EOS-PACK) | 3 | 1 | Yes — v3 draft |
| Total | 11 | 1 |
| Transaction | Policy version pinned | Snapshot hash | Status |
|---|---|---|---|
| Payrun PR-2026-06 84 employees · paid 28 Jun 2026 | PAY-ELEM v9 · PAY-CAL v2 | 3d80…f412 | Posted · WPS accepted |
| Commission calc CM-2026-0088 DL-2026-0142 · Omar Haddad / Layla Hassan | CP-RES-STD v4 | 74b2…e0c9 | Awaiting receipt ≥ 95% |
| EOS settlement ES-2026-011 Leaver · 4 yrs 7 months | EOS-PACK v2 | e58c…2df4 | Settled 14 Jul 2026 |
| Referral payout RF-2026-023 Prime Link Realty · masked IBAN AE12 ●●●● ●●●● ●●●● 8891 | CP-REF-EXT v1 | 66c9…0ab7 | Held — vendor KYC refresh due |
| Payrun PR-2026-07 (preview) Cutoff 25 Jul · pay 28 Jul | PAY-ELEM v9 (v10 not yet active) | — (draft) | Preview |
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 (CFG-06, §5.5, §17.2, Table 11 “People & Payroll”, HR-01/03/04/05/06 configuration baselines) · Covers: CFG-06, HR-01, HR-03, HR-04, HR-05 · Related: Commission Calculation & Payable · Payroll & WPS/SIF · Leave & Rejoining · End of Service & Gratuity · Version Lifecycle · Resolution Explorer.