Human Resources and Payroll Specialist

Salary from gross to net, employee file and attendance, payroll in Excel, labor law and insurance, and end of service in Egypt, Saudi Arabia, the UAE, the Gulf, Jordan, and the Maghreb.

إعداد المادة العلمية : محاسب/ محمد عبدالرزاق

هندسة صوتية : علي قنعان

انيميشن ورسوم : ايمان خليفة

إخراج فنى : م/محمد كريم

HR & Operations Management7h 44m45 lectures8 sections

What you'll learn

  • Understand the parts of a salary from basic pay to net
  • Organize the employee file and the contract in Odoo
  • Follow attendance, overtime, leave and absence
  • Build the payroll sheet in Excel and reconcile it
  • Calculate insurance and payroll tax in Egypt
  • Work with wage protection, Mudad and Qiwa in Saudi Arabia
  • Understand the SIF file and pensions in the Emirates
  • Calculate the end-of-service award and close the month

About this course

This course explains the work of a human resources and payroll specialist from scratch, walking with you alongside one employee from the first working day to the last. It starts with the specialist's role, the employee journey and the monthly calendar, then the full salary: from basic pay to gross to net, the employer's cost and the payslip. After that you build the employee file and the contract, register the employee in the Odoo program, follow attendance, overtime, leave and absence, then build the payroll sheet in Excel through to net pay and reconciliation. Then Egypt: social insurance, payroll tax, the annual settlement, resignation and final clearance. Then Saudi Arabia: the labor law, insurance, the wage protection file, Mudad and Qiwa, localization and the end-of-service award. Then the Emirates: the contract, the SIF file, pensions and end of service. You finish with Kuwait, Qatar, Bahrain, Oman, Jordan, Morocco, Tunisia and Algeria, and a full practical month from closing to payment, entries and review. The course suits people working in human resources, accountants and small business owners. By the end, you will be able to prepare a full monthly payroll and calculate an employee's rights at the end of service.

Expected outcomes

  • - Prepare a complete monthly payroll from attendance to disbursement
  • - Understand labor and insurance laws in 10 Arab countries
  • - Accurately calculate employee rights upon leaving the job
  • - Close the month, record the entry, and review before disbursement

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.

No reviews yet.

Course content

1

البداية: الأخصائي والراتب من الأساس

5 lectures
  1. المقدمةPresents the payroll and HR specialist course, from the shared foundation to Egypt, Saudi Arabia, the UAE and other Arab countries, building a payroll sheet in Excel and closing a full month.4:05
  2. الأخصائي ورحلة الموظف والتقويم الشهريExplains the payroll specialist's role and the employee journey from joining to exit, computing length of service and probation days, and the monthly calendar for closing changes, paying salaries and authority deadlines.10:32
  3. الأدوات والسرية والدقةIntroduces the payroll specialist's tools: HR software, Excel and government portals, along with confidentiality, accuracy and review habits, and differences in the profession between Egypt, Saudi Arabia and the UAE.10:10
  4. من الأجر الأساسي إلى الإجماليExplains moving from basic pay to gross pay, the difference between fixed and variable pay, the thirty-day month rule, and computing pay for an employee who starts mid-month.10:46
  5. من الإجمالي إلى الصافي وتكلفة صاحب العمل وقسيمة الراتبExplains going from gross to net pay through deductions, the employer's cost including its insurance share, loan installments and their cap, and building and reconciling the payslip.10:55
2

ملف الموظف والحضور والإجازات

4 lectures
  1. ملف الموظف والعقد وأنواعهExplains the employee file and employment contract types, fixed-term and open-ended, writing pay in itemized form, explicit and implicit renewal, tracking contract end dates, and organizing the data in Excel.10:30
  2. بطاقة الموظف والعقد على برنامج OdooExplains entering an employee card and contract in Odoo, writing each pay item in its own field and comparing the total with the contract, date reminders, and protecting personal data.10:29
  3. سجل الحضور وساعات العمل والإضافيExplains the attendance log, working hours, weekly limits and breaks, computing hourly pay and overtime with its multiplier, and why overtime is compared day by day against the shift rather than the weekly total.10:52
  4. الإجازات والغياب وإقفال الحضور قبل الراتبExplains annual and sick leave and balances, absence deductions, and closing attendance before payroll, with anything after the cut-off day moving to the next month's pay.10:03
3

كشف الرواتب على Excel

2 lectures
  1. كشف الرواتب على Excel - البيانات والمتغيرات والإجماليBuilds a payroll sheet in Excel from fixed data and variables to gross pay, using sum and IF formulas for absence deductions and rounding, and avoiding stale figures carried over from the previous month.10:54
  2. كشف الرواتب على Excel - الاستقطاعات والصافي والمطابقةCompletes the Excel payroll sheet with deductions and net pay, a settings sheet, anchoring cells with the dollar sign when copying formulas, and reconciling totals two ways before delivery.10:54
