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.
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.
An industry association membership may be just what you need
Joining an industry association can help towards things like CPD points, but it pays to make sure you’re getting market rate for any courses and that the ongoing fees are of benefit to you.
IF YOU LIKE BOOKKEEPING, but you’d like to provide additional services to your clients, the next step is to become a BAS agent. BAS agents provide businesses with a range of services, including the lodgement of business activity statements, registering and advice on all GST matters, assistance with PAYG, and a number of other services.
Association of Accounting Technicians — affiliate members must have Certificate IV in Financial Services or at least two years experience and no formal qualifications; membership fees: $295 for three months ($1,180 per year).
Australian Bookkeepers Network — no requirements to join; membership fees: $462 annually.
Institute of Certified Bookkeepers — Affiliate members must have Certificate IV in Financial Services or complete an ICB assessment; membership fees: $264 annually. (After achieving 12 months experience Affiliates can become Associate members; membership fees for contractors $432 annually.)
Other industry associations BAS agents can join, include:
Association of Chartered Certified Accountants ANZ
Chartered Accountants ANZ
CPA Australia
Institute of Public Accountants
New Zealand Institute of Chartered Accountants (NZICA)
Many associations run their own webinars and in-person seminars (for an additional fee), which count towards your CPD hours. (BAS agents must complete 45 hours of CPD over a three year period.) Some of them will help you with the running of your own bookkeeping business, while others will take you through new trends in bookkeeping (single touch payroll) or changes to the Act and relevant legislation.
Each time you complete a webinar or some other form of approved CPD training, it’ll be counted towards your CPD hours. You can also complete CPD training through an accredited training organisation. (Check with your industry organisation to see which training institutions you can learn with.)
Choosing an industry association
Not all industry associations are the same. Some are geared more towards the accounting industry (CPA, Chartered Accountants ANZ, etcetera) and accountants; others cater specifically to bookkeepers. Even within the group of associations that cater only to bookkeepers, some provide a range of services (updates on the industry, CPD training), while others offer very little (discounts on professional indemnity, a newsletter).
As the old saying goes, you get what you pay for. If you want to pay very little, you’ll get very little in return from your industry association. But that doesn’t mean you need to spend a lot either. Have a look at a few of the associations we’ve listed above, and see which one suits you best.
The Association of Accounting Technicians offers affiliate memberships, which provides affiliates with access to a number of discounted fees on training courses to help them develop their skills and progress to a “member” level membership — and then register as a BAS agent with the TPB at the reduced 1,000 hours of experience concession.
Join the Bookkeeping Academy for CPD Points
Industry Associations can offer discounts on professional indemnity insurance and bookkeeping journals and publications. And they offer a range of online webinars to help members get their CPD hours up but you just have to demonstrate continuing education to keep you your CPD requirements.
EzyLearn’s online training courses are accredited by BAS agents, accountants and bookkeepers — those we deem to be the industry’s “high water mark” for bookkeeping work. These people are the highest qualified individuals operating in the accounting and bookkeeping space. If they believe the content of our courses is genuinely of high quality and relevant to the bookkeeping world, then this is the accreditation that should give our students peace of mind.
I found the EzyLearn Xero course great — a comprehensive step-by-step learning tool to add to my resume and a new tool to use in my Bookkeeping Practice.”
— Patricia Darby Registered BAS Agent and Bookkeeper, High Quality Bookkeeping
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. 
