End-of-Service Calculator in Excel: UAE, Kuwait and Qatar with an Editable Rules Table

End-of-service benefit differs from one Gulf country to the next: days per year, the cap on the benefit, and the effect of resignation. Most calculators hide these rules. This sheet shows them in a table so you can see how the number came out and edit it if the law changes.

Pick the country, enter the start and end dates, the monthly wage used and the reason for leaving, and the sheet works out service with fractions, the months due after applying the cap, then the benefit.

Who is it for?

• Employees in the UAE, Kuwait and Qatar who want to estimate what they are owed
• HR officers and accountants estimating liabilities
• Small business owners ending an employee contract
• Engineers and technicians moving between Gulf countries

What is inside the sheet?

• Employee data: country, start and end dates, absence days, wage and reason
• Service length in years with fractions
• Minimum service, months due after the cap and the share by reason for leaving
• An editable rules table for three countries
• A full guide sheet

How to use it

1. Pick the country from the list.
2. Enter the start date, last working day and any unpaid absence days.
3. Enter the monthly wage used, and check its type in the wage note below the sheet.
4. Choose the reason for leaving and read the benefit due.

Formulas used

• Service years = (service days − absence days) ÷ 365
• Months due = min(years, 5) × first-five-years months + max(years − 5, 0) × after-five months
• After cap = min(months, cap) when a cap exists
• Benefit = wage × months after cap × share due

Worked example from the sheet itself

Example: an employee in the UAE from 1 March 2018 to 31 August 2026 on a wage of 10,000 with an ordinary contract end.

• Service is 3,106 days, or 8.51 years.
• Months due = 5 × 0.7 + 3.51 × 1 = 7.01 months (cap not reached).
• Benefit = 10,000 × 7.01 = 70,095.89.

Tips for best results

• The wage base differs: basic wage only in most UAE and Qatar cases, last total wage in Kuwait. Read your contract and the law.
• The rules table at the bottom is the source of the numbers, so edit a cell there if the law changes and the sheet recalculates.
• Unpaid absence days are deducted from service length in the calculation.

Frequently asked questions

Which rules are included?

UAE: 21 days (0.7 month) per year for the first five, then 30 days, capped at two years of wage. Kuwait: half a month per year for the first five, then a month, capped at one and a half years, with shares for resignation. Qatar: three weeks per year after one year of service. This is what was known when the sheet was made.

Are the laws fixed?

No, they change. Check the latest labour law in your country and edit the table when needed.

Is it suitable for Saudi Arabia?

Saudi Arabia has its own sheet on the site, following the Saudi labour law.

Download the sheet

Press the download button at the top of the page to get the Excel file. It includes a full guide sheet, yellow input cells and formulas protected from accidental edits. The sheet is also available in Arabic from the language switcher.

A guidance calculator, not legal advice. Confirm with the official authority in your country.