Hi All,
I am Akanksha working in an IT Company in Indore. Can anyone help me with the MIS report format.
I am in urgent need of the format, else tell me what are the things which should be covered in a MIS report.
Thanks
Akanksha
From India, Bhopal
1I am Akanksha working in an IT Company in Indore. Can anyone help me with the MIS report format.
I am in urgent need of the format, else tell me what are the things which should be covered in a MIS report.
Thanks
Akanksha
From India, Bhopal
Hi Akansha...
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.
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.
From India, Ahmadabad
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.
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.
From India, Ahmadabad
I also very useful for this MIS formats.. thanks i am m.com graduate in india.. I would like to thank you akansha & amit.. very good this is helping to develop my future
From India, Madras
From India, Madras
Hi everyone.
I would like to add on to Amit.
Sheet 1
Department wise number of employees (staff in 1 column and workers in other).
Sheet 2
Level wise or designation wise number of employee.
Sheet 3
Ratios
1. Male employees Vs Female employees
2. Technical staff Vs Non technical staff
3. Staff Vs workers
4. Budgeted Vs Actual employees
Number of Engineers Vs Diploma Holders Vs CA Vs MBA Vs others etc.
Sheet 4
Number of emolyees joined in that month. Their names, Designation, Level, department, Date of joining, CTC
Sheet 5
Number of emolyees left in that month. Their names, Designation, Level, department, Date of joining, Date of leaving, CTC
Hope this will help you.
Regards,
Surbhi Gupta
From India, Mumbai
I would like to add on to Amit.
Sheet 1
Department wise number of employees (staff in 1 column and workers in other).
Sheet 2
Level wise or designation wise number of employee.
Sheet 3
Ratios
1. Male employees Vs Female employees
2. Technical staff Vs Non technical staff
3. Staff Vs workers
4. Budgeted Vs Actual employees
Number of Engineers Vs Diploma Holders Vs CA Vs MBA Vs others etc.
Sheet 4
Number of emolyees joined in that month. Their names, Designation, Level, department, Date of joining, CTC
Sheet 5
Number of emolyees left in that month. Their names, Designation, Level, department, Date of joining, Date of leaving, CTC
Hope this will help you.
Regards,
Surbhi Gupta
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
MIS Report.xls