Hi All,
I am describing the contents to you sheet-wise, which you may include in your monthly HR report.
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 salary after any revision.
Third Sheet:
New Joinees:
Record the names of new joiners of the month with details like CTC, Designation, DOB, etc.
Fourth Sheet:
Resigned employees:
List the names of employees who resigned during that particular month along with details like name, designation, date of joining, date of resignation, and last working day.
Fifth Sheet:
Attrition rate:
Based on this MIS report, you can derive the attrition report, qualification analysis reports, team management reports, and more.
Regards,
Amit Seth