No Tags Found!

vivek sang
65

I prepared one excel sheet in excel to calculate Gratuity. Kindly let me know if any correction is needed.
From India, Buldana
manpreet_6755
5

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
vivek sang
65

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
manpreet_6755
5

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
vivek sang
65

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
shwetarani27
2

i got the formula but still i am not getting the idea of 15/26 days.
From India, Noida
vivek sang
65

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

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
pandey_vivek786
3

Dear Vivek, Pls check it your excel sheet not work proper. Regards, Vivek
From India, Ahmadabad
vivek sang
65

Updated the file. Please check and let me know in case of error. Vivek Sang
From India, Buldana
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.