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.
I RECENTLY SPOKE WITH the owner of a hairdressing salon who’s been in business for over 18 years (at various different businesses). This woman has ALWAYS used a manual wages timesheet system.
Our team are exploring typical rosters and problems which occur in the payroll processing, and as such, we’re also exploring all the different ways that wages are managed.
We feel your pain! Often businesses lack the cash flow to make super payments, but you always have to pay them in the end…
WHEN YOU’RE SELF EMPLOYED you are responsible for managing your taxes and your superannuation — the latter of which many business owners let go by the wayside. It’s almost always because they don’t have the cash reserves to contribute to their super fund regularly enough.
Just as you would create a budget to make a business investment or asset purchase, you can use Xero and Excel to determine how much super you should contribute on your behalf, and then make the payments.
Run a cashflow report
You’ll learn how to run a cashflow report in our Xero training courses. This report will show you the periods when cashflow is liquid and when it isn’t. Run a cashflow report for a couple of different periods, and export them into Excel. This will give you a better idea of trends and cycles in your business.
You can also use a cashflow report to determine your income before taxes, expenses, and so forth. Superannuation is determined based on gross earnings — or revenue — so you should use this figure to work out your super contributions. This is especially important before end of financial year!
Determine super contributions
At time of writing, the superannuation guarantee is 9.5 percent of your gross revenue, before taxes, expenses, etc. If you set your prices correctly, you should have already factored this 9.5 percent into your prices or hourly rate. If you haven’t, you ought to consider revising what you charge customers and clients.
If you were an employee of a business, your employer would be required to make super contributions on your behalf, at least each quarter. Because you’re self-employed and self-managing your super contributions, you can make them as frequently or infrequently as you like, so long as you’re contributing the correct amounts. (Speak to your accountant or financial advisor, however, if you’re salary sacrificing above the minimum amount — this may affect your tax.)
Make super contributions
Once you’ve determined how much you should contribute to your super fund each quarter, refer back to your cashflow report and to the periods where your cashflow is especially liquid. Are you able to make your contributions each quarter easily, and without compromising your business’s liquidity? Would it be easier to make smaller, more regular contributions?
The decision is yours.
Use Xero to make your super contributions. Xero is connected to a superannuation clearing house, and if you’ve been using to Xero to pay yourself a wage, it’s the easiest way to do so. If you’re not using your accounting software to pay yourself a wage, you can make the payment directly out of your bank account, however, you’ll need to track this in Xero for taxation purposes.
***
Our Xero training courses will show you how run cashflow reports and make wage and super payments, while our Excel training courses will also teach you how to create business budgets and forecasts. Visit our website for more information.
Don’t get lumped with penalties when you don’t need to!
It’s not only frustrating and disheartening, but a waste of business funds to be penalised for lodging your financials too late.
A LOT OF SMALL BUSINESSES have trouble managing their payroll, especially when they only have a few employees and paying to access a payroll system in their accounting package is an unnecessary expense. You’ll learn how to use Excel to manage your PAYG and super contributions in our Intermediate Microsoft Excel Training Courses. However, sometimes you may have a backlog of PAYG and super payments. Let’s take a look at how to manage these.
For businesses that only withhold up to $25,000 each year, you’re supposed to make PAYG payments and file a withholding report each quarter. You have 28 days from the end of the quarter to do so, after which time, you may incur a Failure To Lodge (FTL) penalty.
Superannuation payments
As with PAYG payments and reporting, you can also incur a FTL penalty for not lodging or paying your employees’ superannuation contributions in time. All businesses, regardless of size, have to make superannuation payments each quarter — the ATO sets out the due dates for each period on their website.
Lodging late PAYG and super payments
The ATO only applies penalties for failure to lodge reports or make payments for each period of 28 days (or part thereof) that a document or payment is overdue. Each period incurs one penalty unit for each document, up to a maximum of five penalty units.
From 2015 onwards, the value of a penalty unit is $180 (previously it was $170) for small businesses, which are defined as entities with an assessable income or GST turnover of no more than $1 million a year.
The maximum penalty a small business will pay is $900 for each document or payment that is overdue. Note too that FTL penalties will also incur a general interest charge (GIC), applied on top of the penalty.
Managing late PAYG and super payments
Use the Ad Hoc Payroll Guide, a new case study that is included in our Intermediate Microsoft Excel Training Coursesto determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel. Once you’ve worked out the required amounts (visit the ATO website for tax tables prior to 2017), lodge the necessary PAYG payments and reports to the ATO; pay super contributions using the SuperStream super clearing house.
The ATO will write to you if you are required to pay a penalty — sometimes they are waived for first-time offences, or if the amounts are small.
Create brilliant presentations and graphics for all kinds of business purposes.
Gone are the days of excruciatingly dull PowerPoint slide presentations. Nowadays PowerPoint is the hidden gem used to generate animations, videos, movies, advertising and graphics. It’s a great ally to the marketer or social media person in your organisation.
This creative program can also be used to conjure up the most beautiful and modern pictorial slides to enhance any presentation or induction. Find out more about our 2016 version PowerPoint courses.
Third Quarter is Looming; Are You Up to Date with Payroll?
Most businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense.
Every Australian business with employees who are each paid more than the tax-free threshold has a legal obligation to withhold tax on their employees’ behalf. This is known as the PAYG System (or Pay As You Go), where amounts of tax are withheld from each employee’s wage payments.
Businesses that withhold up to $25,000 each year only need to make payments to the ATO each quarter; businesses withholding amounts greater than $25,001 may have to make payments to the ATO each month or as regularly as each week.
At the time of writing, the tax-free threshold is currently $18,200, which is equivalent to:
$350 a week
$700 a fortnight
$1,517 a month
Superannuation contributions
Again, any business that pays its employees more than $450 each month must also make regular superannuation contributions on their employees’ behalf. We’ve written in the past about the government’s clearing house called SuperStream, which allows you to easily make super contributions — for free.
But first, you need to work out how much super you need to contribute for your employees. The superannuation guarantee is currently 9.5 percent of your employees’ gross wages, which is payable on top of their wages — not deducted out of.
Using tax tables to calculate wages
Each year, the ATO produces a range of tax tables to help you work out how much to withhold from payments you make to your employees. In our Ad Hoc Payroll Micro Course, we’ve already added the most current tax tables to the accompanying payroll spreadsheet, as well as the superannuation guarantee tables.
The MYOB Payroll Training Course is in stage two of development. The contents of our existing Payroll course give students an introduction to how to navigate around and get fundamental information about the payroll environment in the sample company file. As part of our constant improvement process we are developing payroll scenarios as exercises for our students. This new content when published will be available for all existing Payroll Students and all those who have enrolled with the LIFETIME training course Access option.
Which table to use?
The ATO release papers that provide you with the information you need to perform your calculations regarding PAYG, super etc. In this blog post we look at Schedule 1 Pay as you go (PAYG) withholding NAT 1004. If you take a look at table 7 on page (see diagram on this page) you’ll see the variables or what the Australian Tax Office call coefficients.
New Spreadsheet for Excel and MYOB students
One of our content creators is in the process of creating an Excel spreadsheet as a simple tool to help you work out how much PAYG tax and super you owe at the end of quarterly BAS reporting period. It’s a tool that we will offer both Microsoft Excel and MYOB Training Course students when it’s ready. And no, before you think of asking, it won’t cost you any extra money to receive it. It’s available as part of our LIFETIME student access.
A student took a look at our newly created Staff Payment, PAYG, Super spreadsheet file and they wanted to know which formulas are used in the spreadsheet. This is a great question because there are many ways that a spreadsheet like this can be created and we’ll explore these methods in the forthcoming month.
The secret to reveal formulas is the Tilde key at the top left of your keyboard. Simply press Ctrl + ` and all the formulas in the spreadsheet will be revealed. You can then work intelligently on your spreadsheet and make changes fully aware of where numbers are simply entered or where complicated formulas exist.
This is a tool that I use all the time when I am surfing and searching the Internet and I thought you’d be interested to learn about it.
My last post was about the new WordPress search field we implemented on our WordPress Employment Training Blog site but it occurred to me that you might like to use a great search tool you are already using – Google.
If you want to search for PAYG and Microsoft Excel information in our blog site, you simply need to type the following information into the Google search box:
payg excel site:ezylearn.com.au/wordpress
You will end up seeing results very similar to the image in this blog post. Notice that you:
Type the word site: before the domain name of the website you want to search
Don’t need to type www
Can search within sections of a website (ie. the /wordpress)
We’ve written over 200 blog posts since 2008 and we’ve found them to be very popular but some readers have mentioned that it is hard to go back and find ones that they were very interested in reading again so we’ve done something simple. Added a search box. I know, it seems simple but it took a reader to ask for us to implement it. Thank YOU 🙂
While we are on this topic, did you know that we use WordPress to manage our blog site? It’s a great blogging platform but even fantastic for just creating a normal website that you can edit and make changes to as you please. The best part is that it’s open source so effectively it’s free! All you have to do is learn how to use it and we have a course just for it, our WordPress Website Design Course and just like our MYOB Training Courses it comes with LIFETIME student access.
So, if you want to find out the blog post where we wrote about PAYG tax tables and how you can workout the taxes that you owe for employees doing a search for “payg excel” and you’ll come up with these results. See what else you can discover.
There are times when I wish we all had the choice to only upgrade our software if we wanted to!
Microsoft made us all do it by changing the “look and feel” of their Microsoft Office programs like Microsoft Excel and MYOB made us all doing it by putting the changes in PAYG tax tables in their update rather than leaving it in the core MYOB AccountRight software.
I had a few days off and decided NOT to take my laptop with me and gee that felt great!
When I came back my Inbox was full and my website was out of date! Some students messaged to say that the software was a bit different to the training material and the navigation of some of my apps had changed.
It’s normal these days to spend time just catching up on changes in your software, office procedures and prices!
We’re so used to paying subscription fees for everything today but not really owning anything. I was speaking with Brian from Spina Coffee Roaster in Morisset and he reminded me when small businesses could buy MYOB AccountRight and then only upgrade if they wanted too.
I recall the first subscriptions that MYOB introduced relating to Payroll tax tables. If the PAYG brackets or superannuation (covered in the MYOB Payroll Course) were changed by the Australian Government then you had to buy the upgrade from MYOB – even though it was a simple change of a couple of percentages in the software.
Now, most small businesses don’t even budge when they pay $1000pa for a Xero subscription!
Am I a bookkeeping nerd or is everyone else also seeing these “financial” advertisements for tax lodgement, easy bookkeeping and 6 month FREE access to accounting software?
It’s interesting to see a new accounting software company appear in Australia despite the fact that many have come and gone in the past – particularly during this market downturn for technology shares! Their offer is pretty compelling though..
Knowledge of payroll is an important skill for bookkeepers, accountants, business owners, and BAS agents. EzyLearn has payroll courses in multiple accounting software, but now we’re introducing a course that covers all of these payroll training courses in one place, and under one fee.
Xero Certification is designed for contract bookkeepers to increase the number of customers who use and support the software.
Like all “partner” programs offered by software vendors including MYOB and Intuit QuickBooks the purpose of these programs is to increase their “channel to market” but it may not always suit every student.
People working as payroll administration officers, or payroll administrators, can also work as bookkeepers, or even BAS agents, who specialise in payroll only; either within the payroll department of a business or accounting / bookkeeping firm.
Here are some common Payroll Administration tasks in a job description.
TSheets is a cost effective way to manage and track your time
TSheets, THE TIME MANAGEMENT SOFTWARE, is a great way for independent and remote contractors to manage their client’s projects. It’s especially useful for contractors who are collaborating remotely with other contractors and businesses on one project.
But back to TSheets. TSheets was recently acquired by Intuit, the parent company of QuickBooks. Both TSheets and QuickBooks shared 12,000 customers in common and the time management system had been developed to work specifically with QuickBooks. Deeper integration with QuickBooks can be expected now, following the acquisition.
If you were to think about the top three cloud accounting apps in terms of the types of businesses they appeal to, QuickBooks would appeal most to micro businesses and independent contractors. Check out an earlier blog post where we assess two main factors: User Experience & Ease of Use, and Reporting Tools in a comparison between MYOB and Quickbooks for small businesses.
Type the first 3 characters to discover courses, up-skilling programs and CPD articles.
EzyLearn's Career Academy
Enrolled into an EzyLearn course since 2013? Get access to new & updated course content and support by joining the EzyLearn Course Refresher Access membership Program. See how to extend your course life & support.
Xero is a great bookkeeping program for tradies who are on the go and using their phones (or a tablet) all the time. From receipts scanning to creating quotes and invoices, receiving payments and keeping track of project costs.
bookkeepercourse.com.au/produ…
EzyLearn Excel, MYOB and Xero online training courses count towards 
Most businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense. 
