Amitmhrm
Hr Practices
Jayachandran
Manager - Finance
VEDPAL
Service Man
Kanak
Asst.manager Hr
Sreekumar.N
Human Resource
Chandniwtfl
Human Resource
Usha_nalawde
Telecom Billing & Revenue Assurance.
Sunandita Mukherjee
Hr Generalist
Sai Manohar
Employee
+14 Others

Dear All, please send me MIS report formats in excel.
Cite.Co is a repository of information created by your industry peers and experienced seniors made possible with help from our prime sponsors like:

TALENTEDGE Who provide a platform for "interactive anywhere learning". Courses from top reputed institutes like IIM, XLRI, MICA. View Courses

FACTOHR - Provides Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS that can help streamline your organisation. Explore Features

Register Here and help by adding your inputs. Contributions From Other Members Follow Below...
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.
HI MIS Report attached Regards Rajasekar

Attached Files
Membership is required for download. Create An Account First
File Type: xls MIS.xls (605.0 KB, 60642 views)

Hi Friends You need enable the Macros in your system, then only the buttons will work. Regards Rajasekar
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
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:
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.

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

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
Here Find A Hr Related Mis Report And Another Finance Related Mis Report

Attached Files
Membership is required for download. Create An Account First
File Type: xls MIS Financials Format.xls (521.5 KB, 5386 views)
File Type: xls MIS REPORT FOR HRM FUNCTION.xls (118.0 KB, 5704 views)

Dear Rajasekar, Can u please email me the the password for the sheet to unprotect shared work book. Regards, aShvini
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.
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 ?
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
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
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
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
Thanks for the format. Is there a possibility that you can share the break up salary in the xl format? I am looking for the %s alongwhich we need to allot the amounts. Please help
rajasekar16 I m not able to work on the file. Macros disabled error is displayed. What shall I do rgds
hi,
I am new to this site and would request your help. I am loking for guidelines to format a joining kit for the employees. Please if u can help me on this with some valuable suggstions.
Also if u can help me in understanding if there are any specific formats in terms of offer letter or appointment letters for employees who come on board and are on contract?
Regards
Sunandita Mukherjee
Hi Rajasekhar,
Very very good format.. Really appreciate the effort.. However, would like to incorporate some additional features and edit wherever i can to add some of my own observations that would be required in the MIS.. I would need the password to unprotect the sheet for the same.
Please let me know.
Thanks in advance,
Anamika.C
Hi Rajasekar, Good one, but not able view as access to each functions is disabled. Regards, Sreekumar.N
Request for MIS report format.
hi .. I am new to this site and would request your help. I am loking for format of MIS Report (Preferably excel format) , please if u can help me on this with some valuable suggstions would be appriciated.
Thanks in Advance
Ajay
Re: MIS Report formats in excel
Can anybody email me the complete MIS-Report formate (Excel)with running function to my email id:alaudeen786@gmail.com. It's very urgent for me.
1. MIS TELECOM
2. MIS HR
3. MIS SALES
4. MIS PURCHASE
5. MIS ACCOUNTS
PLEASE PROVIDED ME VERY FAST.
hi amit, quite informative. thanks... can u help me in preparing the flow chart ??? for different departments viz.. customer care, finance, production, hr, logistics etc.
hey hi jaya, r u working on MIS reports ?? u have any formats for any sales related data pls share ?? Regards, Chandraknat 09158138999
Hi team,
There are lots of format for MIS reports, which depends upon the type of the information, people to whom it will be circulated share, frequency..etc viz for projects, for departements, internal / external etc.
VLOOKUP
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)
explanation:
=vlookup (the thing (or array) whose cooresponding value you want to lookup some where, array where you want to look up corresponding value, column no. (starting from source column), optional)
hope it helps.
Regards,
Bharat
Hi friends
Now i m working at a denim factory at production MIS
also working at process control dept
but i want to work another knit dyeing unit of us
plz anybody help me giving suggestion about knit dyeing procedure, recipe, process contol or monitoring data sheet.
thnks
faruque
Hello everyone,
I'm new member in your team, can anybody please help me out by attached mis report regarding both for HR and Finance to my mail id -
Pls., it's very urgent.
Dear Amit,
The report you have attached is really good and easily understandable.
1. Form 3 macros are not working in Statutory Sheet(wich u hav attached)
2. In accident sheet nothing is given (its blank sheet).
pls, make me clear on the above queries.
Can you tell me, what does attrition rate mentions all about?
Regards,
R.S.Sugasini
not related to this not related to this not related to this not related to this
may this help you may this help you may this help you may this help you
Hi Everyone...!!

I am new to this forum and came to know about this from one of my friend. Few months back I was working with one of the biggest MNC at Delhi NCR location but due to some personal reasons, I left the company after spending more 5.5 yrs. From the last 5 months I am trying to get a a suitable jobs but all vent in vain and now I think I'll not able to celebrate this Diwali with great enthusiasm..Let see which way wind blows............

A brief introduction about me....I am B.com(H) graduate aged 35 yrs and having an experience close to 08 yrs. My last drawn CTC was INR 5,10,000/-. and key skills are as under :-

•Liaison with third party vendors

•Customer Relationship Management (CRM)

•Virtual Transitioning of work from Onshore US/UK locations

•Compliance – In terms of Data Security

•Quality Checks of Processing – Internal Audit

•Commitment to Quality – Adopted Lean best practice, Continuous process Improvements

•Systems knowledge – MS Office, Citrix, Lotus Notes, COGNOZ, IBM Mainframe, Siebel, Maestro

Can anyone please help in getting a suitable job in Delhi NCR ?

Recently I had been interviewed by some companies at Delhi NCR but not succeeded..Now, I had given interview in one of the Outsourcing companies based at Delhi NCR for Mid-level profile. Now, they are asking to submit ORIGINAL educational documents for at least 3-6 months and also need to sign a bond.

I know that this kind of practice is very much prevalent in UAE but not sure about in country like India..As far as my knowledge is concerned, companies Act of India does not allow such kind of unethical practice...Can any one throw some light on this ?

Thanks

GSA
Can anybody e-mail me the complete MIS-Report formate (Excel) with running function to my email id - .
MIS PURCHASE
MIS SALES
MIS ACCOUNTS
Thank You in advance
Please give me the certain requirement and I will prepare the Mis report for you please send you are requirement to mail
Hi Friends,
This is Murali. I have 5 years of Experience in accounts.
I don't have knowledge in HR department.
Please help me for HR Payroll Calculations, PF, ESI, other deductions.
What is PF deduction rules
What is ESI deduction rules & etc...

Hello everyone,
I'm new member in your team, can anybody please help me regarding mis report for Stores Management from indent to procurement. my mail id
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™