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
Acknowledge(0)
Amend(0)
10Please provide me...the details related to maintaining and preparing database.
Regards,
Chanchal
From India, Thana
Acknowledge(0)Amend(0)
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
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. 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
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
MIS Report.xls
MIS Report.doc