Add rows under Earnings: PF employer contribution (if returning to employee), gratuity formula = (Last drawn salary * 15/26 * years of service).
An effective Excel-based settlement template typically consists of two parts: a data entry/calculation sheet and a printable letter format. 1. Header & Employee Information Company Details : [Company Name], Logo, and Office Address. Employee Profile full and final settlement letter format in excel
| Formula | Purpose | |---------|---------| | =ROUND((Monthly Salary/30)*Days Worked,0) | Pro-rata salary | | =(Basic Salary/30)*Leave Balance | Leave encashment | | =IF(LastWorkingDate-DateOfJoining>=1825, GratuityEligible, 0) | Gratuity eligibility (5 years) | | =VLOOKUP(NetAmount, WordsTable, 2, 0) | Convert amount to words (needs helper table) | Add rows under Earnings: PF employer contribution (if
Do not treat settlement as a goodbye—treat it as a final professional handshake, documented in rows and columns. Header & Employee Information Company Details : [Company