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.

Next month you’ll copy the register and recount every code by hand.
In RosterElf staff clock in on their phone or a shared tablet and request leave in the app, so attendance is recorded as it happens. Approved hours go to Xero UK or a CSV for your payroll.
Your download has started.
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
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:
| Code | Means | Why it matters |
|---|---|---|
| P | Present | The day count; hours go on a timesheet. |
| A | Absent, unauthorised | A pattern is a conduct question; note the reason. |
| S | Sick | Statutory sick pay is payable from the first day off sick; record the first and last day. |
| AL | Annual leave | Counts towards the 5.6 weeks of statutory holiday. |
| BH | Bank holiday | 8 in England and Wales, 9 in Scotland, 10 in Northern Ireland. |
| TOIL | Time off in lieu | Should match the TOIL balance on the overtime tracker. |
| UNP | Authorised unpaid leave | Agreed 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.
Timesheets filled from the time clock
Staff clock on and off; the hours land on the timesheet.
Approve the hours instead of adding them up
- 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
More timesheet templates
Sick pay from GOV.UK: statutory sick pay; bank holidays from GOV.UK; records from GOV.UK: running payroll, keeping records. The file counts days only; it does not work out pay or sick pay.
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.