To view and export a complete summary of employee attendance and activity:
Go to the Dashboard Tab
Click on the Summarize Report subtab.Default Date Range
The system automatically shows a pre-arranged 31-day summary (typically the previous month).
What You Can View
The summary includes comprehensive sections such as:Employee Info: Name, Department, Position, Location
Scheduled Section:
Working Days
Working Hours
Days Off
Holidays
Attendance Section:
Actual Working Days
Actual Working Hours
Absent Days
Attendance on Day Off
Attendance on Holidays
Leave Days
Late Days & Hours
OT Hours
Leave Section:
Unpaid Leave
Total Leave
Customize Date Range
You can change the date range to suit your reporting needs.
Export Options
Click the up arrow icon beside the date selector to access export options:Export Summary Data
Export Day-by-Day Report (only available for ≤60 days)
Export Location Snapshot
Download the File
Once generated, the file appears in the Downloads icon at the bottom left corner.
Click “Download” to get the Excel file.
Understanding the Excel File Tabs
Summary Dashboard: High-level view (same as what you see in system)
Absent Detail: Employees marked absent
Late Detail: Late check-ins
Early Checkout Detail: Early checkouts
No Check-in but Has Check-out
No Check-out
Overtime Detail: For clients using old OT feature
Unpaid Leave Detail
Leave Detail: All leave types
Day Off Attendance Detail
Remote Check In/Out Detail
Export Day-by-Day Report (Disabled if range > 60 days)
Includes detailed check-in/out times with color-coded highlights for:Late Minutes
Leaves
Absences
Public Holidays
Days Off
Export Location Snapshot
If employees use the Location Snapshot feature in the Better HR app, this export shows:
Date and time of each location snapshot
Latitude and longitude of the exact location shared
Useful for tracking remote attendance or fieldwork locations
