Alifazil
Head Travel Services
Amitmhrm
Hr Practices
L.Kumar
Manager Hr & Admn
Mvijiabraham
Corporate Trainer
+7 Others

Thread Started by #saisunitha@gmail.com

Hi, I newly joined in a company.They are entering attendance manually in an Excel sheet, using some formulas.In that I found all mistakes, the HR gave me a job to prepare a good Attendance sheet in excel only. Friends plz help me in this issue and forward me the best method for the attendance.
Thanks & Regards,
Sunitha.
7th December 2007 From Hong Kong
Hi Sunitha,
Entering the attendance in an excel sheet will definitely require some formulas at the time of payroll processing...
Prepare a sheet in an excel sheet with the headers-
1. Employee Code
2. Employee Name
3. Designation
4. Date of Joining
5. Start with the entering 1st 2nd, 3rd and so on till the last date of the month
6. Below the date just mark P for present, A for absent, L for Leave, W for week off and H for Holidays... after filling the data use the formula count if to calculate number of A as well as number of L.. it will be used for the payroll processing..
Hope it has definitely given you a good idea to proceed on..
Regards,
Amit Seth.
7th December 2007 From India, Ahmadabad
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
7th December 2007 From Hong Kong
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.
7th December 2007 From India, Ahmadabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls leave_register_585.xls (19.5 KB, 6975 views)

Hi, this is for u... Regards, Sandeep
7th December 2007 From India, Pune

Attached Files
Membership is required for download. Create An Account First
File Type: xls format_179.xls (28.0 KB, 5561 views)

Hi Sunitha, Try this format for the attendance, It is partially automated, you can enhance as per your requirement. Abraham
10th December 2007 From India, Hyderabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls attendance_format_745.xls (30.0 KB, 7058 views)

Dear Sunitha
Attendance register is a statutory document and the requisite information need to be filled to avoid legal problems at the later date. The printed format of attendance details is available in any book shop as per act
and hence you may get one attendance register and start filling the attendance of your office.
Regards
L.Kumar
14th December 2007 From India, Madras
Hi Abraham,
The format which you forwarded is suits to my company.
But still I have small doubts in formulas. If it is possible can you give me your ID OR CONTACT NO. My mail ID is
Once again thanks to all.
Sunitha.R
14th December 2007 From Hong Kong
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
14th December 2007 From Hong Kong
Hey guys good information, need a detailed excel sheet.... how can i have a Attendence & Leave Records for whole year. i am bad in excel please help. our company has a policy of 30days leave annualy, has WO and holiday.
5th June 2008 From India, Mumbai
Good Morning Amith,
Iam working as hr executive as unit level in pharma industry in bidar. I would like to maintain all formalities as per the laws. so can u give me suggestions and example copys to maintain a to z activities in unit level
Thanking you
sreehariraju
5th June 2008 From India, Pune
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
5th June 2008 From India, Gurgaon
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
5th June 2008 From India, Gurgaon
Hello, let me introduce my self. 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 attendance format that I need sooo bad. I live in Jakarta Indonesia...so far away. So sorry for my "modest" english :).
cheers,
Poppy
Nice to meet you all!
22nd July 2008 From Indonesia, Jakarta
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?
30th September 2009 From India, Mumbai
Dear G.PRASATH, I am sending you an attendance register please find the attachment Regards, Bandini
28th November 2009 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls attendance_format.xls (28.5 KB, 486 views)

Hi this is Maysha ....I have recently joined new orgzn...I want to kindly help me how to prepare new attendence worksheet in which daily records of absent ,present outdoor activity need to be mentioned.
13th May 2010 From India, Pune
Hi, I newly joined in a company.They are entering Leave Wth Wages Register Friends Plz help me in this issue and forward me the best method for the Register .
Thanks & Regards,
Jaiprakash Bhati
PLEASE
Jaiprakash Bhati
9650070351
27th November 2016 From India, New Delhi
Hi please inform me if any job for suitable me .my profile is pay roll executive and i am looking job
13th December 2016 From India, Delhi
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™