Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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

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.

Hi,,,
Please click the following link,,,
You will get lots of information..
#124202
#50348
#146348
#160545
#51380

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

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 @ 2020 Cite.Co™