No Tags Found!

Jayachandran
23

Dear All, please send me MIS report formats in excel.
From India, Madras
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Amitmhrm
Hr Practices
Jayachandran
Manager - Finance
VEDPAL
Service Man
Kanak
Asst.manager Hr
Sreekumar.N
Human Resource
Chandniwtfl
Human Resource
+8 Others

Amitmhrm
496

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.

From India, Ahmadabad
rajasekar16
59

HI MIS Report attached Regards Rajasekar
From India, Madras

Attached Files (Download Requires Membership)
File Type: xls MIS.xls (605.0 KB, 62358 views)

rajasekar16
59

Hi Friends You need enable the Macros in your system, then only the buttons will work. Regards Rajasekar
From India, Madras
pundalikhr
6

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
From India, Pune
chandramouli1986
1

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:

From India, Madras
VEDPAL
1

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.

From India, New Delhi
mal.sarfaraz
1

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

From India, Ahmadabad
rajasekar16
59

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

From India, Madras
amardeepsingh30
19

Here Find A Hr Related Mis Report And Another Finance Related Mis Report
From India, Chandigarh

Attached Files (Download Requires Membership)
File Type: xls MIS Financials Format.xls (521.5 KB, 6164 views)
File Type: xls MIS REPORT FOR HRM FUNCTION.xls (118.0 KB, 6604 views)

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






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHR

All Copyright And Trademarks in Posts Held By Respective Owners.