In Excel, if you have a deduction row (e.g., laptop damage), add a called "Approval Ref No." and enter the employee’s signed acknowledgment reference.
Note: Excel lacks native number-to-words. Use this for Google Sheets: =TEXT(B25, "0") & " Only" (or install Num2Words add-in). full and final settlement letter format in excel
| Feature | Word Document | Excel Spreadsheet | | :--- | :--- | :--- | | | Manual (error-prone) | Automatic (formulas) | | Tax Computation | External calculator needed | Built-in formulas | | Deduction Tracking | Static table | Dynamic drop-downs | | Audit Trail | Hard to trace changes | Version history & cell tracking | | Bulk Processing | One-off letters | Template for multiple employees | In Excel, if you have a deduction row (e
| Particulars | Amount (₹) | Remarks | |-------------|------------|---------| | | | | | Pro-rata salary for last month | =Sheet1!B9 | | | Leave encashment | =Sheet1!B12 | 10 days | | Bonus/Incentive | =Sheet1!B13 | | | Gratuity | =Sheet1!B14 | | | Reimbursements | =Sheet1!B15 | | | Subtotal Earnings | =Sheet1!B16 | | | B. Deductions | | | | TDS | =Sheet1!B19 | | | Notice pay recovery | =Sheet1!B20 | | | Loan/Advance recovery | =Sheet1!B21 | | | Subtotal Deductions | =Sheet1!B23 | | | C. Net Payable | =Sheet1!B24 | | | Amount in words | | Rupees ________________ only | | Feature | Word Document | Excel Spreadsheet
A legally sound settlement letter should include:
This settlement is accepted voluntarily and in full satisfaction of all claims.