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(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.