Sharing My HR MIS Compilation: A Resource for Our Community's Benefit

Hi,

I am posting everything I have on HR MIS. I hope this will help lots of members in here. Thank you, Octavious.

The post is the efforts of many and has just been represented by me after compiling all them together. At times, I may forget to put the above lines. If so happens, then do remind me because taking undue credit for others' work is not ethical.

For various links to my posts, kindly visit the links provided below:

[Major HR Links](https://www.citehr.com/99968-major-hr-links.html)

Hi Octavious,

GJD. It's quite informative, but it could be more informative if we add additional information such as attrition rate, attendance rate for the whole month, employee strength with their salary levels, and employee shifting information from one project to another, from one floor to another, and from one Team Lead to another (if applicable) as it affects their performance levels. This should also be considered in the MIS report. Looking for suggestions from all the members.

Regards,
SBA

Hi,

Thanks a lot for your valuable information sharing. I hope this will be very useful to all HR professionals working in different companies. Please share if you have any other information so that it will help newcomers in this field like me.

Thanks & Regards,
Prathima.

Hi,

A lot of stuff shared. Thanks Octavious. I also feel that instead of having all this in different documents, you can prepare one Excel workbook with different sheets, with each sheet representing one detail (like one sheet showing the headcount with their details, 2nd - new joiners and their details, 3rd - attrition, 4th - welfare activities, 5th - HR initiatives or issues and concerns, 6th - Recruitment report, etc.). You can also prepare a PDF format at the end of the same with graphs. This would provide better and easier access when you submit it to your higher authorities.

Regards,
Vinitha

Thank you for HR MIS.

I am unable to open the document "mis_report_for_hr_451.xls." Would you kindly forward it to my email id "scphro@gmail.com" and if possible, with additional information like attrition rate, attendance rate for the whole month, employee strength with their salary level, and employee shifting information from one project to another project, from one floor to another floor, and from one Team Lead to another Team Lead (if any) as it affects their performance level too so this should also be considered in the MIS report. Looking for suggestions from all the members. (As said by Sandeep Bahuguna)

Regards,

Sachin Chavan

Thank you for sharing the important data. It is very helpful to us. How can we maintain the employees' master list (contains the information of the employees) data?

Regards

Hi,

Thanks a ton, buddy. Really, you have done a tremendous job! Three cheers for you :).

I would like to know if you have any special formats or related information regarding EWS, RAG, and Attrition.

Regards,
Imeee

Hi,

Regarding variable pay compensation - is it mandatory that the company pays it every year? Is it based on employee performance alone or on overall company performance? Also, is it compulsory to do a performance appraisal every year? Should there be some increase in salary even if the company is not doing too well?

Hi,

Regarding variable pay compensation - is it mandatory that the company pays it every year? Is it based on employee performance alone or on overall company performance?

Also, is it compulsory to do a performance appraisal every year? Should there be some increase in salary even if the company is not doing too well?

Dear Octavius,

I was actually looking for the format of budgeted staff versus actual staff. If anyone can help me by sending the same to my email, I would greatly appreciate it.

Thank you for your previous assistance.

Best regards, [Your Name]

This is a very good format of MIS for HR. Everybody, especially new HR joiners in any organization, can use this with some changes as per their requirement.

Dear All,

We are in the process of defining broader guidelines for the security agency at the manufacturing location. A sincere request to all members: if you have any write-up available on the topic, please forward it.

Best Regards,
Sandip