Hi, I recently joined a company. They are currently entering attendance manually in an Excel sheet, using some formulas. I have noticed several mistakes in the sheet, and the HR department has assigned me the task of creating a more accurate Attendance sheet in Excel. Friends, please assist me with this issue and share the best method for maintaining attendance.
Thanks & Regards, Sunitha.
From Hong Kong
Acknowledge(0)
Amend(0)
Thanks & Regards, Sunitha.
From Hong Kong
Acknowledge(0)Amend(0)
Hi Sunitha,
Entering the attendance in an Excel sheet will definitely require some formulas at the time of payroll processing. Prepare a sheet in Excel with the following headers:
1. Employee Code
2. Employee Name
3. Designation
4. Date of Joining
5. Start by entering 1st, 2nd, 3rd, and so on until the last date of the month.
6. Below the date, mark P for present, A for absent, L for Leave, W for week off, and H for Holidays. After filling the data, use the COUNTIF formula to calculate the number of A's as well as the number of L's. This information will be used for payroll processing.
Hope this has given you a good idea to proceed.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
508Entering the attendance in an Excel sheet will definitely require some formulas at the time of payroll processing. Prepare a sheet in Excel with the following headers:
1. Employee Code
2. Employee Name
3. Designation
4. Date of Joining
5. Start by entering 1st, 2nd, 3rd, and so on until the last date of the month.
6. Below the date, mark P for present, A for absent, L for Leave, W for week off, and H for Holidays. After filling the data, use the COUNTIF formula to calculate the number of A's as well as the number of L's. This information will be used for payroll processing.
Hope this has given you a good idea to proceed.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi Amit, Thx for your immediate response. But I have another doubt, monthlast we have to calculate the EL, SL if not LOP, Pls give me the required formulas or format . Sunitha.R
From Hong Kong
Acknowledge(0)Amend(0)
From Hong Kong
Acknowledge(0)Amend(0)
Hi Sunitha, Welcome.. find enclosed one of the Leave register, hope it shall help you to keep the track of Leave records.. Regards, Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi Sunitha, Try this format for the attendance, It is partially automated, you can enhance as per your requirement. Abraham
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Sunitha,
The attendance register is a statutory document, and the requisite information needs to be filled to avoid legal problems at a later date. The printed format of attendance details is available in any bookstore as per the act, so you may acquire an attendance register and start recording the attendance of your office.
Regards,
L. Kumar
From India, Madras
Acknowledge(0)Amend(0)
The attendance register is a statutory document, and the requisite information needs to be filled to avoid legal problems at a later date. The printed format of attendance details is available in any bookstore as per the act, so you may acquire an attendance register and start recording the attendance of your office.
Regards,
L. Kumar
From India, Madras
Acknowledge(0)Amend(0)
Hi Abraham,
The format which you forwarded suits my company. However, I still have some doubts regarding the formulas. If possible, could you please provide me with your ID or contact number? My email ID is saisunitha.r@gmail.com.
Once again, thanks to all.
Sunitha R
From Hong Kong
Acknowledge(0)Amend(0)
The format which you forwarded suits my company. However, I still have some doubts regarding the formulas. If possible, could you please provide me with your ID or contact number? My email ID is saisunitha.r@gmail.com.
Once again, thanks to all.
Sunitha R
From Hong Kong
Acknowledge(0)Amend(0)
Hi Kumar, Thanks for your suggestion. I am maintaining the Muser Roll at the same time I have to maintain Excel Sheet also. Where I have to forward for Corporate office. Sunitha.R
From Hong Kong
Acknowledge(0)Amend(0)
From Hong Kong
Acknowledge(0)Amend(0)
Hey guys, good information. I need a detailed Excel sheet on how to create an "Attendance & Leave Records" for the whole year. I am not proficient in Excel, so please help. Our company policy allows for 30 days of annual leave and includes work orders (WO) and holidays.
Thank you!
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you!
From India, Mumbai
Acknowledge(0)Amend(0)
Good Morning Amith,
I am working as an HR executive at the unit level in the pharma industry in Bidar. I would like to maintain all formalities as per the laws. Could you please provide me with suggestions and example copies to manage A to Z activities at the unit level?
Thank you,
Sreehariraju
From India, Pune
Acknowledge(0)Amend(0)
I am working as an HR executive at the unit level in the pharma industry in Bidar. I would like to maintain all formalities as per the laws. Could you please provide me with suggestions and example copies to manage A to Z activities at the unit level?
Thank you,
Sreehariraju
From India, Pune
Acknowledge(0)Amend(0)
kindly let me know about IN 1.PL : SUNDAY/HOLIDAY INCLUDE OR NOT 2.SL : SUNDAY/HOLIDAY INCLUDE OR NOT 3.CL : SUNDAY/HOLIDAY INCLUDE OR NOT REGARDS DINESH
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
kindly let me know about IN 1.PL : SUNDAY/HOLIDAY INCLUDE OR NOT 2.SL : SUNDAY/HOLIDAY INCLUDE OR NOT 3.CL : SUNDAY/HOLIDAY INCLUDE OR NOT REGARDS DINESH
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Hello, let me introduce myself. My name is Poppy. I'm a new starter in the business (management training provider). I feel so lucky finding this site, which is very informative; therefore, it could enrich my knowledge :) Thanks a lot for posting the attendance format that I need so badly. I live in Jakarta, Indonesia... so far away. So sorry for my "modest" English :). Cheers, Poppy. Nice to meet you all!
From Indonesia, Jakarta
Acknowledge(0)Amend(0)
From Indonesia, Jakarta
Acknowledge(0)Amend(0)
Hi Abraham, I was just gng through the excel sheet for attendance.... can you plz let me know what is meant by Loss of Pay and how to calculate half-days in that sheet?
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear G.PRASATH, I am sending you an attendance register please find the attachment Regards, Bandini
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi, this is Maysha. I have recently joined a new organization. I would like to kindly ask for help on how to prepare a new attendance worksheet where daily records of absences, presences, and outdoor activities need to be recorded. Thank you.
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
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.
SBudget Format HR.xls