I have been recruited by an IT organization(450 employees) recently as a HR Executive.Prior to my joining both the HRD &GAD were acting as one Department ,where there was no proper information flow to the management .I would like to know the Various HR MIS reports we can generate to get the complete picture of the Departmental outputs.
From India, Hyderabad
From India, Hyderabad
There can be N numbers of reports. I work in an It firm, reports having the following data:
Active projects, with the active members with their correct % allocation and resource location.
Costing report which has the details of cost along with the the above mentioned informations
People availabilty
Resource skill set
Visa status
Leaves Xls
Contact Info Xls
there are many.
Regards,
Vidya
From India, Gurgaon
1Active projects, with the active members with their correct % allocation and resource location.
Costing report which has the details of cost along with the the above mentioned informations
People availabilty
Resource skill set
Visa status
Leaves Xls
Contact Info Xls
there are many.
Regards,
Vidya
From India, Gurgaon
Hi Everybody,
A lot of information we can give through MIS reports.here are some of them----
1.Newl joinee in the month--
Sr.No.--Names---Dept.--designation--DOJ --Period ends on--Gross Sal- -Total CTC & Remarks
2. Attrition Repoert for the Month----
Sr.No. Names---Dept. --Appointment type ---Date of Resignatio -- Date of Releive -- Remarks
3. Departmentwise Strength for the Month----
Sr.No. --Dept. --Permanent ---Third Party Contract --Temperory -- Retainers like this....
4. Total Strength for the month----
Sr.No. --Opening Balance ---Joined during Month --- Seperated during Month --- Remarks
5.Monthly Employees MIS Report
Sr.No. --Emp_Nos. ---Emp_Names ---Dept.---Designation --- Location-- Reporting To ---Employment Type ---Basic Salary -- DA --Allowances ---Total gross ---PF Contri. ---Bonus --Gratuity --
Other Earnings --Total CTC --(We can add leaves here also Overtime 7 Night Shift All applicability etc.)
Regards,
padmini.
From India, Thana
A lot of information we can give through MIS reports.here are some of them----
1.Newl joinee in the month--
Sr.No.--Names---Dept.--designation--DOJ --Period ends on--Gross Sal- -Total CTC & Remarks
2. Attrition Repoert for the Month----
Sr.No. Names---Dept. --Appointment type ---Date of Resignatio -- Date of Releive -- Remarks
3. Departmentwise Strength for the Month----
Sr.No. --Dept. --Permanent ---Third Party Contract --Temperory -- Retainers like this....
4. Total Strength for the month----
Sr.No. --Opening Balance ---Joined during Month --- Seperated during Month --- Remarks
5.Monthly Employees MIS Report
Sr.No. --Emp_Nos. ---Emp_Names ---Dept.---Designation --- Location-- Reporting To ---Employment Type ---Basic Salary -- DA --Allowances ---Total gross ---PF Contri. ---Bonus --Gratuity --
Other Earnings --Total CTC --(We can add leaves here also Overtime 7 Night Shift All applicability etc.)
Regards,
padmini.
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
Sixth Sheet - Training programs conducted
Seventh Sheet - Other activities done in that month.
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
Sixth Sheet - Training programs conducted
Seventh Sheet - Other activities done in that month.
Hope now it will be very much helpful for you.
Regards,
Amit Seth.
From India, Ahmadabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
New MIS reports Master Data.xls