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)
Updated the file. Please check and let me know in case of error. Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)
From India, Buldana
Acknowledge(0)Amend(0)
Dear Sir, i got everything about gratuity. Thankyou for your great help. I need ur help regarding Job portal(naukri.com). If possible then pls help me. thanks & Regards, Shweta
From India, Noida
Acknowledge(0)Amend(0)
From India, Noida
Acknowledge(0)Amend(0)
Dear Shweta, Wht type of help you require in job portel? pls describe in details. Regards, Vivek
From India, Ahmadabad
Acknowledge(0)Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)
New Updated Gratuity Calculation Utility in Excel. Please let know your reviews regarding the same.
From India, Buldana
Acknowledge(0)Amend(0)
From India, Buldana
Acknowledge(0)Amend(0)
Why we use boolean search on naukri, waht is the use of that. There r many specific search. Pls tell me the by making comparision with other search?
From India, Noida
Acknowledge(0)Amend(0)
From India, Noida
Acknowledge(0)Amend(0)
Dear friends,
I worked in an organization for exactly 4 years and 6 months. Am I applicable 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.
Prashant
From India, Mumbai
Acknowledge(0)Amend(0)
I worked in an organization for exactly 4 years and 6 months. Am I applicable 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.
Prashant
From India, Mumbai
Acknowledge(0)Amend(0)
Hello Vivek,
First of all, thank you for the excel sheet. You have mentioned that if an employee completes 4 years & 8 months in a company, then he/she is eligible for gratuity. So, if an employee completes 4 years & 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)
First of all, thank you for the excel sheet. You have mentioned that if an employee completes 4 years & 8 months in a company, then he/she is eligible for gratuity. So, if an employee completes 4 years & 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)
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)
The basic rule of 26 days should apply, if that is the rule. However, cross check with HR. :)
From India, Kolkata
Acknowledge(0)Amend(0)
From India, Kolkata
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.
Employee excel sheet.xls