may be this tool help u for gratuity calculation
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls Gratuity Calulation.xls (19.5 KB, 2151 views)

Hi All, Can anyone provide latest Min Wages change of Uttaranchal & Jharkhand. Sumita Nagpur
From India, Hyderabad
Rajesh,
Have a look on below formula
15 days salary for each completed year = (Basic Salary+DA)/26 Days*15 Days
Gratuity = 15 days salary * total completed years of service.
The rule is that service should be continuous and the person is liable to get gratuity only after retirement.

From India, Nasik
Dear Mr.manilam
Sory u r gratutity calacilation Sheet totally worng
as per your ABC service just 4 years 5 months 29 days only then he is not elgibul for gratutity
your calacilation wright but your service formet worng
Plz cheack
Guru
Synergies castings ltd.

From India, Visakhapatnam
Dear All, Can anyone one provide us a clear picture of graduity calculation.... Im totally confused by many replies....
From India, Madras
Dear Mr.Manilam,
Your formula for calculation of gratuity is OK. But there are certain points also to be considered while creating a formula. One is the eligibility. The minimum years of completed service for eligibility is FIVE. If one has completed 4 years 6 months service, he will also be eligible. Second point is that while calculating the total number of years of service, the days of service after completed years are not considered porportionately. The last year service will be rounded off to one year if the employee crossed six month service on that year. Otherwise those days will not be counted. This point has to be considered while creating the formula. Otherwise the result will be incorrect.
Regards,
Babusivaprasad

From India, Kochi
The actual formula for Gratuity is your last drawn basic + DA/26*15*no of years worked in the organisation.
if you have completed 4 years 6 months than too it is considered as 5 years for the calculation of gratuity.
Regards,
Surjeet Kaur

From India, Mumbai
Dear,
Gratuity calculation sheet is totally right but i also agree with u dat acc to tenure ABC was not eligible,
but it is just a calulation sheet/method to cal the gratuity.
5 yr is min time period to claim for graruity
Manilam

From India, Delhi
Dear Akhilesh, Even if an employee has completed 4 years 6 month he is eligible for gratuity.
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.