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(1)
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)

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, 1444 views)

Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.