4

مصر: قانون العمل والتأمينات وضريبة المرتبات

10 lectures
  1. مصر - العقد والتجربة والساعات والإضافيExplains Egypt's new labor law: the employment contract in four copies, the probation period and its cap, working hours and rest, overtime pay with day, night and rest-day multipliers, and how public holidays differ.10:27
  2. مصر - الإجازات والأجر وحدود الاستقطاعExplains under Egyptian labor law leave balances and casual leave, the minimum wage and periodic raise, limits on wage deductions and disciplinary penalties, then computes them with Excel formulas.10:20
  3. مصر - أجر الاشتراك والحدود والنسبExplains how the insurable wage is set for social insurance in Egypt and what it includes, the minimum and maximum limits and their yearly update, and calculating employee and company shares in Excel, with common mistakes.10:23
  4. مصر - حساب التأمينات والاستمارات والسدادExplains calculating social insurance for each employee in Egypt step by step in Excel, then the forms and their deadlines, payment of contributions, penalties for late payment and non-registration, and matching the sheet to the receipt.10:39
  5. مصر - من الإجمالي إلى الوعاء والشرائحExplains calculating payroll tax in Egypt from gross income to the taxable base, then the personal exemption, the tax brackets and rounding of the base, building it in Excel and avoiding the mistake of applying a bracket rate to the whole base.10:40
  6. مصر - حساب ضريبة المرتبات شهرا بشهرExplains calculating payroll tax in Egypt month by month for a fixed wage, the cumulative method when pay changes, mid-year joiners, and the martyrs' fund deduction, with the sheet built in Excel.10:34
  7. مصر - بوابة التأمينات ومنظومة المرتباتExplains working with Egypt's insurance portal and payroll tax system: who logs in, what is submitted and when to pay, registering a new employee, the monthly form, and matching the expected contribution with the authority and the bank.10:40
  8. مصر - رفع الملف ونموذج 4 والتسوية السنويةExplains uploading the monthly payroll file to Egypt's tax system, remitting the tax and its deadline, the quarterly Form 4, the annual settlement, and matching template totals to the payroll sheet before sending.10:49
  9. مصر - الاستقالة والإخطار والفصلExplains how employment contracts end in Egypt, the notice period, calculating compensation, service award and notice pay, absence-based termination, with the calculation in Excel and avoiding early rounding.10:10
  10. مصر - حساب الشهر الأخير والمخالصةExplains the final month calculation for a leaving employee in Egypt: leave balance, final month tax, Form 6 to end insurance, and the settlement document, built in Excel and avoiding paying leave out of the payroll.10:13
5

السعودية: نظام العمل والتأمينات وحماية الأجور

12 lectures
  1. السعودية - العقد والتجربة والساعاتExplains reviewing an employment contract in Saudi Arabia: the labor law and wage types, the contract and its registration, the probation period and its cap, working hours and rest, and calculating actual and daily wage in Excel.10:40
  2. السعودية - الإضافي والإجازات والأجر والإنهاءExplains under Saudi labor law how overtime pay is calculated, sick and unpaid leave, limits on wage deductions, and end-of-contract compensation, applied in Excel with a fix for a common overtime mistake.10:42
  3. السعودية - الأجر الخاضع والفروع والنسبExplains social insurance in Saudi Arabia: the subject wage, the branches of annuities, occupational hazards and SANED, employee and employer rates, their difference between old and new systems, and calculating them in Excel.10:38
  4. السعودية - غير السعودي والحد الأعلى وفاتورة الفرعExplains insurance for non-Saudi employees in Saudi Arabia, the maximum subject wage, and building the full branch invoice in Excel with one formula for all three systems, plus paying contributions and accounting for employee shares.10:32
  5. السعودية - تسجيل مشترك وتحديث الأجور على بوابة التأميناتExplains registering a new subscriber and updating wages on the Saudi insurance portal step by step, the subject wage fields, the two update methods, the mistake of entering the transport allowance, with matching in Excel.10:40
  6. السعودية - الاستبعاد والفاتورة الشهرية والغراماتExplains in Saudi Arabia removing a departed employee from insurance, reading and checking the monthly invoice, the payment deadline, calculating late penalties by months, violation fines, and matching the invoice in Excel.10:31
  7. السعودية - ملف حماية الأجورExplains the Wage Protection System in Saudi Arabia: paying wages through banks, building the wage file with header and employee lines, calculating net pay and its total in Excel, and common errors that make the bank reject the file.10:35
  8. السعودية - الرفع على مدد ونسبة الالتزامExplains uploading the wage protection file on the Mudad platform, processing statuses, the dashboard and compliance rate, payment and upload deadlines, and violation fines, with deadlines and fines calculated in Excel.10:25
  9. السعودية - توثيق العقد على قوى ونطاقاتExplains documenting an employment contract on the Qiwa platform in Saudi Arabia step by step, the Nitaqat program and its categories, contract data such as wage, leave and probation, and matching the contract wage to payroll in Excel.10:29
  10. السعودية - التوطين ورخصة العمل والمخالفاتExplains the Saudization ratio in Saudi Arabia and how a Saudi employee is counted by wage, nationals-only professions, the work permit, the violations schedule, and calculating the ratio and fines in Excel.10:41
  11. السعودية - حساب مكافأة نهاية الخدمةExplains calculating end-of-service award in Saudi Arabia: the full award at half wage then full wage, the resignation scale, cases entitling the full award, the mistake of using basic pay alone, built in Excel.10:33
  12. السعودية - كسور السنة والتسوية وحاسبة على ExcelExplains in Saudi Arabia calculating partial years in the end-of-service award, final settlement items and leave balance, payment deadlines, the lost-day error in computing service length, and building the award calculator in Excel.10:26
