HR and Payroll
العربية AR

HR and Payroll

An Excel workbook for your employees, their shifts, attendance and leave. It works out leave balances and prepares a payroll draft from your own policies, in Arabic or English.

Coming soon
Format
One .xlsx file, no macros
Capacity
200 employees, 3,000 attendance records
Copies
Empty, Large (twice the capacity), and a demo with sample data
Language
An Arabic file and an English file
Checks
42,470 values checked automatically in the demo
hr-en-demo.xlsx As of 16 Oct 2026
EmployeeNameStatusHireIDMobile
EM-0001محمد القحطانيActive01 Jul 2019****00010500000001
EM-0002عبدالله الشمريActive15 Apr 2024****00020500000002
EM-0003فهد الدوسريActive10 Oct 2023****00030500000003
EM-0004سارة الحربيActive08 Aug 2022****00040500000004
EM-0006خالد الغامديActive29 Apr 2021****00060500000006
EM-0007ريم المطيريActive24 Dec 2022****00070500000007
EmployeeNameBasicHousingGrossGOSI employeeNetStatus
EM-0001محمد القحطاني5,750.001,437.507,759.38718.757,040.63Draft
EM-0002عبدالله الشمري8,750.002,187.5012,890.631,093.7511,796.88Draft
EM-0004سارة الحربي11,250.002,812.5015,239.841,406.2513,564.06Draft
EM-0005نورة الزهراني13,500.003,375.0017,375.001,687.5015,687.50Draft
EM-0006خالد الغامدي5,000.001,250.007,050.000.006,643.06Draft
Sample data from the demo copy, calculated on its report date, 16 Oct 2026, for payroll period 2026-10. Its social-insurance rates are examples, not advice, and some columns are left out here. ID numbers are masked in the directory, as in the file. The English file keeps the sample's Arabic names.

What it does

  • Your policies, no built-in rates

    Leave days, accrual method, carry-over cap, overtime and the social-insurance percentages are columns of a dated Policies table. A calculation missing a value shows “Policy not configured”, never 0.

    Policies

  • Two punch pairs, overnight shifts

    Each day takes two in-and-out pairs, and an out before the in means the next day. Grace minutes count: 08:10 with 10 minutes' grace is not late; 08:11 is 11 minutes late.

    Attendance, Shifts

  • Corrections keep the original

    A correction never overwrites the original punch, and applies only once it is approved and has a reason.

    Attendance corrections

  • Annual leave balances

    Monthly pro-rata or the full year on 1 January, and anything above the carry-over cap on 31 December is forfeited. Leave days skip the weekend and holidays, per leave type.

    Leave balances

  • A payroll draft, line by line

    Gross is fixed pay plus overtime and additions; deductions are the fixed deduction, unpaid leave, lateness, the employee's social-insurance share and other deductions. The employer's share is shown, never deducted.

    Payroll draft

  • Period lock

    Approved payroll holds pasted values as the record of a locked period, and any approval dated after the lock shows in its own report.

    Approved payroll, Changes after lock

Inside the file

55 sheets: reports, data entry sheets and protected calculation sheets. These are the main ones.

  1. DashboardIndicators as of the report date
  2. Employee directoryEmployees, with ID numbers masked
  3. Daily attendanceRecords on the report date
  4. Monthly attendanceThe month chosen on Settings
  5. Yearly attendanceThe report date's year: attendance, absence, lateness
  6. Leave registerLeave by start date
  7. Leave balancesAnnual leave as of the report date
  8. Leave reportOne employee or all, from and to
  9. Payroll draftFor review only, not a WPS file
  10. Approved payroll totalsTotals per approved period
  11. Policy registerPolicies and their effective dates
  12. Data qualityA count for each data entry issue

Before you buy

Not a certified system
It produces no WPS file and makes no Labor Law or GOSI compliance claim. The draft is for review before anything is paid.
Rates
Social-insurance rates and leave days are not built in; you enter them from the official source on the Policies sheet.
Balances
Balances are worked out for one leave type you choose; other types show days taken in the register only.
Software
Calculations are verified in Excel for Windows (Microsoft 365) and in LibreOffice. Not tested on Excel 2021 or 2024, Mac, Excel for the web or mobile; Excel 2016 and older are not supported.
Language
An Arabic file and an English file, with the same formulas.
Report date
The file never reads today's date. Every status and day count comes from the report date on the Settings sheet, so update it each time you open the file.
Reminders
The file sends nothing and cannot alert you while it is closed.
Capacity
Printed at the top of each data entry sheet. If one fills up, move your rows to the Large edition, which opens more slowly.
Protection
It stops typing over formulas; it does not encrypt the file.
Privacy
No internet, subscription or account. Your data stays on your device and never reaches us.
Support
30 days from purchase, for a file that will not open or a calculation that contradicts the guide. Not data entry, customisation or updates.
Licence
One business.