Top
Request a demo Start a free trial

Using the Attendance Report

  • all plans
  • hr

Availability: All plans with the Workable HR package

Key info: Overview of each employee's scheduled and tracked working hours

Data filter: Time entry creation date

Update frequency: Every 30 minutes

To access the report:

  1. Go to Reports in the main navigation bar
  2. Open the Employee Management tab

HR Admins and Line managers can access this report.

The time when the report was last synced is shown at the top of the report.

 

Filtering and sorting

Use the filter options to narrow down report data by time tracking policy, department, entity & location, or employee (you can select more than one at a time). Advanced filtering is available, allowing you to filter by any table column — including the hours columns (Scheduled hours, Worked hours, and Deviation). Filters follow the format [filter] [operator] [value].

Most columns are sortable. Select a column header to sort the table in ascending or descending order.

You can customize which columns are visible in the report, as well as their order. Select the column picker to add, remove, or reorder columns. Resetting the columns returns them to the default state.

 

Grouping

The report defaults to the View by Day view, which lists time entries grouped by day for a given date range for all employees. Individual time entries for each day are visible. The default preset date range for this grouping is Today.

The Group by Employee view lists time entries grouped by employee for a given date range. Individual time entries for each day are visible. The default preset date range for this grouping is Today.

You can also group data by Week or Month to get an aggregated overview of employee attendance performance across a broader time period. In these views, fields such as deviation reason, work schedule, workplace, and notes display as counts of occurrences rather than individual values.

Entries are shown for only the time an employee was active (data will not show before an employee's start date or after the employee's offboarding date). The columns shown are:

 

Column Explanation
Date  
Employee name

Selecting an employee's name opens their time tracking tab directly, allowing you to quickly review or fix specific time records.
Employee ID  
Work schedule

Displays the work schedule for the specific employee for that date. For example, 09:00AM - 05:00PM, or in case of a double schedule, 09:00AM-1:00PM 5:00AM-9:00PM. In case the employee is on Time-off, Holiday or non-working day (i.e. weekend), the columns show as such:

  • Time off - amount e.g., "PTO UK · 1 day" or "Parental leave · 2h"
  • Public Holiday
  • Day off

In the week or month view, this field displays a count of the different schedule occurrences within the period.

Note: If no work schedule is assigned to the employee, it will show as overtime all the time.
Time entries
  • Displays the time entries for the specific employee for that date. For example, 09:00AM - 05:30PM.
  • In case of no entries, it will appear as empty "-".
  • In case there is an active entry, the end time will appear as "Ongoing".
Scheduled hours
  • Displays the total hours the employee is expected to work that day in hours and minutes (e.g., 8h 30m).
  • In case the employee is on approved Time-off, Holiday, or non-working day (i.e. weekend) the columns will appear as empty "-".
  • Breaks are not accounted for in this column — only start & end time.
Worked hours
  • Displays the total hours worked by the employee for that day in hours and minutes (e.g., 8h 45m).
  • When exporting this value to CSV, it is displayed as a float with 3 decimal places of precision. This is so payroll providers can utilize this information to calculate payment according to worked hours — especially useful for hourly employees in the US.
Deviation

Displays the hours an employee deviated from the expected schedule (actual hours - scheduled hours), shown in hours and minutes. Can be negative if the employee worked less than expected.

Important: This data is not meant to be used for payroll purposes, only to help HR admins flag any significant discrepancies between scheduled and actual hours.
Deviation reason

Flags reasons where the time entry does not match the expected schedule:

  • No Deviation
  • Missing time entry: When the employee was expected to work and there were no entries.
  • Partial time entry: When the employee was expected to work and there are partial entries (i.e., only clock in but no clock out).
  • Unplanned attendance: When the employee was not expected that day (for the full length of that day) but actually worked.

In the week or month view, this field displays a count of each deviation reason type across the period.
Workplace

Displays whether the employee worked on-site or remotely. This value only shows on working days. Days where an employee took a half day or a few hours of leave still count as working days for this column.

In the week or month view, this field displays a count of on-site and remote occurrences within the period.
Over-scheduled hours Displays the total hours worked above the scheduled hours for the period (e.g., 1h 15m). This column helps identify employees who are consistently working beyond their expected schedule.
Under-scheduled hours Displays the total hours the employee fell short of their scheduled hours for the period (e.g., -0h 45m). This column helps identify employees who may need attention or schedule adjustments.
Note
  • Displays any (optional) time entry notes that were accompanying a time entry.
  • In case there are no time entries for that employee for that day, this value will be empty.
  • In the week or month view, this field displays a count of notes left within the period.

Note: Since this report also triages time tracking information alongside data from work schedules, time-off, and holiday calendars, altering any of these will have an immediate impact on the report.

 

Employee row highlights

Employees are highlighted based on the presence of a deviation reason:

  • Missing entries are highlighted in red.
  • Unplanned attendance is highlighted in red.
  • Partial entries are highlighted in orange.

 

Saving, scheduling, and exporting

The attendance report can be saved and scheduled. Saved reports are listed under the Custom reports section of the Employee Management tab. When saving, your column selection, order, and applied filters are all preserved.

To export the report, select Download CSV. The export is processed asynchronously — once ready, a link will be sent to your email address. Export links are valid for 7 days. A maximum of 100,000 rows applies per CSV export.

Note: PDF export is temporarily unavailable. Any scheduled reports with PDF export will notify you that only CSV exports can be delivered in the meantime.

Related articles