Hi, Can anybody tell me how to record the employee details in Pvt.Ltd. Co. ? Please help me . You already knew i am new to this field. I hope you are not disappointing me. Thank You Geetha :(
From India, Bangalore
Acknowledge(0)
Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi,
You may prepare the same in Excel at your end, as it will help you prepare other similar formats as well.
I am describing the contents sheet-wise:
First Sheet - Details of Employees:
a. E. Code
b. Name of Employee
c. Date of Birth
d. Designation
e. CTC
f. Address for Communication
g. Permanent Address
h. Contact Number
i. Blood Group
j. Maximum Qualification
k. Extra Qualification
l. Total Experience
Second Sheet - Salary Structure:
In this sheet, write down the complete salary structure and include a column for the salary after any revision.
Third Sheet - New Joinees:
In this sheet, list the names of new joiners for that month with details such as CTC, Designation, DOB, etc.
Fourth Sheet - Resigned Employees:
List the names of employees who resigned during that particular month with details including name, designation, date of joining, date of resignation, and last working day.
Fifth Sheet - Attrition Rate:
Based on this MIS report, you can generate the attrition report, Qualification analysis reports, team management reports, and more.
Regards,
Amit Seth
From India, Ahmadabad
Acknowledge(0)Amend(0)
508You may prepare the same in Excel at your end, as it will help you prepare other similar formats as well.
I am describing the contents sheet-wise:
First Sheet - Details of Employees:
a. E. Code
b. Name of Employee
c. Date of Birth
d. Designation
e. CTC
f. Address for Communication
g. Permanent Address
h. Contact Number
i. Blood Group
j. Maximum Qualification
k. Extra Qualification
l. Total Experience
Second Sheet - Salary Structure:
In this sheet, write down the complete salary structure and include a column for the salary after any revision.
Third Sheet - New Joinees:
In this sheet, list the names of new joiners for that month with details such as CTC, Designation, DOB, etc.
Fourth Sheet - Resigned Employees:
List the names of employees who resigned during that particular month with details including name, designation, date of joining, date of resignation, and last working day.
Fifth Sheet - Attrition Rate:
Based on this MIS report, you can generate the attrition report, Qualification analysis reports, team management reports, and more.
Regards,
Amit Seth
From India, Ahmadabad
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.
HR Manual (Employee Hand Book).doc