Dear all, I have prepared calculator for calculating Gratuity. Your suggestions are welcome for any modifications.
From India, Mumbai
121From India, Mumbai
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
From India, Mumbai
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
From India, Mumbai
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.
From India, Mumbai
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.
From India, Mumbai
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
From India, Lucknow
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
From India, Lucknow
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
From India, Mumbai
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
From India, Mumbai
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.
From India, Mumbai
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.
From India, Mumbai
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.
From India, Mumbai
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.
From India, Mumbai
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
From India, Mumbai
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
From India, Mumbai
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.
From India, Mumbai
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.
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Gratuity calculation.doc
Gratuity Calculation tool.xls