Price:
R598.00 (VAT Incl.)
Level:
Accounting Professionals
Sub-level:
Bookkeeping
Lecturer:
Ruzel Van Jaarsveld
Duration:
120 Minutes
Additionals:
R598.00 (VAT Incl.)
Level:
Accounting Professionals
Sub-level:
Bookkeeping
Lecturer:
Ruzel Van Jaarsveld
Duration:
120 Minutes
Additionals:
CPD Assessment
Certificate
Certificate
Lesson Outline
Tired of messy payroll spreadsheets and month-end confusion?
Join my practical webinar where I’ll show you how to build a complete payroll
system in Excel—from monthly worksheets to journals, reconciliations and
statutory dashboards.
Ideal for payroll admins, bookkeepers, HR and small business owners.
Topics Discussed:
Module 1 – Set up monthly worksheets
Module 2 – Salary control account reconciliation (12-month view)
Module 3 – Monthly journals
Module 4 – SARS dashboard
Module 5 – Journal import file
Module 6 – EMP501 interim and annual reconciliations
Module 7 – DOL UI-19 reconciliation
Module 8 – COIDA reconciliation
Module 9 – Full-year capture and reconciliation
Module 10 – Year-end close off and roll forward