• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Taxable Gratuity Calculator Excel Template

Download Taxable Gratuity Calculator Excel Template

Taxable Gratuity Calculator Excel Template is a simple and ready-to-use excel template to the amount of gratuity that is taxable under the Indian Income Tax Act.

Income tax applicability differs from according to the companies falling/not falling under the Gratuity Act 1972 and also the type of company (Government or non-government).

An employee is entitled to get gratuity when he/she:

  • Resigns
  • Retires
  • Laid off
  • Death or Disablement

An employee is entitled to gratuity if he/she completes a minimum service of 5 years with that particular employer. There is no minimum eligibility period in the case of death or disablement.

Taxable Gratuity Calculator Excel Template

We have created the Taxable Gratuity Calculator excel template with predefined formulas to easily calculate your taxable gratuity.

Click here to download the Taxable Gratuity Calculator Excel Template.

Taxable Gratuity Calculator

Download other useful templates like Financial Statement Templates: Balance sheet, Profit & Loss Account, Bank Reconciliation, etc.

Let us discuss how to use this calculator to calculate gratuity.

How To Use Taxable Gratuity Calculator?

There are 3 different criteria to calculate taxable gratuity for any employee depending on his company and Gratuity Act applicability:

  1. Employees Falling under the Gratuity Act 1972
  2. Employees not falling under the Gratuity Act 1972
  3. State/Central Government Employees

Every employee is entitled to gratuity who is working in any company which has 10 or more employees on any day in the preceding 12 months.

Once the Gratuity Act is applicable to the company, even if the number of decreases below 10, the company falls under the Gratuity Act.

1. Employees Falling Under The Gratuity Act 1972

For employees falling under this category, least of the following is exempt from the income tax [Gratuity Act 1972, Section 10(10)(ii)]:

  • Last drawn salary (basic + DA) X Years of Service X 15/26
  • Rs. 20 lakhs (Earlier it was Rs. 10 Lakh)
  • Gratuity Actually received.

Taxable Gratuity Calculator Excel Template 1

In this section, you need to enter your name, years of service and last drawn salary (that is Basic + DA). The template will automatically calculate the taxable gratuity for you.

2. Employees Not Falling Under The Gratuity Act 1972

Employees falling under this category, least of the following is exempt from the income tax [Gratuity Act 1972, Section 10(10)(ii)]:

  • Last 10 month’s average salary (basic + DA)* number of years of employment* 1/2.
  • Rs. 10 lakhs (the hike of Rs 20 lakhs is not applicable for these employees).
  • Gratuity actually received.

Taxable Gratuity Calculator

Similar to the above section, enter the name, sum of 10 months salary (that is Basic + DA) and. It will automatically calculate the taxable gratuity for you.

3. State/Central Government Employees

Gratuity paid by the government to government employees is fully exempt from tax. Gratuity received by state or central government employees [under Section 10(10)(i) of Gratuity Act 1972] on death-cum-retirement is completely exempt. Employees of the statutory corporation will not fall under this category.

Taxable Gratuity Calculator

Last drawn salary will not be total take home salary. It is only the basic salary in addition to the dearness allowance.

If your years of service are less than 5 years the gratuity calculator will display NIL.

Disclaimer: This template has been created for educational purpose. Kindly consult any tax consultant before finalizing the gratuity amount. 

We thank our readers for liking, sharing and following us on various social media platforms.

If you have any queries or suggestions, please share in the comment section below. We will be more than happy to assist you.

« Download Gratuity Calculator (India) Excel Template
Download Employee Training Log Excel Template »

Filed Under: HR Templates

You are Here: Home / Excel Templates / HR Templates / Download Taxable Gratuity Calculator Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

HR Templates

  • Salary Sheet Excel Template
  • Daily Work Schedule Excel Template
  • Weekly Timesheet Excel Template
  • Corporate Salary Slip Excel Template
  • Employee Attendance Sheet Excel Template
  • Employee Performance Evaluation Excel Template
  • Employee Provident Fund Calculator Excel Template
  • Job Candidate Tracker Excel Template
  • Employee Resignation Schedule Excel Template
  • Employee TA Reimbursement Excel Template
  • Employee Contract Renewal Schedule Excel Template
  • Employee Overtime Calculator Excel Template
  • Simple Age Calculator Excel Template
  • Employee Mileage Log Excel Template
  • Multiple Employees Weekly Timesheet Excel Template
  • 9 Ready-To-Use Salary Slip Excel Templates
  • Salary Sheet With Attendance Register In Single Excel Template
  • Weekly Timesheet With Payslip Excel Template
  • Salary Breakup Report Excel Template
  • Gratuity Calculator (India) Excel Template
  • Taxable Gratuity Calculator Excel Template
  • Employee Training Log Excel Template
  • Employee Vacation Tracker Excel Template
  • Salary Arrears Calculator Excel Template
  • Resume/Cover Letter Excel Template
  • Professional Resignation Letter Excel Template
  • Employee Termination Letter Excel Template
  • Employee Promotion Letter Excel Template
  • Salary Certificate Format Excel Template
  • Absconding Letter Excel Template
  • Employee Disciplinary Memo Excel Template
  • Casual Leave Application Excel Template
  • Employee Transfer Letter Excel Template
  • Employee Show Cause Notice Excel Template
  • Promotion Request Letter Excel Template
  • Transfer Request Letter Excel Template
  • Job Rejection Letter Excel Template
  • Promotion Rejection Letter Excel Template
  • Transfer Refusal Letter Excel Template
  • Transfer Rejection Letter Excel Template
  • Employee Welcome Letter Excel Template
  • Employee Thank You Letter Excel Template
  • Layoff Notice Letter Excel Template
  • Employment Verification Letter Excel Template
  • Job Offer Letter Excel Template
  • Accommodation Request Letter Excel Template
  • Loan Application Letter Excel Template
  • Workplace Harassment Complaint Letter Excel Template
  • Internship Request Letter Excel Template
  • Additional Facility Request Letter Excel Template
  • Salary Increment Request Letter Excel Template
  • Employee Of The Month Certificate Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT