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
From India, Bangalore
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 you 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 what is salary after any revision
Third Sheet -
New Joinees
In this sheet write down the name of New joinees of that month with detail
like
CTC,
Designation,
DOB n etc.
Forth Sheet -
Resigned employees
In this sheet write the name 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 now it will be helpful for you,,
Regards,
Amit Seth.
From India, Ahmadabad
Contributing Member
496As 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 you 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 what is salary after any revision
Third Sheet -
New Joinees
In this sheet write down the name of New joinees of that month with detail
like
CTC,
Designation,
DOB n etc.
Forth Sheet -
Resigned employees
In this sheet write the name 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 now it will be helpful for you,,
Regards,
Amit Seth.
From India, Ahmadabad
Contributing Member
Dear Amit,
i appreciate the guidance you have given to Bhupesh. MIS in a recruiting company cannot be mroe than that. However, In the sixth sheet one more column may be added "Exit Interview". Because this would assist the orgn. to exercise adequate control over attrition. :idea:
regards,
Yours Truly,
satish kumar
ntpc foundation, noida
From India, Delhi
Contributing Member
i appreciate the guidance you have given to Bhupesh. MIS in a recruiting company cannot be mroe than that. However, In the sixth sheet one more column may be added "Exit Interview". Because this would assist the orgn. to exercise adequate control over attrition. :idea:
regards,
Yours Truly,
satish kumar
ntpc foundation, noida
From India, Delhi
Contributing Member
Dear Satish,
Thank you.. :D
Its a good point that you have raised but Exit Interview is different actions that can't be taken in MIS separately, that can be put in the sheet resigned employees.. Just add another column and write whether exit Interview done or not..???
I think it can be a better option to include Exit Interview.
Regards,
Amit Seth.
From India, Ahmadabad
Contributing Member
Thank you.. :D
Its a good point that you have raised but Exit Interview is different actions that can't be taken in MIS separately, that can be put in the sheet resigned employees.. Just add another column and write whether exit Interview done or not..???
I think it can be a better option to include Exit Interview.
Regards,
Amit Seth.
From India, Ahmadabad
Contributing Member
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
Most Appreciated Member
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
Most Appreciated Member
Hai,
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 paid towards gratuity, leave encashment etc.
3.you have to calculate the rate of turnover in the company.
By
Mahesh.CH
From India, Hyderabad
Contributing Member
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 paid towards gratuity, leave encashment etc.
3.you have to calculate the rate of turnover in the company.
By
Mahesh.CH
From India, Hyderabad
Contributing Member
Dear Mahesh,
Just go through my points regarding MIS preparation once again.. I am just clearing your question point wise
You will get the details to write regarding new employees in the 3rd Sheet..
Regarding rate of turnover it is already detailed to do in 5th Sheet with the heading Attrition rate..
Regarding Final settlements made during a month, you may add another column in the 4th Sheet, with a heading status on Full & Final settlement..
Otherwise in my view no need to mention other details like how much salary been paid for Full & Final settlement..
thats an another statement that you do prepare at the time of preparing Full & Final settlement, so no need to include that in the MIS..
By the way thanks for taking concern on these points.. :D
Regards,
Amit Seth.
From India, Ahmadabad
Contributing Member
Just go through my points regarding MIS preparation once again.. I am just clearing your question point wise
You will get the details to write regarding new employees in the 3rd Sheet..
Regarding rate of turnover it is already detailed to do in 5th Sheet with the heading Attrition rate..
Regarding Final settlements made during a month, you may add another column in the 4th Sheet, with a heading status on Full & Final settlement..
Otherwise in my view no need to mention other details like how much salary been paid for Full & Final settlement..
thats an another statement that you do prepare at the time of preparing Full & Final settlement, so no need to include that in the MIS..
By the way thanks for taking concern on these points.. :D
Regards,
Amit Seth.
From India, Ahmadabad
Contributing Member
Dear Amit,
Its really useful information you have provided for updation of employees for quick retrival of the inframtion. Sir, i feel there should be one more coloum because at the time of increment it will help to have glance over it as what was their Previous salary,Date of Joining, Present Desigination, increment date, Incremented salary Total CTC . Pls give your sugesstions .Thanks
Regards
Lizetta
From India, Pune
Contributing Member
Its really useful information you have provided for updation of employees for quick retrival of the inframtion. Sir, i feel there should be one more coloum because at the time of increment it will help to have glance over it as what was their Previous salary,Date of Joining, Present Desigination, increment date, Incremented salary Total CTC . Pls give your sugesstions .Thanks
Regards
Lizetta
From India, Pune
Contributing Member
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.