Dear Senior and all the Members of CiteHr,
Every month i prepare the staff attendance of my staff employees,who are deployed on different sites and i face lots of problems to compile the attendance in one excel sheet and it is also difficult to trace the payable days and absent details on the excel sheet.
I would request you all to please suggest or advice me on how to prepare the attendance without committing any errors.
Waiting for for suggestions.
Trupti :P

From India, Pune
Hi Trupti,
see the attachment regarding Attandance sheet.
Send it to each site for maintaining and towards the end of the month make summary for salary prepration.
Also ask Sr. person from each site to sign. Hard copy of the same sheet which would ensure you getting correct details.

From India, Mumbai

Attached Files
File Type: xls attendance_991.xls (26.0 KB, 3868 views)

Dear Trupti, The attendance document is protected. To make any changes and to unprotect it it is asking for the password. Please give us the password. Thanks Geetanjali
From India, Hyderabad
Trupti, you can use this sheet. pl feel free to contact me on any clarification required. swapna
From India, Pune

Attached Files
File Type: xls copy_of_attendance_feb_07_143.xls (74.5 KB, 1834 views)

Thank you Swapna Mam You have given a lot of help to all the junior HR Executives But if you can please let us know the instructions of using the file . Amrita :D :D

Hi Swapna, Good efforts. Really very useful. Keep up the good work. Regards Arvinder Rawat
From India, Visnagar
First I would like to thank my friends & seniors who had given sample format for Attendance for the month. This is leave based.
Can someone help me in dailry attendance register (Time Register) so that late coming can be calculated.
Please find attached sample attendance register for the month which I prepared.
I would like to have format for daily register pl.
My email id is
Thanks & Regards,

From India, Madras

Attached Files
File Type: xls Attendance Register.xls (21.0 KB, 1569 views)

Dear Trupti,
We have 4 plants & we have to send data to H O for making salary. I have made one format for our plant, you can ask your Site Incharge to send similar data. You can also ask to send xerox / scan copy of attendance register for cross checking.
Format is attached for yoyr reference.
Durgadas V Gosavi

From India, Pune

Attached Files
File Type: xls WAGE & SAL DATA.xls (19.0 KB, 1186 views)

hi how r u, i cannot able to modify as our wish because the sheet is protected, r u wish to help me to modify the sheet pls mam be touch with me i need much formats of hr regards karthik
From United Arab Emirates, Abu Dhabi
I'm attaching an attendance sheet here that I've designed and have been using for our employees.
Basically, the attached sheet(Unprotected)
i) Tracks the monthly attendance of employees,
ii) Tracks the leaves availed by the employees in that month.
iii) Returns the No. of days salary payable to respective employees for that month.
Hope the sheet would be useful for all those who are looking for the attendance format for their employees.
SENIORS: Suggestions from SENIOR HR Peers are mostly anticipated and welcome so as to improve the attendance format in a much better way

From India, Hyderabad

Attached Files
File Type: xls Attendance Sheet.xls (101.5 KB, 1085 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server