I am working as a Compensation & MIS Executive where I need to maintain various reports. However, as I am new to the company, I require different formats and guidance on how reports can be prepared and when to send them to the HR Manager.
Please provide me with details related to maintaining and preparing the database.
Regards,
Chanchal
From India, Thana
Acknowledge(0)
Amend(0)
10Please provide me with details related to maintaining and preparing the database.
Regards,
Chanchal
From India, Thana
Acknowledge(0)Amend(0)
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 I will definitely mail it to you.
I am describing the contents sheet-wise.
First Sheet - Details of employees:
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 include a column for the salary after any revision.
Third Sheet - New Joinees:
In this sheet, write down the names of new joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet - Resigned employees:
In this sheet, write the names of employees who resigned during that particular month with details such as name, designation, date of joining, date of resignation, last working day.
Fifth Sheet - Attrition rate:
Hope this information is very helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)
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 I will definitely mail it to you.
I am describing the contents sheet-wise.
First Sheet - Details of employees:
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 include a column for the salary after any revision.
Third Sheet - New Joinees:
In this sheet, write down the names of new joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet - Resigned employees:
In this sheet, write the names of employees who resigned during that particular month with details such as name, designation, date of joining, date of resignation, last working day.
Fifth Sheet - Attrition rate:
Hope this information is very helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
New MIS reports Master Data.xls
Amazing excel sheets very very informative.zip