Which are the main MIS Reports of an accounts department & what the format of preparing the MIS ?
MIS report is known as Management Information System... regarding the Manpower status of a particular month, place and overall..
It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..
You may prepare the same at your end.As it will help you to prepare other such formats too.
I am describing you the contents with sheet wise..
First Sheet - Details of employee
b. Name of employee
c. Date of birth
f. Address for communication
h. Contact number
i. Blood group
j. Maximum qualification
k. Extra qualification
Second Sheet- Salary structure
In this sheet write down the complete salary structure.. and make a column what is salary after any revision
Third Sheet - New Joinees
In this sheet write down the name of New joinees of that month with detail like CTC, Designation, DOB etc.
Forth Sheet - Resigned employees
In this sheet write the name 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
Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..