Payroll register in Saudi Arabia: what it is and how to prepare it, step by step (free Excel template)

Payroll register in Saudi Arabia: what it is and how to prepare it, step by step (free Excel template)

Published By

Issam Siddique
Human Resources
Nov 19, 2026

About the author: Issam Siddique is Chief Sales Officer at HAL Simplify. The rules in this guide were checked against GOSI's published guidance and the Saudi Labour Law in November 2026.

In short: a payroll register is the monthly sheet that shows, for each employee, what they earned (basic salary, allowances, overtime), what was deducted (GOSI, absence, loan instalments) and their net pay. It is reviewed and approved before salaries are paid and the wage file is uploaded to Mudad. To prepare one: fix the period, update employee data, collect attendance and adjustments, calculate earnings and then deductions, review and approve, then pay, upload the WPS file and post the journal entry.

It is the last working day before payday, close to five o'clock. Attendance has arrived from supervisors in three files, overtime hours in a WhatsApp message, and a new employee's loan instalment is not recorded yet. The finance manager is waiting to approve, and the bank is waiting for the file.

Most payroll errors don't happen in the arithmetic. They happen earlier: an attendance figure copied wrongly, an allowance nobody updated, a GOSI deduction worked out on last year's salary. This guide puts the work into seven steps, gives you a worked example with real numbers, and an Excel template that does the calculation for you.

What is a payroll register?

A payroll register (also called a payroll sheet or salary register) is a table prepared every month, with one row per employee and one column per pay item. For each employee it answers three questions: how much they earned this month, how much is deducted, and how much reaches their account.

It does three jobs in the company:

  • Approval document: someone reviews and signs it before any money moves.
  • Source of the wage protection file: the file uploaded to Mudad is produced from it.
  • Source of the journal entry: salary expense, GOSI and payables are posted from it.

What a payroll register contains

What a payroll register contains: employee data, fixed earnings, variable earnings, deductions, net pay and employer cost
The six column groups of a monthly payroll register.
GroupColumnsNote
EmployeeEmployee number, name, nationality, ID or iqama, department, IBANNationality decides how GOSI is calculated
PeriodMonth, start and end date, days workedFor joiners and leavers during the month
Fixed earningsBasic salary, housing, transport, other allowancesAs in the contract
Variable earningsOvertime, commission, bonusNeed monthly approval
DeductionsEmployee GOSI share, absence, loan instalments, otherWithin Labour Law limits
Net payTotal earnings − total deductionsThe amount transferred to the employee
Employer costEmployer GOSI shareNot in the employee's net, but a cost to the company
ApprovalPrepared by, reviewed by, approved by, dateThe audit trail

Payroll register vs payslip vs wage protection (WPS) file

Payroll registerPayslipWPS file (Mudad)
CoversAll employees, one monthOne employee, one monthAll employees, one month
ForFinance and HR, to review and approveThe employeeMudad and the bank
DetailEvery item, deductions and employer costThe employee's items and net payThe payment data, in the format the platform requires
OrderPrepared and approved firstProduced from the approved registerProduced from the approved register

The simple rule: the register is the master. The payslip and the WPS file are copies of it for two different readers. If the register is right, both are right.

How to prepare a payroll register in 7 steps

How to prepare a payroll register in 7 steps: fix the period, update employees, collect inputs, earnings, deductions, review and approve, pay and post
The seven steps of a monthly payroll register.

1. Fix the payroll period and the cut-off

Agree a fixed period: the calendar month, or the 16th to the 15th of the next month, which many companies use to leave time to collect attendance. Set a clear cut-off date. Any attendance or change that arrives after it goes into next month's payroll. A cut-off prevents most last-minute mistakes.

2. Update employee data

Before calculating anything, review what changed since the last payroll:

  • new joiners and their start dates;
  • leavers and their last working day (their final settlement is a separate run);
  • approved salary and allowance changes;
  • each employee's IBAN and bank;
  • nationality, and for Saudi employees the date they were first registered with GOSI (before or after 3 July 2024), because contribution rates differ.

3. Collect the month's inputs

From attendance: unauthorised absences, and lateness if your policy deducts it. From leave: unpaid leave. From managers: approved overtime hours, commission and bonuses. From finance: loan and advance instalments. Ask for every input in writing and approved. Don't accept a figure given verbally.

