Excel template · HR & payroll

Full and Final Settlement Format in Excel (F&F Calculator)

Enter the exit details, monthly pay, notice terms, leave balance and recoveries. The calculator works out the last month's salary, notice pay or recovery, leave encashment, bonus, gratuity, PF, ESI, PT and TDS, and the net amount – with the two-working-day payment deadline under the Code on Wages.

For: HR and accounts teams settling dues of employees who resign, retire or are let go.

Free download · no sign-up · no macros · Excel 2010+, Google Sheets, LibreOffice

Preview of the Full & Final Settlement Calculator Excel template with sample data
Main sheet with sample data

At a glance

What it is
Full & Final Settlement Calculator — an Excel workbook for Indian employers, HR and payroll teams
Free edition
3 sheets (Guide, Inputs, Settlement) — free download, no sign-up
Pro edition
5 sheets, adds F&F Statement and Exit Checklist — ₹19 one-time (regular ₹99)
Works in
Microsoft Excel 2010 or later, Google Sheets, LibreOffice Calc — no macros
Checked
Recalculated with zero formula errors; sample data and a Guide sheet included
Made by
Prakash Bagchi, finance professional, PB Lab (Raipur, India)

Free vs Pro: what you get

SheetFreePro
Guide
What it does, how to use it, assumptions and a live status check
Inputs
Exit details, monthly pay, notice terms, leave balance, bonus, statutory deductions and recoveries
Settlement
Working, earnings, deductions, net payable or recoverable, payment deadlines and checks
F&F Statement
Print-ready settlement statement with signature lines for HR, approver and employee
—
Exit Checklist
15 exit steps with owners, target dates from the last working day and a completion %
—

Pro edition

Get Full & Final Settlement Calculator – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • F&F Statement — Print-ready settlement statement with signature lines for HR, approver and employee
  • Exit Checklist — 15 exit steps with owners, target dates from the last working day and a completion %
  • One-time payment, instant .xlsx download, free updates
+91

Secure payment by Razorpay · UPI, cards, netbanking & wallets

We use your details only to deliver the file and support your purchase. See our privacy policy and terms.

Need more than one? The HR & Payroll Kit has all 9 hr & payroll Pro templates, including this one, for ₹134.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2On Inputs, enter the employee, resignation and last working dates, reason for leaving and monthly pay.
  3. 3Add the notice terms, earned-leave balance, bonus, reimbursements, deductions and recoveries.
  4. 4Check the working and the net amount on the Settlement sheet.
  5. 5Pay the settlement within two working days, and gratuity within 30 days.

What full and final settlement covers

Full and final (F&F) settlement squares up everything between an employer and an employee who leaves. On the earnings side: salary up to the last working day, notice pay if the employer ends the employment without notice, encashment of unused earned leave, bonus, gratuity if eligible, and pending reimbursements. On the other side: PF, ESI, professional tax and TDS on the final pay, recovery for any notice period not served, outstanding advances or loans, and unreturned company property.

Two working days

Since the labour codes came into force on 21 November 2025, section 17(2) of the Code on Wages, 2019 requires the wages of an employee who is removed, dismissed, retrenched or resigns to be paid within two working days. That is much faster than the 30–45 days many companies were used to, so the settlement has to be prepared before or on the last working day. Gratuity has its own deadline of 30 days.

Notice pay and leave encashment

If an employee resigns and leaves before completing the notice period in their appointment letter, the employer may recover pay for the shortfall – usually on gross pay, sometimes on Basic, divided by 30 – unless the shortfall is waived. If the employer ends the employment without notice, notice pay is payable to the employee instead.

Unused earned leave is encashed on Basic + DA, divided by 30 or 26 according to your policy. Under the labour codes a worker can encash all accumulated leave on leaving, and leave encashment is not treated as an allowance for the 50% wage rule.

Gratuity and tax

Gratuity is payable after five years of continuous service (one year for fixed-term employees, and none on death or disablement), at 15/26 of last drawn Basic + DA for each year, where a part-year over six months counts. Gratuity and leave encashment are partly tax-exempt for private-sector employees, so work out TDS on the settlement separately and enter it in the template.

Keep the working on file

Keep the working with the employee's file. If the settlement is disputed later, a clear statement showing days paid, the leave balance used, the notice shortfall and every recovery is the best evidence that the dues were worked out fairly and paid on time.

Free vs Pro

The free edition works out the full settlement with deadlines and checks. The Pro edition adds a printable F&F statement for signatures and an exit checklist that tracks asset return, access removal, payment, EPFO exit update, relieving letter and Form 130 so nothing falls through the cracks.

Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .

Frequently asked questions

What is the time limit for full and final settlement?

Under section 17(2) of the Code on Wages, 2019, in force from 21 November 2025, wages must be paid within two working days of the employee leaving. Gratuity must be paid within 30 days.

How is leave encashment calculated?

Earned leave balance × monthly Basic + DA ÷ 30 (or 26, per your policy).

Can notice pay be recovered from final settlement?

If the employee resigns and doesn't serve the notice period in their appointment letter, the shortfall can usually be recovered unless waived. Check your contract and policy.

Is PF deducted on leave encashment or gratuity?

No. PF is deducted only on the wages for the last month, not on leave encashment, gratuity or notice pay.

Is gratuity part of full and final settlement?

Yes, if the employee is eligible – usually after five years of service, or one year for fixed-term employees.

What documents should be given after exit?

A relieving letter, experience certificate and the salary TDS certificate (Form 130, earlier Form 16) after the year end, and the exit date should be updated on the EPFO portal. The Pro checklist tracks all of these.

How much does the Pro edition cost and how do I get it?

The Pro edition is ₹19 (regular price ₹99), a one-time payment through Razorpay by UPI, card, netbanking or wallet. You download the .xlsx file right after paying, and the download page works again later if you bookmark it. Pro adds: F&F Statement, Exit Checklist.

Related free calculators

More Excel templates

See all templates →

Disclaimer: This template is a working aid, not legal, tax or accounting advice. Sample data is fictional. Laws, rates and thresholds change — verify them against the current Act, rules and notifications, or with a qualified professional, before relying on the results. PB Lab is not responsible for decisions made using this file.