Learn Xero in less than 5 days

Xero is complicated, let’s be honest. I know that Xero tell you the software is beautiful and simple to use but in reality it’s accounting software and if accounting software was easy then everyone would have their BAS’s lodged on time and have no credit risk issues.

It also depends on what kind of past experience you’ve had with accounting and bookkeeping work, but there is a way to up-skill in Xero quickly.

Continue reading Learn Xero in less than 5 days

Bookkeeping Basics: Payroll and Paying People

EOFY is nearly here — can you manage payroll?

woman studying myob payroll xero payroll quickbooks payroll online training courseIN OUR FREE, EDUCATIONAL GUIDE, Bookkeeping Basics, we feature a section that briefly discusses payroll, which we thought was worthy of being expanded upon on here. You might also like to go back and revisit our other blog post that complements the guide, Bookkeeping Basics: Cash vs. Accrual Systems, if you haven’t already.

Paying your employees

Before you employ staff, you need to determine how they will be employed. Are you going to use casual or permanent employees? If you’re employing the latter, will they be employed on a full-time or part-time basis? As the business owner and employer, you must also ensure that you’re paying your staff the correct rate of pay, as well as any entitlements — such as, sick leave, annual leave, overtime, etc — that may be owed to them.

This blog post isn’t going to go into the intricacies of how to work out what you should pay your employees, nor will the Bookkeeping Basics guide, as it generally falls outside the scope of the role of a bookkeeper, however, you can use the Fair Work Ombudsman’s (FWO) Pay Calculator to work out the following:

  • Base pay rates
  • Allowances
  • Overtime and penalty rates
  • Pay rates per hour
  • Pay rates per shift
  • An employee’s employment status (i.e., full time, part time, casual).

Record keeping

If you employ staff under a modern award or agreement (virtually all Australian businesses do), you have a legal requirement to keep accurate and correct time and wage records, in addition to issuing payslips to all of your staff — failure to issue pay slips incurs harsh penalties if it comes to the attention of the Fair Work Ombudsman. You must also keep your each staff member’s time and wage records for, at least, seven years and make sure they’re stored somewhere that’s always accessible, should they ever need to be inspected.

Although you don’t have to keep all employee records, it’s best practice to keep the following records for seven years, even after the employee has left the business, in case they ever file a complaint with the Ombudsman or the Tax Office ever does an audit:

  • Employee resume and application details
  • Employee workplace performance records
  • Employee trade certificates or registration certificates.

For tax purposes, all employee and contractor records must be kept for five years, but most businesses keep them for seven years, in case an enquiry is made by the FWO.

Deducting tax from an employee’s pay

Under the Pay As You Go (PAYG) withholding rules, you are legally obliged to collect tax from employee payments so they can meet their end-of-year tax liabilities. In order to do so, you must first register with the ATO for PAYG withholding, which you can do online, over the phone or through your BAS or tax agent.

You must also provide your employees with a tax file declaration form, which you can also obtain from the ATO, and must be completed by an employee if they want to:

  • Claim an entitlement to tax offsets by having a reduced amount withheld from payments made to them
  • Advise you of changes to their:
    • tax-free threshold
    • residency status
    • HELP, Trade Support Loan or Financial Supplement debt.

You must then determine how much to withhold your employee’s pay, which you can do by referring to the ATO’s Tax Tables or the Tax Withheld Calculator.

If you have staff that are under 18 years of age

You do not have to withhold amounts from payments to employees under 18 years of age if those amounts are not more than:

  • $350 per week
  • $700 per fortnight
  • $1,517 per month.

Employees with HELP, TSL or Financial Supplement debts

If an employee has indicated they have a HELP, TSL or Financial Supplement debt, you should use the HELP/TSL or Student Financial Supplement Scheme tax table on the ATO website to work out how much extra to withhold for these debts. Add this to the amount withheld shown in the relevant tax table.

Your superannuation obligations

As an employer, you also have an obligation to make super contributions for each of your employees. You must also ensure that you:

  • Offer eligible employees a choice of super fund (temporary residents are eligible to choose)
  • Pay the minimum amount, called the super guarantee (SG), which is currently 9.5 per cent of ordinary time earnings
  • Make your super contributions on the required dates as set by the ATO.

