Hi,
I'm a part of HR in an MNC and need to request MIS reports. I would like to understand what exactly MIS reports are. Do they have a specific format or require the use of a particular application, considering I already deal with data extensively?
Thanks,
Roopali
From India, Gurgaon
Acknowledge(0)
Amend(0)
I'm a part of HR in an MNC and need to request MIS reports. I would like to understand what exactly MIS reports are. Do they have a specific format or require the use of a particular application, considering I already deal with data extensively?
Thanks,
Roopali
From India, Gurgaon
Acknowledge(0)Amend(0)
Hi Rupali,
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 many other factors to aid in decision-making. With the help of MIS, you can prepare a variety of reports like annual attrition, region-wise attrition, region-wise manpower, graphical representation of region's manpower status, and so on.
You can prepare the same at your end. It will help you to prepare other such formats too. I am describing the contents 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 create a column for salary after any revision.
Third Sheet-
New Joinees
In this sheet, list the names of New joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet-
Resigned employees
In this sheet, list the names of employees who resigned during that particular month with details such as name, designation, date of joining, date of resignation, last working day.
Fifth Sheet-
Attrition rate
Based on this MIS report, you can derive the attrition rate, Qualification analysis reports, team management reports, and more to prepare a number of reports.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
508MIS 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 many other factors to aid in decision-making. With the help of MIS, you can prepare a variety of reports like annual attrition, region-wise attrition, region-wise manpower, graphical representation of region's manpower status, and so on.
You can prepare the same at your end. It will help you to prepare other such formats too. I am describing the contents 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 create a column for salary after any revision.
Third Sheet-
New Joinees
In this sheet, list the names of New joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet-
Resigned employees
In this sheet, list the names of employees who resigned during that particular month with details such as name, designation, date of joining, date of resignation, last working day.
Fifth Sheet-
Attrition rate
Based on this MIS report, you can derive the attrition rate, Qualification analysis reports, team management reports, and more to prepare a number of reports.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
New MIS reports Master Data.xls
A BRIEF CONCEPT ON MANAGEMENT INFORMATION SYSTEM.ppt