Hi, I have recently joined a new organization where my manager has asked me to prepare an attendance format in an Excel sheet for all the branches, including all the vendors in a single sheet. Please help me out with how to prepare this sheet. Looking forward to your valuable replies.
Thanks,
Rupashree HR Coordinator
From India, Kolkata
Acknowledge(0)
Amend(0)
2Thanks,
Rupashree HR Coordinator
From India, Kolkata
Acknowledge(0)Amend(0)
This format can be prepared by following this way:
Attendance Sheet Format
First of all, at the top of the sheet, mention the "Name of Location." Then the header will start for the table, in which you should include 7 columns: S. No., Name of Employee, Department/Designation, In Time, Sign In, Out Time, Sign Out. You can also keep a blank column between In Time-Sign In and Out Time-Sign Out.
Apart from this, I suggest keeping separate attendance records for on-roll employees and each individual vendor.
Hope this will help you. Cheers.
From India, Delhi
Acknowledge(1)Amend(0)
Attendance Sheet Format
First of all, at the top of the sheet, mention the "Name of Location." Then the header will start for the table, in which you should include 7 columns: S. No., Name of Employee, Department/Designation, In Time, Sign In, Out Time, Sign Out. You can also keep a blank column between In Time-Sign In and Out Time-Sign Out.
Apart from this, I suggest keeping separate attendance records for on-roll employees and each individual vendor.
Hope this will help you. Cheers.
From India, Delhi
Acknowledge(1)Amend(0)
Thank you for your suggestion. I would like to know how I can include the vendors' details in the same sheet since this organization collaborates with three to four vendors. The corporate staff do not require the in-time and out-time information. However, they do need the specifics of leave, overtime, and absence in an Excel format.
It would be convenient if you could share any format that may be available.
Thanks
From India, Kolkata
Acknowledge(0)Amend(0)
It would be convenient if you could share any format that may be available.
Thanks
From India, Kolkata
Acknowledge(0)Amend(0)
If you use the attendance sheet with In Time & Out Time, you can easily find the particulars you need. By using the simple signature sheet/register, you can easily point out the Presence and Absence. Accordingly, Leave/Absence can be determined.
However, if you also need to keep track of overtime (OT), then you will have to maintain the In Time and Out Time. This information may be kept in Sheets, Registers, or a Biometric Attendance System. This is the only way to find out the OT hours. If you do not know when the employee came in and when they went out, how will you calculate the total working hours?
Thank you.
From India, Delhi
Acknowledge(0)Amend(0)
However, if you also need to keep track of overtime (OT), then you will have to maintain the In Time and Out Time. This information may be kept in Sheets, Registers, or a Biometric Attendance System. This is the only way to find out the OT hours. If you do not know when the employee came in and when they went out, how will you calculate the total working hours?
Thank you.
From India, Delhi
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.
Format for Attendance sheet.xls
Labr laws for Vendor compliance Management.pdf