may be this tool help u for gratuity calculation
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Gratuity Calulation.xls (19.5 KB, 2151 views)

Acknowledge(0)
Amend(0)

Gratuity Calculation Formula

Please take a look at the formula below:

15 days' salary for each completed year = (Basic Salary + DA) / 26 Days * 15 Days. Gratuity = 15 days' salary * total completed years of service. The rule is that service should be continuous, and the person is eligible to receive gratuity only after retirement.

From India, Nasik
Acknowledge(0)
Amend(0)

Dear Mr. Manilam, Sorry, your gratuity calculation sheet is incorrect. According to your ABC service, only 4 years, 5 months, and 29 days of service are eligible for gratuity. Your calculation is correct, but the service format is wrong. Please check.

Regards, Guru Synergies Castings Ltd.

From India, Visakhapatnam
Acknowledge(0)
Amend(0)

Dear All, Can anyone one provide us a clear picture of graduity calculation.... Im totally confused by many replies....
From India, Madras
Acknowledge(0)
Amend(0)

Your formula for the calculation of gratuity is okay. However, there are certain points to consider while creating a formula. One is the eligibility criteria. The minimum years of completed service for eligibility is five. If an individual has completed 4 years and 6 months of service, they will also be eligible.

The second point to note is that when calculating the total number of years of service, the days of service after completed years are not considered proportionately. The service in the last year will be rounded off to one year if the employee completes more than six months of service in that year. Otherwise, those days will not be counted. This aspect must be taken into consideration when formulating the formula to ensure accurate results.

Regards,
Babusivaprasad

From India, Kochi
Acknowledge(0)
Amend(0)

Gratuity Calculation Formula

The actual formula for Gratuity is your last drawn basic + DA/26 * 15 * number of years worked in the organization. If you have completed 4 years and 6 months, then it is considered as 5 years for the calculation of gratuity.

Regards,
Surjeet Kaur

From India, Mumbai
Acknowledge(0)
Amend(0)

The gratuity calculation sheet is totally correct, but I also agree with you that according to tenure, ABC was not eligible. However, it is just a calculation sheet/method to calculate the gratuity. Five years is the minimum time period to claim for gratuity.

Regards,
Manilam

From India, Delhi
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.