Calculation Of Gratuity - Xls Download

Dear all,
I have prepared calculator for calculating Gratuity.
Your suggestions are welcome for any modifications.

Dear All,
Kindly ignore earlier attachment and please consider the revised one.
sorry for the inconvenience caused.
the attached calculator calculates gratuity only for completed years of service.
if person works for 240 days in last year then that should be considered as completed year.
e.g. if person works for 4 years and 240 days of 5th year then his working should be considered as 5 years.
in calculation of continuous service consider Actual working+Weekly Offs+ Compensatory offs+Paid Holiday+ Paid Leaves

Dear All,
1 completed calendar year as per Payment of gratuity act=240 days of working (Actual working+Weekly Offs+ Compensatory offs+Paid Holiday+ Paid Leaves)
Calendar year means the year starting on 1st day of Jan and ending on 31st Dec in any year.

Dear Suhas Khambe ji,
As per the provisions of The Payment of Gratuity Act if a worker has worked more than six months (even a single day) in a calender year then it will be treated as one year. I think the 240 days condition is not valid. Though your sincere efforts are really excellent.
Regards
Lokesh C. Sharma
Sr HR Professional

Dear all,
I feel that the explanation of continuous service with condition of 190 days or 240 days has been given in the context of interrupted service in the form of strike, lay off, etc. and not for counting the total number of years of eligible service of first five years. In any case, the person has to complete five years of service, i.e. from the date of joining to date of separation, except case of death, for being eligible for gratuity. The completed year of service has been reckoned for the period of service of more than six months in the last year of service. The calculation for persons employed in seasoned industry also differs.
Hence, the calculations need review.
Regards

Dear Mr. Lokesh Sharma Sir,
There has been debate on this site regarding 6 months should be considered as completed year or not.
there should be any written evidence for this purpose.
kindly provide copy of any GR or case law where judgement has been given that 4 years and 6 months are considered for payment of gratuity.
your help in this regard will be really very useful to us.

If any employee goes on leaves without pay with approval then this days are deducted from his Actual working days.
with reference to case laws if employee goes on leave which is unpaid one then this days are deducted. and after deduction if his service is 240 days in an year then that year is considered for calculation.

Dear Mr. Suhas,
Please refer to section 4(2) of the Payment of Gratuity Act, 1972 which states that for every completed year of service or part thereof in excess of six months, the employer shall pay gratuity to an employee at the rate of 15 days' wages based on the rate of wages last drawn by the employee concerned.
I hope your query is clarified now. No GR or case law is required.
Regards

Dear Mr. Premkumar Nair Ji,
Thanks for your valuable reply. my query has been satisfied with your answer. actually i was seeking for this kind of solution.
in case of calculator in excel i have left margin for manually entering years. so the calculator is still useful. please refer the second attachment.

Dear Mr. Khambe,
Your efforts are appreciable but should be calculated by considering 6 months condition as provided in the Gratuity Act.
( J.S.Walia)