The whole reason to install an attendance system is what happens at month-end. A biometric machine that captures punches but does not feed payroll cleanly has not solved the problem, it has moved it. Here is what a working integration between attendance and payroll actually looks like in a UAE deployment.
The end-to-end flow
An employee walks up to the terminal at 08:42 on the 14th. What happens between that moment and their salary hitting their bank on the 30th:
-
08:42:00: Face terminal captures the employee, matches against the enrolled template in 0.5 seconds, sends a check-in event to the attendance software with timestamp, employee ID and terminal ID.
-
Throughout the shift: the same happens for breaks (if configured) and check-out. Every event is timestamped and stored with a full audit trail.
-
End of shift: the software groups the day's punches into a shift, applies any grace period, calculates worked hours, and identifies overtime by rule.
-
End of pay period: the software aggregates every employee's worked hours, overtime hours, absences and late deductions across the period. The audit trail records every edit and approval.
-
Payroll day: an HR or finance user runs the payroll export. The software produces a file with columns matching the payroll process: employee ID, worked hours, overtime hours, deductions, absence hours, per day and per period.
-
Payroll processing: the export file feeds the payroll system (Zoho Payroll, Bayzat, Peoplestrong, an internal ERP module, or an Excel-based process). Salary calculation applies the base salary, allowances and deductions.
-
WPS SIF submission: the payroll system produces the SIF file for WPS submission through your bank or exchange house. The salary figures in the SIF are the output of the payroll calculation, which used the attendance file as an input.
At no point in that sequence does anyone retype timesheets by hand.
What the software calculates that a spreadsheet gets wrong
Spreadsheets can do the arithmetic. What they get wrong consistently is the UAE-specific rule application:
Overtime by day type. Weekday overtime at 1.25×, Friday and rest-day overtime at your configured multiplier, public holiday overtime at another. In a spreadsheet, this becomes a set of nested IF formulas that go wrong at every edge case. In the software, it is configured once and applied every month.
Ramadan working hour reductions. Reduced hours for the fasting period apply automatically. In a spreadsheet, an accountant remembers to adjust the roster (sometimes) and then remembers to unadjust it after Eid (less often).
Public holidays. UAE public holidays maintained centrally in the software calendar. A spreadsheet needs an accountant to maintain a list of dates every year and remember to reference it correctly.
Grace periods. "Late by less than 15 minutes does not attract a deduction." Applied to every punch by the software; forgotten on some days in a spreadsheet.
Approved leave adjustments. A day of approved leave should not count as unpaid absence. In a spreadsheet, this requires the accountant to know which leave was approved. In the software, the leave calendar is joined to the attendance data automatically.
Rest day identification. The rest day may differ by employee (Friday for most, Sunday for some in specific sectors). The software knows each employee's rest day; a spreadsheet often gets this wrong for edge cases.
The WPS side, honestly
A common misconception: "does the attendance software generate the WPS SIF file?" Not directly. WPS SIF is the file your payroll process produces for submission to the bank or exchange house for salary transfer. It contains the final salary figures.
What the attendance software does is produce the inputs to the payroll calculation: the actual worked hours, overtime, deductions and absences per employee per period. Your payroll process then:
- Starts with the employee's base salary and allowances.
- Applies attendance-driven adjustments (overtime pay, late deductions, unpaid absence).
- Produces the final net salary.
- Formats the SIF file to WPS specification.
If your payroll system already handles WPS SIF generation, the attendance software feeds it the numbers it needs. If your payroll is a manual Excel process, we can produce a report structured to make the WPS calculation straightforward.
Integration architectures
Three common patterns in UAE deployments:
File-based export. The attendance software produces an Excel or CSV file at the end of each period, formatted to your payroll process's expected columns. Manually uploaded to payroll. Simplest and most common; works with any payroll system.
Direct API integration. For payroll systems that expose an API (Zoho Payroll, some HRMS platforms), attendance data pushes directly without a file step. Faster but requires the payroll system to support it.
Shared HRMS. Some organisations run a single HRMS platform that includes both attendance and payroll modules. Data never leaves the platform. Cleanest architecturally, but locks you into one vendor.
We support the first pattern by default and integrate directly where the payroll system allows it.
What the MOHRE side sees
Beyond the payroll flow, attendance data is the evidence base for MOHRE record-keeping. Specifically:
- Hours worked must be defensible. Biometric records are stronger evidence than paper.
- Overtime paid must be defensible. The calculation trail must show how each overtime hour was classified.
- Leave and absence must be tracked and reconciled with salary payments.
An integrated attendance and payroll system produces this evidence base without any additional work. When an inspection asks for records, they are exported in seconds for any date range.
What testing at handover should look like
Before signing off an integration, run:
-
Payroll dry-run. Take a real month of attendance data, run it through the software, produce the payroll export, run it through your payroll process, compare the salary output against what you calculated manually for the same month.
-
Overtime edge case testing. A public holiday shift, a rest day overtime shift, a Ramadan period, an employee on approved leave for part of the period. Verify the software handles each correctly.
-
WPS SIF end-to-end test. Produce the SIF from the payroll output, verify the format is accepted by your bank's WPS portal (in a sandbox or with a small test batch).
Any supplier who resists this level of pre-handover testing is not confident in their integration. Any supplier confident in their integration welcomes it.
Related reading
- Time attendance machine vs attendance software
- How attendance machines help UAE businesses manage employee attendance
- What should you check before buying a time attendance machine?
Or book a free site survey, we integrate with your payroll process before we take the invoice.