Reports & Analytics
Generate, filter, and export comprehensive reports covering attendance, payroll, vacations, and more.
Reports Hub Overview
The Reports hub is your central dashboard for generating and accessing all system reports. Each report type is represented by a card with quick access to filters and export options.
| Report Type | Description | Export |
|---|---|---|
| Attendance | Detailed daily check-in / check-out records for all employees. | PDF, Excel |
| Attendance Summary | Aggregated attendance statistics per employee. | PDF, Excel |
| Employees | Complete employee directory with personal and employment details. | PDF, Excel |
| Payroll | Detailed salary breakdown with bonuses, deductions, and net pay. | |
| Absences | Records of all employee absences with dates and reasons. | PDF, Excel |
| Vacations | Summary of vacation requests, approvals, and remaining balances. | PDF, Excel |
| Detailed Vacations | In-depth vacation report with type, duration, and approval chain. | PDF, Excel |
| Yearly Vacations | Annual vacation entitlement, used, and remaining days per employee. | PDF, Excel |
| End of Service | End-of-service bonus calculations based on labor law regulations. | |
| Single Punch | Employees who checked in but did not check out (or vice versa). | PDF, Excel |
| Vacation Calendar | Visual calendar view showing all scheduled vacations across the team. | — |
Attendance Report
The detailed attendance report shows check-in/check-out records for every employee. Use filters to narrow down by branch, department, date range, or individual employee.
| Employee | Present | Absent | Late | Rate |
|---|---|---|---|---|
| Ahmed M. | 26 | 0 | 1 | 100% |
| Sara A. | 24 | 1 | 3 | 92% |
Available Filters
| Filters | Description |
|---|---|
| Date Range | Select a start and end date for the report period. |
| Employee | Search and select a specific employee. |
| Branch | Filter by a specific company branch. |
| Department | Filter by department within a branch. |
| Status | Filter by attendance status (Present, Late, Absent, Leave). |
Attendance Columns
| Column | Description |
|---|---|
| Employee Name | Full name of the employee. |
| Date | The working day. |
| Check-In | Time the employee checked in. |
| Check-Out | Time the employee checked out. |
| Total Hours | Calculated working hours for the day. |
| Overtime | Extra hours beyond the scheduled shift. |
| Status | Present, Late, Absent, or On Leave. |
Attendance Summary Report
Aggregated view showing total present days, absences, late arrivals, and overtime per employee for a given period.
Shows total working days, absences, late arrivals, early departures, and overtime hours for each employee.
Payroll Report
The payroll report provides a comprehensive breakdown of salary components for all employees during a payroll period.
| Column | Description |
|---|---|
| Employee | Employee name and ID. |
| Basic Salary | The base monthly salary before additions or deductions. |
| Overtime | Total overtime pay calculated based on hourly rate. |
| Bonuses | Sum of all approved bonuses for the period. |
| Deductions | Sum of all applied deductions (absences, late penalties, etc.). |
| Net Salary | Final amount after all additions and deductions. |
Absences & Vacations Reports
Multiple specialized reports cover different aspects of employee leave:
Tracks unexcused and excused absences by date and reason.
Vacation Reports
The system offers several vacation-focused reports for different needs:
Vacations
Overview of all vacation requests with approval status.
Detailed Vacations
Extended details including type, approval chain, and attached documents.
Yearly Vacations
Annual entitlement calculations showing used, remaining, and carried-over days.
Vacation Calendar
A visual calendar showing when each team member is on vacation — useful for workforce planning.
Other Report Types
Employees
Includes hire date, department, position, salary, and contact information.
End of Service
Calculates end-of-service bonus according to local labor law based on years of service and last salary.
Single Punch
Lists employees with incomplete attendance records (missing check-in or check-out).
Export Formats
All reports can be exported in multiple formats for offline analysis and record-keeping.
| Format | Description | Best For |
|---|---|---|
| Formatted, print-ready document with company header and styling. | Printing, sharing with management, official records. | |
| Excel | Spreadsheet file with raw data for further analysis. | Data analysis, custom calculations, importing into other systems. |
Example: Generating a Monthly Attendance Report
Open Reports Hub
Navigate to Reports from the sidebar and click the "Attendance" card.
Set Filters
Select branch "Cairo", date range "01 Jan – 31 Jan 2025", and leave status as "All".
Generate Report
Click "Generate" to view the report. Review the attendance data in the table below.
Export as PDF
Click the "Export PDF" button. The report downloads with company header and formatting ready for printing.