Download Gratuity Calculator Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

Monthly Budget

What is the Monthly Budget for Project? The monthly budget is known as the fund …

Read More

3 year Calendar

Our new 3-year calendar are great for planning. They let you print multiple years on …

Read More

Independent Contractor Profit And Loss

Working as an independent contractor Profit and Loss Statement, I’ve used variety of accounting solutions …

Read More

AA Attendance Sheet

Recording the attendance of Alcoholics Anonymous (AA) meetings has found many benefits, including tracking milestones, …

Read More
Generic filters

Gratuity Calculator Template in Excel easily calculate your gratuity amount as per the Gratuity Act 1972 in India.

Gratuity Calculator with predefine formulas helps you calculate the end of service amount also known as Gratuity.

All you need to do is to enter your last drawn salary and the total years of service and it will automatically calculate your gratuity amount.

What is Gratuity?

Gratuity is end of service benefits provided by an employer to the employee for the service rendered to the organization.

An employee is entitled to gratuity when he/she:

  • Resigns
  • Retires
  • Laid off
  • Death or Disablement

Eligibility Criteria For Gratuity

According to the Gratuity Act, an employee is paid gratuity if he/she completes a minimum service of 5 years in that particular company.

Furthermore, in case of death or disablement, there is no minimum eligibility period. Disablement means loss of the earning capacity of an employee. It is of two types; temporary disablement & permanent disablement.

Gratuity Rule For Terminated Employees

The employer can cancel gratuity payment of employee even though he/she has completed 5 or more years only if the following conditions:

“An employee facing termination due to disorderly conduct. Disorderly conduct mainly includes physically harming individuals during employment.”

Gratuity Payment Process

The gratuity payment process involves following 4 step process:

  • Apply
  • Acknowledgment
  • Calculation
  • Disbursement

Thus, the eligible employee must send an application to the employer to process his gratuity payment. The employer then accept the application.

Furthermore, the employer initiates calculation process and sends it to the concerned department for disbursement. Finally, the concerned department disburses the Gratuity to the employee.

Gratuity Calculation Formula

The formula to calculate Gratuity is as follows:

Last Drawn Salary X Total Years of Service X 15/26

Last Drawn Salary: Basic Salary + Dearness Allowance (DA)

Total Years of Service: Number of years of service in a company. The mathematical rule of point will apply here in calculating years.

End of service calculator

The template consists of 2 sections: Employee Information and Employee Gratuity Calculations

Employee Information Section

In this section, you need to enter name and your organization type. It can be government organization or a non-government organization.

Gratuity Calculation Chart

To calculate gratuity, you need to enter 2 main details: Last drawn salary and Total years of service. Applying the above-mention formula, the template calculates the gratuity for the given years of service.

The last drawn salary will not be a total take-home salary. It is only the basic salary in addition to dearness allowance.

Download Gratuity Calculator Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Gratuity Calculator Excel Template

Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: