Bonous Calculation - Xls Download

Dear all,
Please send me the Bonous calculation Format

I hope this attached file useful for you after some changes as per your requirement.
Regards
Ravinder Rawat

A very masterly worked out sheet. However it takes into account the maximum eligible amount off salary as Rs. 3500.00 maximum eligibility of an employee earning up to Rs. 10000 a month.
These two eligibility amount should be defined separately and the formulae must use those values, so that one can change them as and when there is any change in these limits. We will soon see these limits as Rs. 5000 and 15000 respectively. In that case all the formulae in cells G4 through R4 and G7 through R7 are require to be re-written.

Hello Friends
Here I am enclosing You the Form A, B & D as per The Payment of Bonus Act.
Please find enclosed.
Regards,
Arihant

Dear Shreedhar ji,
Will you please explain what way it is wrong ? The salary which we have to put in the colom is the earning salary of the month is in't it.
Regards,
PBS KUMAR

Dear Mr.Ravinder,
I think you are forgot the payable days. Bonus gives in payable days basis.
Regards
T S

I agree with Shreedhar Kantharia and tsatchidhanandam. Bonus is payable on the actual days worked and salary/wages paid and not at the monthly rates as worked out in the sheet. The wages on which PF was deducted are the actual wages. This excludes even the leave without pay and absenteeism from the work.

Hi,
Kindly find attached the Form D format

Hi Friends,
can any one clarify me in Bonus calculation only monthly salary will taken or salary and no. of days leave taken during the financial year. if one concern allow 36 days leave for the year, more than taken leave take it as loss of pay on bonus calculation. please clarify.
thanks
regards
sahana samu