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
From India, Bhopal
Acknowledge(0)
Amend(0)
1I 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
From India, Bhopal
Acknowledge(0)Amend(0)
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.
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. 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.
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi there,
Please click the following links to access a wealth of information:
- #124202
- #50348
- #146348
- #160545
- [url]#51380]
Thank you.
From India, Coimbatore
Acknowledge(0)Amend(0)
Please click the following links to access a wealth of information:
- #124202
- #50348
- #146348
- #160545
- [url]#51380]
Thank you.
From India, Coimbatore
Acknowledge(0)Amend(0)
I also very useful for this MIS formats.. thanks i am m.com graduate in india.. I would like to thank you akansha & amit.. very good this is helping to develop my future
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, Mumbai
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.
Employee Data - Format.xls
10 ways to format Excel data.pdf