4. Calculate earnings

  • Fixed: basic and allowances as in the contract. For someone who joins or leaves during the month, pro-rate by days worked.
  • Overtime: Article 107 of the Labour Law requires the employer to pay, for each overtime hour, the hourly wage plus 50% of the basic hourly wage. Most companies get the hourly wage by dividing the monthly wage by 30 days and then by 8 hours.
  • Commission and bonuses: the approved amount.

5. Calculate deductions

How GOSI is calculated in the payroll: basic plus housing, SAR 1,500 to 45,000, Saudi 9.75% and 11.75%, new-law Saudi 10.75% and 12.75% from July 2026, non-Saudi employer 2%
GOSI rules used in the payroll register and the Excel template.
  • GOSI: calculated on basic salary plus housing allowance, with a floor of SAR 1,500 and a ceiling of SAR 45,000 a month (per GOSI). The rates depend on the employee's group (see the table below).
  • Absence: the daily wage × unauthorised days absent. Most companies take the daily wage as the monthly wage ÷ 30.
  • Loan instalments: recovery of an employer loan may not exceed 10% of the employee's wage (Article 92).
  • Overall cap: total deductions may not exceed 50% of the wage due without a court decision (Article 93), and Mudad raises an alert when they do.
Employee groupEmployee shareEmployer shareNotes
Saudi, first registered before 3 July 20249.75%11.75%9% annuities + 0.75% SANED; employer also pays 2% occupational hazards
Saudi under the new Social Insurance Law (first registered from 3 July 2024)10.75%12.75%From 1 July 2026. The annuities rate rises 0.5% every 1 July, to 11% each by 2028. Commission and percentage-of-sales pay count toward the contribution wage
Non-Saudi0%2%Occupational hazards only

Any other deduction needs the employee's written consent.

6. Review and approve

Separate the person who prepares the payroll from the person who approves it. Before approving, compare with last month: headcount, total payroll and the ten largest changes. Every change should have a known reason (a joiner, a raise, overtime). Then the HR manager approves the data and the finance manager approves the amounts.

7. Pay, upload the WPS file and post the entry

After approval: transfer salaries through the bank, upload the wage protection file to Mudad, send payslips, post the journal entry and file the approved register with its supporting documents. Mudad tracks late salaries and unusual wages, so pay on time and pay the amounts registered in the contracts.

Worked example: October payroll for two employees

An illustrative example for a trading company in Riyadh. The figures are made up.

Payroll register worked example: Saudi accountant net 9,835, non-Saudi sales rep net 7,450, company cost SAR 20,060
From earnings to net pay and company cost, in SAR.

Employee 1: Saudi accountant (registered with GOSI before July 2024). Basic 8,000, housing 2,000, transport 800. Worked 6 approved overtime hours and was absent one day without leave.

Employee 2: non-Saudi sales representative. Basic 5,000, housing 1,250, transport 500. Commission 1,200 and a loan instalment of 500.

ItemAccountant (Saudi)Sales rep (non-Saudi)How
Basic salary8,0005,000contract
Housing allowance2,0001,250contract
Transport allowance800500contract
Overtime370—6 × (45.00 + 16.67)
Commission—1,200approved
Total earnings11,1707,950
Absence deduction360—10,800 ÷ 30 × 1
GOSI (employee share)975—9.75% × 10,000
Loan instalment—500below 10% of wage
Total deductions1,335500
Net pay9,8357,450
GOSI (employer share)1,17512511.75% × 10,000 / 2% × 6,250

How the overtime was worked out:

  • Hourly wage = 10,800 ÷ 30 ÷ 8 = SAR 45.00.
  • Basic hourly wage = 8,000 ÷ 240 = 33.33, and half of it is 16.67.
  • Overtime rate = 61.67 per hour × 6 hours = SAR 370.

The sales rep's GOSI is calculated on basic plus housing (6,250) at 2%, paid by the employer alone.

Totals:

  • total earnings: 19,120;
  • net transferred: 17,285;
  • employer GOSI: 1,300;
  • so the payroll costs the company SAR 20,060.

The payroll journal entry

AccountDebitCredit
Salaries and wages expense (19,120 − 360 absence)18,760
GOSI expense (employer share)1,300
GOSI payable (975 + 1,300)2,275
Employee loans500
Salaries payable17,285
Total20,06020,060

On the bank transfer: debit salaries payable 17,285, credit bank 17,285. If journal entries are new to you, see debits and credits explained with examples.

Checklist before you approve the payroll

