Sample HR MIS Report Format - decision making Xls Download.. CiteHR

Vedha Ravishankar Started The Discussion:

Hello, Please send to me a sample format of HR- MIS report & let me also know how it works & what purpose it serves Thanks & Regards, Vedha Ravishankar

Amitmhrm -  Member Since: Feb 2007
Hi Vedha,

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.

anas_zubair -  Member Since: Jun 2008
Hello Everyone,
I have newly joined this group. Kindly keep me updated for any activities/developments in HR field. More over i an in very bad need of MIS reports samples for human resources, may i ask our group members for this kind help.

God bless you all.

to_nsuchitra -  Member Since: Aug 2008
Hi ,please send me a sample MIS report , Pay roll report . I would like to know about statutory compliance ( PF , ESI ) etc

subashpv -  Member Since: Apr 2009
hi can anyone send a MIS report sample to my email for Healthcare industry(medical billing). Thanks my email is

Asker -  Member Since: May 2009
why dont you try Attend HRM it basically a integrated time attendance and payroll software which gives you many aditional benifits like document mangement,leave management, roster, complete payroll income tax,all related reports with daily attendance like over time ,late in/out time,various other attendance calculation,you can also centralise the data for all the brances in in one single location;send reports by one single click for bulk mails etc all this in one application..........

illiyas1985 -  Member Since: Jun 2009
Hi subashpv Here with Sample xls sheet go through it useful for you

Attached FilesProvided by community member illiyas1985. Join us to learn and grow with your peers.
File Type: xls Monthly Business Reportsold.xls (46.0 KB, 4281 views)
joyneo04 -  Member Since: Aug 2008
you can check out this as welll....follow all the three sheet and one thing that is missing is code no or sap id which you can insert a row just beside s no...

Attached FilesProvided by community member joyneo04. Join us to learn and grow with your peers.
File Type: xls MIS.xls (8.5 KB, 4189 views)
Mou prasad -  Member Since: Jan 2009
Hi Suchita! Can you please help on preoparing MIS reports for the HR department? regards, Mou

venhadesh -  Member Since: May 2009
Can you pls send the Sample MIS for entire Hr dept and also monthly HR Report. I need it for our manufacturing firm. Since i am a fresher, top management peoples are expecting more like this kind of activities from me. Can any1 help me out in this regard pls. send it at


  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • 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.

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Share This Discussion:

    3M Users, 100K+ Documents & 450K+ Discussions
    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network