Hi All,
As you require the MIS Excel sheet, it would be better if you prepare the same at your end because it will help you to prepare other such formats too. But if required, then I will definitely mail it to you.
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, write down the names of new joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet - Resigned employees:
In this sheet, write the names of employees who resigned during that particular month with details such as name, designation, date of joining, date of resignation, last working day.
Fifth Sheet - Attrition rate:
Hope this information is very helpful for you.
Regards,
Amit Seth.