UAE Final Settlement Excel Template (Free Workbook)

What the workbook is for

Use it when you need a transparent final-settlement format rather than one unexplained “net payable” number. Every major amount has its own line so you can attach the contract, payslip, leave record or calculation that supports it.

Download the Excel workbook

Replace every example with facts you can prove. The workbook is designed for audit and discussion; it is not a government certificate and should not be used unchanged for ADGM, DIFC, domestic-worker or Savings Scheme cases.

Download Excel workbook

What is included

Employment and wage inputs: start/end dates, basic wage and total wage.
Final salary: keep ordinary salary through the final day separate from end-of-service benefits.
Unused annual leave: record eligible closing days and the wage basis used.
Notice: record contract notice, days served and any unserved-notice amount.
Traditional federal gratuity: show eligible service, basic-wage formula and relevant cap rather than typing one total manually.
Additions and deductions: list each loan, advance, overpayment, reimbursement or other item separately.
Employer comparison: enter the employer's proposed total and trace the difference to a specific line.

How to use the template

Confirm the employment jurisdiction and end-of-service system first.
Enter dates and wage components from original records.
Complete each settlement line independently.
Enter the employer's figures in the comparison area.
Investigate only the lines that differ instead of arguing about the net total.
Save the source document beside every disputed input.

Example: turn a AED 9,000 difference into questions

If your workbook is AED 9,000 higher than the employer statement, do not stop at the difference. The workbook may show AED 3,000 missing final salary, AED 2,000 unused leave and AED 4,000 gratuity difference. Those become three precise questions that payroll or an authority can verify.

Evidence to prepare

Employment contract and amendmentsPayslips and bank/WPS recordsLeave ledgerWritten resignation or termination noticeTimesheets or attendance recordsEmployer settlement statementVisa/work-permit cancellation recordRelevant messages and complaint references

Evidence categories prepared0 of 8

Keep original files, full dates, sender/recipient information and a chronology. Do not edit evidence to fit a calculation.

What this Excel template should not do

It should not encourage you to invent a divisor, combine basic and total wage, or hide a disputed deduction inside the gratuity formula. If a legal or payroll assumption is uncertain, keep the cell and note visible and verify it against the current official source.

Important limitations

The workbook is not a legal certificate, MOHRE form or payroll approval.
Formula assumptions are visible so they can be reviewed or replaced.
Do not email identity documents, bank statements or unredacted contracts to unknown recipients.
Use the current official source and professional support where facts, jurisdiction or entitlement are disputed.

Prefer an interactive calculation? Use the UAE Final Settlement Calculator. Already have an employer statement? Use the Settlement Statement Checker.