Jira & Confluence 
Bitrix24 End of service · Qatar Labour Law · Excel
End of service gratuity calculator for Qatar — three weeks' basic wage per year, with a statement and a request for your dues
Short answer. Enter your last basic wage and your start and end dates. Who qualifies: employees with one full year of service or more; under a year = no gratuity (Article 54).
- Give written notice — 1 month before (first two years) or 2 months (after that)type the date
- Ask for a written final settlement statement — 2 weeks beforetype the date
- Ask for your service certificate — on your last daytype the date
Check your own case.
Notice periods are from Article 49; the other reminders are practical.
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
Calculator · end of service · Article 54
Your gratuity in QAR — three weeks' basic wage per year of service
Enter your last basic wage and your service dates. We count your service including part years, the gratuity under Article 54 of the Labour Law, your leave balance pay and notice period, and prepare an Excel file and a request for your dues.
- Ask your employer for a written final settlement statement and compare it with this calculation.
- Send the request for your dues and ask for your service certificate (Article 53).
- If you disagree: complain to the Ministry of Labour for an amicable settlement, then the Labour Dispute Settlement Committee.
Arithmetic only, under Article 54 of Labour Law No. 14 of 2004: after one full year, weeks' wage × 7 × years of service (with part years) × daily basic wage. Dividing by 30 is common practice; the law does not set it. Not legal advice.
Lida, Layers template assistant
Enter your basic wage and service dates, and I work out your gratuity, leave pay and notice period.
Then download the statement and the request letter.
Deadlines
The rules, with the source
| What | Deadline | Source |
|---|---|---|
| Who qualifies | Employees with one full year of service or more; under a year = no gratuity | Article 54 |
| How much | At least three weeks' wage per year (more if your contract says so), part years in proportion, on the last basic wage | Articles 54 and 72 |
| Deductions | The employer may deduct amounts the employee owes them | Article 54 |
| Notice | One month in the first two years, two months after that | Article 49 |
| Loss of gratuity | Only on dismissal in one of the ten cases in Article 61 | Article 61 |
Daily wage = basic wage ÷ 30 is common practice, but the law does not set the divisor; you can change it to match your contract.
Step by step
What to do, in order
1
Enter wage and dates
Last monthly basic wage (without allowances), service start and end date.
2
Add leave and deductions
Unused leave in days, and any amount you owe your employer.
3
Download statement and letter
An Excel file with formulas and a letter asking for your dues and a service certificate.
Questions
How is end of service gratuity calculated in Qatar?
Under Article 54 of Labour Law No. 14 of 2004: after one year or more, at least three weeks' wage for each year of service, part years in proportion, on your last basic wage. Example: basic QAR 8,000 and 7.38 years = 155.05 days × QAR 266.67 ≈ QAR 41,346.67.
Is gratuity based on basic or gross salary?
On the last basic wage (Articles 54 and 72), not salary plus housing and transport allowances — unless your contract gives more.
Do I get gratuity if I resign?
Yes, after a full year: Article 54 does not distinguish between resignation and termination. You lose it only if dismissed in one of the ten cases in Article 61. Respect the Article 49 notice period.
What is the notice period for resignation in Qatar?
After probation: one month during the first and second year of service, two months after the second year (Article 49 as amended).
Is there an Excel version?
Yes: all formulas visible, yellow cells for your data, and a «Before you rely on it» sheet listing what to check.
Is it free? Do I need to sign up?
Free, no sign-up: calculate and download. With a free account you save a copy and come back to it.
Official sources
Other documents
Keep the papers in one place
Letters, receipts and notices in one folder you can share with family or a lawyer. The templates and the editor are free; Layers is free for up to 20 people.
An estimate, not legal advice; disputes go to the Ministry of Labour and then the Labour Dispute Settlement Committee.