hi i think u can use some software like adrenalin by polaris that automatically generated MIS reports. Regards, Sharad
From India
From India
thanks sharad for your quick response. I wanna in excell sheet how can MIS reports can be prepared andreports on that like attrition reports,qualification analysis reports etc
From India, Delhi
From India, Delhi
Hi,
Following reorts are prepared on monthly basis :
1. Monthly MIS - Show previous months balance as opening balance and plus joinees , transfers in and minus resignees and transfers out.It will give you monthly status of FTE (full time employees).
2. HR Activity Minus - Show various trainings done during that month , any staff welfare activity etc.
3.Joinees and Resignees list to calculate attrition per month and hiring cost monthly.
4. COO Report - Show HR monthly activities.
regards,
Runa Berry
From India, Delhi
10Following reorts are prepared on monthly basis :
1. Monthly MIS - Show previous months balance as opening balance and plus joinees , transfers in and minus resignees and transfers out.It will give you monthly status of FTE (full time employees).
2. HR Activity Minus - Show various trainings done during that month , any staff welfare activity etc.
3.Joinees and Resignees list to calculate attrition per month and hiring cost monthly.
4. COO Report - Show HR monthly activities.
regards,
Runa Berry
From India, Delhi
HI, Can any one provide me with the formats of these report and MIS in excel. Hoping for prompt response. Rgds, Ravi
Hi!
As you know MIS is prepared to get all the details of employees in the last month with the help of MIS top level management get an idea about the employees status in the last month you can prepare in an excel sheet.
MIS with the help of Following information.
1) Employees Details in this sheet you should write the details like Employee code,Employee name,designation,date of birth,date of joining,CTC.addess,contact number,blood group,qualification,total years of expereince.
2)Salary Structure of the employees you should write salary break-up of all the employees.
3)New Joinees details.
4)Details of Resigned Employees.
5)Attrition Rate.
The mentioned points should be prepared in different sheets.I hope this information will help a bit in preparing MIS.
Regards,
Trupti :P
From India, Pune
As you know MIS is prepared to get all the details of employees in the last month with the help of MIS top level management get an idea about the employees status in the last month you can prepare in an excel sheet.
MIS with the help of Following information.
1) Employees Details in this sheet you should write the details like Employee code,Employee name,designation,date of birth,date of joining,CTC.addess,contact number,blood group,qualification,total years of expereince.
2)Salary Structure of the employees you should write salary break-up of all the employees.
3)New Joinees details.
4)Details of Resigned Employees.
5)Attrition Rate.
The mentioned points should be prepared in different sheets.I hope this information will help a bit in preparing MIS.
Regards,
Trupti :P
From India, Pune
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.
Mis.jpg
New MIS reports Master Data.xls
Mis-report_form _116.doc