Dear Mohana Pathma Priya,
Your Gratuity Calculator.XLS is interesting. Good attempt. However, there is a mistake in the calculations.
As per the Payment of Gratuity Act, 1972, the payment of gratuity is calculated on a full year and not a partial year, i.e., on a pro-rata monthly basis.
It means that if you have completed 5 years of continuous service, you are eligible for gratuity. But if your service is 5 years and 1 month (i.e., up to 6 months), it is considered as only 5 years and not for 5.1 years. Similarly, if it is 5 years and 7 months (i.e., more than 6 months), it is to be paid for 6 years and not 5 years and 7 months on a pro-rata basis.
You may correct your calculator accordingly for the benefit of other junior HR fraternity.
With kindest regards,
J N Pathak
09825303208
Mohana Pathma Priya
Re: Clarifications on Payment of Gratuity Act, 1972
Dear Mr. Murthy,
Please find attached for your information. If you need more information.
Thanks & Regards,
Mohana S
Attached Files:
GRATUITY.ppt (101.0 KB, 13 views)
Gratuity Calculator.xls (18.5 KB)