I prepared one excel sheet in excel to calculate Gratuity. Kindly let me know if any correction is needed.
From India, Buldana
Acknowledge(0)
Amend(0)
65From India, Buldana
Acknowledge(0)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(0)Amend(0)
From India, Ludhiana
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Buldana
Acknowledge(0)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)
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)
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)
i got the formula but still i am not getting the idea of 15/26 days.
From India, Noida
Acknowledge(0)Amend(0)
From India, Noida
Acknowledge(0)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 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 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(0)Amend(0)
From India, Buldana
Acknowledge(0)Amend(0)
Hi Swetha,
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 his 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 9490448544.
Regards,
PGR
From India, Hyderabad
Acknowledge(0)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 his 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 9490448544.
Regards,
PGR
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Vivek, Pls check it your excel sheet not work proper. Regards, Vivek
From India, Ahmadabad
Acknowledge(0)Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.