Jayachandran Started The Discussion:
Dear All, please send me MIS report formats in excel.
Posted 14th December 2007 From India, Madras
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
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

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

Regards,


Amit Seth.
Posted 14th December 2007 From India, Ahmadabad
Hi Amit, thanks for that. I need Finance related MIS reports formats. appriciate your response. regards jay
Posted 14th December 2007 From India, Madras
HI MIS Report attached Regards Rajasekar
Posted 6th March 2009 From India, Madras
Attached Files
File Type: xls MIS.xls (605.0 KB, 52851 views)
SS01 
hey, thnx for the info amit. thnk u rajasekar but the button is not functioning.:) cheers! sue
Posted 6th March 2009 From Iran, Pars
Can anybody email me the MIS-Report format (Excel) to my email id:soma_dg2005@yahoo.com. It’s very urgent..
Posted 9th March 2009 From India, Calcutta
Hi Friends You need enable the Macros in your system, then only the buttons will work. Regards Rajasekar
Posted 10th March 2009 From India, Madras
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
Posted 10th March 2009 From India, Pune
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.


Regards,

S.chnadramouli:confused:
Posted 12th March 2009 From India, Madras
VEDPAL 
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.

1. MIS TELECOM
2. MIS HR
3. MIS SALES
4. MIS PURCHASE
5. OTHER TYPE

PLEASE PROVIDED ME VERY FAST.


Posted 13th March 2009 From India, New Delhi
How To Run The Mis Sheet As Button Is On Security Level Please Let Me Know Thanking You Sarfaraz
Posted 17th March 2009 From India, Ahmadabad
Sir,
Your Mis Report Is Excellent But I Am Not Able To Use The Excel Because It Not Working

So Please Tell Me How To Use The Excels As Macros And Not Running

Hoping For The Best

Thanking You

Sarfaraz

Posted 18th March 2009 From India, Ahmadabad
Truely, this is very helpful. PL keep posting all these usefull stuffs. Thank U So much. Shefali:) Executive - HR
Posted 18th March 2009 From India, Mumbai
Hi friends

you need to enable the macros in excel, then only the buttons will work.

To enable the macros follow these steps (windows 2007)

* Go to "excel options" (this will be in the same tab where the print option is)
* then "Trust center"
* then "Trust center setting"
* In that go for "Macros Setting"
* In "Macros Setting" u need enable option called "Enable All Macros"

I hope this will help u


Regards
Rajasekar
Posted 18th March 2009 From India, Madras
Here Find A Hr Related Mis Report And Another Finance Related Mis Report
Posted 30th March 2009 From India, Chandigarh
Attached Files
File Type: xls MIS Financials Format.xls (521.5 KB, 2874 views)
File Type: xls MIS REPORT FOR HRM FUNCTION.xls (118.0 KB, 2514 views)
hi every body good discussion how to mis reports in excel .what is the mis req in sales and marketing
Posted 3rd April 2009 From India, Visakhapatnam
Kanak 
Dear Rajasekar, Can u please email me the the password for the sheet to unprotect shared work book. Regards, aShvini
Posted 8th April 2009 From India, Mumbai
Hi Rajasekar, Your contribution for MIS reports thread is appreciative. Thank you very much for sending such a great document. Thanks&Regards Ramesh
Posted 1st May 2009 From India, Bangalore
Thank you for sharing with us, but when we click the buttons thats not opened. I tried can you solve this please. Thanks & Regards, Srinivas
Posted 12th May 2009 From India, Delhi
Hi Srinivasan You need to enable the Macros in your system. Already i have posted in this thread how to enable the macros. You just go through my previous posts. You are welcome sureshkumar.
Posted 12th May 2009 From India, Madras
Hi Seniors, Pls help me for the below query...

Any group of persons, who are under going training for 2 years (As per the Appintment order) and they have already completed 1 year, can they registered with trade union ?
Posted 23rd May 2009 From India, Visakhapatnam
adhila 
Dear Rajasekar ji,
I found ur MIS report very informative.Being a fresher in HR field ,it was like a eye opener to me.Based on the report,i started collecting more info and found it worth.
Could you please update me with the various activities and the reports to be prepared by the Hr.

Revert me ASAP

With lots of cheers
Adhi
Posted 29th May 2009 From India, Madras
Hi Rajasekar Thank you so much for the attched document. It is of great help to us. Regards & Bunches of smiles Chandni Pandey Human Resources Walchand Talent First Ltd Mumbai
Posted 18th September 2009 From India, Mumbai
sonu23 
Dear Mr.Rajasekar,

Your MIS attachement is great, but unabled one, a reuest please , i am not too good at Excel , can you guide me with some functions which you have used to make this MIS report.I would be v much grateful to you


Regards
Priya
Posted 21st September 2009 From India, Pune
MAM, CAN YOU GIVE ME THE EXCELL FORMAT OF MIS REPORT? MY E-MAIL ID IS "swarupgoswami.1519@rediffmail.com"
Posted 2nd October 2009 From India, Calcutta
Hi Rajashekhar, Please forward me the MIS excel. I am not able to access it on my system. Regards, Abhibroto Bose
Posted 12th December 2009 From India, Mumbai
Hi rajashekar, Really u did a good one . Thanks for sharing the information. Keeeeeeep on sharing such information. Regards Shirisha
Posted 29th January 2010 From India, Hyderabad
Dear All, I want to HR Report format or Traning report can any one sent report on my email id rishikesh.poddar@gmail.com
Posted 8th February 2010 From India, Delhi
Hi friends

you need to enable the macros in excel, then only the buttons will work.

To enable the macros follow these steps (windows 2007)

* Go to "excel options" (this will be in the same tab where the print option is)
* then "Trust center"
* then "Trust center setting"
* In that go for "Macros Setting"
* In "Macros Setting" u need enable option called "Enable All Macros"

I hope this will help u
Posted 9th February 2010 From India, Madras
daily mis report to managment . inthis mis all cash bank balance and credtors , debtors , stocks
Posted 17th February 2010 From India, Hyderabad




This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.

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