I prepared one excel sheet in excel to calculate Gratuity. Kindly let me know if any correction is needed.
From India, Buldana
please clear the calculation of gratuity. i know the formula which is basic+Da*15/26*no. years. Please clear this by example. Regards, Manpreet
From India, Ludhiana
Dear Manpreet, What exactly you want to know. if you have the basic salary, dearness allowance and the number of year an employee worked then you can apply the formula.
From India, Buldana
Dear Vivek sang,
Thanks for your advise, actually when try to calculate this thing or formula the payable amount not calculated rightly. thats why need an example.
Please help me if you can.

From India, Ludhiana
Dear Manpreet, Tell me what figures you entered and what was the calculation result only then I can let you the procedure.
From India, Buldana
i got the formula but still i am not getting the idea of 15/26 days.
From India, Noida
For gratuity minimum period of service is 4 years 8 Months.
Suppose an employee has completed 5 years of service then he is entitled to
15 days days average salary last drawn by employee per completed year
In a month there are 26 working days
Hence average 15 days salary for 5 completed years will be
(15/26)*5 yrs
Salary here means Basic + Dearness Allowance and that too the last salary dran by the employee
If the employee basic salary is 4000 and Dearness Allowance is 3000 then complete formula for gratuity will be
7000 * (15/26) * 5
Hope it's clear to all

From India, Buldana
Hi swetha,
I am ganesh from Hyderabad. Nice to meet you in this forum.
The gratuity calculation is
Basic x No. of years servie x 15 / 26
For examble:
A person worked for 6 years and his basic 10000/-
then the gratuity amount comes to Rs.10000/- x 6 x 15 / 26
= Rs.34,615/-
15 is meant for half month salary
26 is meant for month days (after leaving w/offs)
If you have any query, please get in touch with me 9490448544

From India, Hyderabad
Dear Vivek, Pls check it your excel sheet not work proper. Regards, Vivek
From India, Ahmadabad
Updated the file. Please check and let me know in case of error. Vivek Sang
From India, Buldana

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHRô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server