Full And Final Settlement Letter Format In Excel Direct
This settlement is accepted voluntarily and in full satisfaction of all claims. | | | |---|---| | Employee | For [Company Name] | | Signature: ___________ | Signature: ___________ | | Name: =Sheet1!C2 | Name: HR Manager | | Date: =Sheet1!C5 | Date: =Sheet1!C5 | 4. Excel Formulas to Automate Key Calculations | 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) |
| A (Item) | B (Amount) | C (Remarks) | |----------|------------|--------------| | Employee Name | | John Doe | | Employee ID | | EMP001 | | Designation | | Sr. Analyst | | Date of Joining | | 01-Jan-2020 | | Last Working Day | | 15-Mar-2025 | | Total Days in Last Month | 31 | March | | Days Worked in Last Month | 15 | | | Monthly Gross Salary | 60,000 | | | | | | | Unpaid Salary (pro-rata) | =B8*(B7/B6) | Formula | | Leave Encashment (days) | 10 | | | Leave Encashment Amount | =(B8/30)*B11 | | | Bonus/Incentive | 5,000 | | | Gratuity (if eligible) | 25,000 | | | Reimbursements | 2,000 | | | Total Earnings | =SUM(B9,B12,B13,B14,B15) | | | Deductions | | | | TDS (as per form 16) | 3,000 | | | Notice Pay Recovery | 0 | | | Advance/ Loan Recovery | 1,500 | | | Provident Fund adjustment | 0 | | | Total Deductions | =SUM(B19:B22) | | | Net Payable | =B16 - B23 | | | Amount in Words | (manual or formula) | | Tip : Use =TEXT(B24,"0") and a lookup table for words, or leave manual. Step 3 – Build the Letter Format (Sheet2) Now link Letter_Format to the calculated values in Sheet1 . A. Header Section Merge cells A1 to E1 → type: FULL AND FINAL SETTLEMENT LETTER (bold, size 16) A2 to E2: Company Name A3 to E3: Company Address & Contact B. Employee & Reference Details Date: [=Sheet1!C5] (or =TODAY()) Ref No.: FNF/EMP001/Mar2025 Subject: Full and Final Settlement for [=Sheet1!C2] Dear [=Sheet1!C2], C. Settlement Statement Table (in Excel table format) Create a 3-column table: full and final settlement letter format in excel
Add rows under Earnings: PF employer contribution (if returning to employee), gratuity formula = (Last drawn salary * 15/26 * years of service). This settlement is accepted voluntarily and in full
Sub SaveAsPDF() Dim empName As String empName = Range("C2").Value ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:="FNF_" & empName & ".pdf", Quality:=xlQualityStandard End Sub | A | B | C | |-----------------------|-----------|---------------| | FULL AND FINAL SETTLEMENT LETTER | | Date: | 15-Mar-25 | | | Employee Name: | John Doe | ID: EMP001 | | Last Working Day: | 15-Mar-25 | | | | PARTICULARS | AMOUNT (₹) | REMARKS | | Pro-rata salary | 29,032 | 15 days | | Leave encashment | 20,000 | 10 days | | Bonus | 5,000 | | | Total Earnings | 54,032 | | | TDS | 3,000 | | | Loan recovery | 1,500 | | | Total Deductions | 4,500 | | | NET PAYABLE | 49,532 | | | | Accepted by Employee: _________ | | For ABC Corp: _________ | 10. Frequently Asked Questions Q: Can I use Google Sheets instead of Excel? Yes, the same logic applies. Use =GOOGLETRANSLATE or add-ons for amount in words. Analyst | | Date of Joining | |
If printed on company letterhead and signed by both parties, yes. Excel is just the tool; the final signed PDF/paper copy is binding.