Gratuity Calculator

Gratuity is a statutory benefit paid by employers to employees who have rendered continuous service for at least 5 years. It is governed by the Payment of Gratuity Act, 1972.

Eligibility Criteria:

• Minimum Service: You must complete 5 continuous years of service with the same organization.
• Exceptions to 5-Year Rule:
• Death or Disablement: Gratuity is payable even if service is less than 5 years.
• Contract Employees: Eligible if the contract specifies gratuity.
• Applicability: Applies to factories, mines, oilfields, plantations, ports, railway companies, shops, or other establishments with 10 or more employees.

For employees covered under the Payment of Gratuity Act, the calculation is standardized.

Formula:

Gratuity = (Last Drawn Salary × 15 × Years of Service) / 26

Components:

• Last Drawn Salary: Basic Pay + Dearness Allowance (DA).
• 15: Represents 15 days' wages for every completed year.
• 26: Number of working days in a month.
• Years of Service: Rounded off to the nearest year (e.g., 5 years 7 months = 6 years; 5 years 4 months = 5 years).

Example:

Salary = $50,000, Service = 10 Years

Gratuity = (50,000 × 15 × 10) / 26 = $2,88,461

If your organization is not covered under the Gratuity Act (e.g., <10 employees), but the employer chooses to pay gratuity, the formula differs slightly.

Formula:

Gratuity = (Last Drawn Salary × 15 × Years of Service) / 30

Key Differences:

• 30 Days: Working days are considered 30 instead of 26.
• No Rounding Off: Years of service are not rounded up. Only completed years are considered (e.g., 10 years 11 months = 10 years).

The tax treatment of gratuity depends on the type of employee:

1. Government Employees:

• Gratuity received by employees of Central/State Govt and Local Authorities is 100% Tax-Free u/s 10(10)(i).

2. Private Employees (Covered by Act):

• Least of the following is exempt u/s 10(10)(ii):

1. Actual Gratuity Received
2. $20 Lakhs (Lifetime Limit)
3. (15/26) × Last Salary × Years of Service

3. Private Employees (Not Covered by Act):

• Least of the following is exempt u/s 10(10)(iii):

1. Actual Gratuity Received
2. $20 Lakhs
3. (15/30) × Last Salary × Years of Service

In the unfortunate event of an employee's death, gratuity is paid to the nominee/legal heir. The 5-year service rule is waived off.

Calculation based on Service Tenure:

• Less than 1 year: 2 × Basic Pay
• 1 to 5 years: 6 × Basic Pay
• 5 to 11 years: 12 × Basic Pay
• 11 to 20 years: 20 × Basic Pay
• 20+ years: Half of Basic Pay for every completed 6-month period (Max 33 × Basic Pay)

Note: This specific slab applies to Central Govt employees; private sector rules may vary but typically follow the standard formula or better.

Many employees confuse Gratuity with PF and Pension. Here is a quick comparison:

| Feature | Gratuity | Provident Fund (EPF) | Pension (EPS) |

| :--- | :--- | :--- | :--- |

| Purpose | Reward for long service | Retirement savings | Post-retirement income |

| Contribution | Employer only | Employer + Employee | Employer (part of PF) |

| Eligibility | 5 Years continuous service | From day 1 of joining | 10 Years service |

| Payment | Lump sum on exit | Lump sum on exit/retirement | Monthly after age 58 |

| Taxability | Tax-free up to $20 Lakhs | Tax-free (if >5 yrs service) | Fully Taxable |

| Withdrawable? | No (only on exit) | Partial withdrawal allowed | No (only monthly) |

Step-by-Step Guide:

1. Identify Last Drawn Salary: Add Basic Pay + DA. (Exclude HRA, Special Allowances).
2. Determine Tenure: Round off years if covered by Act (e.g., >6 months counts as 1 year).
3. Apply Formula:

• Covered: (Salary × 15 × Years) / 26
• Not Covered: (Salary × 15 × Years) / 30

1. Check Tax Limit: Compare with $20 Lakhs exemption limit.

Example:

• Basic+DA: $80,000
• Service: 7 Years
• Covered by Act: Yes

Calculation: (80,000 × 15 × 7) / 26 = $3,23,076

You can easily create a gratuity calculator in Excel using simple formulas.

Scenario 1: Covered by Gratuity Act

Formula: `=(Last_Drawn_Salary 15 Years_of_Service) / 26`

• Last_Drawn_Salary: Cell A1 (e.g., 50000)
• Years_of_Service: Cell A2 (e.g., 10)
• Excel Formula: `=(A115A2)/26`

Scenario 2: Not Covered by Gratuity Act

Formula: `=(Last_Drawn_Salary 15 Years_of_Service) / 30`

• Excel Formula: `=(A115A2)/30`

Note: Always remember the maximum tax-free limit is $20 Lakhs.