No Tags Found!

Whats is the calculation of Gratuity and Leave salary (15) if Gross Salary of Employee 38500?
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)

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
Attached Files (Download Requires Membership)
File Type: zip Book1.zip (7.7 KB, 347 views)

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)

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
Attached Files (Download Requires Membership)
File Type: xls Gratuity-Leave calculation on CTC-Rev..xls (29.5 KB, 1442 views)

Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.