I prepared one excel sheet in excel to calculate Gratuity. Kindly let me know if any correction is needed.
From India, Buldana
64From 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
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
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
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
From India, Buldana
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
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
Rgds
PGR
From India, Hyderabad
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
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.
#Subject List: basic salary dearness allowance calculation of gratuity payment of gratuity employee joining job portal gratuity calculation City-India-Buldana Country-India
Bonus-calculati on-excel-sheet. xls