Payroll deduction limits in Saudi Arabia: loan instalment up to 10%, total deductions up to 50%, overtime under Article 107, absence at monthly wage divided by 30
The limits the Excel template checks for you.
  • Headcount in the register = active employees (joiners added, leavers removed).
  • Every salary or allowance change has an approved decision.
  • Attendance and overtime are approved by the line manager.
  • GOSI is calculated on basic + housing (plus commission for new-law Saudis), between SAR 1,500 and 45,000.
  • The GOSI rate is right for each group: Saudi before July 2024, Saudi after, non-Saudi.
  • No loan instalment is above 10% of the wage, and total deductions are not above 50%.
  • Every IBAN is correct.
  • Changes from last month are explained.
  • Net pay total in the register = bank transfer total = WPS file total.

Common payroll register mistakes

  1. GOSI on the gross salary. Transport allowance is not part of the contributory wage. Commission counts only for employees under the new Social Insurance Law.
  2. Forgetting joiners and leavers during the month. A partial month is paid by days.
  3. Overtime on basic only, or on gross only. Article 107 combines the two: the hourly wage plus half the basic hourly wage.
  4. A loan instalment above the limit, or deductions adding up to more than half the wage.
  5. Editing the register after approval without re-approving it.
  6. Figures that don't match between the register, the bank transfer and the Mudad file.

Is Excel enough, or do you need payroll software?

Excel is enough when headcount is small and the inputs are simple, as long as the formulas are protected and someone other than the preparer reviews the register. You start to need a system when manual copying piles up: attendance from biometric devices, loans in instalments, different GOSI groups, settlement and leave runs, multi-level approvals. At that point copying figures between files becomes the biggest source of errors.

If you've reached that point, take a look at HAL payroll software. It builds the register from recorded attendance and loans, sends it for approval and posts the entry to the ledger.

How to prepare the payroll register in HAL ERP

  1. Attendance: approve employee absences for the month.
  2. Pay adjustments: enter and approve overtime, bonuses and deductions.
  3. Generate payroll: choose the month and the account salaries are paid from, and payslips are created for every employee. Review them, re-run the payroll if something needs correcting, then approve it, which posts the accounting entries.
  4. Payslips: print payslips for everyone or for one employee.

Loan instalments are deducted automatically. Step-by-step screens are in the Basic steps for running payroll guide in the HAL Knowledge Base. For a leaver's final dues, use the end of service calculator.

Download the payroll register template (Excel), free

Free Excel template
HAL payroll register template (Saudi Arabia)
Earnings, overtime, absence, GOSI by employee group, loan and deduction limits, net pay, employer cost and the journal entry. English and Arabic. No sign-up.
Download the template (.xlsx)

The template:

  • calculates earnings, overtime, absence and GOSI by employee group;
  • applies the loan and deduction limits;
  • gives you net pay, employer cost and the journal entry.

GOSI rates, days in the month and working hours sit on the Settings sheet, so you can match them to your company. Example rows are marked; delete them and enter your own employees.

Frequently asked questions

What is a payroll register?

A monthly sheet showing each employee's earnings, deductions and net pay. It is reviewed and approved before salaries are paid and the wage protection file is uploaded.

Is the payroll register the same as the WPS file?

No. The register is the complete internal sheet the company approves. The wage protection file is produced from it, in the format required for upload to Mudad.

How is GOSI calculated in the payroll?

On basic salary plus housing allowance, between SAR 1,500 and 45,000 a month. For a Saudi registered before 3 July 2024: 9.75% from the employee and 11.75% from the employer. For a Saudi under the new law (registered from 3 July 2024): 10.75% and 12.75% from 1 July 2026, rising 0.5% each year to 2028, with commission included in the wage. For a non-Saudi: 2% from the employer only.

How is overtime calculated in Saudi Arabia?

Under Article 107: the hourly wage plus 50% of the basic hourly wage, for each overtime hour.

What is the maximum deduction from an employee's salary?

Total deductions may not exceed 50% of the wage due without a court decision. Recovery of an employer loan may not exceed 10% of the wage.

How is an absence deduction calculated?

The daily wage times the days of unauthorised absence. Most companies take the daily wage as the monthly wage divided by 30.

Can I prepare the payroll register in Excel?

Yes, for small companies with simple inputs, with protected formulas and a second person reviewing. The free Excel template above calculates the register and applies the Labour Law limits.

Issam Siddique