Need Help with MIS Report Format: What Should It Include for IT Companies?

Hi all,

I am Akanksha, working in an IT company in Indore. Can anyone help me with the MIS report format? I am in urgent need of the format. Otherwise, please advise me on what should be covered in an MIS report.

Thanks,
Akanksha

Hi, Akansha...

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. I am describing the contents to you 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 for the salary after any revision.

Third Sheet-

New Joinees

In this sheet, write down the names of New Joinees 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 like name, designation, date of joining, date of resignation, last working day.

Fifth Sheet-

Attrition rate

I hope this will be very helpful for you.

Regards,

Amit Seth.

Hi everyone,

I would like to add on to Amit's suggestions.

Sheet 1
Department-wise number of employees (staff in one column and workers in the other).

Sheet 2
Level-wise or designation-wise number of employees.

Sheet 3
Ratios:
1. Male employees Vs Female employees
2. Technical staff Vs Non-technical staff
3. Staff Vs workers
4. Budgeted Vs Actual employees
Number of Engineers Vs Diploma Holders Vs CA Vs MBA Vs others, etc.

Sheet 4
Number of employees who joined in that month. Their names, Designation, Level, Department, Date of joining, CTC.

Sheet 5
Number of employees who left in that month. Their names, Designation, Level, Department, Date of joining, Date of leaving, CTC.

Hope this will help you.

Regards,
Surbhi Gupta

Amitmhrm, in your message to Akansha, you suggested preparing an MIS Excel sheet with specific details organized across different sheets. Here is a summary of the contents for each sheet:

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:
Include the complete salary structure and a column for salary after any revision.

Third Sheet
New Joiners:
List the names of new joiners for that month with details like CTC, Designation, DOB, etc.

Fourth Sheet
Resigned employees:
Record 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.

I hope this information is very helpful for you.

Regards,
Amit Seth