How to prepare Hr monthly report - XLS Download

How to prepare Hr monthly report. Hope You will all get advantage through this Report.

Hi Vikas,
Can you please elaborate these points?
15 Total Overtime Cost/late sitting 100105
How do these points justify our reports?
17 Total mandays attendance of housekeeping during Dec 2011 140
18 Total Housekeeping bill payment(including Service Tax 10.30%) 31038
I liked this report, specially the Attrition Rate section. Thanks buddy.

Dear Sir,
Now a days HR Report is a must in all concerns. Reports may be daily, weekly, fortnightly, monthly etc.
Information Regarding Recruitment of employees, Man days, Machine utilization, Production targets-Contribution of HR. Absenteeism, Long absentees, problems, grievances, solutions, wages, incentives, Disciplinary actions. Union demands, negotiations etc. (A to Z) day to day matters of HR to be mentioned in the HR Report. Compliance reports. This will be known as MIS Report.
There is no prescribed format. The Co. may prescribe some Format, You have to fill and submit.
D.Gurumurthy
LL.HR & IR Consultant

Mr. Gurumurthy,
Good to see your opinion here and in other threads as well. It's good to put an opinion towards a point, however you should also aware what you are writing and in which context.
Frankly, I didn't see any logical connection between your opinion and the threads. HR affairs are sensitive and deeply sensitive. Please do not generalize with hay-way opinions, however you are welcome with a concrete information always.

HI ALL..
I have joined a IT Company of late as an HR. I want Some Suggestions that how should i Ameliorate my E-mail Drafting Skills.SO that i might Draft a Professional E-mail.Because the Head of the Company have Grudges for this thing.
With Best Regards,
Anamika

Dear friends ,
Please let me all the issues in the ESI&PF regardings as iam the fresher and joined in a small company as a hr mgr
Thanking you,
A.Rajesh,
8790000926

Dear Vikas,
Warm Wishes for the day ahead,
I reall want to express my sincere thanks to you coz the post by you is awesome and that's what I have been looking for and now I am thinking to implement the same in our concern.
In this regard I just need your valuable vies on the following my points on which I need some understanding
1.Total absent mandays during the month (on roll & off roll)
2.No. of mandays pay leave (on roll & off roll)
3.No. of mandays without pay leave (on roll & off roll)
4.Total Overtime Cost/late sitting
5.Total Overtime Hours
6.Total mandays attendance of housekeeping during the month
7.Total Housekeeping bill payment(including Service Tax 10.30%)
Please look into above and help.Once again I really want to thank you.

Hi,
You are talking about point number 15..
i want to claear that thing. we give late sitting allowance to staff members. and paid overtime to others workman. so the value u are looking in ponit 15.
this is total expense what incurred on late sitting and overtime.
its not a matter you also divide in two forms i.e 1. overtime cost & 2. late sitting allowance of paricular month.
And points 17 refers that we have housekeeping six personnel on contract basis. so contractor provide us bill against the housekeeping service.
Firstly we give him total mandays attendnce of each month at the end.
Then on this base contractor give the bill payment.
so there is nothing to think deep.
i hope you got it very well.
Thanks
Vikas Khatter HR
[Login to view]
[Login to view]
9034436151

Hello,
You are confusing with on roll & off roll.
i would like to suggest you that every company has its own personnel policy. they hire a employees on roll basis and off roll basis.
in roll basis the employees pf & esi and welfare amount is deducted.
and in off roll ther is nothing llike on roll, because company saved his esi & pf contribution behalf of employer side.
i hope you got it
Thanks
Vikas Khatter
[Login to view]
9034436151

Mr. Gurumurthy,
as you said you didnot see any logical connection between the thrreads and the opinion. so why donot you try put your own real thraeds regarding this report.
that will better. Every company makes the report according their personnel policy and what activities they are following.
If comapny making the HR Report in short manner then it doesnot mean that there is no logical connection.
I know the aforesaid HR Report is good for those who vanish in making HR Report.
In above mention HR Report there may be added so many issues.
and iam waiting for your HR Report..