SOP: Master UAE Payroll Architecture and WPS Processing

Standard Operating Procedure: Master UAE Payroll Architecture & WPS Processing

---

1. Document Control Block

---

2. Executive Summary & Purpose

The objective of this Standard Operating Procedure (SOP) is to formalize, standardize, and execute monthly payroll operations for United Arab Emirates (UAE) entities operating under the regulatory jurisdiction of the Ministry of Human Resources and Emiratisation (MOHRE) and the Central Bank of the UAE (CBUAE).

This SOP enforces absolute compliance with UAE Federal Decree-Law No. 33 of 2021 (Regarding the Regulation of Employment Relationships) and guarantees standard generation of the mandatory Salary Information File (.SIF) for Wages Protection System (WPS) clearance, End of Service Benefit (EOSB) provisioning, and General Pension and Social Security Authority (GPSSA) accounting.

---

3. Scope & Prerequisites

3.Scope

This procedure applies to all full-time, part-time, and fixed-term employees managed across UAE mainland legal entities and applicable free zones (e.g., JAFZA, DMCC, KIZAD) integrated into standard CBUAE WPS clearing mechanisms. Independent entities operating bespoke legal schemes (e.g., DIFC, ADGM) must execute DIFC Employee Workplace Savings (DEWS) or ADGM-equivalent modules appended to Section 5.

Prerequisites & Required Tooling

• Master System Engine: Template Registry Unified UAE Payroll Engine (v3.2.0, macro-enabled .xlsm or Python-backed parsing pipeline).
• Regulatory Identifiers:
  • 13-Digit MOHRE Establishment ID (Employer ID).
  • Bank Routing Code / SWIFT BIC assigned by CBUAE.
  • Employee Labor Card Numbers (14-digit sequence).
• Software Requirements: Microsoft Excel 365 (Build 16.0+) with Data Validation Enabled / Native SIF Builder script; OpenSSL or corporate banking portal client with dual-control authorization modules.
• Security Credentials: Multi-Factor Authentication (MFA) hardware key for corporate banking portal SIF submission.

---

4. Roles & Responsibilities (RACI Matrix)

RACI Matrix

Legend: R = Responsible, A = Accountable, C = Consulted, I = Informed

---

5. Step-by-Step Procedure

[Phase 1: Ingestion & Reconciliation] ──► [Phase 2: Master Computation] ──► [Phase 3: SIF Generation] ──► [Phase 4: Bank Execution]

Phase 1: Pre-Processing & Data Ingestion (T-5 Days)

• Extract Attendance & Leave Data: Pull raw logs from HRIS. Extract unpaid leave (UNPD), sick leave tiered deductions (100% first 15 days, 50% next 30 days, 0% thereafter per Article 31), and approved overtime hours.
• Contract Split Verification: Ensure contract structures follow the standard UAE split: Basic Salary ($\ge 60%$ of Total Gross target) and Allowances (Housing, Transport, Utilities, Communication $\le 40%$).
• Roster Mutation Sync: Update additions (new joiners with signed MOHRE offer letters) and deletions (terminations/resignations requiring final settlement calculation). Verify 23-character UAE IBANs (AE + 21 digits).

Phase 2: Master Payroll Template Computation (T-3 Days)

• Import Raw Payloads: Populate the DATA_INPUT tab of the Unified UAE Payroll Engine.
• Validate Employee Identification Identifiers: Run macro Verify_MOHRE_IDs(). Flag any non-conforming 14-digit Labor Card IDs or missing IBAN strings.
• Execute EOSB Accrual Calculation: For terminated employees, trigger the EOSB script enforcing UAE Federal Law No. 33 of 2021: $$\text{Daily Basic Rate} = \frac{\text{Basic Salary}}{30}$$
  • Service $< 1\text{ year}$: $0$ days.
  • Service $1\text{ to }5\text{ years}$: $21\text{ days Basic per year}$.
  • Service $> 5\text{ years}$: $30\text{ days Basic per year for each additional year}$.
  • Constraint: Total EOSB sum must not exceed 2 years' total salary.
• GPSSA Pension Computation: For UAE National employees, execute statutory deductions on Pension Contribution Account Salary:
  • Employee Contribution: $5%$ deducted from Net Pay.
  • Employer Contribution: $12.5%$ (or $15%$ in Abu Dhabi private sector setups).
• Execute Gross-to-Net Balancing: Run dynamic calculation block. Verify zero instances of negative net pay or unexpected zero balance.

Phase 3: WPS SIF File Generation & Structural Audit (T-2 Days)

• Trigger SIF Compilation Script: Execute Generate_WPS_SIF() to create the standard pipe-delimited text block.
• Validate Record Formats:
  • Header Record (SCR): Format must strictly match: SCR,13-Digit-Employer-ID,Bank-SWIFT-BIC,YYYY-MM-DD,HHMM,YYYY-MM,Total Salary,Currency(AED),Checksum-Count
  • Employee Detail Record (EDR): Every active employee record must match: EDR,Labor-Card-ID,Bank-BIC,IBAN,Start-Date,End-Date,Days-Paid,Fixed-Pay,Variable-Pay,Unpaid-Leave-Days
