Free employee attendance register (Excel)
Track daily attendance status for your team: present, absent, sick, or on leave. Perfect for small businesses and HR teams that need a simple way to monitor who showed up each day.
Employee attendance register
Excel format (.xlsx)
No signup required. Works with Excel and Google Sheets.
What's in this template
A simple attendance tracking layout
Employee name
Full name of each staff member
Date
Each day of the tracking period
Status
Present, Absent, Sick, Leave, or No Show
Notes
Reason or additional details
Monthly summary
Count of days in each status
How attendance is recorded
Use simple codes to mark each day: P (Present), A (Absent), S (Sick), AL (Annual Leave), NS (No Show). Add notes for context where needed.
| Employee | Mon 20 | Tue 21 | Wed 22 | Thu 23 | Fri 24 | Notes |
|---|---|---|---|---|---|---|
| Sarah Jones | P | P | S | S | P | Sick Wed-Thu |
| James Smith | P | P | P | AL | AL | Annual leave |
How to use this template
Get started in four simple steps
Download
Get the Excel file and open it
Add employees
List your team members
Mark attendance
Enter P, A, S, AL, or NS daily
Review summary
Check monthly attendance counts
Who uses this template
Ideal for businesses tracking daily attendance
Cafes & restaurants
Track daily attendance for all staff
Retail stores
Monitor who showed up each day
Office teams
Record attendance for admin and HR
Template disclaimer
This template tracks time and attendance only. It does not calculate wages, penalties, or entitlements. For automated calculations and compliance support, use time and attendance software.
When spreadsheets stop working
Manual attendance registers work for small teams. But as you grow, tracking leave balances, managing approvals, and maintaining records becomes painful. For automated attendance tracking with leave management, try HR software.
Explore time & attendance softwareAttendance register FAQ
- The template includes common statuses: Present (P), Absent (A), Sick (S), Annual Leave (AL), and No Show (NS). You can customise these to match your business needs.
- This template focuses on attendance status (present/absent), not hours. For hour tracking, use our Weekly Timesheet or Daily Time Clock Sheet.
- No, this template tracks attendance status only. It does not calculate wages, leave balances, or entitlements. For automated leave management, consider leave management software.
- Yes, save a copy for each month with the date in the filename (e.g., "attendance-jan-2025.xlsx"). This keeps a record of past attendance while you track current periods.
- Yes, this template is useful for basic HR attendance records. However, for compliance and long-term record keeping, consider dedicated HR software.
Related templates
Explore more time tracking templates
Ready to track attendance?
Download the template now and start recording employee attendance.
Disclaimer
This template tracks time and attendance only. It does not calculate wages, penalties, or entitlements. RosterElf Pty Ltd accepts no liability for any loss arising from reliance on this template. For automated calculations and compliance support, use time and attendance software.