Hi My name is Bhupesh I have recently joined a recruiting company n my boss is asking me to submit MIS reports Can anybody tell me how to prepare MIS reports? :unsure:
From India, Bangalore
Acknowledge(0)
Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Bhupesh,
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 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 make a column for the salary after any revision.
Third Sheet -
New Joinees
In this sheet, write down the names of new joinees 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
Hope this information will be helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
508As 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 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 make a column for the salary after any revision.
Third Sheet -
New Joinees
In this sheet, write down the names of new joinees 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
Hope this information will be helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
There are many MIS reports. First, ask your boss what type of MIS report is needed, then email me at ravishankar11584@gmail.com. I can also send you formats of MIS reports once you confirm the exact type of report you are looking for.
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
Dear Amit,
I appreciate the guidance you have given to Bhupesh. MIS in a recruiting company cannot be more than that. However, in the sixth sheet, one more column may be added "Exit Interview". This addition would assist the organization to exercise adequate control over attrition. :idea:
Regards,
Yours Truly,
Satish Kumar
NTPC Foundation, Noida
From India, Delhi
Acknowledge(0)Amend(0)
I appreciate the guidance you have given to Bhupesh. MIS in a recruiting company cannot be more than that. However, in the sixth sheet, one more column may be added "Exit Interview". This addition would assist the organization to exercise adequate control over attrition. :idea:
Regards,
Yours Truly,
Satish Kumar
NTPC Foundation, Noida
From India, Delhi
Acknowledge(0)Amend(0)
Dear Satish,
Thank you! :D
It's a good point that you have raised, but an Exit Interview is a different action that can't be taken in MIS separately; it can be included in the sheet for resigned employees. Just add another column and indicate whether the Exit Interview has been conducted or not.
I think it would be a better option to include the Exit Interview.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Thank you! :D
It's a good point that you have raised, but an Exit Interview is a different action that can't be taken in MIS separately; it can be included in the sheet for resigned employees. Just add another column and indicate whether the Exit Interview has been conducted or not.
I think it would be a better option to include the Exit Interview.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
BHUPESH,
Based on your brief, you are working for a recruitment company.
YOUR MIS REPORTS COULD INCLUDE
MONTHLY / YEAR TO DATE.
1. NO. OF PROSPECTIVE ACCOUNTS [ COMPANIES] CONTECTED.
2. TYPES OF ACCOUNTS [ INDUSTRY TYPES]
3. TYPES OF ACCOUNTS [ SIZE -EMPLOYEES SIZE.
4. CLASSIFICATION OF ACCOUNTS
*RED HOT CLASSIFICATION.[ 85-100]%
*AMBER CLASSICATION [ 70-85]%
*GREEN CLASSIFICATION [ BELOW 70 SUSPECT]
5.NO. OF ACCOUNTS SIGNED.
6.NO. OF PEOPLE INVOLVED
7. ESTIMATE OF BILLING.
8. BUDGETED BILLING FOR THE MONTH.
9. ACTUAL BILLING FOR THE MONTH.
10.FORECASTED ESTIMATE FOR NEXT 3 MONTHS
BUDGETED BILLING.
11.NO. OF PEOPLE INTERVIEWED –CURRENT MONTH
12. NO. OF PEOPLE TO BE INTERVIEWED -NEXT
3 MONTHS.
13. SIGNIFICANT PROBLEMS IN PROSPECTING.
13. SIGNIFICANT PROBLEMS IN RECRUITMENT
13. SIGNIFICANT PROBLEMS IN SELECTION.
14. AN ANALYSIS OF RECRUITMENT CHANNELS
IN THE CURRENT MONTH.
15. ESTIMATE OF THE PLACEMENT MARKET
IN THE NEXT 3 MONTHS.
16. SIGNIFICANT COMPLAINTS FROM ACCOUNTS.
17. ANALYSIS OF ACCOUNTS REJECTING YOUR OFFER.
18. ANALYISIS OF ACCOUNTS LOST.
19. MARKET TRENDS IN THE RECRUITMENT.
20. COMPETITION ANALYSIS.
21. NEW COMPETITORS IN THE RECRUITMENT FIELD.
22.NEW TOOLS NEEDED TO DEVELOP BUSINESS.
ETC ETC
regards
LEO LINGHAM
From India, Mumbai
Acknowledge(0)Amend(0)
Based on your brief, you are working for a recruitment company.
YOUR MIS REPORTS COULD INCLUDE
MONTHLY / YEAR TO DATE.
1. NO. OF PROSPECTIVE ACCOUNTS [ COMPANIES] CONTECTED.
2. TYPES OF ACCOUNTS [ INDUSTRY TYPES]
3. TYPES OF ACCOUNTS [ SIZE -EMPLOYEES SIZE.
4. CLASSIFICATION OF ACCOUNTS
*RED HOT CLASSIFICATION.[ 85-100]%
*AMBER CLASSICATION [ 70-85]%
*GREEN CLASSIFICATION [ BELOW 70 SUSPECT]
5.NO. OF ACCOUNTS SIGNED.
6.NO. OF PEOPLE INVOLVED
7. ESTIMATE OF BILLING.
8. BUDGETED BILLING FOR THE MONTH.
9. ACTUAL BILLING FOR THE MONTH.
10.FORECASTED ESTIMATE FOR NEXT 3 MONTHS
BUDGETED BILLING.
11.NO. OF PEOPLE INTERVIEWED –CURRENT MONTH
12. NO. OF PEOPLE TO BE INTERVIEWED -NEXT
3 MONTHS.
13. SIGNIFICANT PROBLEMS IN PROSPECTING.
13. SIGNIFICANT PROBLEMS IN RECRUITMENT
13. SIGNIFICANT PROBLEMS IN SELECTION.
14. AN ANALYSIS OF RECRUITMENT CHANNELS
IN THE CURRENT MONTH.
15. ESTIMATE OF THE PLACEMENT MARKET
IN THE NEXT 3 MONTHS.
16. SIGNIFICANT COMPLAINTS FROM ACCOUNTS.
17. ANALYSIS OF ACCOUNTS REJECTING YOUR OFFER.
18. ANALYISIS OF ACCOUNTS LOST.
19. MARKET TRENDS IN THE RECRUITMENT.
20. COMPETITION ANALYSIS.
21. NEW COMPETITORS IN THE RECRUITMENT FIELD.
22.NEW TOOLS NEEDED TO DEVELOP BUSINESS.
ETC ETC
regards
LEO LINGHAM
From India, Mumbai
Acknowledge(0)Amend(0)
Hi,
I have gone through the detailed explanation given by Mr. Amith. I would like to add further:
1. How many employees joined in the particular month?
2. Final settlements made for the employees during the month and how much amount has been paid towards gratuity, leave encashment, etc.
3. You have to calculate the rate of turnover in the company.
By Mahesh.CH
From India, Hyderabad
Acknowledge(0)Amend(0)
I have gone through the detailed explanation given by Mr. Amith. I would like to add further:
1. How many employees joined in the particular month?
2. Final settlements made for the employees during the month and how much amount has been paid towards gratuity, leave encashment, etc.
3. You have to calculate the rate of turnover in the company.
By Mahesh.CH
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Mahesh,
Just go through my points regarding MIS preparation once again. I am just clarifying your questions point by point.
You will find the details to write about new employees in the 3rd Sheet.
Regarding the rate of turnover, it is already detailed in the 5th Sheet under the heading Attrition rate.
For final settlements made during a month, you may add another column in the 4th Sheet with the heading "Status on Full & Final Settlement."
In my opinion, there is no need to mention other details like how much salary has been paid for Full & Final settlement. This is another statement that you prepare at the time of preparing Full & Final settlement, so there is no need to include that in the MIS.
By the way, thanks for addressing these points. 😊
Regards,
Amit Seth
From India, Ahmadabad
Acknowledge(0)Amend(0)
Just go through my points regarding MIS preparation once again. I am just clarifying your questions point by point.
You will find the details to write about new employees in the 3rd Sheet.
Regarding the rate of turnover, it is already detailed in the 5th Sheet under the heading Attrition rate.
For final settlements made during a month, you may add another column in the 4th Sheet with the heading "Status on Full & Final Settlement."
In my opinion, there is no need to mention other details like how much salary has been paid for Full & Final settlement. This is another statement that you prepare at the time of preparing Full & Final settlement, so there is no need to include that in the MIS.
By the way, thanks for addressing these points. 😊
Regards,
Amit Seth
From India, Ahmadabad
Acknowledge(0)Amend(0)
Dear Amit,
It's really useful information you have provided for the updating of employees for quick retrieval of the information. Sir, I feel there should be one more column because at the time of increment, it will help to have a glance over it to see what their previous salary, date of joining, present designation, increment date, incremented salary, and total CTC were. Please give your suggestions. Thank you.
Regards,
Lizetta
From India, Pune
Acknowledge(0)Amend(0)
It's really useful information you have provided for the updating of employees for quick retrieval of the information. Sir, I feel there should be one more column because at the time of increment, it will help to have a glance over it to see what their previous salary, date of joining, present designation, increment date, incremented salary, and total CTC were. Please give your suggestions. Thank you.
Regards,
Lizetta
From India, Pune
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
Recruitment Analysis of ABC Company.ppt
Excel People-Company Profile.pdf