New to Recruiting? How Do I Start Preparing MIS Reports?

Hi, my name is Bhupesh. I have recently joined a recruiting company, and my boss is asking me to submit MIS reports. Can anybody tell me how to prepare MIS reports? 🤔

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.

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

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.

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

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

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

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