Re: Need Formula For Gratuity Calculation - XLS Download

hi there, I Need formula for gratuity calculation pls. help me thanks, Lokesh
29th February 2008 From United States, Fairfield

Hi Lokesh,
Gratuity Formula is
Last Basic Salary + DA earned / 26 * 15 * No of years worked
The conditions are
1) Minimum of 5 years of service
2) The above formula is for monthly salary employees
Gratuity amount above rupees 3.6 Lacs would be taxable.
Regards,
Amit Seth.
29th February 2008 From India, Ahmadabad

Dear sir,
Pls. clarify gratuity payable to an employee on his death before completion of his 5 yrs service.( 1.5 -2.0 yrs. in service only.)
His salary was Rs. 5000.00 p.m
pls. calculate his gratuity amount for 2 yrs.
Rgds.
ARbindo
2nd March 2008 From India, Mumbai

Hi, Since u have not clarified , whether the amount of Rs. 5000/- is basic or gross salary. The gratuity amount would be calculated , at formula which Amit has mentioned above. katyana
2nd March 2008 From India, Gurgaon

Hi lokesh,,,
Kindly click on the link to get the details
https://www.citehr.com/download-list.php?query=gratuity
Also find an attachment
2nd March 2008 From India, Coimbatore

Attached Files (Download Requires Membership)

gratuity_computation_1__460.xls (24.5 KB, 1442 views)

Hi resigned from my services. I was working on the post of personal secretary to executive Director. I joined my services on 01/05/2001 and resigned on 31/05/2017. My total length of services is of 16 years.
my basic salary is Rs. 15,570/- and DA is 375, hence, I calculated my gratuity as under:
15,570+375= 15,945 x15 x 16 /26= 1,47,184 would be my gratuity amount. But i received the cheque of Rs. 1,29,360/- only. When I asked my accounts department, they said we are giving and calculating like this only. So the question, is should I ask them for the formula which they have used in calculation. Is there different formulas to calculate gratuity rather then above which i have used.
Please anybody guide me - I need clarification.
3rd June 2017 From India, Kolkata