Saudi_Payroll_Template_معاينة.xlsx

	B	C	E	F	H	I	K	L
1	Payroll Dashboard
2	Example Trading Co. • Payroll for 10/2026
3
4	Employees		Total Gross Pay		Net Pay Transferred		Total Company Cost
5	10		134,725.00		125,899.99		145,637.51
6	10		134,725.00		125,899.99		145,637.51
7
8	GOSI – Employer		GOSI – Employee Deductions		Total Overtime		Total EOS Settlement
9	10,912.51		8,475.01		2,250.00		241,733.61
10	10,912.51		8,475.01		2,250.00		241,733.61
11
12	Saudization Indicator (Nitaqat)
13
14	Saudi Employees	6	✔ Company meets the required %				Female Employees
15	Non-Saudi Employees	4					3
16	Count Used	6.00					3
17	Actual Saudization %	60.00%	ℹ The required % varies by company activity and size. Saudi women and people with disabilities may count with extra weight – for the most accurate result, enter the «Weighted Saudi count» and your official % from Qiwa in the Settings sheet.
18	Required %	30.00%
19	Gap	+30.00%
20
21	Breakdown by Department, Nationality & Gender
22	Department	Employees	Gross Pay	Company Cost	Nationality	Count	Gender	Count
23	Management	1	25,000.00	27,700.00	Saudi	6	Male	7
24	Finance	1	13,875.00	15,375.00	Non-Saudi	4	Female	3
25	Human Resources	1	12,050.00	13,484.38
26	Sales	2	28,750.00	31,965.63
27	Operations	1	11,550.00	11,750.00
28	IT	1	15,437.50	15,712.50
29	Customer Service	2	17,800.00	19,200.00
30	Procurement	1	10,262.50	10,450.00
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100