Owners, HR managers and admins processing monthly attendance
How to Import an Attendance File (Excel/CSV) in WatheeqaHR
Go to Attendance > Import File, upload the Excel or CSV export from your biometric device, review the auto-detected column mapping, then confirm. WatheeqaHR auto-detects ZKTeco, Hikvision, Suprema, Dahua, eSSL and generic exports and calculates present/absent/late/overtime per employee automatically.
Steps
-
Confirm your work calendar first
If you haven't already, set your shift times and weekly off days in Settings > Work Calendar — WatheeqaHR will prompt you if this step is missing.
-
Go to Attendance > Import File
Open the Attendance page from the sidebar; the Import File tab is selected by default.
-
Upload your file
Drag or select the .xls, .xlsx or .csv file exported from your attendance device or software.
-
Review the column mapping
WatheeqaHR auto-detects columns like Employee ID/Enrollment No, Date, and Time. Adjust manually if your device uses a non-standard export format.
-
Confirm the import
WatheeqaHR calculates present, absent, late and overtime for each employee and each day based on your work calendar.
-
Review the results
Check the import summary for row errors or unmatched employee IDs, then review the report before it's used for salary.
Frequently asked questions
Which devices are supported?
What happens if an employee ID isn't recognized?
Does importing immediately affect salary?
Still need help?
Contact your account owner/admin, or reach our support team from inside the app.
Create free account