Dear friends,
I am Sripati, working as an accounts executive in a private limited company. I am facing problems in preparing the MIS report. Could you help me in preparing the MIS report? Please send me the format of the MIS report to my email id - sripatisahoo@rediffmail.com.
I need your help.
Thanks.
From India, Delhi
Acknowledge(0)
Amend(0)
I am Sripati, working as an accounts executive in a private limited company. I am facing problems in preparing the MIS report. Could you help me in preparing the MIS report? Please send me the format of the MIS report to my email id - sripatisahoo@rediffmail.com.
I need your help.
Thanks.
From India, Delhi
Acknowledge(0)Amend(0)
Hi Sripati, There are lot of posting on MIS on citehr. Just give a seach you’ll get lot of formats. Regards, Kalyan. :D
From India, Bangalore
Acknowledge(0)Amend(0)
2From India, Bangalore
Acknowledge(0)Amend(0)
Hi Sripati,
As you require the MIS Excel sheet, it would be better if you prepare the same at your end. This will help you to prepare other similar formats too.
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 Joiners:
In this sheet, list the names of new joiners for that month with details such as CTC, Designation, DOB, etc.
Fourth Sheet - Resigned Employees:
In this sheet, list the names 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:
I hope this information will be 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. This will help you to prepare other similar formats too.
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 Joiners:
In this sheet, list the names of new joiners for that month with details such as CTC, Designation, DOB, etc.
Fourth Sheet - Resigned Employees:
In this sheet, list the names 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:
I hope this information will be 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
MIS Report.doc