End-of-service gratuity in Qatar, calculated in your ERP

Under Qatar's labour law, an employee who completes a year or more of continuous service is entitled to an end-of-service gratuity when they leave, calculated on basic wage and length of service. The statutory minimum is three weeks' basic wage per year of service, and many employers commit to more in the contract.

The arithmetic is not the hard part.

What actually goes wrong

The liability is invisible until someone resigns. If gratuity is only ever calculated at exit, it is not on the books as an accruing obligation. A year with several long-serving departures then lands as a surprise on the cash position.

Basic wage drifts from what was agreed. Gratuity is calculated on basic wage, not gross. When a raise is recorded as an allowance increase, the gratuity base does not move — which may be exactly right or exactly wrong depending on the contract, and either way somebody needs to know which.

Service dates are wrong. Transfers between group companies, unpaid leave and re-hires all affect continuous service. If that history only exists in an email chain, the calculation is a reconstruction.

Holding it in the system instead

In ERPNext with Frappe HR, the employee record carries the joining date, the contract, the salary structure and the basic component. That means:

• Service length is derived from the record, not remembered.
• The gratuity base follows the basic component automatically, so a salary revision updates it.
• The accrual can be posted periodically, which puts the liability on the balance sheet where it belongs instead of arriving as a shock.
• Leaving date, reason and final settlement sit against the same employee record as everything else.

The point is not that the system does arithmetic you could do in a spreadsheet. It is that the inputs stay correct across years without anyone maintaining them by hand.

The usual caveat

Entitlement depends on the contract, the reason for leaving and the specifics of the service history, and the law sets a floor rather than the whole answer. Configure the system to match what your contracts and your legal advisor say — do not let a default decide it.

Our HR and payroll setup covers this alongside attendance, leave and WPS salary files.