This Excel is for understanding the Gratuity Calculation, which is a tentative calculation to find the amount for gratuity when a person leaves the organization, or we say at the time of full and final settlement.
Formula: Last Drawn Salary/26*15*No of Yrs Service.
Rules:
1) It consists of a minimum of 5 years of service as per the Gratuity Act 1972. If a person completes more than 6 months, then it counts as 1 year.
2) However, a person with a minimum of 4 years and 8 months of service is considered as "0" zero years of gratuity service.
3) If he works for 4 years and 8 months or more but less than 5 years, he is still considered to have 5 years of service for gratuity to be applicable.
From India, Pune
Acknowledge(0)
Amend(0)
2Formula: Last Drawn Salary/26*15*No of Yrs Service.
Rules:
1) It consists of a minimum of 5 years of service as per the Gratuity Act 1972. If a person completes more than 6 months, then it counts as 1 year.
2) However, a person with a minimum of 4 years and 8 months of service is considered as "0" zero years of gratuity service.
3) If he works for 4 years and 8 months or more but less than 5 years, he is still considered to have 5 years of service for gratuity to be applicable.
From India, Pune
Acknowledge(0)Amend(0)
Hi Sachin,
Thank you for sharing the Gratuity calculator - this is very helpful. However, I believe it is missing a crucial point. According to the gratuity act, a six-month period should be considered as a full year if the number of working days is 95/120 days (as the case may be).
I have a scenario where an employee joined on 18 Jan 2008 and their last working date was 15 July 2021 (resulting in a service period of 13 YEARS 5 MONTHS 28 DAYS). Your file indicates a total of 13 Years of completed service. Nevertheless, in line with the gratuity act, it should be recognized as 14 YEARS since the employee has fulfilled the requirement of working more than 95/120 days in the '5 Month 28 Days' period.
Could you shed some light on this matter? I am attaching your updated template for your reference.
From India, Pune
Acknowledge(0)Amend(0)
Thank you for sharing the Gratuity calculator - this is very helpful. However, I believe it is missing a crucial point. According to the gratuity act, a six-month period should be considered as a full year if the number of working days is 95/120 days (as the case may be).
I have a scenario where an employee joined on 18 Jan 2008 and their last working date was 15 July 2021 (resulting in a service period of 13 YEARS 5 MONTHS 28 DAYS). Your file indicates a total of 13 Years of completed service. Nevertheless, in line with the gratuity act, it should be recognized as 14 YEARS since the employee has fulfilled the requirement of working more than 95/120 days in the '5 Month 28 Days' period.
Could you shed some light on this matter? I am attaching your updated template for your reference.
From India, Pune
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Period of training shall be counted for the calculation of gratuity-HIGH COURT JUDGMENT.doc
Payment of Gratuity Act, 1972 & The Rules.ppt