Building a Payroll System in Excel Self-Study Course

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:

• Set up monthly worksheets
• Salary control account reconciliation (12-month view)
• Monthly journals
• SARS dashboard
• Journal import file
• EMP501 interim and annual reconciliations
• DOL UI-19 reconciliation
• COIDA reconciliation
• Full-year capture and reconciliation
• Year-end close off and roll forward