Using Microsoft Excel to calculate Payroll Liabilities like PAYG, Medicare and Super

Excel Training Quick Tip


We recently created an Excel spreadsheet to demonstrate how to calculate the amount of PAYG, Super, Medicare levy and Flood Levy payable by a company for it’s employees based on an employees gross yearly income. It’s  an excellent example of using IF STATEMENTS and NESTED IF STATEMENTS.

You can change the gross annual income and watch all the other figures change automatically.

We’ll be using this information in our MYOB Payroll Training Course which will undergo a huge update this quarter. If you are a small business owner you can calculate your PAYG obligations on a spreadsheet and then enter the pay transaction as a journal entry or spend money in your MYOB software.

This Payroll, PAYG, Super excel file is now freely available to students of the Microsoft Excel Online Training Course, just log into Course 306 which covers IF STATEMENTS. Remember if you are an MYOB training course student you can enrol into our Excel training course for a discount. See the Course Outline for MYOB Day-to-Day (existing students only) for the details of how to claim your discount.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Mastering Xero with EzyLearn: Building Confidence Through Practical Learning

In today's digital landscape, proficiency in cloud-based accounting software like Xero is essential for professionals…

9 hours ago

Xero gives itself a 90% high distinction – users disagree

Have you seen the recent ads promotion 90+ % approval from their customers? The claims…

1 week ago

Intuit QuickBooks Course updates coming – features and navigation changes

Intuit is hunting for ways of helping their software become more relevant to Australian small…

2 weeks ago

Another price increase from Xero – 4 straight years of price increases sends social media mad?

It's interesting how negative the sentiment is on Linkedin and Facebook when you start seeing…

3 weeks ago

The election for accounting software is now on

Have you noticed the social media ads for Reckon, MYOB and Xero? It's 2 months…

1 month ago

What is the cheapest way to learn Xero and Microsoft Excel

Learning how to use Xero for specific tasks is easy. There are dozens of videos…

1 month ago