Re: Mis - Xls Download - Mis Excel - CiteHR
Amitmhrm
Hr Practices
Anand2708
Accountant
Aru
Hr
Supriya_HR
Service
Hariharan.chandu
Hr-executive
Dbalwani
Hr Professional
Chaya.devi
Advocate
Roop@HR
Hr Executive
Renuka_salaye
Looking For One!

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Dear All, Can anyone help me on MIS- based in the HR field.............. How should I prepare the HRMIS in Ms- Excel PLS HELP!!! Thanks
Community Prime Sponsors
FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS.
Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
Hi Supriya...

As you require the MIS Excel sheet, it would be better if you prepare the

same at your end.Because 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



Hope now it will be very much helpful for you,,

Regards,

Amit Seth.
Ms. Supriya,
MIS is very relevant to our Residence EB or tele bill, which can give us only the required deatils for our end. pls try to work on your own and send us the file so that we can help you in modifing the same.
Cordially,
HH
Hello Supriya, Check out the HR MIS templaet I have attatched ...... I maintain it in this manner in our Co. Regards, SGF

Attached Files
Membership is required for download. Create An Account First
File Type: xls hr_mis_184.xls (87.0 KB, 3167 views)

Thanks for all ur help!!
Thanks..........
Actually I am already maintaining the excel sheets u are talking about..I wjust wanted to know,whether there are some special MIS reports prepared - so that we canjust know..that what actually took place in the HR in a particular month......
If ur company is S/W, the following is applicable :
Sheet 1 - Empooyee details - currently in role
Sheet 2- Employee details - resigned
Sheet 3 - Emp details who travelled to onsite ( long term )
Sheet 4 - Employees who come to India from Onsite
Sheet 5 - Consoldate list of the exisiting employees
Hi Supriya, Just go through yest and today’s posting u wil get the information. Bcoz so many replied for the same question. If you want more details contact me. Regards harini
Hi SGF, i saw your MIS excel sheet, this is for a big organization, can you give me some details on MIS for a organization having 30 to 40 employees Anita.
Hi, With the pivot table you can do the MIS. 1) First Sheet Total MOR 2) Gradewise MOR 3) Recruitment Detail 4) Attrition 5) Training 6) HR Update
Hello Anita,
The MIS report will vary from company to company depending on the direction the senior management wants to move. You have to sit with the main decision makers in your company, understand the business well and in which direction you are moving. Based on these, you will then have to see what information HR can provide which will help the managment in taking decisions with respect to the direction they are moving. Try not to focus on the employee strength or size of the company.
Hope you find this helpful..
I couldn't send you a personal message as I haven't completed 5 posts yet.
Regards,
SGF

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.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™