Attendance Monitoring & Payroll Reporting

📊 Live Attendance Monitoring Hub

The Attendance Module (/attendance) in Work Clock HQ serves as the central command center for real-time workforce visibility. It provides administrators, HR managers, and team supervisors with live oversight of clock-in and clock-out activity across all company users (employees, staff members, contractors, and field personnel).

---

📊 Real-Time Attendance Stat Metrics

At the top of the Attendance dashboard, administrators are provided with five real-time stat cards that summarize daily workforce attendance and punctuality trends:

Stat Metric	Description & Operational Value
📊 Total Attendance	Displays the cumulative count of attendance entries logged during the selected date range.
⏱️ Users On Time	Count of users who successfully registered clock-in on or before their scheduled shift start time.
⚠️ Late Users	Count of users who clocked in after their scheduled start time (beyond any configured grace periods).
❌ Absent Users	Count of users who failed to register attendance for their scheduled work shift.
📉 Average Lateness	Real-time percentage or time metric tracking workforce lateness trends to assist in management evaluations.

---

🔍 Toolbar Controls, Date Ranges & CSV Exports

Located directly above the main attendance records table, the toolbar provides powerful filtering and reporting tools:

📅 Custom Date Range Picker

Administrators can inspect logs across customized operational windows. By default, the date range selector is set to the current calendar month (Start of Month to End of Month). You can easily customize this to reflect weekly pay periods, semi-monthly payrolls, or specific custom dates.

🎯 Punctuality Status Filter

Filter the directory display using the status dropdown selector:

• All Status: Displays all attendance entries regardless of punctuality.
• On Time: Displays entries where clock-in occurred within schedule boundaries.
• Late: Filters for staff who clocked in after shift start time.
• Early: Filters for users who logged out or clocked in early.
• Absent: Displays recorded shift absences.

📥 Exporting Attendance & Payroll Data

Work Clock HQ makes payroll preparation effortless with one-click data exporting:

1. Set your desired Date Range and Status Filter in the toolbar.
2. Click the Export button (featuring the cloud download icon).
3. The system automatically fetches all matching workspace records and generates a formatted CSV report file (attendance_report_YYYY-MM-DD.csv).

[!TIP] Export CSV Contents: The generated report includes staff full names, log dates, exact clock-in timestamps, clock-in locations/IP addresses, clock-out timestamps, clock-out locations, assigned work schedules, calculated total hours logged, and final attendance status badges.

---

📋 Interactive Attendance Table & Directory

The main table presents a clean, responsive ledger of every attendance record:

• Date: The calendar day of the recorded shift.
• Name: The full name of the staff member. Clicking on a user's name acts as a direct shortcut to their detailed profile hub (/employees/detail?id={id}).
• Clock In & Location: Exact time of check-in accompanied by verification icons (GPS map pin, web portal, or hardware biometric clock).
• Clock Out & Location: Exact time of check-out and departure location verification.
• Schedule: The assigned shift time window (e.g., 08:00 AM - 05:00 PM).
• Time Logged: Total calculated hours and minutes spent on duty.
• Status Badge: Visual color-coded badges indicating punctuality state:
  • 🟢 On Time (Green)
  • 🟠 Late (Amber/Orange)
  • 🔴 Absent (Red)

---

🔍 Deep-Dive Attendance Detail Modal

Clicking anywhere on an attendance table row opens the interactive Attendance Detail Modal, providing exhaustive technical verification for that specific shift record across multiple tabs:

1. 📍 Overview / Clock In Tab

Presents complete technical validation captured at the exact moment of check-in:

• Exact Timestamp: High-precision time log.
• GPS Coordinates & Map Pin: Interactive map display showing the physical latitude and longitude recorded by the user's device.
• Geofence Verification: Clear badge indicating whether the user was inside their assigned office geofence radius upon check-in.
• Verification Method: Identifies if clock-in was performed via Mobile App (GPS), Web Browser Portal, or Biometric Hardware Terminal (fingerprint/facial scan).
• Device & IP Signature: Displays device model, OS version, app build, and network IP address for audit trail security.

2. 🏁 Clock Out Tab

Details the shift completion metrics:

• Departure timestamp and location coordinates.
• Clock-out method and device details.
• Net calculated hours worked.

3. 🗺️ Location Logs & Movement Tracking Tab

For organizations utilizing background tracking or mobile heartbeat features, this tab displays periodic ping logs and movement breadcrumbs registered by the staff member during active shift hours.

4. 💬 Comments & Lateness/Absence Reasons Tab

(Automatically enabled for Late or Absent records) When a user is late or absent, Work Clock HQ allows staff to submit explanations directly through their portal:

• User Explanation: View the written excuse or reason submitted by the employee.
• Supporting Attachments: Click attached document or photo links to review medical notes, traffic proof, or emergency documentation.
• Admin Feedback: Administrators can review, acknowledge, or attach supervisor notes directly to the record.

---

🔐 Permission Requirements

Access to attendance management features is controlled by strict permission policies:

Action / Feature	Required Permission Code
View Attendance Logs & Stats	ATTENDANCE.VIEW
Export Attendance & Payroll CSV Reports	data_export (Plan Feature)
Edit Attendance / Reset Logs	ATTENDANCE.EDIT

---

❓ Frequently Asked Questions

Why does a clock-in display a red location warning badge?

A warning badge indicates that the user registered their clock-in from a physical location or IP address outside their assigned office branch geofence radius. You can click the row to open the Attendance Detail Modal and view the exact GPS map pin recorded at check-in.

How are total hours logged calculated?

Total hours logged represent the precise elapsed time between the user's clock-in timestamp and clock-out timestamp, accounting for configured grace periods or flexible clock-out allowances.

Can I export attendance logs for a specific department only?

Yes! You can apply department filters on the Users Hub (/employees) or filter by specific date ranges on the Attendance Hub (/attendance) before initiating the CSV export.