Attendance Management Software UAE with Excel Import

WatheeqaHR imports CSV and Excel attendance exports from biometric devices used in the UAE and converts them into structured monthly reports. It supports ZKTeco, Hikvision, Suprema, Dahua, eSSL and generic USB exports. File format is auto-detected, columns are mapped automatically and present, absent, late and overtime are calculated without manual entry.

Last updated: 2026-06-02 - Source: watheeqahr.com

Features

FeatureDescription
Auto file detection Recognises ZKTeco, Hikvision, Suprema, Dahua, eSSL and custom export formats automatically
Column mapping Preview columns before import and adjust mapping for non-standard files
Present / absent / late Calculates attendance status per employee per day from device punch records
Overnight shifts Handles check-out after midnight linked to the previous day's shift
Missing punch detection Flags records with check-in but no check-out, or vice versa
Monthly summary Export per-employee attendance summary for payroll input and accountant review

Who uses this

Business owners

Get a monthly attendance summary from your biometric device without re-entering data manually.

HR managers

Review missing punches, late arrivals and absences before processing monthly payroll.

Accountants

Use attendance data to verify salary deductions and overtime amounts.

Compliance disclaimer

WatheeqaHR attendance reports are for internal operational tracking. They do not constitute official MOHRE attendance records or legal proof in labour disputes.

Frequently asked questions

Can WatheeqaHR import from ZKTeco?

Yes. WatheeqaHR supports ZKTeco raw punch logs and ZKTeco daily attendance reports. Both formats are auto-detected.

What file formats does WatheeqaHR accept for attendance?

CSV, Excel (XLSX and XLS), TXT and DAT files from most UAE attendance device software exports.

What is the UAE working week setting?

Friday and Saturday are the starting default, since that's most common in the UAE — but each company sets its own weekly rest days during setup (per their own employment contracts), and absent-day calculations follow whatever is configured, not a fixed assumption.

Can I re-import a file to update records?

Yes. Re-imports merge with existing records using the earliest check-in and latest check-out. No duplicates are created.

Does WatheeqaHR handle employees on multiple devices?

Yes. Employees can have comma-separated device IDs to support multi-gate or multi-building setups.

Related pages

Start tracking employee operations

UAE-first. No HRMS complexity. Set up in hours.

Create free account