Could you kindly provide me with the Attendance Register or Muster Roll (Form 12) in Excel format, please?
From India, Delhi
Acknowledge(0)
Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
I understand that you are seeking the Attendance Register or Muster Roll (Form 12) in Excel format for use in Delhi, India. This document is crucial for maintaining accurate records of employee attendance, which is a legal requirement under Indian labor laws.
The Attendance Register or Muster Roll (Form 12) is governed by the Factories Act, 1948 and the rules made thereunder by the respective state governments in India. It's important to note that the format of the register may vary from state to state, but the basic information required remains the same.
Unfortunately, there isn't a universally accepted Excel format for Form 12 available online. However, you can create one yourself by including the following columns: Employee Name, Employee ID, Department, Days of the Month (1 to 31), and Remarks. Under the Days of the Month, you can mark presence with 'P', absence with 'A', leave with 'L', and so on.
Here's a step-by-step guide on how you can create it:
1. Open a new Excel sheet.
2. In the first row, create the following headers: Employee Name, Employee ID, Department, Days of the Month (1 to 31), and Remarks.
3. From the second row onwards, fill in the details of each employee and their daily attendance status.
4. At the end of the month, you can add a total attendance count for each employee.
Remember, it's crucial to update this register daily to maintain accurate records. Also, keep a backup of these files for future reference and compliance with audits.
Please note that this is a simplified version of Form 12, and you may need to add more details depending on your company's policies and the specific labor laws of Delhi. For more detailed information, you may want to consult with a local HR expert or legal advisor.
From India, Gurugram
Acknowledge(0)Amend(0)
139The Attendance Register or Muster Roll (Form 12) is governed by the Factories Act, 1948 and the rules made thereunder by the respective state governments in India. It's important to note that the format of the register may vary from state to state, but the basic information required remains the same.
Unfortunately, there isn't a universally accepted Excel format for Form 12 available online. However, you can create one yourself by including the following columns: Employee Name, Employee ID, Department, Days of the Month (1 to 31), and Remarks. Under the Days of the Month, you can mark presence with 'P', absence with 'A', leave with 'L', and so on.
Here's a step-by-step guide on how you can create it:
1. Open a new Excel sheet.
2. In the first row, create the following headers: Employee Name, Employee ID, Department, Days of the Month (1 to 31), and Remarks.
3. From the second row onwards, fill in the details of each employee and their daily attendance status.
4. At the end of the month, you can add a total attendance count for each employee.
Remember, it's crucial to update this register daily to maintain accurate records. Also, keep a backup of these files for future reference and compliance with audits.
Please note that this is a simplified version of Form 12, and you may need to add more details depending on your company's policies and the specific labor laws of Delhi. For more detailed information, you may want to consult with a local HR expert or legal advisor.
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Attendance Register.xls