sreenivasan Started The Discussion:
hello everyone, If someone can provide me a HR-MIS report format sample then it will be of great use. thank you have a nice time
Dear srinivasan, I am attaching the format for your perusal, regards Raghu
Attached FilesProvided by community member raghupa2000. Register to join your network of peers.
File Type: doc monthly_status_report_from_hr_251.doc (64.0 KB, 9294 views)
File Type: doc monthly_status_report_from_hr_213.doc (64.0 KB, 3589 views)

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 of 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 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
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

Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..


Amit Seth.
Dear All, I m attaching a excel file for MIS reports which are use in HRD. please find the attachment
Attached FilesProvided by community member a3n.nitin. Register to join your network of peers.
File Type: xls HR MIS for the Month of.xls (525.5 KB, 5921 views)
Dear, I have attached the MIS of HR which will be usefull for you. Please try at ones. Nitin
Hi Amit, Very good information. And its very impressive the way you explained. Thanks a lot!
Thank you really its very useful n covered all the areas of HR regards akangksha
upload error.....check the below mentioned thread
Could any one can help me by sending MIS report format suitable for a multi product trading company. Thanks Thomas KK
Hi, i am sujata dalvi. i want to know how to prepare mis report in hr in excel format. there should be some sheets to prepare it , is there any need to excel formulas or any thing else

can u tell mehow toprepare it, what is required for that? how to prepare mis report with example


Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network