Bonus Calc. - Xls Download

Dear my HR Friends, Please find the attachment, it may useful to all my HR Friends, please go thru if need any corrections please suggest me. with kind regards V.Venkatesh 9849650987
31st July 2009 From India, Hyderabad

Attached Files (Download Requires Membership)

Bonus Calculation.xls (16.5 KB, 25487 views)

Dear V.Venkatesh Bonus is depend on employee monthly working days also pls find attached file for example
31st July 2009 From India, Udaipur

Attached Files (Download Requires Membership)

Copy of Bonus Calculation.xls (22.0 KB, 8342 views)

Sir
If a Employee whose Basic+DA is 12000, but due to absent his salary comes down to 9000 for some months, So is the person eligible for bonus for low salary received in those months?
P.Ghosh
Kolkata
21st June 2013 From India, Mumbai

dear Sir Ghosh ji he is not eligible for bonus shailesh bhiwadi(raj)
29th October 2014 From India, New Delhi

but depend on your company policy if you give bonus above 10000/- then he is eligible for bonus
29th October 2014 From India, New Delhi

but depend on your company policy if you give bonus above 10000/- basic +da then he is eligible for bonus
29th October 2014 From India, New Delhi

hi, i want to know if any employee basics is more than 21000, then he is eligible for bonus. please suggest to me.
1st January 2017 From India, Gurgaon

please clarify me if one employee worked 15 days and earned paid leave for 2 days. At time of calculation whether I will calculate the wages for 15 days or 15 days + paid leave 2 days = 17days. Please reply.
8th March 2019 From India, Bhubaneswar