Whats is the calculation of Gratuity and Leave salary (15) if Gross Salary of Employee 38500?
From India, Vadodara
Acknowledge(0)
Amend(0)
From India, Vadodara
Acknowledge(0)Amend(0)
Dear Parul,
Gratuity is calculated after completion of 5 years of service. It is calculated based on the basic salary. For example, if an employee's basic salary is Rs 25,000 per month and their service period is 5 years, the calculation will be as follows:
Basic salary: Rs 25,000
Daily wage: Rs 25,000 / 26
Gratuity amount: Rs 25,000 / 26 * 15 * 5 = Rs 72,115
Regards,
Pankaj
From India, Haridwar
Acknowledge(0)Amend(0)
2Gratuity is calculated after completion of 5 years of service. It is calculated based on the basic salary. For example, if an employee's basic salary is Rs 25,000 per month and their service period is 5 years, the calculation will be as follows:
Basic salary: Rs 25,000
Daily wage: Rs 25,000 / 26
Gratuity amount: Rs 25,000 / 26 * 15 * 5 = Rs 72,115
Regards,
Pankaj
From India, Haridwar
Acknowledge(0)Amend(0)
Dear sir But how to show gratuity in salary Breakup I have enclosed attachment with this .I dont know what is the formula please help
From India, Vadodara
Acknowledge(0)Amend(0)
From India, Vadodara
Acknowledge(0)Amend(0)
Hello dear i had gone trough with your salary sheet i have little bit confusion , How we can ensure gross salary amount
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Parul,
In the sheet, the gratuity amount is correctly shown (it will always be 4.81% of the current basic). However, while calculating the leave, I have inserted the formula for 15 days of annual leave for 26 days of monthly working.
Please find attached the corrected sheet. I hope this will serve your purpose.
Fellow members, can shed more light on it.
From India, Delhi
Acknowledge(0)Amend(0)
In the sheet, the gratuity amount is correctly shown (it will always be 4.81% of the current basic). However, while calculating the leave, I have inserted the formula for 15 days of annual leave for 26 days of monthly working.
Please find attached the corrected sheet. I hope this will serve your purpose.
Fellow members, can shed more light on it.
From India, Delhi
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
SALARY SHEET CALCULATION.xls