All projects
● Live 2024–2025 HR & Payroll

HR system with Egyptian payroll

A full HR platform built for a client still on spreadsheets. Twenty-six tables, a payroll system that handles Egyptian tax and social insurance correctly, plus a mobile app so people can check in from wherever they actually are.

STACK
Supabase · PWA · GPS attendance
ROLE
Solo — schema, backend, mobile, admin
CONTEXT
Client project alongside my day job
STATUS
Live, running month-close every cycle

The problem

A client with 200+ employees was running everything on spreadsheets — attendance, leave, and payroll. Every month-end meant days of checking numbers by hand, and Egyptian tax law made it worse.

What I built

  • 26-table Postgres schema covering employees, contracts, attendance, leave, payroll
  • Progressive-tax engine and social-insurance calculations that match Egyptian law, not the textbook version
  • GPS-based attendance in a mobile PWA — check in from the actual work site
  • Leave request workflow with approval chains
  • Full admin dashboard with month-close and payroll runs
TECHNICAL DEEP-DIVE

The payroll engine

The payroll engine was the hardest part — not the math, the edge cases. Prorated first months, mid-cycle raises, unpaid leave, insurance ceiling changes. The rules aren't written in one place — I collected them from real HR work.