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.

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




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,,


Amit Seth.

From India, Ahmadabad
Please click the following link,,,
You will get lots of information..

From India, Coimbatore
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
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
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.
Surbhi Gupta

From India, Mumbai
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™