All Gamut Of Human Resources, Electrical
Executive Admin & Hr
Sr. Executive P & A
Toopran Geetanjali
Head-human Resources
Recruitment, Training & Development,
+2 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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, 3770 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, 1792 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, 1538 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, 1145 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, 1060 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™