Free download
Attendance sheet template 2027
A monthly attendance register in Excel: one sheet for every month of 2027, a code for each person each day, and totals for present, leave, loss of pay and paid days that count themselves.
Free, no sign-up. Works in Excel and Google Sheets. Updated .
What’s in the sheet
One sheet for every month of 2027
January to December, with the right number of days and the weekday under each date.
Totals that count themselves
Present days, half days, leave, absent (LOP), weekly offs and holidays, and paid days, for every person, as you type the codes.
Sundays and national days already filled in
Sundays are marked WO and Republic Day, Independence Day and Gandhi Jayanti H. Change them to your own weekly offs and holidays.
Names stay in view
The name column and the headings stay put while you scroll across the month.
The codes
| P | Present |
| A | Absent, without leave (loss of pay) |
| L | On leave |
| HD | Half day (counts half present, half loss of pay) |
| WO | Weekly off |
| H | Holiday |
How to use it
Add your people
Type names and employee IDs down the first two columns, once in January, then copy them to the other months.
Mark each day
Type P, A, L, HD, WO or H in each person’s box for the day. Leave nothing blank: an empty day isn’t counted as paid.
Read the totals at month end
The columns on the right give present, leave, absent (LOP) and paid days, ready for salary. The LOP calculator turns LOP days into rupees.
When a sheet stops being enough
A register works while someone fills it in every day and everyone agrees on it. It gets hard with more than a few people, with shifts or work from home, and at month end when “I was there, I just didn’t sign” meets the payroll deadline.
Timerfly is this sheet, filled in by itself. The desktop app marks each day from the person’s own computer: present, late, half day or absent, against their hours or shift, with leave and holidays. At month end, one Excel has paid days and loss of pay for everyone.
Also free: the holiday list 2027, the shift roster template, the LOP calculator and the late mark calculator.
Questions
Is the attendance sheet free?
Yes. Download it and use it as you like; no sign-up, no email.
Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets; the codes and totals work the same.
How are paid days counted?
Every day marked P, L, WO or H is paid, a half day counts half, and a day marked A is loss of pay. Paid days is the month’s marked days minus the LOP days.
Is a manual register enough for the law?
Most states’ Shops and Establishments rules ask employers to keep attendance records, often in a set format. Check your state’s form with your CA or HR adviser; this sheet keeps the same information.
Can attendance be marked automatically instead?
Yes. Timerfly marks present, late, absent and half days from each person’s computer, against their own hours or shift, and gives a monthly Excel with paid days and loss of pay.
Attendance without the register
Timerfly marks present, late and absent from each computer, around your shifts, leave and holidays. 14 days free, no card needed.
Prefer help? We’ll set it up with you in 15 minutes