Dear Senior and all the Members of CiteHr,
Every month I have to prepare the staff attendance of my staff employees who are appointed on different sites, and I face lots of problems compiling the attendance in one Excel sheet. It is also difficult to trace the payable days, absentees, compensatory off, paid holidays, and weekly off details on the Excel sheet.
I would request all of you to please suggest or advise me on how to prepare the attendance without committing any errors.
Waiting for suggestions.
Regards,
Sujata
From India, Pune
Acknowledge(0)
Amend(0)
10Every month I have to prepare the staff attendance of my staff employees who are appointed on different sites, and I face lots of problems compiling the attendance in one Excel sheet. It is also difficult to trace the payable days, absentees, compensatory off, paid holidays, and weekly off details on the Excel sheet.
I would request all of you to please suggest or advise me on how to prepare the attendance without committing any errors.
Waiting for suggestions.
Regards,
Sujata
From India, Pune
Acknowledge(0)Amend(0)
Hi, Sujata,
Please prepare the attendance and send it to the concerned site managers for acknowledgment. You will prepare the report based on the attendance sent by unit managers/site managers.
Cross-check the attendance with the hard copy of the attendance, which you need to obtain from the site, either as a xerox or scan copy. Remember, you may not always make mistakes; your unit/site managers may also send incorrect attendance.
Please find the attached attendance sheet, which may assist you. Everything is already formatted; you just need to enter P/O/CL/SL/PL/CO/HA.
Regards,
Karthik
From India, Vijayawada
Acknowledge(0)Amend(0)
Please prepare the attendance and send it to the concerned site managers for acknowledgment. You will prepare the report based on the attendance sent by unit managers/site managers.
Cross-check the attendance with the hard copy of the attendance, which you need to obtain from the site, either as a xerox or scan copy. Remember, you may not always make mistakes; your unit/site managers may also send incorrect attendance.
Please find the attached attendance sheet, which may assist you. Everything is already formatted; you just need to enter P/O/CL/SL/PL/CO/HA.
Regards,
Karthik
From India, Vijayawada
Acknowledge(0)Amend(0)
Dear Sujata,
There is a simpler way to handle this if you can ask your management to approve a budget for it. You can use software to go online. This will significantly reduce your manual work and, moreover, decrease the chances of errors. Additionally, it will make it easier to track the employees deployed on-site.
Regards,
Hiral
From India, Ahmedabad
Acknowledge(0)Amend(0)
There is a simpler way to handle this if you can ask your management to approve a budget for it. You can use software to go online. This will significantly reduce your manual work and, moreover, decrease the chances of errors. Additionally, it will make it easier to track the employees deployed on-site.
Regards,
Hiral
From India, Ahmedabad
Acknowledge(0)Amend(0)
Sir, Thank you for your reply. I have gone through the attachment but in case if any one can take half leave then how do i put half day as half day abbreviation is not there Thanks Sujata 8550994891
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Dear all,
I want an attendance sheet for my small company. We are distributors in Mysore. Please create an Excel sheet so that I can easily take attendance. Currently, I am managing it manually for the full day, half-day, and total amount. I am currently giving a salary of 5k and 6k. Please help me to grow. Kindly do the needful.
Thank you.
From India, Bengaluru
Acknowledge(0)Amend(0)
I want an attendance sheet for my small company. We are distributors in Mysore. Please create an Excel sheet so that I can easily take attendance. Currently, I am managing it manually for the full day, half-day, and total amount. I am currently giving a salary of 5k and 6k. Please help me to grow. Kindly do the needful.
Thank you.
From India, Bengaluru
Acknowledge(0)Amend(0)Join 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.
Attendance sheet.xls