Pay period: 26th to 25th. Type each opener's basic, KPIs, allowance (EGP), start date and any annual leave carried over (negative for days already used this year before the board), then Save salaries. Each UPL takes one day's pay (basic ÷ 30), each Half day half a day's, and each NSNC three days' pay from the basic only (an NSNC on a Monday or Friday also makes that weekend 2 UPLs); OFF and annual leave are paid. KPIs and allowance are never touched. Someone terminated or resigned gets their basic pro-rated to their last day (basic ÷ 30 × days); set their KPIs and allowance for that month by hand. "Not marked" counts days so far with no attendance mark: check those before paying.
| Opener | Basic | KPIs | Allowance | Start date | Leave carried |
Attended | Half day | OFF | UPL | NSNC | Annual leave | Not marked | Leave left |
UPL deduction | Basic after | Total pay |
|---|