If you don’t pay the super guarantee for your employees, you will have to pay the super guarantee charge, which is not tax deductible.

Which employees are eligible for the SG?

Generally speaking, all employees are eligible if they are paid $450 or more (before tax) in any calendar month. You must pay super for all employees who:

  • Are full-time, part-time or casual
  • Receive a super pension or annuity while still working — including those who qualify for the transition-to-retirement measure
  • Are a temporary resident — when they leave Australia, they can claim the payments you made through a ‘departing Australia superannuation payment’
  • Are a company director
  • Are a family member working in your business — provided they are eligible for SG
  • Are over 70 years of age
  • Some contractors, even if they quote an ABN — visit the FWO website for more information.

Final things to consider

Not all bookkeepers offer payroll services, because it can be time consuming and it’s always in flux (new software enters the fray, employees come and go, and each time that occurs, it results in more work). Additionally, the minimum wage is regularly reviewed and increased, which is something that needs to be monitored to ensure your employees continue to be paid correctly. If you decide to hire a bookkeeper to manage your accounting, and you’d also like them to handle your payroll, be sure to clarify how they’ll bill for payroll services and what your obligations are to ensure you’re not paying too much.

We provide online training courses in Payroll for MYOB, Xero Payroll and Quickbooks. Find out more about our industry-endorsed online training courses and videos.

***  ***  ***

Need help managing your bookkeeping system?

the perfect administrative executive assistant office manager learn online courses trainingIf you’re looking for a reliable bookkeeper to manage your bookkeeping system, who also specialises in payroll services, is highly qualified, or even a registered BAS agent?

See our bookkeeping directory, National Bookkeeping, for more information on the hundreds of bookkeepers listed who are available to work all around Australia. 


Remember, you can download our educational guide, Bookkeeping Basics, for free from the EzyLearn website.


Online bookkeeping accounting training courses for CPD points

Find out more about Continuing Professional Development with EzyLearn


 

 

 

 

MYOB Launches Single Touch Payroll Trial Product

LAST WEEK, MYOB LAUNCHED a beta trial of its single touch payroll (STP) product, as it gears up for the July 1, 2018 compliance deadline.

Businesses with 20 or more employees need to have transitioned to the ATO’s Single Touch Payroll initiative by July.

Businesses with fewer than 20 employees have until July 1, 2019 to be compliant but for these small business owners and contractors the ATO has a new free app.  Continue reading MYOB Launches Single Touch Payroll Trial Product

