Payroll Calculation Egypt: Overtime, Gratuity & WPS Guide

A company with 60 employees ran payroll for 18 days every month — not because the team was slow, but because they had 11 separate spreadsheets reconciling attendance, overtime, advances, and social insurance. Getting it down to 3 days required no magic, just a clear sequence and clean formulas. This article walks through that sequence.

The Egyptian Payroll Stack: What You're Actually Calculating

Every payroll run in Egypt combines at least seven variables: base salary, variable allowances, overtime, deductions (social insurance + income tax), advances repaid that month, any mid-month hires, and the leave balance adjustment. Miss one and the whole figure is wrong. The order matters too — social insurance is calculated on a capped insurable wage, not on gross, so sequence errors compound fast.

Overtime: The 1.35× and 1.70× Rules

Egyptian Labour Law Article 70 sets overtime at 1.35× the hourly rate for daytime extra hours and 1.70× for night-shift or holiday hours. The hourly rate itself is calculated as:

Hourly rate = (Monthly basic salary × 12) ÷ (365 × daily hours)

For a 8-hour day: a basic salary of EGP 8,000/month gives a daily rate of EGP 263 and an hourly rate of EGP 32.9. One evening overtime hour costs EGP 44.4; one holiday hour costs EGP 55.9. Those numbers matter when you have a warehouse team logging 40 extra hours in a peak week — that's EGP 1,776 in daytime OT or EGP 2,236 on a Friday.

Social Insurance: Caps, Bands, and the Missing 1%

Egypt's social insurance currently applies employee contributions of 11% and employer contributions of 18.75%, but only on the insurable wage — which has a monthly ceiling set by NOSI (currently EGP 10,500 for the variable component and a separate cap for the fixed component). Many payroll clerks apply the percentage to gross salary, which is both legally wrong and financially damaging. If an employee earns EGP 18,000 gross, the insurable base is capped, not 18,000. Overpaying silently for a year across 60 employees is real money.

The 1% employees often miss: the additional 1% employee contribution introduced for early retirement entitlement. It applies above certain thresholds. Worth auditing annually.

End-of-Service Gratuity: The Fraction That Trips Everyone

In Egypt, the end-of-service (EOS) gratuity under the Labour Law is funded through the social insurance framework — employees entitled to pension through NOSI receive their entitlement via that system rather than a separate employer lump sum (unlike UAE or KSA). The practical implication: HR teams don't provision a separate EOS liability in Egypt the way Gulf entities do.

In the UAE, however, EOS gratuity under the old scheme is 21 days of last basic salary per year for the first 5 years, then 30 days per year beyond that — capped at 2 years' total salary. For a UAE employee on AED 12,000 basic with 7 years of service:

• First 5 years: (12,000 ÷ 30) × 21 × 5 = AED 42,000
• Years 6–7: (12,000 ÷ 30) × 30 × 2 = AED 24,000
• Total: AED 66,000

Under the UAE's newer DEWS/GPSSA scheme, calculation shifts to defined-contribution, but the legacy formula still governs anyone who hasn't been enrolled in the new system.

For teams managing Gulf entities alongside Egypt operations, the multi-branch payroll considerations covered here are worth reading alongside this guide.

Ramadan Hours and What They Cost

Egypt's Labour Law mandates a reduction of 2 working hours per day during Ramadan for Muslim employees. For a company running 8-hour shifts, that's a 25% capacity drop. The payroll implication: salaries don't decrease, but any performance-linked component tied to hours logged needs manual adjustment. If your attendance system auto-flags the reduced hours as absence, you'll generate phantom deductions. The fix is a Ramadan-hours schedule applied at the shift level before the payroll run executes, not corrected after.

Prorated Salaries for Mid-Month Hires

Standard practice in Egypt is to prorate on calendar days, not working days. A new hire joining on the 10th of a 30-day month earns 21/30 of their monthly salary (days 10–30 inclusive). Some companies use working days instead — that's not illegal, but it must be consistent and documented in the employment contract to avoid disputes. For a salary of EGP 12,000, the difference between calendar-day and working-day proration in a month with 23 working days can be over EGP 400. Multiply that across 8 mid-month joiners and the variance hits the thousands.

WPS Export: What the UAE File Actually Needs

The Wage Protection System requires a Salary Information File (SIF) in a specific flat-file format: employer ID (MOL number), employee ID (Emirates ID or passport), basic salary, allowances, and deductions listed separately — not as a net figure. Banks reject SIF files for three common reasons:

1. Decimal formatting: some systems export EGP/AED figures with a comma separator instead of a period — the file parser fails silently.
2. Employee count mismatch: the SIF header declares 42 employees but 43 rows exist.
3. MOL registration lag: a new joiner appears in payroll before their MOL registration clears, creating an invalid employee ID.

Generating a clean SIF from a payroll tool that structures data in WPS-compatible fields is straightforwardly faster than reformatting a spreadsheet export each month.

Salary Advances: The Deduction Timing Problem

An advance paid on the 20th of the month needs to be tracked against which payroll cycle it repays — current month or next. If the advance module isn't connected to the deduction engine, the HR clerk adds a manual line, the payslip shows it, but the general ledger doesn't. The employee gets the right net; the books are wrong. The discipline required is: advances must be posted in the same system that generates payroll, not managed separately in a petty-cash log.

13th-Month and Annual Bonuses: Tax Timing Matters

Egypt taxes employment income progressively. A 13th-month bonus paid in December gets added to that month's taxable income, potentially pushing an employee into a higher bracket for that single month. Some payroll systems annualize the bonus across 12 months for tax calculation; others don't. The difference can be a few hundred pounds per employee — real money if you have 200 staff. Check whether your system annualizes or lumps. If it lumps, employees may query why their December payslip shows a higher tax deduction than expected.

Common Mistakes Payroll Teams Make

• Applying SI contributions to gross instead of insurable wage — creates overpayment that's hard to recover
• Not updating the SI ceiling after NOSI announcements — Egypt has adjusted it multiple times in recent years
• Using a 26-working-day divisor for all months — February and months with public holidays have different actual working days
• Forgetting the employer share in cost-to-company reporting — budget holders see the net salary, not the true employment cost
• Running WPS export before all attendance disputes are resolved — once submitted, corrections require a reversal file

Where Software Actually Saves Time

The calculations above aren't complex individually — they become complex when 11 of them interact across 200 employees with different contract types, shift patterns, and hire dates. Tools like Attendux handle the sequencing: attendance locks before the payroll engine runs, insurable-wage caps are pre-configured per jurisdiction, and WPS exports generate in the correct SIF format. The 18-day payroll run mentioned at the start dropped to 3 days primarily because attendance data fed directly into the payroll engine — no re-entry, no reconciliation spreadsheet.

If your team is still building the HR and attendance foundation before worrying about payroll automation, the SME setup guide for biometric and payroll configuration covers the prerequisite steps in detail.

And if you're managing payroll compliance across Egypt and a Gulf entity simultaneously, it's worth reviewing the HR compliance checklist to make sure both jurisdictions are covered before the next audit cycle.

Ready to talk?

If your payroll run is taking more than a week, or your WPS files keep bouncing back from the bank, we're happy to look at your current process and tell you plainly where the bottleneck is. Reach out to the ProgMine team — no deck, just a conversation about your specific setup.