Struggling with MIS Report Preparation: Can Anyone Share a Helpful Format?

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.

Hi Sripati,

There are a lot of postings on MIS on citehr. Just give a search, and you'll get a lot of formats.

Regards,
Kalyan. :D

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