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.

From India, Pune

Attached Files (Download Requires Membership)
File Type: xlsx SACHIN GRATUITY FORMULA SHEET.xlsx (12.6 KB, 295 views)

PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Madhu.T.K
Industrial Relations And Labour Laws

Revised formula for error 5.6 yrs convert in 6 yrs.
From India, Pune

Attached Files (Download Requires Membership)
File Type: xlsx SACHIN GRATUITY FORMULA SHEET (1).xlsx (12.6 KB, 125 views)

The calculation is okay and useful. Congratulations!
From India, Kannur
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.

From India, Pune

Attached Files (Download Requires Membership)
File Type: xlsx UPDATED SACHIN GRATUITY FORMULA SHEET (1).xlsx (12.7 KB, 15 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.







About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server