Announcement: Updated Intuit QuickBooks Online Course (#522) Training Workbook

Intuit QuickBooks is gaining in popularity since MYOB made a false start in the online (cloud) accounting market. Their software is well priced and feature rich and now they can deal direct with Aussie businesses they’re always on special!

Just wanted to share with all current QuickBooks Online Training Course students that the Daily Transactions workbook is the latest training resource to be updated – so you’ll see 2018 screen shots in the step-by-step exercises.

Updates and Additions to Online Course Content

As a training course creator we spend a lot of time creating and updating our training materials and all existing students receive access to this material during their course access period. Learn more..

New Advanced Payroll Certificate Course

In case you missed it, these updates are on top of the New Advanced Payroll Training Course workbooks and videos we’ve created for the course.

 

 

 

How Are You Managing Rostering, Timesheet, Wages, PAYG, Super?

Manual Wages book and timesheet from the 1890's Cork City Archive - PAYG Super rosteringYou could use a wages book

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.

The manual wage processing that this hairdressing salon owner uses is very similar to this timesheet tracking system from the late 1890’s and she seems to be quite efficient at it. When I explore the process she uses I can see why business owners would prefer not to spend the money, but if things got busy or tricky and staff numbers are high and hours varied, then a computerised system is definitely more “systemised”.

Computerised Time Sheet Software

I wrote recently about popular time-tracking apps for Xero (also QuickBooks Online) and how they help you manage the time that you spend on various work projects as a professional service provider (like website design, marketing and even bookkeeping) and in the next couple weeks we’re going to explore time sheet management software like Tsheets and Deputy. Not only are they good for scheduling your staff but they can help you keep track of when they sign on and sign off for work.

I was recently talking with someone who uses Deputy as an employee and they described the experience like signing in on a bundy clock! The particular person I spoke to didn’t enjoy the regimen of doing it but it makes perfect sense from the business owners perspective so they have a very tight record of time worked.

Announcement: MYOB Payroll Course recently beefed up

EzyLearn has beefed up our MYOB Payroll online training courseIf you’re an existing EzyLearn student who is interested in learning more about the more advanced, more complex areas of Payroll you’ll be pleased to learn that we’ve created and implemented the Advanced Payroll Course (Level 2) into the MYOB AccountRight Payroll Course package.

Here are the topics included:

  • Set Up Timesheet Preferences
  • Edit an Existing Super Payroll Category
  • Create a New Super Payroll Category
  • Add a New Payroll Category
  • Edit Employment Classifications to Suit the Business
  • Create Casual & permanent Employee in MYOB
  • Enter Timesheets in MYOB
  • Process a Pay Run
  • Import Timesheets
  • Process Payroll with Personal Leave included
  • Create a New Deduction Payroll Category
  • View Employee Leave Accrued
  • Process Pay including Annual Leave
  • Run a Payroll Entitlements Report
  • Run a Payroll Journal Report
  • Produce a Balance Sheet
  • Record your Bank Details
  • Record Employee Bank Details
  • Process a Pay Run
  • Create an Electronic Payment File
  • Process Final Pay

Stay tuned for updates and additions of advanced MYOB, Xero and Quickbooks training content in the coming announcements.

Employer Recognised & Trusted Course

Employer Recognised and Trusted Online Excel, Word, Office, MYOB, Xero, QuickBooks Online Training CoursesI was going through some enrolments from recent and past students with our marketing team and realised we’ve helped thousands of students from hundreds of different companies large and small, government, not-for-profit and industry organisations which help students retrain and up-skill if they are injured at work. That’s not to mention the thousands of students who do one of our courses to help them in their career advancement or to find a job.

***

Take a look as some of the employers who recognise and trust EzyLearn as their first choice for bookkeeping and office admin courses.

PS. I have some exciting new additions to announce from Ross Miller regarding the Workface Career Academy!

MYOB Essentials Accounting, Credit Management & Payroll Courses included for FREE

myob-essentials online training course live logoYOU COULD CALL IT a New Years Resolution that we’ve managed to tick off already! Early January 2018 I promised that EzyLearn would include the MYOB Essentials Courses in with our traditional MYOB AccountRight Courses and that offer is NOW available — see our Specials Page for the details.

We currently have 2 MYOB Essentials Courses available together FOR FREE (MYOB Essentials Accounting, Daily Transactions AND MYOB Essentials Payroll Course) when you enrol in our MYOB AccountRight Courses — or available separately via the Bookkeeping Academy enrolment form.

MYOB Essentials seems to tick the boxes for most small businesses

Our MYOB Essentials course seems to cater to small business for the following reasons:

  • It enables businesses to keep track of quotes and convert them to sales invoices
  • It includes bank feeds for faster, more accurate and less stressful end of month/quarter reporting
  • You can work out the allocation of GST paid and received for quicker BAS reports
  • Included is Payroll to manage the sometimes complex compliance requirements faced by small businesses

And here’s an excerpt from the MYOB Essentials website:

Features of MYOB Essentials cloud accounting software in our income, expenses, GST, & Payroll Online Course

 

MYOB Essentials has a well-placed price

MYOB also seem to have the pricing at just the right level to not hurt the wallet of small business owners. Xero is now powering ahead with constant features updates (and that puts regular pressure on us to continually create Xero Course updates — which we LOVE doing!) to justify a higher price as they hurtle along on their journey of being a quasi-ERP system using integrated apps in their marketplace.

MYOB Essentials Pricing as of February 2018 - online training courses
Pricing as of 24 February 2018

QuickBooks Online, on the other hand, use an ongoing cheap price special offer to attract new users and use an Australian-based payroll services provided to provide very sophisticated advanced payroll features while keeping the total price low.

We’ve just completed the production side of our QuickBooks Online Advanced Payroll Course so subscribe to get notified of when this training course material is ready to view.

QuickBooks Online Pricing as of February 2018 - online training courses
Pricing as of 24 February 2018

 

Current MYOB training course students receive MYOB Essentials Courses FREE

When I first took EzyLearn online in 2006 it was a huge change in my life and I’ve always been grateful to every student who has chosen EzyLearn to do online training. I’m always looking for ways to help them learn more, do more and achieve better results in their career, business and life goals.

***

My commitment to continuing to keep MYOB Essentials courses available FREE for current MYOB Accountright Course students has never wavered. The other recent commitment is that we’ve made is the Workface Career Academy and the Selling Academy programs available to ALL EzyLearn students via our new LIFELONG Learning Hub.


learn xero myob excel cheap online training courses videos

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

$99 MYOB Course: Intro, Intermediate, Payroll – ALL FOR $99!?

When a training course is not really a training course…

WE REGULARLY PARTAKE in competitive analysis so we can keep giving you top quality online training courses for the best value out there, and in doing so, I found an online offer for not just one, but THREE levels of MYOB — Intro, Intermediate and Payroll OR ALL THREE for $99.

Not mentioning any names; we’re not in the business of naming and shaming and, besides, you can search the deal easily enough online yourself, but it prompted me to put out a reminder that not all courses are created equal.

Not all training courses are the same

I guess it’s obvious to some degree, but many of us are still misled by marketing, and sometimes what’s packaged to the customer as an online training course, is simply a pile of videos (and not even featuring current and up-to-date software versions, either!) all plonked together. You know what, you can get this, and possibly more, directly off You Tube for free!

Using old versions of the accounting software

myob logo online myob training course videosThere are many online courses available for cheap prices, but many of these same courses are not providing training on the latest version of software packages. A quick scan of the fine print shows that this particular $99 MYOB deal is training you on Version 19 of MYOB. This dates back to 2010, which in any one’s language, is very old. Very, very old.

As part of our suite of online MYOB courses, we include access to our old “archived” courses where we use version 19 of MYOB; only for the benefit of those people who still use it and don’t need features like payroll, super and other added features that you’d expect to get after 8 or so years of software development.

What’s retail price anyway?

Box saying If its too good to be true read the fine print for online training courses

Another thing to be wary of is “retail price” comparisons. Plenty of these may be legit, but there are others out there who deliberately distort the truth or make a current cheap offer seem far more appealing by comparing their cheap price to a retail price that isn’t really indicative of what’s on offer out there online.

Make sure you’re talking “courses for courses” and that the retail price comparison isn’t looking at prices from half a decade ago or thereabouts. The price of online training courses is a forever shifting thing, so do your research!

What your online training course should include

In our books, an online training course that’s actually going to deliver results for you should come with these ingredients at the very least:

  1. A detailed workbook to supplement your training and absorption
  2. Knowledge reviews, quizzes and tests (so you can see how you’re absorbing information as you go)
  3. Certificate of completion option formally stating what you’ve achieved
  4. Case studies that keep the content based in real-world scenarios and ensure you’re learning things that will be practical in real-life circumstances and situations
  5. Responsive email and phone student support for all queries
  6. Money-back guarantee; if you’re not happy with the course content, or it’s not what you thought it would be, you shouldn’t be stuffed around in the fine print by not getting a full refund, (no matter how small the amount you’ve originally paid).

The training course should feature the training on the software as it is in its current version and this training, or training videos, workbooks, whatever, should be provided in an order that’s been carefully considered, trialled and tested.

Oh, and some testimonials by real people vouching for the effectiveness, quality and professionalism of the course content and course content provider is pretty important too. Then there’s CPD point accreditation, access to lifelong learning platforms, the option to get lifetime course membership to course content so you’ll always get updates at no extra cost and have an “after course resource” … yep, don’t get me started, courses simply ain’t all the same and you usually pay for what you get (though I think we’re super cost-effective by those standards!)

***

People say “if it sounds too good to be true, it probably is”. This isn’t always the case, and sometimes excellent opportunities in life seem, at first, too good to be true. But when it comes to online MYOB courses for $99 or $29 or $69 or whatever the probably-too-good-to-be-true price point is, just make sure you’re getting apples for apples, or courses for courses, or horses for horses, Mr Ed.

Mr Ed a horse is not just a horse and an online course is not just an online course

You can watch some FREE MYOB course videos? Scroll through our freebies list of online training videos that you can watch without charge or obligation and subscribe to our blog to get updates to more free videos as we’re adding them all the time. Or check out our special offers page to see what discounts we’re giving at the moment or online training courses in MYOB, Xero, Excel and many others.


Online bookkeeping accounting training courses for CPD points


 

What Does a Typical Staff Roster Look Like?

What Does a Staff Roster Need to Include?

staff roster sheets
Staff roster sheets have come a long way since the time of punch in-punch out cards; let us show you how to create intricate rosters that include RDOs, leave, breaks and so forth. 

IF YOUR BUSINESS RELIES on staff to work different shifts, then you’ll need to provide them with a staff roster. We’ve written about the three ways you can create staff rosters for free before.

One of the exercises in our Microsoft Excel Training Course shows you how to create your own staff roster, so we’re not going to do that here. Instead, we’re going point out the things you need to include in a staff roster.

Different employment types

If your business employs a combination of full time, part-time and casual staff, you’ll need to prioritise the full time first, then the part time staff, as by law, they’re guaranteed a certain number of hours each week — 38 hours for full time staff, fewer than 38 hours for part time staff.

Employee RDOs, leave

A rostered day off (RDO) is a day in a roster period that an employee doesn’t have to work and these can be paid or unpaid depending on individual agreements. Both full time and part time staff members will have annual and sick leave entitlements. Make sure you mark these up on your rosters. It’s not just easier to schedule the rest of your employees when you can see who’s working and who’s not working, but it’s also useful for the rest of your team to know this as well.

Staff breaks

Depending on the modern award and the duration of the shift, certain staff members will be entitled to different kinds of breaks — two 15 minute breaks and one 30 minute lunch break, is common in retail, for example. Mark these break times up in your staff roster, so the staff member can see when they’re due for breaks.

Employee signature

Leave a column on your roster, so each employee can sign off at the end of each week to confirm they worked their rostered shifts. This is important, particularly if any of your employees ever claim a discrepancy in their pays due to shift changes, etc.

*** 

Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information on our suite of Excel online training courses.  


learn excel online training course

At EzyLearn we are constantly refreshing the content of our online training courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.


And of course, all of our online training courses can be counted towards your Continuing Professional Development (CPD) points!


 

 

 

 

 

 

We Give You 3 FREE Ways to Schedule Staff Rosters

Scheduling for Rostered Staff Can Be Easy — and Free

staff roster sheets for free
If you have rostered staff members or shift workers in your business, check out our three suggestions for creating free roster sheets.

SHIFT WORK TYPICALLY EXISTS in businesses that operate outside of regular business hours — on weekends, the wee hours of the morning, late at night — and to be fair to all of the business’ employees, the shifts are rotated. Other times, as in the case of home care nurses, it’s because the employee has to visit a different patient each day of the week.

As such, it’s necessary for these businesses the provide staff members with a roster each week, fortnight or month. Although there are lots of roster programs available, we’re going to look at 3 great ways you can create staff rosters for free.

1. Use Microsoft Excel

One of the exercises in our Microsoft Excel training courses is to create your own staff roster, because once you understand how to change the margins and set up a worksheet correctly, Excel is still one of the most common programs to create a roster in. Most businesses ensure a new roster is available at the premises on the same day each week, fortnight or month, with at least a week’s notice so each employee has time to check their shifts when they’re at work. Other times, they’re printed and emailed to staff, again with at least a week’s notice.

2. Google Sheets

Once you’ve had Microsoft Excel training, you’ll find little difference between Excel and Google Sheets, as the former was so efficient that not even Google could find a way to improve its offering (ditto for Google Docs). Once your roster has been created in Google Sheets you can likewise print it out, email it or, if your staff have Google accounts, share it with them.

3. Google Calendar

This only works if your staff are all using the same domain — i.e., they have a company email address — but if you open up Google calendar, you can start scheduling events as shifts. This may be suitable for call centres or businesses whose employees work in their office, both of which only have a handful of employees and a few shifts to cover. Scheduling lots of staff members across lots of different shifts this way can be tedious.

***

Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information.


Xero online training course

At EzyLearn we offer online training courses to help you up-skill and find employment.

Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

Turn Your Wage Payments into a Business Loan

Only Managing Payroll on an Ad Hoc Basis? We Show You How

managing ad hoc payroll
If you know that you can’t quite make payroll, a short-term business loan may see you through and avoid penalties.

WE’VE RECENTLY UPDATED THE course content in our Intermediate Microsoft Excel training courses to include a workbook and spreadsheet (that you can use in your own business) showing you how to manage ad hoc payroll using Microsoft Excel. This will enable you to calculate your PAYG and superannuation obligations in Excel.

Using Excel to work out your PAYG and super obligations is a great way for small businesses, with a small number of employees, to save money. It saves you having to purchase this extra module in MYOB or Xero, for instance, when you may rarely use it. Saving money for small business is crucial as often it’s these same small businesses that have trouble making payroll payments each week, fortnight or month — and then wind up incurring further fees from the ATO when they’re late with their reporting and payments. It’s a vicious cycle.

When you can’t make payroll

If you’re finding it a stretch to make payroll payments, don’t worry, you’re not alone. Lots of business owners have trouble making payroll. But there are things you can do about it. We find that it frequently comes down to poor credit management processes or perhaps a downward trend in a business’ cycle that’s been missed due to poor or inefficient accounting processes. All of these can be rectified.

If the reason your business can’t make payroll is due to one or more shortcomings in your business’ operations, remedy the problems now. Similarly, if credit management is the issue, and late-paying clients are partially to blame, then tighten up or implement a credit management process. If it’s the result of bookkeeping that’s not up-to-date, find a bookkeeper to manage this for you.

How you can make payroll when cash is tight

Get financing. There are lots of ways to do this, but a common method, particularly if you need access to funds quickly, is to get a short-term business loan. Many short-term business loans don’t require businesses to have a great credit score, and will offer funding of as little as $5,000 right up to $500,000.

You’d have between 3 and 36 months to pay back the loan, but you need to be aware — the annual percentage rates (APR) are usually high. Most lenders require the business to have been active for a minimum of 9 months, and have revenue of more than $75,000 per annum. However, if paid off quickly, these can be an alternative to incurring penalties — it will obviously depend on your business’ individual circumstances.

Keep on top of bookkeeping

If you stay on top of your bookkeeping, you’ll either reduce the likelihood that you won’t make payroll, or as a worst case scenario, be able to foresee the periods when you won’t be able to, and be able to arrange finance in time to cover it.

***

Use the Ad Hoc Payroll Guide included in our Intermediate Microsoft Excel training courses to determine the rate of PAYG tax to withhold — and the required super contribution amounts in Excel. Visit our website for more information on our entire suite of Excel training courses.


Xero online training course

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 

All of our online training courses can also be counted towards Continuing Professional Development points.


 

What Happens if You Have Backlog of PAYG and Super Payments?

Don’t get lumped with penalties when you don’t need to!

failure to lodge penalties how to manage payroll in Excel online training course
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.

Rescue bookkeeping

A backlog of PAYG and super payments that date back more than three months is known as rescue bookkeeping, although it can often include other bookkeeping issues, like bank accounts that don’t reconcile with statements.

PAYG payments

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 Courses to 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.

Our courses now include real-life case studies

learn excel online training course

Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business, so you can easily work out your PAYG and super obligations. Visit our website for more information on all of our Excel training courses.


learn PowerPoint online training course

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.


online bookkeeping courses to earn cpd pointsEzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.