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 1 hour

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 Group 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'.

Note: Aggregated views by week or month are available in the Enterprise plan's report builder.

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

  

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
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 with minute granularity.
  • 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 this column - only start & end time.

Worked hours
  • Displays the total worked hours that an employee worked that day with minute granularity.
  • 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 worked hours an employee deviated against the expected (actual hours - scheduled). Can be negative if 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

Only available for Group by Day / Employee views. It 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.

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.

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.

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.

Known issue: At this time, all hours columns display as numeric values (e.g., 8.50 instead of 8h30m). This will be fixed in an upcoming update. The numeric format will continue to be used for CSV exports, as it is useful for payroll purposes.

 

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.

Related articles