Gratuity Calculator

Calculate your gratuity as per the Payment of Gratuity Act, 1972

Basic salary + Dearness Allowance (DA). Do not include HRA or other allowances.
Minimum 5 years of continuous service required for gratuity eligibility
Excel courseLearn Excel from beginner to confident userthe Udemy course by Ajay Anand, 7× Microsoft Excel MVPView the course →
Gratuity amount
—
Monthly salary used
—
Years of service
—
Taxable amount
—
Max tax-free limit
₹20 Lakh
—

About Gratuity

What is gratuity?

Gratuity is a lump sum amount paid by an employer to an employee as a token of appreciation for the services rendered. It is governed by the Payment of Gratuity Act, 1972 and is mandatory for organisations with 10 or more employees.

Formula for gratuity

For covered employees: Gratuity = (Last salary × 15 × Years of service) ÷ 26. The factor 15 represents 15 days per year, and 26 represents the number of working days in a month.

Is gratuity taxable?

Gratuity received by government employees is fully tax-exempt. For private sector employees covered under the Act, gratuity up to ₹20 lakh is tax-free. Any amount above ₹20 lakh is taxable as income.

Free tutorialsFree Excel tips & tutorials at XLnCADstep-by-step guides by a 7× Microsoft Excel MVPVisit xlncad.com →

Master Excel & Google Sheets

These calculators give you quick answers — but building them yourself in a spreadsheet is a real superpower. Learn Excel from the basics to confident, everyday use in my top-rated Udemy course.

Start the Excel course →