Dear Seniors and all the Members of CiteHR,
Every month, I prepare the staff attendance of my employees who are deployed on different sites, and I face numerous problems compiling the attendance into one Excel sheet. It is also challenging to track the payable days and absent details on the Excel sheet.
I would like to request all of you to suggest or advise me on how to prepare the attendance without making any errors.
I am looking forward to your suggestions.
Regards,
Trupti
From India, Pune
Acknowledge(0)
Amend(0)
17Every month, I prepare the staff attendance of my employees who are deployed on different sites, and I face numerous problems compiling the attendance into one Excel sheet. It is also challenging to track the payable days and absent details on the Excel sheet.
I would like to request all of you to suggest or advise me on how to prepare the attendance without making any errors.
I am looking forward to your suggestions.
Regards,
Trupti
From India, Pune
Acknowledge(0)Amend(0)
Hi Trupti,
Please see the attachment regarding the Attendance sheet. Kindly send it to each site for maintenance, and towards the end of the month, prepare a summary for salary preparation. Additionally, request a senior person from each site to sign the hard copy of the same sheet to ensure accurate details.
Regards,
Mahesh
From India, Mumbai
Acknowledge(0)Amend(0)
Please see the attachment regarding the Attendance sheet. Kindly send it to each site for maintenance, and towards the end of the month, prepare a summary for salary preparation. Additionally, request a senior person from each site to sign the hard copy of the same sheet to ensure accurate details.
Regards,
Mahesh
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Trupti, you can use this sheet. pl feel free to contact me on any clarification required. swapna
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Hi Swapna, Good efforts. Really very useful. Keep up the good work. Regards Arvinder Rawat
From India, Visnagar
Acknowledge(0)Amend(0)
From India, Visnagar
Acknowledge(0)Amend(0)
First, I would like to thank my friends and seniors who provided a sample format for attendance for the month. This is leave-based. Can someone help me in the daily attendance register (Time Register) so that late coming can be calculated? Please find attached a sample attendance register for the month which I prepared. I would like to have a format for the daily register, please. My email id is bvijayakrishnan@rediffmail.com. Thanks and Regards, B VIJAYAKRISHNAN
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Dear Trupti,
We have 4 plants, and we have to send data to H O for salary processing. I have created a format for our plant; you can instruct your Site Incharge to provide similar data. Additionally, you can request to send a xerox or scanned copy of the attendance register for cross-checking purposes.
The format is attached for your reference.
Durgadas V. Gosavi
From India, Pune
Acknowledge(0)Amend(0)
We have 4 plants, and we have to send data to H O for salary processing. I have created a format for our plant; you can instruct your Site Incharge to provide similar data. Additionally, you can request to send a xerox or scanned copy of the attendance register for cross-checking purposes.
The format is attached for your reference.
Durgadas V. Gosavi
From India, Pune
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From United Arab Emirates, Abu Dhabi
Acknowledge(0)Amend(0)
Hi,
I'm attaching an attendance sheet here that I've designed and have been using for our employees. Basically, the attached sheet (unprotected) tracks the monthly attendance of employees, tracks the leaves availed by the employees in that month, and returns the number 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 to improve the attendance format in a much better way.
Regards,
Amberibrahim
From India, Hyderabad
Acknowledge(0)Amend(0)
I'm attaching an attendance sheet here that I've designed and have been using for our employees. Basically, the attached sheet (unprotected) tracks the monthly attendance of employees, tracks the leaves availed by the employees in that month, and returns the number 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 to improve the attendance format in a much better way.
Regards,
Amberibrahim
From India, Hyderabad
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.