Attendance Report: tardiness, absences and amendments

Attendance Report: tardiness, absences and amendments

Use the Attendance Report to see, per employee, how many days they were late or absent, how often they asked to correct their attendance, and how many short-notice vacation and sick leave requests they made. It is the report to open before a performance conversation or a disciplinary review, because it puts the counts for a whole team side by side, and you can export it.

Where: Attendance › Tools & Reports › Attendance Report

You need: the Team Attendance right. You see only the people your access covers. See Attendance user rights.

When to use this, and when not to

The questionUse
Who is late or absent most often?Attendance Report, here
How many hours were lost to lateness overall?Attendance Rate
What happened on one person's day?Event List
What are we paying this period?Timesheet

How to run the Attendance Report

  1. Go to Attendance › Tools & Reports and open Attendance Report. It opens on the last 7 days.
  2. Set the date range.
  3. Use Search to find a person, or select Filters to narrow by Department, Branch, Position, Cost Centre, Subsidiary or Group.
  4. To count only some kinds of amendment, choose one or more reasons under Standard Response in Filters.
  5. Select a column header to sort, for example Tardy, to put the most frequent first.

How to export it

  1. Set the date range and filters you want in the file.
  2. Select Export, then Microsoft Excel (.xlsx).
  3. Choose the columns. As well as the standard columns, you can add a column for any of your company's own leave types, such as PTO or Emergency Leave.
  4. Confirm. The file is built in the background and sent to you. A message on screen confirms it.

What each column counts

All counts are for the date range you set.

ColumnWhat it counts
NameThe employee, with their position underneath
TardyDays with a check-in marked tardy
AbsenceDays with any absence recorded, including part-day absence
Event AmendmentsAmendment requests the employee made for themselves. A correction a manager made for them is not counted
MonthsMonths in the range in which the employee had 3 or more amendment requests
Vacation LeaveVacation (annual) leave requests filed with 3 days' notice or less before the leave started
Sick LeavesSick leave requests starting in the range

Leave columns count requests, whatever their status. A request that was later declined or cancelled is still counted, because the report measures how people file leave, not what leave they took.

Standard Response narrows Event Amendments only. The reasons in the list are your company's standard responses for event edits. Months always counts every amendment.

What Happens Next

The report only reads data. Nothing changes when you open or export it.

What it should produce is a short list of people to talk to:

  • High Tardy or Absence → open their days in the Event List before the conversation, to see whether it is lateness or a check-in problem.
  • High Event Amendments → someone who corrects their attendance every week is often fighting a device or a schedule that does not fit their work. Check Timekeeping Health first.
  • High Vacation Leave → a pattern of last-minute leave. Your leave rules can require more notice. See Leave policies.

Any penalty for lateness or absence is set in your attendance pay rules, not in this report. The report does not change pay.

Tips

  • Run it for a full month or quarter. A week is too short to tell a habit from a bad week.
  • Check the check-in reports before you act on Absence. A failed check-in can make a person look absent. See Check-in error and GPS mock reports.
  • Use Standard Response to separate forgotten check-ins from real schedule changes. "Forgot to check out" and "Approved schedule change" are very different conversations.
  • Export and keep the file when a case may go further. It records the counts as they stood on that date.

Troubleshooting / FAQ

Q: Someone was late but their Tardy count is 0. Tardy counts only days whose check-in is marked tardy. Open the day in the Event List to see how it was recorded.

Q: Why does Months show 1 when the tooltip says "more than 3"? The column counts months with 3 or more amendments, so a month with exactly 3 counts.

Q: Can I add a column for our own leave type? Yes, in the export. Select Export, then choose it in the column list. It is not shown on screen.

Q: The export did not download. It is built in the background. Wait for the file to be sent to you, rather than exporting again.

Related articles