betterjobs

Free template template · Word

Final Salary Settlement Sheet

A final salary settlement sheet is a payroll working sheet that calculates the last month's pay component by component for a leaving employee. It works out payable days, loss of pay, prorated earnings and statutory deductions, and feeds those numbers into the full and final settlement statement.

  • Editable Word (.docx)
  • Made for India
  • 11 fill-in fields highlighted
  • Free, no sign-up

Preview of the template

[Highlighted] = fill in
[Company Logo][Company Name]

FINAL SALARY SETTLEMENT SHEET

Employee:
[Employee Name] ([Employee ID])
Salary Month:
[Month YYYY]
Last Working Day:
[Last Working Day]

1. Attendance

Calendar DaysDays up to LWDPaid LeaveLOP DaysPayable Days
[Number][Number][Number][Number][Number]

2. Earnings

ComponentMonthly Rate (₹)Payable DaysProrated Amount (₹)
Basic + DA[Basic Salary][Number][Amount]
HRA[HRA][Number][Amount]
Special allowance[Amount][Number][Amount]
Shift / night allowance[Amount][Number][Amount]
Overtime / arrears--[Amount]
Gross earnings[Amount]

3. Exit-specific Items

ItemDaysPer-day Rate (₹)Amount (₹)
Leave encashment[Number][Amount][Amount]
Notice shortfall recovery[Number][Amount]([Amount])
Notice pay (employer-initiated)[Number][Amount][Amount]

4. Deductions

DeductionBasisAmount (₹)
Employee PF12% of PF wages[Amount]
Employee ESI (if covered)0.75% of gross[Amount]
Professional taxState slab[Amount]
Labour welfare fund (if applicable)State rule[Amount]
TDSAnnual recomputation[Amount]
Total deductions[Amount]

5. Net Final Salary

ParticularsAmount (₹)
Gross earnings + exit items[Amount]
Less: total deductions[Amount]
Net final salary (carried to F&F)[Amount]
Prepared by
[Payroll Executive]
Date: [Date]
Checked by
[HR Name]
Date: [Date]

What this template includes

  • Attendance summary: calendar days, days worked, LOP, paid leave
  • Component-wise monthly rate and prorated earnings
  • Allowances and arrears for the final month
  • Statutory deductions: PF, ESI, professional tax, labour welfare fund where applicable
  • Leave encashment and notice recovery per-day computations
  • Net final salary carried to F&F

When to use it

  • Payroll is processing a leaver's final month salary
  • The employee left mid-month and earnings must be prorated
  • There are loss-of-pay days, arrears or shift allowances to adjust
  • You want a working sheet behind the F&F summary

How to customise this template

  1. 1Replace components with your salary structure (for example special allowance, conveyance)
  2. 2Apply your payroll's per-day rule consistently
  3. 3Add shift, night or overtime allowances for operations staff
  4. 4Link the net to the F&F statement

HR tips

  • Use the attendance cut-off date of the last working day, not the payroll cycle date
  • Check ESI applicability against the gross wage ceiling
  • Recompute TDS for the year on exit
  • Get the sheet checked by a second person

For HR & hiring managers

Hire top talent from BetterJobs

Experienced and fresher candidates across India — blue, grey and white collar. Post a job in 5 minutes and start receiving applications.

  • Post in 5 minutesDescribe the role in one line — we write the job description.
  • Verified applicantsEvery applicant has a verified mobile number.
  • Resume databaseSearch experienced candidates by skill, city and experience.

Frequently asked questions

How is final month salary calculated when an employee leaves mid-month?+

Each salary component is prorated for payable days, usually monthly rate divided by days in the month or the company's fixed divisor, multiplied by days paid.

Are PF and ESI deducted from the final salary?+

Yes, PF is deducted at 12% of PF wages and, where the employee is covered, ESI at 0.75% of gross wages for the final month.

What is the difference between this sheet and the F&F statement?+

This sheet is the detailed payroll working for the last month. The F&F statement is the overall summary including gratuity, bonus, recoveries and net payable.