Monthly Attendance & Leave Tracker
31-day P/A/L/H/W grid with colour-coded cells; auto counts of present/absent/leave, attendance %, and a running leave balance against entitlement. Summary dashboard with average attendance and a day-type doughnut.
There is also a lightweight version of this template: Monthly Attendance Tracker · Free
Track a whole team's attendance in one sheet. Mark each day as Present, Absent, Leave, Holiday or Week Off and this free Attendance & Leave Tracker counts present, absent and leave days for every employee automatically, then works out each person's attendance percentage. Colour-coded cells make patterns easy to read across the month.
Set a leave entitlement per employee and the template keeps a running leave balance as leave is taken. A summary dashboard shows average attendance, total present, absent and leave days, and a day-type distribution chart. Built for Microsoft Excel 2016+, ready to use with sample staff.
Key features
- Daily P / A / L / H / W marking
- Auto present, absent and leave counts
- Automatic attendance percentage
- Running leave balance per employee
- Attendance summary dashboard
- Built for Microsoft Excel 2016+
This template is designed for HR teams and team managers who track daily attendance, leave balances and absences across a workforce — without the need for expensive specialist software.
The Monthly Attendance & Leave Tracker is part of our HR & Workforce Management collection — downloaded 18 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Frequently asked questions
Is the attendance tracker free?
Yes, free download, no sign-up.
Does it calculate leave balance?
Yes, it subtracts leave taken from each employee's entitlement automatically.
Which months does it cover?
It provides 31 day columns for any single month.