I hope this attached file useful for you after some changes as per your requirement. Regards Ravinder Rawat
From India, Delhi
4From India, Delhi
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.
From India, Chandigarh
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.
From India, Chandigarh
Hello Friends Here I am enclosing You the Form A, B & D as per The Payment of Bonus Act. Please find enclosed. Regards, Arihant
From India, Surat
From India, Surat
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
From India, Kakinada
From India, Kakinada
Dear Mr.Ravinder, I think you are forgot the payable days. Bonus gives in payable days basis. Regards T S
From India, Pune
From India, Pune
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.
From India, Chandigarh
From India, Chandigarh
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
From India, Madras
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
From India, Madras
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.
SALARY SHEET CALCULATION.xls