Formats of monthly HR reports to be submitted to management - XLS Downloads

Hi Friends, Can you send me the formats of monthly HR reports to be submitted to management
Thanks

Hi All,

I am describing you the contents with sheet wise.. which you may prepare in your monthly HR report..

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

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..

Regards,

Amit Seth.

Dear All, Plese See the HR Monthly Report Format Attachment I think it would be Useful if Useful Justb let me know

Hi Deepa
Thanks for that.
I was looking for the same from long time.Thanks again.
Can you please help me with some format which allows us to store all these things in common, showing their current status?
Our company has such records , and my boss wants me prepare a common record which could help us find the status ofall these things at one go.

:-P Hi guys, i really enjoy your comments. I am particularly interested in a Monthly HR report that can be used for normal monthly reporting as well as a strategy tool to assist with long term planning decisions.
Hope you have something

:-|hi deepa
how are you deepa iam working in HR Department but idont have Sufficient information please let me know more about the HR report that you send there is some in initials i could not under stand so please can you explain
thanks :-|

Hi,
Enclosed please find one sample format of the MIS report. Can add a number of other sheets related with other informations needed to know on monthly basis.
Regards,
Amit Seth.

its cool. But i face a problem. i don't understand the word DOB, DOJ. what does it mean?

Just a quick one , i just opened the MIS document and it seems like a data base of staff not a report . what i would really like to have is a sheet with a monthly report for management on the activities in HR

Enclosed please find one sample format fyi for share information