How To Calculate Gratuity Xls Download

suki.suman@gmail.com
Dear All,
Please help me out in calculating Gratuity......
If you have any study and practical materials ..please send me....
tsatchidhanandam
Dear Suki,
Gratuity calculation is = Basic + D.A. X 15 / 26 X No. of years completed in services = Gratuity Amount.
t satchi
sharathN
Hi,
The gratuity computation is as follows:
Basic salary as on 31st Mar+DA * (15/26) * No. of yrs of service.
Hope you are aware that gratuity is payable to a resigned employee only if he has completed 5 years of service. However, finance department may need to know the gratuity amount to provide provision for gratuity payment. Here, gratuity is computed for all employees irrespective of their years of service, but not paid out.
Eg 1:
An employee joins on 1st March 2002 and resigns on 26th December 2008. His basic salary as on 31st Mar 2008 is 15000.00, then how do you calculate gratuity
Ans:
1st March 2002 to 26th December 2008 = 6.8 years of service
15000 * (15/26) * 6.8 years = 58846.00
If there is a increase in basic salary during the year, the same can be considered proportionately.
Rgds,
Sharath
9341906204
Email: [Login to view]
kalpeshpatel
hi suki pls find here attachment of gratuity calculation.
i
1 Attachment(s) [Login To View]

mohanms007@gmail.com
Hi Suki,
Please herewith find the attached file of PPT for Gratuity Calculation.
Warmest Regards,
Mohan.M.S
1 Attachment(s) [Login To View]

kuppibai
Please calculate my gratuity as my salary drawn in December 2009 Basic +DA is 11600 and From January 2010?
My Basic+DA is Rs 17523 .Retirement date will be on 15/03/2010. My date of Joining was 06/09/1978.
Please tell me how much Gratuity amount I can get after my settlement
canijasure
please send me the file in which calculation of gratuity can be done.
Regards,
Charudatta Nijasure
Dy. Manager - HR
TACO Composites Ltd.
jsharma1775
ELIGIBILITY FOR GRATUITY : I had joined a company in 4-Dec-2004 and left from there in 31-July-2009.
Can i claim the gratuity?
Viannie
Pls can someone explain what "DA" means??? I just keep seeing Basic+DA But dnt get wot DA stands for
Viannie
Can some please explain the Gratuity formula in details??? Why do we times the Monthly salary by 15days? what does the 15days stand for??? I know 26 stands for the number of working days available in a month
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute