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.
Module 1 – Set up monthly worksheets
Create a consistent structure for each month in the financial year so data captures the same way every month.
Module 2 – Salary control account reconciliation (12-month view)
Build 12 worksheets (or a consolidated control sheet) to reconcile payroll totals to a salary control account over the full year.
Module 3 – Monthly journals
Set up journal templates that pull totals automatically from each month’s worksheet—ready for accounting entries.
Module 4 – SARS dashboard
Build a SARS dashboard to reconcile payroll taxes to relevant entities, including PAYE, UIF and SDL using clear monthly and YTD views.
Module 5 – Journal import file
Create an Excel-based journal import format to upload into bookkeeping software, reducing manual posting errors.
Module 6 – EMP501 interim and annual reconciliations
Set up reconciliation tools for EMP501 interim and annual submissions, including cross-checking totals to payroll and statutory accounts.
Module 7 – DOL UI-19 reconciliation
Create a UI-19 data extract that pulls required fields from the monthly worksheets into a separate reconciliation tab for Department of Labour reporting.
Module 8 – COIDA reconciliation
Set up a COIDA reconciliation sheet that pulls earnings/classifications from worksheets and supports annual COIDA preparation.
Module 9 – Full-year capture and reconciliation
Capture payroll data for 12 months and reconcile the salary control account for the year using the Excel system you built.
Module 10 – Year-end close off and roll forward
Close the workbook properly, lock down the year, and create a clean template to start again for the next year.
• Set up a full 12-month payroll workbook
• Reconcile a salary control account for the year
• Create monthly journals + a journal import file for bookkeeping software
• Build a SARS dashboard (PAYE/UIF/SDL)
• Set up EMP501 interim & annual reconciliations
• Prepare UI-19 and COIDA reconciliation sheets
• Close off and roll forward for the next year
Ideal for payroll admins, bookkeepers, HR and small business owners.
