
A short introduction on the course and myself
This lecture covers:
How to use Excel formulas to create a workday spreadsheet
This lecture covers:
How to use Excel formulas to create an automated leave day spreadsheet
This lecture covers:
How to use Excel formulas to create an automated timesheet
This lecture covers:
How to use Excel formulas to automatically calculate PAYE deductible from the employee's salary
Income Tax Brackets for the 2020/2021 financial year
Rebates for the 2020/2021 financial year
This lecture covers:
How Excel formulas can be used to automatically calculate the amounts of UIF, SDL and PAYE that need to be submitted and paid over to SARS
This lecture covers:
ETI calculations
Who qualifies for ETI
A basic Excel structured Payroll course, to teach you the basics of payroll, as well as to provide you with the tools needed to edit and create your own personalized Excel Payroll workbook.
The workbook is structured in an easy and user friendly manner, to facilitate learning and personalization.
This course is best suited for:
Start-up business owners, who cannot afford expensive payroll packages or extra help in the office
Persons who consider pursuing a career in payroll administration and /or bookkeeping
Beginner payroll administrators and /or bookkeepers; and
Students
Please note that the information used during this course may differ from company-to-company, and was only used as sample data. It is your responsibility to make sure that you use the information relevant to your specific needs. Two sources of information has been provided in the introduction video, which will assist you in determining the data that applies to your business.