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 definitely will mail the same.
I am describing you the contents with sheet wise..
First Sheet-
Details of employee
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 make a column
what is salary after any revision
Third Sheet - New Joinees
In this sheet write down the name of New joinees of that month with detail
like CTC, Designation, DOB n etc.
Forth Sheet - Resigned employees
In this sheet write the name of employees who resigned during that
particular month with details like name, designation, date of joining, Date of
resignation, last working day.
Fifth sheet - Attrition rate
Hope now it will be very much helpful for you,,
Regards,
Amit Seth.