A senior engineer hands in her resignation after seven years. Payroll opens the gratuity spreadsheet, finds her start date, types in her basic salary — and then stops. Did that unpaid month in 2023 ever get recorded? Was the figure in the sheet her basic, or basic plus housing?
Nobody can say for sure. And the number at the bottom of that sheet is going to be paid out in one lump sum.
End-of-service gratuity is one of the largest statutory liabilities a UAE employer carries. The formula itself is short. The trouble is the inputs, and the fact that most companies only work the number out on the day someone leaves.
The Formula, Stated Once
Under Federal Decree-Law No. 33 of 2021, gratuity is a tiered calculation on the employee's final basic wage:
- Years one to five — 21 days of basic wage for each completed year of service
- Beyond year five — 30 days of basic wage for each additional year
- The cap — the total can never exceed two years' worth of the employee's wage
So the engineer above, with seven completed years, is owed 5 × 21 plus 2 × 30 — 165 days of basic wage. That part a spreadsheet handles fine. For the full walk-through of edge cases, see Gratuity Math, Demystified.
What the 2021 Reform Changed
The current law reshaped exit obligations in three ways that matter for anyone maintaining a calculation by hand:
- Fixed-term contracts for everyone. Unlimited contracts are gone, so the private sector now works on a single contract model — and a single basis for exit calculations.
- One rule for resignations. An employee who resigns after at least one year of continuous service receives their full gratuity. The old reduction tables for resignations no longer apply.
- Basic wage only. Housing, travel and other variable allowances stay out of the calculation. So do bonuses and performance pay.
A workbook built before the reform may still carry the old resignation logic in a hidden column. It will keep producing confident, wrong answers.
Where the Spreadsheet Breaks
The formula is not where errors come from. The inputs are.
Unpaid Absence
Days taken as unpaid leave are excluded when counting continuous service. Every one of them shortens the service period and reduces the payout. If unpaid leave lives in a manager's inbox rather than in the same system as the employee record, the spreadsheet never hears about it.
Partial Years
Very few people leave on their work anniversary. Pro-rating the days owed for a final, partial year is exactly the kind of step that gets done one way by one payroll officer and another way by the next.
The Wrong Salary Column
Basic wage and total package sit side by side on most payroll exports. Pick the wrong column once and the gratuity is overstated for that leaver — or, worse, understated and disputed.
No Audit Trail
When the employee asks how their figure was built, a spreadsheet can only show the final cell. It cannot show which start date, which salary and which absence days fed into it, or who last changed them.
What Automation Actually Fixes
Good human resource software for the UAE does not use a cleverer formula. It uses the same one, but reads the inputs from records HR already maintains rather than from whatever someone typed into a cell.
In HRHub, the exit settlement is calculated per UAE labour law from the employee's recorded start date, basic salary and unpaid leave days. Unpaid leave is captured where it is approved, in leave management, so it reaches the settlement without anyone copying it across. The result is a settlement statement HR can review line by line before it is approved — not a single number with no history behind it.
If your team still runs leave, salaries and exits from separate files, our comparison of HR software vs Excel covers the wider picture.
Plan for the Liability Before Anyone Resigns
Getting the figure right is half the job. The other half is having the money.
Unlike pension systems funded by regular payroll withholding, traditional UAE gratuity is paid by the employer as a lump sum when the contract ends. For SMEs in particular, the risk is concentration: if several long-serving staff leave in the same quarter, an obligation that built up quietly over years lands on cash flow all at once.
The fix is a practice, not a product feature:
- Work out the figure regularly, not only at exit. Running the settlement calculation for long-tenured staff on a set schedule shows finance what the business would owe if they left tomorrow.
- Watch the five-year mark. Service beyond year five accrues at 30 days rather than 21, so the liability for each employee grows faster once they cross it.
- Hold a reserve against it. Treat the total as a real obligation on the balance sheet and keep cash set aside in proportion, rather than discovering it at resignation.
Because HRHub's settlement calculation works from live employee records, it gives that figure on demand for any employee — which makes the regular review a quick check rather than a spreadsheet project.
Mainland vs. DIFC: Two Different Models
The UAE is not a single gratuity regime any more. In the DIFC, employers are required to contribute to the Employee Workplace Savings (DEWS) scheme — a defined-contribution model funded through recurring contributions. On the mainland, authorities have introduced voluntary defined-contribution savings funds alongside the traditional end-of-service system.
For groups with entities in both, the practical point is simple: know which model each employee falls under before relying on any calculation, and plan cash for the lump-sum obligations accordingly.
The Payoff
The gratuity formula has not been the hard part for a long time. The hard part is clean inputs — the right start date, the right basic wage, every unpaid day accounted for — and knowing the total before it is due.
Put those inputs in one system and the settlement stops being a negotiation. HR approves a breakdown it can defend, the employee sees how it was built, and finance is not surprised. See how HRHub handles payroll and exits, or check pricing for your team size.
