Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Payroll Administration Basics on Excel - Short Course
Rating: 3.9 out of 5(45 ratings)
129 students

Learn Payroll Administration Basics on Excel - Short Course

User-friendly Payroll Administration Excel spreadsheets
Last updated 5/2020
English

What you'll learn

  • How to use Excel Spreadsheets to keep accurate and up-to-date Payroll records

Course content

1 section7 lectures32m total length
  • Introduction1:40

    A short introduction on the course and myself

  • Part 1 - Workday Tracker Spreadsheets2:10

    This lecture covers:

    • How to use Excel formulas to create a workday spreadsheet

  • Part 1 - Workday Tracker Spreadsheets
  • Part 2 - Leave Day Worksheet8:46

    This lecture covers:

    • How to use Excel formulas to create an automated leave day spreadsheet

  • Part 2 - Leave Day Tracker
  • Part 3 - Timesheets, Salaries /Wages and Deductions9:29

    This lecture covers:

    • How to use Excel formulas to create an automated timesheet

  • Part 3 - Timesheets, Salaries /Wages and Deductions
  • Part 4 - PAYE Data Sheet6:30

    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

  • Part 4 - PAYE Data Sheet
  • Part 5 - EMP201 Information2:03

    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

  • Part 5 - EMP201 Information
  • Part 6 - ETI1:30

    This lecture covers:

    • ETI calculations

    • Who qualifies for ETI


  • Part 6 - ETI

Requirements

  • Basic Bookkeeping / Payroll knowledge

Description

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.

Who this course is for:

  • Start-up Business Owners
  • Payroll Administrators
  • Junior Bookkeepers
  • Financial Administrators
  • Payroll Students
  • Bookkeeping Students