Gratuity Calculation Formula & Sheet
Years of service, last drawn pay, and the figure that comes out.
Details
gratuity calculation formulaUploads
Your logo
A photo or picture
Goes on this page only. Drag it anywhere and pull its corner to resize it.
Your signature
Draw it with a finger, a mouse or a trackpad, and it goes on the page like a picture.
Pictures and signatures stay on this device. Nothing is uploaded to a server.
Red highlights mark what is still blank. Click anything on the page to change it. Your draft is kept on this device as you work.
| Name | [name] |
| Designation | [designation] |
| Date of joining | [date] |
| Date of leaving | [date] |
| Reason | [reason] |
| Continuous service | — |
| Last drawn basic + DA | ₹ [amount] |
Working
Last drawn basic and dearness allowance × 15 ÷ 26 × completed years of service. A part-year of six months or more counts as a full year.
[enter joining date, leaving date and last drawn basic + DA to calculate]
What is a Gratuity Calculation?
A gratuity calculation sheet works out the lump sum payable to an employee at the end of long service: the qualifying years, the last drawn wage, the formula applied, and the amount after any statutory maximum. It is what finance pays from, what the employee checks, and what an inspector or auditor asks to see. Without it, a leaving payment rests on an unrecorded calculation nobody can repeat.
HR and payroll teams prepare one for each employee leaving with qualifying service — on resignation, retirement, redundancy, death or disablement — and finance uses the same method to value the liability sitting in the balance sheet. Employees ask for it when the figure paid does not match what they expected. It also matters at hiring and at appraisal, because gratuity accrues against last drawn wages, so a large final-year increase changes the whole liability, not only the last year of it.
Gratuity as a legal entitlement is jurisdiction-specific. India's Payment of Gratuity Act sets a qualifying period of continuous service, a formula based on last drawn wages and completed years, and a statutory maximum that has been raised by amendment more than once — check the current figures and the current wage definition before calculating. Several Gulf states operate an end-of-service benefit on a different formula, sometimes varying with whether the employee resigned. The UK, the US, Canada and Australia have no equivalent statutory gratuity; long service leave and redundancy pay are different entitlements with their own rules.
The sheet computes a figure; it does not decide entitlement. Whether service was continuous, whether a break counts, whether an establishment is covered, and whether gratuity can be forfeited for misconduct are questions for the statute and, if disputed, for the controlling authority — not for a spreadsheet. It is not a full and final settlement statement, which also covers notice, leave encashment, dues and recoveries. And it is not tax advice: exemption limits for gratuity differ by country and by whether the employee is covered by the relevant Act.
What to put in a Gratuity Calculation
These are the details this template asks for. Anything left blank is marked in red on the preview so you can see what is still missing.
| Field | What goes in it |
|---|---|
| Issuing organisation | For example: Maple Grove Homeowners Association |
| Organisation address | For example: 1420 Kinnear Road, Columbus, OH 43212 |
| Issued to (full name) | For example: James Whitfield |
| Designation | For example: Senior Assistant |
| Date of joining | Free text |
| Date of leaving | Free text |
| Last drawn basic + DA (monthly) | For example: 38,400 |
| Reason for cessation | Free text |
How to write a Gratuity Calculation
Establish continuous service in years
Record the date of joining and the last working day, then compute completed years of continuous service under the applicable rule, noting how part-years and breaks are treated — some schemes round a part-year above a threshold up to a full year, others do not. Flag any period of unpaid leave, transfer between group entities, or break in service, because those are what turn a simple calculation into a dispute.
Identify the correct last drawn wage
Use the wage definition the applicable rule specifies, not gross salary. Under a statutory scheme this is typically a narrow base such as basic plus dearness allowance, excluding allowances, overtime, bonus and reimbursements. Show the components you included and excluded on the face of the sheet. Where the employee's pay changed in the final months, record which month's figure you have taken and why.
Apply the scheme formula transparently
Set out the formula in the sheet rather than burying it in a cell: the wage base, the number of days of wages allowed for each completed year, the divisor the scheme uses to convert a monthly wage, and the years counted. Showing each element separately lets a reviewer or the employee recompute the result. Different schemes use different day counts and divisors, so name the one you are applying. In India, the Payment of Gratuity Act, 1972 gives a monthly-paid employee: last drawn wage × 15 × completed years of service ÷ 26.
Apply any maximum and note the tax
Cap the result at the statutory or scheme maximum where one applies, and show the uncapped figure alongside so the reduction is visible. Then note the tax treatment separately — many systems exempt gratuity up to a limit that depends on coverage and on the individual's circumstances. Do not fold tax into the gratuity figure; record it as its own line for payroll to apply.
Get it approved and pay on time
Have the sheet checked by someone other than the preparer, attach it to the settlement file with the service record and the wage evidence, and record the payment date. Where the applicable law sets a deadline for payment after the last working day, and often interest for late payment, diarise it. Give the employee a copy of the calculation, not just the final amount.
Common mistakes
- Calculating on gross salary instead of the narrower statutory wage base, which overstates the payment and, once made, becomes the figure every future leaver expects.
- Counting a resignation and a rehire as unbroken service without checking how the applicable rule treats the gap, producing a payment the employer cannot justify to an auditor.
- Using an outdated statutory maximum copied from an old sheet, so every calculation is wrong the moment the ceiling is amended.
- Paying after the statutory deadline where one applies, which can attract interest and turn an administrative delay into a claim before the controlling authority.
- Giving the employee only the final number with no working, which guarantees a dispute the moment they compare it with an online calculator using a different wage base.
Frequently asked questions
What is the gratuity calculation formula?
In India, the Payment of Gratuity Act, 1972 sets gratuity at 15 days' wages for each completed year of service, counting a final part-year of more than six months as a full year. For a monthly-paid employee that works out as: last drawn wage × 15 × years of service ÷ 26, where the wage is usually basic pay plus dearness allowance. Example: a last drawn wage of 40,000 and 10 years of service gives 40,000 × 15 × 10 ÷ 26 = 2,30,769. The Act also sets a qualifying period and a maximum amount, and the Code on Social Security, 2020 carries these rules forward — check the current text and notifications for the wage definition and the ceiling before you pay. Other countries use different days, divisors and wage bases, so use the formula in the statute that governs the employment.
How many years of service are needed for gratuity?
A qualifying period of continuous service is standard, with exceptions where employment ends because of death or disablement. The length, and the definition of continuous service, are set by the applicable statute, and how part-years and breaks count has been the subject of litigation. Check the current provision, and where service is broken or spans group companies, take advice before deciding.
Is gratuity taxable?
It depends on the country, on whether the employee is covered by the relevant statute, and often on a lifetime exemption limit that applies across employers. Some systems exempt it up to a cap and tax the balance as employment income. Do not assume the whole amount is exempt. Check your revenue authority's current guidance or ask an accountant before deciding what to withhold.
Can an employer withhold gratuity?
Only on the narrow grounds the applicable law allows, which typically involve termination for specified misconduct causing loss or damage, and often only to the extent of that loss. Withholding for unreturned property, notice shortfalls or ordinary performance issues is not generally permitted. Where you think forfeiture applies, have it reviewed before acting, because the procedure matters as much as the ground.
Does gratuity apply if the employee resigns?
Under India's Act, resignation after the qualifying period generally does not remove the entitlement — gratuity is payable on resignation, retirement, death and disablement alike. Some other end-of-service schemes, including in parts of the Gulf, reduce or vary the benefit where the employee resigns rather than being dismissed. Check which scheme governs the employment before answering for a specific person.
This page explains general practice and is not legal advice. Requirements differ between countries and, in some cases, between states — check what applies where the document will be used.