Sir, I am working as an Office Coordinator.Please advise me as the way of making MIS report
From India, Gurgaon
From India, Gurgaon
Hi Arti,
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 regions' 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 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 for what the salary is after any revision.
Third Sheet -
New Joinees
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.
From India, Ahmadabad
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 regions' 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 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 for what the salary is after any revision.
Third Sheet -
New Joinees
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.
From India, Ahmadabad
Hi,
I am looking for an MIS report for marketing, HR, and Admin. I am working as a marketing manager but want to know about the MIS reports that can be generated for the other two departments as well.
Regards,
Shaona Adhikari
From India, Nagpur
I am looking for an MIS report for marketing, HR, and Admin. I am working as a marketing manager but want to know about the MIS reports that can be generated for the other two departments as well.
Regards,
Shaona Adhikari
From India, Nagpur
Dear Amit,
I'm working in an IT company as a Business Analyst cum Project Coordinator and planning to learn MIS reports. According to you, which type of MIS report would be most suitable for me? As I'm also engaged in HR Generalist as well as Administrative activities, can you please suggest some MIS report types? Could you also provide me with some formats and documents to learn MIS reports?
I need your help, so please try to reply.
Regards,
Sancy.
From India, Madras
I'm working in an IT company as a Business Analyst cum Project Coordinator and planning to learn MIS reports. According to you, which type of MIS report would be most suitable for me? As I'm also engaged in HR Generalist as well as Administrative activities, can you please suggest some MIS report types? Could you also provide me with some formats and documents to learn MIS reports?
I need your help, so please try to reply.
Regards,
Sancy.
From India, Madras
Can someone help me with the format in XL as mentioned by Amitmhrm Re: How to make MIS reports?
From India, Vadodara
From India, Vadodara
[QUOTE=artikaul;211397] I am working as a secretary to the Managing Director in a private company. I want to learn how to prepare MIS reports to present before the Managing Director of the company. Please advise me.
Thanks & Regards,
Anil Kumar
From India, New Delhi
Thanks & Regards,
Anil Kumar
From India, New Delhi
Hi Amit,
This is the first time I registered on this site as I found it very helpful. I have recently completed my MBA in HRM from Sikkim Manipal University. Currently, I am working with an NGO as a Communication Assistant and Graphic Designer under PRO. I intend to transition into a role within the HR Department as I no longer wish to continue as a Graphic Designer. Please suggest which position I should pursue. Is an MBA from SMU worthwhile?
Regards,
Sanjeev
From India, New Delhi
This is the first time I registered on this site as I found it very helpful. I have recently completed my MBA in HRM from Sikkim Manipal University. Currently, I am working with an NGO as a Communication Assistant and Graphic Designer under PRO. I intend to transition into a role within the HR Department as I no longer wish to continue as a Graphic Designer. Please suggest which position I should pursue. Is an MBA from SMU worthwhile?
Regards,
Sanjeev
From India, New Delhi
This is really a great help for freshers and experienced individuals as well. You have done a great social job by providing the details of the MIS report format, as this experience is not readily available elsewhere. Thank you so much.
Regards,
M. Abbas
Riyadh, Saudi Arabia
From Saudi Arabia, Riyadh
Regards,
M. Abbas
Riyadh, Saudi Arabia
From Saudi Arabia, Riyadh
Creating MIS Reports for NGO Organizations
I am working as an Office Coordinator. Please advise me on how to create MIS reports, specifically the type of MIS reports typically generated in NGO organizations. Could you please suggest some types of MIS reports? Additionally, can you provide me with some sample formats and documents to aid in learning about MIS reports?
Could you also forward the MIS Report to my email address: [Email Removed For Privacy Reasons]
Thank you.
Regards,
G. Ganesh
From India, Mumbai
I am working as an Office Coordinator. Please advise me on how to create MIS reports, specifically the type of MIS reports typically generated in NGO organizations. Could you please suggest some types of MIS reports? Additionally, can you provide me with some sample formats and documents to aid in learning about MIS reports?
Could you also forward the MIS Report to my email address: [Email Removed For Privacy Reasons]
Thank you.
Regards,
G. Ganesh
From India, Mumbai
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.