• Filename Syntax Check: Export file with exact standard structure: [13-Digit-MOHRE-ID][YYMMDD][HHMMSS].sif (e.g., 1234567890123231024143000.sif).
• 80% Minimum Threshold Check: Confirm total salaries processed via WPS account for at least 80% of total workforce contractual commitment to ensure complete immunity from MOHRE blockades/penalties.

Phase 4: Bank Execution, Dual Control & Archival (T-0)

• Upload to Corporate Banking Portal: PS uploads the validated .sif file via the secure clearing dashboard.
• Execute Cryptographic Checksum Audit: Compare local SHA-256 hash generated by the Template Registry tool against the hash computed by the bank portal.
• Dual Control Authorization: FC reviews payroll summary totals against template control totals and approves execution using hardware token 2FA.
• Archive Operational Artifacts: Store encrypted copies of the .sif file, signed Payroll Summary Register, and Bank Delivery Voucher in immutable cold storage (AES-256) retention path s3://company-payroll-vault/uae/YYYY/MM/.

---

6. Quality Assurance & Pro-Tips

Critical Operational Metric Thresholds

• SIF Structural Rejection Rate: $0.00%$ target.
• WPS Compliance Ratio: $\ge 90%$ (MOHRE minimum: $80%$; operating below $90%$ triggers auto-flagging on MOHRE dashboard).
• Payment Dispatch Timing: $\le 28\text{th}$ calendar day of the processing month.
• Data Reconciliation Balance: Total Net Salary Output = Total Bank Ledger Outflow ($\pm 0.00\text{ AED}$).

Top Systemic Failure Modes & Mitigation Architectures

+------------------------------------+---------------------------------------+------------------------------------------+
| Failure Mode                       | Root Cause                            | Systemic Prevention Architecture         |
+------------------------------------+---------------------------------------+------------------------------------------+
| WPS File SIF Structure Rejection   | Carriage return line feeds or extra   | Enforce UTF-8 Without BOM output in script|
|                                    | spaces in IBAN/MOHRE ID fields.       | stripping `\r\n` to native `\n`.         |
+------------------------------------+---------------------------------------+------------------------------------------+
| Incorrect EOSB Calculation         | Including total gross salary instead  | Restrict formulas strictly to cell ranges|
|                                    | of contracted Basic Salary component.  | labeled `REF_BASIC_PAY`.                 |
+------------------------------------+---------------------------------------+------------------------------------------+
| Bank Rejection of Variable Pay     | Value set to zero for unpaid sales    | Input absolute `0.00` rather than null/  |
|                                    | commissions without parameter flags.  | empty text values in Variable Pay field. |
+------------------------------------+---------------------------------------+------------------------------------------+

Chief Architect Pro-Tip

Never modify basic formula strings directly in operational production tabs. Use dynamic array constraints (MAP, LAMBDA, BYROW) integrated into non-editable calculation layers. Ensure the Excel sheet protection password is stored inside enterprise credential managers (e.g., HashiCorp Vault / Enterprise Password Manager). Always sanitize variable pay inputs: if an employee receives zero variable pay, export explicit 0.00 rather than blank strings to prevent the bank parser from dropping trailing record fields.

---

7. Frequently Asked Questions (Operational Troubleshooting)

Q1: What changes did UAE Federal Decree-Law No. 33 of 2021 introduce regarding End of Service Benefit (EOSB) calculations?

Under Law No. 33 of 2021, distinctions between "limited" and "unlimited" contracts were abolished, and all workers are placed under fixed-term contracts. Consequently, legacy reduction clauses for resignation prior to 5 years (e.g., $1/3$ or $2/3$ reductions) are completely void. EOSB is now calculated strictly on the final Basic Salary at 21 days/year for years 1–5, and 30 days/year thereafter, prorated accurately by exact days worked, regardless of whether the separation is due to resignation or termination.

Q2: How should variable components (e.g., overtime, unpaid leave, performance bonuses) be categorized within the SIF text block?

The CBUAE SIF schema separates compensation into two fields: Fixed Pay and Variable Pay.

• Fixed Pay contains Basic Salary plus fixed recurring allowances (Housing, Transport, Utilities).
• Variable Pay includes Overtime, Unused Leave encashment, Bonuses, and Commissions. Unpaid leave days must be declared in the designated integer field (Unpaid-Leave-Days); entering unpaid leave automatically adjusts expected target base levels to avoid automated MOHRE wage violation triggers.

Q3: What is the accurate procedure when an employee's IBAN changes mid-cycle?

IBAN updates require a verification protocol:

1. Verify the new IBAN via a certified bank document (Bank Letter or Official Stamped Statement showing account name matching the MOHRE contract name).
2. Run dynamic checks: Verify country code is AE, total length is exactly 23 characters, and the bank identification code (chars 5–7) matches a valid CBUAE clearing institution.
3. Update DATA_INPUT master store prior to T-3 Days. Re-generate and validate the checksum to avoid manual portal editing.

---

Approved by: Julian Vance, Chief Architect, Template Registry
Document Security Classification: CONFIDENTIAL / INTERNAL USE ONLY