UK
Start trial
Free template· UK, Excel, opens in Google Sheets

Free employee attendance register template (Excel)

An attendance register marks each employee once a day for a month with a code: P present, A absent, S sick, AL annual leave, BH bank holiday, TOIL or UNP unpaid leave. This template counts present, absent, sick and leave days per person; statutory sick pay now starts on the first day off sick.

rosterelf-uk-employee-attendance-register.xlsx
The attendance register filled in for the last eleven days of December: P, A, S, AL, BH, TOIL and UNP codes, weekends blank, and totals per person

File checked No signup

The download

What’s in the file

  • One row per employee, one column per day, for a whole month
  • Present, absent, sick and annual leave counted per person
  • Room for 20 staff, with a notes column for reasons
  • An Instructions tab: absence codes and how long to keep records
Download Excel (.xlsx)
Only on this page

The seven codes, and what each one feeds

Each cell is a drop-down, so nobody invents a new code halfway down the sheet. What each code is for:

CodeMeansWhy it matters
PPresentThe day count; hours go on a timesheet.
AAbsent, unauthorisedA pattern is a conduct question; note the reason.
SSickStatutory sick pay is payable from the first day off sick; record the first and last day.
ALAnnual leaveCounts towards the 5.6 weeks of statutory holiday.
BHBank holiday8 in England and Wales, 9 in Scotland, 10 in Northern Ireland.
TOILTime off in lieuShould match the TOIL balance on the overtime tracker.
UNPAuthorised unpaid leaveAgreed time off that is neither holiday nor sickness.

Weekends are left blank, so a blank Saturday never reads as an absence. Track time off in lieu with the overtime tracker.

In RosterElf

Timesheets filled from the time clock

Staff clock on and off; the hours land on the timesheet.

A woman at her computer beside timesheets for the week to Sunday 1 November: Mia Chen matches her roster, Jack Osei worked an hour over, with an Export to Xero button

Approve the hours instead of adding them up

Rota vs actualXero export
  • Staff clock on and off on their phone or a kiosk
  • Each timesheet shows the rota’d and the clocked hours
  • Corrections made before approval
  • Approved hours exported to Xero and more
FAQ

Attendance register FAQ

  • A register records whether someone was there, as one code per day. A timesheet records how long they worked, with start and finish times and breaks deducted. You need the register for absence management and the timesheet for pay; most teams keep both.

  • Record the first and last day of the absence, not just the total. Statutory sick pay depends on the shape of the absence and whether it links to a previous one, so a count of sick days on its own is not enough. Our statutory sick pay guide sets out what to capture.

  • There is no automatic right to bank holidays off, paid or otherwise. The 5.6 weeks of statutory holiday can lawfully include the eight bank holidays in England and Wales, and most contracts do exactly that. Mark them BH so they are distinguishable from ordinary annual leave. See our holiday entitlement guide.

  • Yes. Print it from Excel or Google Sheets with File, Print, landscape and fit to one page wide; Save as PDF gives you a copy to file. There is no separate PDF download.

  • National Minimum Wage records must be kept for six years. PAYE records must be kept for three years from the end of the tax year they relate to. Working time records have no fixed period beyond being adequate, so in practice the six-year minimum wage rule sets the floor. See our employee records guide.