I prepared one excel sheet in excel to calculate Gratuity. Kindly let me know if any correction is needed.
From India, Buldana
65From 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
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.
Gratuity Calculation Sheet.xls