6

الإمارات: قانون العمل وحماية الأجور ونهاية الخدمة

6 lectures
  1. الإمارات - العقد والتجربة وأنماط العملExplains UAE labor law on the job offer and contract: reading offer terms, the probation period and ending the contract during it, work patterns, and the share of basic pay in total pay, calculated in Excel.9:58
  2. الإمارات - الساعات والإضافي والإجازات وإنهاء العقدExplains in the UAE working hours and calculating overtime from basic pay alone, leave, limits on wage deductions, contract termination and notice period, with the calculation in Excel.10:21
  3. الإمارات - حماية الأجور وملف SIF والمعاشاتExplains the UAE wage protection system and the SIF file with its control record and employee records and matching totals, then citizens' pension contributions under the old and new systems, and net pay in Excel.10:29
  4. الإمارات - راتب الاشتراك وتأمين التعطل والتوطينExplains in the UAE the pension contribution salary and its minimum and maximum limits, unemployment insurance premiums and benefits, the Emiratization contribution, with Excel calculation and avoiding the fixed-salary mistake.10:06
  5. الإمارات - حساب مكافأة نهاية الخدمةExplains calculating end-of-service gratuity in the UAE: eligibility conditions, last basic salary, days per year before and after the fifth year, the effect of unpaid days, built in Excel and avoiding calculation on total pay.10:26
  6. الإمارات - الحد الأعلى والاستقالة وحاسبة على ExcelExplains in the UAE the cap on end-of-service gratuity, the rule on resignation, payment timing and permit cancellation, the alternative savings scheme, with a gratuity calculator in Excel choosing the smaller of gratuity and cap.10:19
7

باقي الخليج والأردن والمغرب العربي

4 lectures
  1. الكويت وقطر - التأمينات والتقاعد وحماية الأجورExplains social insurance in Kuwait and Qatar: insurance branches, their caps and citizen rates, expatriate end-of-service award, working hours and overtime, wage protection, and calculating contributions and net pay in Excel.10:38
  2. قطر والبحرين وعمان والخليج في جدول واحدExplains overtime, insurance and expatriate award rules in Qatar, Bahrain and Oman, and brings the four Gulf countries into one settings table without adding amounts across currencies, with calculations in Excel.9:57
  3. الأردن والمغرب - الضمان الاجتماعي والضريبةExplains social security and income tax in Jordan with the cap, brackets and personal exemption, then Morocco's social security fund with its capped branches, calculated in Excel using the MIN and MAX functions.10:18
  4. المغرب وتونس والجزائر وأربع دول في ورقة واحدةExplains income tax in Morocco with the bracket table and deducted amount, then Tunisia with its brackets and solidarity contribution, Algeria with social security and the reduction, and gathers the four countries in one Excel settings sheet.10:14
8

شهر كامل تطبيقي

2 lectures
  1. شهر كامل - الإقفال والكشوف الثلاثةExplains closing the payroll month across three branches: the monthly calendar and legal deadlines, monthly variables, preparing the Cairo, Riyadh and Dubai payrolls, and matching net pay and the control record before sending.10:01
  2. شهر كامل - الصرف والقيد والتوريدات والمراجعةExplains the steps after closing: paying salaries, the balanced payroll journal entry with an insurance line covering both shares, remittances to authorities, and the month-end closing review, without adding different branch currencies.10:10

Production team

Mohamed Abdelrazek

إعداد المادة العلمية

Mohamed Abdelrazek

An accountant with a master's degree in accounting from Alexandria University, specializing in financial accounting and auditing. He focuses on simplifying accounting concepts and linking theory to practice, especially in preparing and analyzing financial statements.
442 views2 courses

هندسة صوتية

علي قنعان

انيميشن ورسوم

ايمان خليفة

إخراج فنى

م/محمد كريم

Related courses