Chanchal411
9

I am working as Compensation & MIS Executive...where i need to maintain various reports, but as i am new to company...i need various formats, and in what ways reports can be prepared and when to send the same to HR Manager.
Please provide me...the details related to maintaining and preparing database.
Regards,
Chanchal

From India, Thana
Amitmhrm
496

Hi All,

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. But if required then definitely will mail the same.

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.

From India, Ahmadabad
Amitmhrm
496

Attached please find one of the sample format of the same. Regards, Amit Seth.
From India, Ahmadabad
Attached Files (Download Requires Membership)
File Type: xls MIS.xls (23.5 KB, 383 views)

Community Support and Knowledge-base 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 @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.