Understanding HR MIS: What Should You Know About It?

Hello,

What to know about HR MIS?

Hi,

MIS report is known as Management Information System regarding the Manpower status of a particular month, place, and overall. It helps the Management in decision-making, like what are the reasons for resignation, in which area attrition is high, and so many things to help in decision-making. With the help of MIS, you may prepare a lot of reports like annual attrition, region-wise attrition, region-wise manpower, graphical representation of region's manpower status, and so on.

You may prepare the same at your end. As it will help you to prepare other such formats too. I am describing the contents with 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 make a column for what the salary is after any revision.

Third Sheet -

New Joiners

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 like name, designation, date of joining, date of resignation, last working day.

Fifth sheet -

Attrition rate

Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports, and so on. You can prepare a number of reports.

Regards,

Amit Seth.

Hello Vaishali,

The first sheet is a very common and simple employee database, in which you have to enter all their details like their address, DOB, and other things as Amit has mentioned.

Cheers,
Swati

Thank you, Vaishali and Swati! 😊

In the 5th sheet, you are required to maintain the attrition rate for that particular month based on the database.

Regards,
Amit Seth.

Hi,

The formula for calculating the Attrition Rate is as follows: Attrition Rate = Number of resignations in that month / Available manpower * 100.

For example, if at the beginning of the previous month the manpower was 80, and during that month 5 employees resigned and 10 joined, then by the last day of the month, the manpower would be 80 - 5 + 10 = 85. Therefore, the Attrition Rate would be calculated as 5 / 85 * 100.

I hope this addresses your query.

Regards,
Amit Seth.

Dear Amit Sir,

Could you please provide a sample MIS report along with this post? I think it will help a lot of freshers like me.

Thank you in advance.
Nishant Joshi

Hi Nishant,

I have provided guidelines on how to prepare the MIS at one's end. So, it's better to practice at your end first. If you encounter any problems, I will definitely help you.

Regards,
Amit Seth.