Most UAE businesses still calculate gratuity in spreadsheets — and most of those spreadsheets have errors.
The UAE Labour Law (Federal Decree-Law No. 33 of 2021) defines gratuity as a function of tenure, contract type, and basic salary. Getting it wrong means underpayment (legal risk) or overpayment (cash leak). Neither is acceptable.
Start here
The gratuity formula operators actually need
For unlimited contracts (most common post-2022):
- First five years: 21 calendar days of basic salary per year of service
- After five years: 30 calendar days of basic salary per each additional year
- Cap: total gratuity cannot exceed two years of basic salary
The daily rate is basic salary divided by 30 — not by calendar days in the month. This is where most spreadsheet errors start.
Controls that prevent calculation errors
Do not let gratuity run on manual input alone. Your system should enforce:
- Basic salary sourced from the latest payroll record, not manually entered
- Tenure calculated from the official join date in the HR record, not from memory
- Contract type (limited vs. unlimited) pulled from the employee profile
- Approval required before any gratuity payment is processed via payment controls
If any of these are manual, the calculation is a guess.
Partial-year proration
Employees rarely leave on exact anniversaries. Proration matters:
- Calculate full years of gratuity first
- Then prorate the remaining months and days as a fraction of 365
- Round to the nearest fils (0.01 AED)
A system that tracks employee records with audit trails eliminates disputes about join dates and salary history.
What your audit trail should capture
Every gratuity calculation should log:
- Employee ID, name, and join date used
- Basic salary at the time of calculation
- Tenure breakdown (years, months, days)
- Formula applied and intermediate values
- Approver and approval timestamp
- Payment reference once disbursed
Without this trail, any labor dispute becomes your word against theirs.
When to run gratuity provisions
Do not wait until termination. Run a monthly gratuity provision so your balance sheet reflects the real liability. This is especially important for construction and contracting firms with large field workforces where turnover is high and exits cluster around project completions.