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.
Regards,
Manpreet

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
pganeswararao
14

Asst. General Manager - HR & IR
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
Rgds
PGR

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

This discussion thread is old and is closed for new comments. If you want to continue this discussion or have a follow up question, please post a new thread. Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 Cite.Co™