HR Attendance Report Generator

You have Viewer access. Contact an administrator to upload files and generate reports.

1

Select Report Period

Month

Year

2

Upload Documents

Report Period:

Attendance File *Required

File Requirements:

Excel file (.xlsx) with attendance log data from Biostat
Concidered user groups are "GCGRA", "GCGRA ELT", "All Users"
Concidered devices: Entrance/Exit to Main Reception, Staff, Pantry, CEO + Chairman

Drag & Drop your Attendance file here

or

Absence File *Required

File Requirements:

Excel file (.xlsx) with absence/leave records
Only "Completed" Approval Status will be counted
Please make sure to manually split batch Remote Work entries

Drag & Drop your Absence file here

or

Holidays File (Optional - uses existing if not uploaded)

ℹ️ Current holidays file: Loading...

File Requirements:

Excel file (.xlsx) with public holidays
Optional: Detail column with reduced hours (e.g., 05:30 for Ramadan)
Current Holiday version on SharePoint

Drag & Drop to update Holidays file

or

Employee Joining Dates (DOJ) (Optional - uses existing if not uploaded)

ℹ️ Current DOJ file: Loading...

File Requirements:

Excel file (.xlsx) with employee name/DOJ mappings
Current DOJ version on SharePoint

Drag & Drop to update DOJ file

or

3

Processing

Uploading files to SharePoint...

✓

Analysis Complete

Your attendance reports have been generated successfully!

Download Monthly Report Download Yearly Report

!

HR Attendance Report Generator

Select Report Period

Upload Documents

Attendance File *Required

Absence File *Required

Holidays File (Optional - uses existing if not uploaded)

Employee Joining Dates (DOJ) (Optional - uses existing if not uploaded)

Processing

Analysis Complete

Error

Attendance Analytics Dashboard

Admin Access Required