Excel workbookOfficial Zeyto

End-of-Service Final Settlement Workbook (UAE)

An Excel workbook for owners, HR officers and accountants who handle exits and want one method and a record.

Work out everything owed to a leaver.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box3 files, 80 KB
  • Works withMicrosoft Excel 2016 or later, or Google Sheets
  • Made forUAE businesses

How it works

  1. BuyPay on Stripe’s secure page.
  2. DownloadYour order page opens at once with a secure link.
  3. Open and useOpen the workbook in Excel and start from the example.

What you get

  • Full final settlement statement, not gratuity alone
  • Gratuity tiers with a daily-rate method you choose
  • 17 flag messages and a second-method cross-check
  • Register for 60 leavers and a printable one-page statement
  • Five-leaver filled example with expected figures
Files and sizes (3)
  • end-of-service-final-settlement-workbook.xlsx38 KB
  • end-of-service-final-settlement-workbook-example.xlsx39 KB
  • README.txt3.5 KB

3 files, 80 KB in total. You download them from your order page after payment.

What it does not do

  • It is an estimate, not a legal ruling.
  • Confirm gratuity, deductions and deadlines with a lawyer or MOHRE.

After you buy

  • Instant downloadYour order page opens right after payment with a secure link for each file. The link is emailed to you too.
  • A fresh link any timeLinks last 48 hours. Enter your order reference and the email you paid with and we will send a new one.
  • Help is one email awayWrite to support@zeyto.app with your order reference. The team answers every enquiry.
  • Fix, replace or refundIf a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Find my purchasesContact the Zeyto teamMarketplace terms

Full refund wording

Digital downloads (files, templates, skill packs, guides) are delivered straight away, so they are not refunded once downloaded. If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Applies to products sold by Zeyto itself. None of this takes away rights you have under UAE law.

About this product

End-of-Service Final Settlement Workbook is an Excel workbook for UAE employers who need to work out and document everything owed when someone leaves.

Read the full description

End-of-Service Final Settlement Workbook is an Excel workbook for UAE employers who need to work out and document everything owed when someone leaves. It is broader than the Zeyto End-of-Service Gratuity Calculator, which is a cheaper tool for the gratuity figure only. This workbook builds the whole statement for the employee to sign.

What is inside:

  • Five sheets: Instructions, Settings, Register (up to 60 leavers), Statement and Worked Example
  • Gratuity with the published tiers (21 days of basic wage a year for the first five years, 30 days after, one-year minimum, part years in proportion, cap of two years of wage), computed from joining and leaving dates
  • Unused annual leave, salary for the final month, notice pay in lieu and notice recovery (each controlled by a setting you choose), additions, advances, loans and other deductions
  • A Settings sheet for the choices the law leaves open: the daily-rate method, the cap basis, the days basis and the notice rules, so you can match your accountant
  • 17 flag messages (for example under one year of service, notice shortfall, negative net) and a second-method gratuity cross-check so a wrong setting shows up
  • A gratuity override column for when a lawyer tells you a different amount applies
  • A one-page statement per leaver, with the working for each line, for the employee to sign
  • A filled example file with five fictional leavers and expected figures computed outside the workbook

Who it is for: owners, HR officers and accountants who handle exits and want one consistent method and a record.

What it does not do: it gives an estimate for planning and review, not a legal determination. The law does not define the daily rate: Zeyto's default is basic x 12 / 365 and you can change it. Whether the cap is measured on basic or total wage in your case, how unpaid leave counts toward service, how leave and notice pay are calculated for your contracts, which deductions are allowed and the payment deadline are points to confirm with your lawyer, accountant or MOHRE. Free zones can have their own schemes. It does not cover tax (none on salary in the UAE), social security for UAE and GCC nationals, insurance payouts or any claim the employee may bring.

Verified by recalculating the five-leaver example with an independent engine and comparing results with a separate calculation. Not opened in Microsoft Excel itself.

Requirements: Microsoft Excel 2016 or later, or Google Sheets.

Questions

Who is it for?
Owners, HR officers and accountants who handle exits and want one method and a record.
What do I need to use it?
Microsoft Excel 2016 or later, or Google Sheets.
How do I get it?
Pay on Stripe, then download from your order page at once. Links last 48 hours: ask for a fresh one with your order reference and email.
What if the file is wrong?
If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you. Read the terms.

End-of-Service Final Settlement Workbook (UAE): AED 89

Pay once, download at once.

Damaged, will not open or not as listed? Tell us within 7 days and we fix it, replace it or refund you.

Questions before you buy? Contact the Zeyto team. This is sold by Zeyto (Emeron Infospace FZE) itself, not by an independent seller. See the marketplace terms.

Not sure it is the right one?

Works well with

Other official products that cover the same ground or finish the job.