Excel workbookOfficial Zeyto

End-of-Service Gratuity Calculator

An Excel workbook for owners, HR officers and accountants who need a quick estimate or a figure to accrue.

Estimate end-of-service gratuity for planning.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box2 files, 32 KB
  • Works withMicrosoft Excel 2016 or later, Google Sheets or LibreOffice Calc
  • 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

  • Excel workbook with 4 sheets
  • One-employee calculator with the working shown
  • Staff register with total liability
  • Two daily-rate methods compared
  • Worked example with five employees
  • Instructions sheet and README
Files and sizes (2)
  • uae-end-of-service-gratuity-calculator.xlsx28 KB
  • README.txt4.1 KB

2 files, 32 KB in total. You download them from your order page after payment.

What it does not do

  • It is an estimate, not a final settlement.
  • Confirm the method and cap with your accountant or the authority.

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

This workbook estimates the end-of-service gratuity for employees under the UAE private-sector rules: at least one year of service, 21 days of basic wage for each of the first five years, 30 days for each year after.

Read the full description

This workbook estimates the end-of-service gratuity for employees under the UAE private-sector rules: at least one year of service, 21 days of basic wage for each of the first five years, 30 days for each year after that, part years in proportion, and a cap of two years' wage. The tiers follow Federal Decree-Law 33 of 2021, Article 51, as published on the UAE government portal.

The law does not define the daily rate. The workbook shows two methods side by side so you can see the difference: basic x 12 / 365, which is the method Zeyto's own gratuity calculator uses (with a cap of 24 x basic), and basic / 30, which many online calculators use. Choose one with your accountant and apply it consistently.

What is inside:

  • A Calculator sheet for one employee: dates, basic wage, method and the amount with the working shown
  • A Staff Register for a team, with the liability per person and in total
  • A Worked Example with five fictional employees, including one under a year and one that reaches the cap
  • Instructions sheet and README

Who it is for: owners, HR and accountants who need a quick estimate, or a figure to accrue in the books.

What it is not: it is an estimate, not a final settlement. It does not include notice pay, unused leave, final salary, allowances or any contractual benefit beyond the standard gratuity. Open points to confirm with your accountant: whether the cap is measured on basic or total wage in your case, how unpaid leave counts, and whether your free zone has its own scheme. Check with your accountant or the relevant authority for your case.

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

Questions

Who is it for?
Owners, HR officers and accountants who need a quick estimate or a figure to accrue.
What do I need to use it?
Microsoft Excel 2016 or later, Google Sheets or LibreOffice Calc.
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 Gratuity Calculator: AED 30

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.