MIS Report formats in excel - trade union Xls Download.. CiteHR

Jayachandran Started The Discussion:

Dear All, please send me MIS report formats in excel.

Amitmhrm -  Member Since: Feb 2007
Hi Jaya,

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.

Jayachandran -  Member Since: Dec 2007
Hi Amit, thanks for that. I need Finance related MIS reports formats. appriciate your response. regards jay

rajasekar16 -  Member Since: May 2008
HI MIS Report attached Regards Rajasekar

Attached FilesProvided by community member rajasekar16. Join us to learn and grow with your peers.
File Type: xls MIS.xls (605.0 KB, 29343 views)
SS01 -  Member Since: Mar 2009
hey, thnx for the info amit. thnk u rajasekar but the button is not functioning.:) cheers! sue

soma.dasgupta -  Member Since: Apr 2008
Can anybody email me the MIS-Report format (Excel) to my email id:soma_dg2005@yahoo.com. It’s very urgent..

rajasekar16 -  Member Since: May 2008
Hi Friends You need enable the Macros in your system, then only the buttons will work. Regards Rajasekar

pundalikhr -  Member Since: Jun 2008
Dear sir, Informative & comprehensive excel sheet. Is it use for SAP-HR? still it has got some technical problem are you facing the same. Awaiting of your earliest reply Pundalikhr

chandramouli1986 -  Member Since: Mar 2009
Dear Friends,

I want to know about the New TDS rates of Salaries and otherthan salaries,and also Sales tax rates and rules and Vat rates and rules and procedures for Bill Passing and CST rates and rules.Service Tax for various service and rates for the same.This is for your kind information.



VEDPAL -  Member Since: Dec 2007
Can anybody email me the complete MIS-Report formate (Excel)with running function to my email id:rana.vedpal@rediffmail.com. It's very urgent for me.




  • 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