I prepared one excel sheet in excel to calculate Gratuity. Kindly let me know if any correction is needed.
From India, Buldana
Acknowledge(10)
Amend(0)
65From India, Buldana
Acknowledge(10)+5 more
Amend(0)
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
Acknowledge(3)
Amend(0)
From India, Ludhiana
Acknowledge(3)Amend(0)
Dear Vivek Sang, thank you for your advice. Actually, when I try to calculate this formula, the payable amount is not calculated correctly. That's why I need an example. Please help me if you can.
Regards,
Manpreet
From India, Ludhiana
Acknowledge(0)Amend(0)
Regards,
Manpreet
From India, Ludhiana
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Buldana
Acknowledge(0)Amend(0)
Gratuity Calculation Explained
For gratuity, the minimum period of service is 4 years and 8 months. Suppose an employee has completed 5 years of service; then he is entitled to 15 days of the average salary last drawn by the employee per completed year. In a month, there are 26 working days. Hence, the average 15 days' salary for 5 completed years will be (15/26) * 5 years.
Salary here means Basic + Dearness Allowance, and that too, the last salary drawn by the employee. If the employee's basic salary is 4000 and the Dearness Allowance is 3000, then the complete formula for gratuity will be 7000 * (15/26) * 5. Hope it's clear to all.
From India, Buldana
Acknowledge(2)
Amend(0)
For gratuity, the minimum period of service is 4 years and 8 months. Suppose an employee has completed 5 years of service; then he is entitled to 15 days of the average salary last drawn by the employee per completed year. In a month, there are 26 working days. Hence, the average 15 days' salary for 5 completed years will be (15/26) * 5 years.
Salary here means Basic + Dearness Allowance, and that too, the last salary drawn by the employee. If the employee's basic salary is 4000 and the Dearness Allowance is 3000, then the complete formula for gratuity will be 7000 * (15/26) * 5. Hope it's clear to all.
From India, Buldana
Acknowledge(2)Amend(0)
I am Ganesh from Hyderabad. Nice to meet you in this forum. The gratuity calculation is: Basic x No. of years of service x 15 / 26
For example: If a person worked for 6 years and their basic salary is Rs. 10,000/-, then the gratuity amount would be Rs. 10,000/- x 6 x 15 / 26 = Rs. 34,615/-. Here, 15 represents half-month salary, and 26 represents the total number of days in a month (accounting for weekends and holidays).
If you have any queries, please feel free to contact me at [Phone Number Removed For Privacy Reasons].
Regards,
PGR
From India, Hyderabad
Acknowledge(2)
Amend(0)
For example: If a person worked for 6 years and their basic salary is Rs. 10,000/-, then the gratuity amount would be Rs. 10,000/- x 6 x 15 / 26 = Rs. 34,615/-. Here, 15 represents half-month salary, and 26 represents the total number of days in a month (accounting for weekends and holidays).
If you have any queries, please feel free to contact me at [Phone Number Removed For Privacy Reasons].
Regards,
PGR
From India, Hyderabad
Acknowledge(2)Amend(0)
Updated the file. Please check and let me know in case of error. Vivek Sang
From India, Buldana
Acknowledge(1)
Amend(0)
From India, Buldana
Acknowledge(1)Amend(0)
New Updated Gratuity Calculation Utility in Excel. Please let know your reviews regarding the same.
From India, Buldana
Acknowledge(2)
Amend(0)
From India, Buldana
Acknowledge(2)Amend(0)
Am I eligible for gratuity? If yes, please let me know the detailed calculation. How much will I receive in the form of gratuity?
My present Basic + DA is $18,500 per month.
Help me please, it's an urgent matter.
Regards,
Prashant
From India, Mumbai
Acknowledge(0)Amend(0)
My present Basic + DA is $18,500 per month.
Help me please, it's an urgent matter.
Regards,
Prashant
From India, Mumbai
Acknowledge(0)Amend(0)
First of all, thank you for the Excel sheet. You have mentioned that if an employee completes 4 years and 8 months in a company, then he/she is eligible for gratuity. So, if an employee completes 4 years and 9 months in a company, how will the gratuity be calculated? I tried using the Excel sheet, but no value is shown in this case. Do I need to consider it as completing 5 years?
Regards,
Sarita
From India, Mumbai
Acknowledge(0)Amend(0)
Regards,
Sarita
From India, Mumbai
Acknowledge(0)Amend(0)
In BPOs - the monthly working days are 22 as there is weekly off for Saturday also. So in that case will it be counted as 15/22 or still the formula of 15/26 will be applied? Thanks Sarath
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee excel sheet.xls