RPT-19 — Payroll & WPS Reconciliation
Certified payrun-to-bank/WPS reconciliation for Payroll and Finance. Report owner: Fatima Rashid (Finance Manager) · metric maker: Daniel Chen (Accountant). Cadence: per payrun · viewing payrun PR-2026-07M.
RPT-19
HR-05
§9.2
Report certification & definition
Certified
Definition v3.1
- Report owner
- FRFatima Rashid — Finance Manager
- Business definition
- Approved payrun snapshot totals vs generated bank/WPS SIF file totals vs bank acknowledgement, per payrun
- Authoritative dataset
dwh.fct_payroll_reconciliation(governed semantic layer)- Refresh cadence
- Per payrun approval event · certified snapshot on bank acknowledgement
- Last refresh
- 17 Jul 2026 13:42 GST (payrun PR-2026-07M approved 13:40)
- Certification state
- Certified — reconciled through PR-2026-06M; PR-2026-07M in transit
- Definition version
- RPT-19 v3.1 · approved 02 Jun 2026 (change CHG-2026-0451)
- Governing policy versions
- WPS jurisdiction pack
UAE-WPS v4.2(signed) · payroll policy packPAY-2026.2· authority matrixAM-v9 - Currency / time zone
- AED · Gulf Standard Time (UTC+4) · fiscal year FY2026
- Access scope
- Payroll Officer, Finance Manager, Auditor (read-only) — salary detail masked for all other roles
PR-2026-07M net pay
AED 1,770,120.00
▲ 0.12% vs Jun · within ±5% tolerance
Employees in payrun
148
+1 net (3 joiners, 2 leavers)
WPS/SIF status
Generated v2
Schema valid · awaiting bank ack
Payrun ↔ SIF difference
AED 0.00
Zero-unexplained-difference gate met
Variance exceptions
1
▼ flagged deduction cap check — see below
PR-2026-07M net pay by departmentGoverned dimension: DEPT v4
| Department | Employees | Net pay (AED) | Δ vs Jun |
|---|---|---|---|
| Sales | 41 | 512,400.00 | +0.4% |
| Operations | 38 | 396,200.00 | +0.1% |
| Finance | 14 | 232,180.00 | 0.0% |
| Technology | 15 | 214,300.00 | 0.0% |
| Compliance | 11 | 148,340.00 | +0.2% |
| Facilities | 19 | 145,000.00 | −0.3% |
| HR | 10 | 121,700.00 | 0.0% |
| Total PR-2026-07M | 148 | 1,770,120.00 | +0.12% |
Variance & control checks — PR-2026-07M1 exception
| Check | Result | Tolerance / rule | Status |
|---|---|---|---|
| Net pay vs prior month | +0.12% | ±5% (PAY-2026.2 §4) | Pass |
| Headcount movement | 3 joiners · 2 leavers | All from approved HR events | Pass |
| Salary changes applied | 4 | All approved, effective-dated | Pass |
| Approved commission import | AED 86,200.00 | From RPT-07 approved statements | Pass |
| Lawful deduction cap | EMP-0781 loan 27.4% of wage | ≤25% per UAE-WPS v4.2 | Exception — held for checker |
| WPS/SIF schema validation | SIF-2026-07M v2 | Reject unvalidated schema (HR-05) | Valid |
| Maker-checker approval | Maker DC 13:12 → Checker FR 13:40 | SoD: maker ≠ checker | Enforced |
Payrun ↔ bank/WPS reconciliation register — FY2026 (9 payruns)
Drill-down is permission-aware
| Payrun | Period / type | Maker → checker | Emp. | Gross (AED) | Net pay (AED) | WPS / SIF file | Bank ack | Reconciliation |
|---|---|---|---|---|---|---|---|---|
Approved 17 Jul 13:40 |
Jul 2026 · monthly | Daniel Chen → Fatima Rashid |
148 | 1,984,300.00 | 1,770,120.00 | SIF-2026-07M v2 sha256 9f3a…c2e1 · ENBD H2H · IBAN AE07 0331 ●●●● ●●●● ●●●● 456 |
Awaiting ack | In transit · Δ 0.00 |
PR-2026-06C Commission run · links RPT-07 |
Jun 2026 · commission | Daniel Chen → Fatima Rashid |
12 | 412,600.00 | 412,600.00 | SIF-2026-06C v1 sha256 4b7d…08aa |
Ack 01 Jul 10:04 | Reconciled · Δ 0.00 |
PR-2026-06M Approved 25 Jun |
Jun 2026 · monthly | Daniel Chen → Fatima Rashid |
147 | 1,981,050.00 | 1,768,050.00 | SIF-2026-06M v1 sha256 c118…7f30 |
Ack 28 Jun 09:31 | Reconciled · Δ 0.00 |
PR-2026-05X End-of-service · 2 employees · HR-06 preview → approved |
May 2026 · off-cycle | Daniel Chen → Fatima Rashid |
2 | 96,410.00 | 96,410.00 | SIF-2026-05X v1 sha256 77d0…b3c4 |
Ack 30 May 11:18 | Reconciled · Δ 0.00 |
PR-2026-05M Approved 25 May |
May 2026 · monthly | Daniel Chen → Fatima Rashid |
146 | 1,976,400.00 | 1,764,880.00 | SIF-2026-05M v1 sha256 a90f…2d11 |
Ack 27 May 09:12 | Reconciled · Δ 0.00 |
PR-2026-04M SIF v1 rejected — schema → regenerated v2 (HR-05: unvalidated schema rejected) |
Apr 2026 · monthly | Daniel Chen → Fatima Rashid |
146 | 1,971,200.00 | 1,760,240.00 | SIF-2026-04M v2 sha256 e4c2…9910 · v1 retained as evidence |
Ack 28 Apr 10:02 | Reconciled · Δ 0.00 |
PR-2026-03M Approved 25 Mar |
Mar 2026 · monthly | Daniel Chen → Fatima Rashid |
145 | 1,966,300.00 | 1,755,900.00 | SIF-2026-03M v1 sha256 1b6e…44af |
Ack 27 Mar 09:44 | Reconciled · Δ 0.00 |
PR-2026-02M Approved 25 Feb |
Feb 2026 · monthly | Daniel Chen → Fatima Rashid |
144 | 1,948,900.00 | 1,738,450.00 | SIF-2026-02M v1 sha256 5aa3…d802 |
Ack 26 Feb 10:15 | Reconciled · Δ 0.00 |
PR-2026-01M Approved 25 Jan |
Jan 2026 · monthly | Daniel Chen → Fatima Rashid |
144 | 1,952,700.00 | 1,742,300.00 | SIF-2026-01M v1 sha256 08fe…61c9 |
Ack 27 Jan 09:58 | Reconciled · Δ 0.00 |
| FY2026 YTD reconciliation total | — | 14,289,860.00 | 12,808,950.00 | Bank/WPS acknowledged: AED 11,038,830.00 | In transit: AED 1,770,120.00 | Unexplained Δ AED 0.00 | ||
Rows 1–9 of 9 · payslip-level drill-down restricted to Payroll/Finance roles
Lineage — source to report (§9.2)Lineage ref LIN-RPT19-v3
hr.payrun_snapshot→
hr.payslip_lines→
bank.wps_sif_files→
tfm_payroll_recon v2026.07.1 (policy PAY-2026.2)→
dwh.fct_payroll_reconciliation→
RPT-19 viewer
| Source object | System | Version / watermark | Extracted |
|---|---|---|---|
hr.payrun_snapshot | HR / Payroll | Immutable approved snapshot PR-2026-07M | 17 Jul 13:41 |
hr.payslip_lines | HR / Payroll | Snapshot-bound · policy pack PAY-2026.2 | 17 Jul 13:41 |
bank.wps_sif_files | Banking gateway | SIF-2026-07M v2 · UAE-WPS v4.2 | 17 Jul 13:42 |
fin.bank_acknowledgements | ENBD host-to-host | Through 28 Jun (07M pending) | 17 Jul 13:42 |
Report definition of done (§9.2)7 / 7 met
| §9.2 criterion | Status | Evidence |
|---|---|---|
| Named owner & business definition | Met | Fatima Rashid · definition v3.1 |
| Authoritative dataset & lineage | Met | dwh.fct_payroll_reconciliation · LIN-RPT19-v3 |
| Filters, dimensions, currency/time zone | Met | AED · GST · DEPT v4 · payrun dimension |
| Refresh & certification state | Met | Per payrun · Certified badge shown |
| Permission-aware drill-down, controlled export | Met | Role-scoped payslip drill-down · watermarked export |
| Reconciliation totals, tolerances, evidence | Met | Zero-unexplained-difference tfoot · SIF hashes |
| Accessible chart/table alternative · EN/AR labels | Met | Bars + table above · AR label set v1.4 approved |
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: RPT-19 (Table 15), §9.1–9.2 reporting principles & definition of done, HR-05 payroll/WPS controls.