Monthly Attendance Tracker
Monthly attendance tracker with P/A/L status and automatic percentage calculation.
Try the advanced version with a built-in dashboard: Monthly Attendance & Leave Tracker · Free
Attendance is one of those records you only miss when you need it. This free Monthly Attendance Tracker lets you mark each employee present, absent, on leave or late across the month, with totals — so you have an accurate, at-a-glance record for payroll and HR.
How to use it: list your team, then mark each day's status per person. The monthly totals summarise attendance, absences and leave, ready to feed into payroll or review. Keep a tab or copy per month.
Key features
- Daily attendance across the month
- Present / absent / leave / late
- Monthly totals per employee
- Ready for payroll and HR
- Works in Excel and Google Sheets
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 Tracker is part of our HR & Workforce Management collection — downloaded 4 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 with no registration.
Can I mark different statuses?
Yes — present, absent, leave, late and more.
Does it total automatically?
Yes, monthly totals summarise per employee.
Is it editable?
Fully editable in Excel or Google Sheets.