Hi Friend,
You can write the formula on your own. The Gratuity Rule is calculated as follows: Last Basic/26 Days X 15 Days X Number of working years.
For example, if someone worked for 6 years and their last Basic was 5000 (at the time of their exit), you can calculate as follows: 5000/26 to get the per day amount. Then, multiply the per day amount by 15 days to get the per year amount. After that, multiply the per year amount by 6 years (Number of Years worked) to determine the gratuity liability.
I hope this clears things up for you.
From India, Hyderabad
You can write the formula on your own. The Gratuity Rule is calculated as follows: Last Basic/26 Days X 15 Days X Number of working years.
For example, if someone worked for 6 years and their last Basic was 5000 (at the time of their exit), you can calculate as follows: 5000/26 to get the per day amount. Then, multiply the per day amount by 15 days to get the per year amount. After that, multiply the per year amount by 6 years (Number of Years worked) to determine the gratuity liability.
I hope this clears things up for you.
From India, Hyderabad
As you know these days lot of companies work only 22 days in a month. in this case employee will get more Gratuity. Is the 26 is common for all or will it differ as per company?
From United Kingdom, Otley
From United Kingdom, Otley
Normally, we provide our staff with gratuity of 21 days per year. For example:
Total Salary: 10000 * 12 = 120000
Total Working Days: 455
Total Years: 1.25
Daily Wages: 328.80
Gratuity Calculation: 21 * 328.80 * 1.25 = 8631
From United Arab Emirates, Dubai
Total Salary: 10000 * 12 = 120000
Total Working Days: 455
Total Years: 1.25
Daily Wages: 328.80
Gratuity Calculation: 21 * 328.80 * 1.25 = 8631
From United Arab Emirates, Dubai
Hello there, Attached the Gratuity Working sheet, hope it will be helpful for calculating gratuity for number of employees. Cheers, Nithil
From India, Coimbatore
From India, Coimbatore
hello i have start job for 28/08/2004 and resign 05/01/2014 my monthly salary is 25000 so how many gratuity received me so plz send gratuity calculation. thanking you
From India, Surat
From India, Surat
Hi, If a employee worked for 5y 8months then how to calculate gratuity of the employee please reply me as early as possible
From India, Tiruchi
From India, Tiruchi
Hi Venkat, If Employee worked for 5y 8m then u have to consider 6 years as a no. of completed yrs of services. Formula for Calculation =Last Basic/26 X 15 X 6.
From India , Mumbai
From India , Mumbai
Please clear, how to calculate number of years working for gratuity. Example: If anyone has worked 5.5 years, How many years to be considered and paid? What is exact concept.. Please clear. Regards,
From India, New Delhi
From India, New Delhi
My name is jitendra I am working in company almost 9.8 months how can calculate my gratuity please calculate my gratuity and email me my email id
From India, Nashik
From India, Nashik
My name is jitendra I am working in company almost 9 years 8 months my basic salary is 7200 how can calculate my gratuity please calculate my gratuity and email me my email id
From India, Nashik
From India, Nashik
one of my employee’s date of joining is 02/10/2009 & date of leaving is 31/03/2016. kindly verify the year of gratuity year.
From India, Mumbai
From India, Mumbai
Hi, I have a doubt in the Gratuity formula (Last basic X 15 / 26 X No of years). If 26 represents the number of working days in a month, how should we calculate if an organization has workings of 22 days and salary calculation is for 30 days? Can you provide an example specific to IT/ITES companies?
From India, undefined
From India, undefined
Can someone please share the exact formula with explanations for 1) limited contract and 2) unlimited contract? Also, how is gratuity calculated from probation to 1 year, from 2 to 3 years, and from 3 to 5 years, and so on! This is urgent, please.
From United Kingdom, London
From United Kingdom, London
Can someone assist me, please?
I need to calculate gratuity for our employees, and the criteria are as follows:
- Basic salary * 7 days if years of service is 1 to 3 years
- Basic salary * 14 days if years of service is 3.1 to 4.99 years
- Basic salary * 21 days if years of service is more than 4.99 to 5 years
- Basic salary * 30 days if years of service is more than 5.1 to above
I am looking to implement this calculation using the IF function in Excel.
Thanks
From United Arab Emirates, undefined
I need to calculate gratuity for our employees, and the criteria are as follows:
- Basic salary * 7 days if years of service is 1 to 3 years
- Basic salary * 14 days if years of service is 3.1 to 4.99 years
- Basic salary * 21 days if years of service is more than 4.99 to 5 years
- Basic salary * 30 days if years of service is more than 5.1 to above
I am looking to implement this calculation using the IF function in Excel.
Thanks
From United Arab Emirates, undefined
Hi,
Nowadays, most companies work only 22 days in a month. In this case, employees will receive more Gratuity. Is the 26th common for all companies, or will it differ based on the company?
Please provide clarity on this subject.
From India, Bengaluru
Nowadays, most companies work only 22 days in a month. In this case, employees will receive more Gratuity. Is the 26th common for all companies, or will it differ based on the company?
Please provide clarity on this subject.
From India, Bengaluru
Yeah, but I still don't quite understand how to calculate years of paid work. In slope 3, feel the rhythm of the pulse-pounding soundtrack that amplifies every twist and turn.
From United States
From United States
Many companies only require employees to work 22 days a month. In this case, the employee will receive a higher severance pay from the company. However, this severance allowance does not depend on the company's number of working days in the month but is calculated based on a standard formula.
From Greenland, undefined
From Greenland, undefined
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.
CiteHR.AI
(Fact Checked)-The calculation of gratuity for an employee who has worked for 5 years and 8 months involves considering the total service period as 6 years for gratuity payment. (1 Acknowledge point)