Gratuity Formula Calculations format as per tentative Details - XLS Download

This excel is for understanding the Gratuity Calculation, which is a tentative Calculation to find the amount for Gratuity when person left from the organisation. or we say at the time of full and final settlement.
Formula :- Last Drawn Salary/26*15*No of Yrs Service.
Rules :-
1) Which consist of Minimum 5 Yrs Service as per Gratuity Act 1972. and if person complete more than 6 month , then its consists 1 Year.
2 )But the person who is minimum 4 yrs & 8 month service is consider as "0" zero years of gratuity service.
3) And if his is work for 4 Yrs & 8 Month and more but less than 5 yrs, then also he is consider as 5 yrs of services for gratuity is applicable.

Revised formula for error 5.6 yrs convert in 6 yrs.

The calculation is okay and useful. Congratulations!

Hi Sachin, thanks for sharing the Gratuity calculator - this is very helpful. But I think it is missing a fine point. As per gratuity act, six month period is to be considered as full year if no. of working days are 95/120 days (as the case may be). I have a case where employee joined on 18 Jan 2008 and last working date was 15 July 2021 (so effectively service period is 13 YEARS 5 MONTHS 28 DAYS). As per your file, total completed years of service is 13 Years. However, as per the gratuity act, it should be considered as 14 YEARS as the employee has met the criteria of working more than 95/120 days in the '5 Month 28 Days' period.

Can you please throw some light on this. I am attaching your updated template for reference.