I am working as Compensation & MIS Executive...where i need to maintain various reports, but as i am new to company...i need various formats, and in what ways reports can be prepared and when to send the same to HR Manager.
Please provide me...the details related to maintaining and preparing database.
Regards,
Chanchal
From India, Thana
9Please provide me...the details related to maintaining and preparing database.
Regards,
Chanchal
From India, Thana
Hi All,
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. But if required then definitely will mail the same.
I am describing you the contents with 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
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 n 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
Hope now it will be very much helpful for you,,
Regards,
Amit Seth.
From India, Ahmadabad
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. But if required then definitely will mail the same.
I am describing you the contents with 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
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 n 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
Hope now it will be very much helpful for you,,
Regards,
Amit Seth.
From India, Ahmadabad
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
MIS Report.xls
MIS Report.doc