Category: News

Posted on by — 2 Comments

Xero’s Reports to Help Decide Whether to Buy or Rent

Xero’s reports can help you decide to buy or rent your business premises

learn xero online training course
There are pros and cons to owning your business premises depending on your circumstances, but appreciation is a significant benefit.

A BIG DECISION FOR A NUMBER of business owners is whether they should buy their own premises. And because there are upsides and downsides to both owning and renting your business’s premises, we’re going to look at some of the considerations you should take into account first.

Buying is an appreciating asset

The biggest advantage to buying is that it’s an asset that appreciates over time. As such, purchasing a property can provide your business with an additional source of income that, over time, will allow you to grow your business.

Buying also gives you access to equity that will allow you to use the property as a guarantee when you’re striking deals with potential suppliers and clients.

There are also tax advantages and deductions you wouldn’t ordinarily have by renting, something we discussed in a recent blog post about investing in a granny flat.

There are upfront costs to buying

That said, you shouldn’t overlook the upfront costs associated with buying. In particular, you’ll need to ensure you have the appropriate amount of capital available before you can buy.

There are certain reports you can run in your accounting software, which will provide you with a clear picture of your business’s financial health and help you determine whether buying is the best option for your business. We always suggest running regular reconciliation reports, even weekly, in say, Xero to help you know the true financial picture of your business.

Our online Xero training courses show you how to run reports that will help you make the vital business decisions; particularly relating to how a capital outlay like buying commercial premises would likely impact your cashflow.

Renting is flexible

If your business is relatively new or it’s generally difficult to predict your future growth over the next five to ten years, renting may be a more viable option. This allows your business to remain agile and offers flexibility that buying doesn’t.

Renting, for example, offers a better range of property types of locations that mightn’t be within your price range if you were to buy.

Furthermore, shared office spaces or co-working spaces are good options for businesses with a small, mostly virtual team, or startups looking for meet like minded individuals.

You miss out on equity gains when renting

The main downside to renting your business premises is that, over time, it is your landlord’s equity you are contributing to, rather than building your own asset.

***

Using your accounting software to determine the financial health of your business will help you to make important business decisions. Our Xero training courses will teach you how to run different financial reports. Visit our website for more information.

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.

 

Posted on by

Paying Several Employees With One Payroll Payment

MYOB and Xero now make payroll easier to manage

myob and xero online payroll management
Struggling to manage your online payroll management? Our Xero and MYOB courses will help you get the most out of this software so you can manage payroll in house.

MANY COMPANIES OUTSOURCE PAYROLL because it contains many moving parts. For instance, there’s the payment of wages each week or fortnight or month, sure. But there’s also superannuation contributions, PAYG obligations, annual and sick leave accrual. 

Fortunately, most accounting apps like Xero and MYOB have made payroll easier to manage, particularly if you only have a handful of employees.

Superannuation clearing houses

Nearly every major cloud accounting package has a connected superannuation clearing house within its payroll package. Xero and MYOB are both SuperStream compliant, a government initiative to help business owners tell which accounting software apps will let them make electronic superannuation payments. And QuickBooks uses a partner payroll system which is also SuperStream compliant.

Batch wage payments

Electronic superannuation payments are one way that paying staff is made easier, but paying a dozen or so employees individually each week or fortnight can be tedious. Fortunately, both Xero and MYOB have a ‘pay run’ function that lets you make batch wage payments. This eliminates the tedium of paying employees individually, as well as the potential for error.

Accounting software calculates entitlements

MYOB, Xero and QuickBooks, if you’ve set up your employees correctly and have the appropriate payroll subscription, will also calculate your employees’ sick and annual leave entitlements, also reducing the time it takes to process payroll and the potential for error.

Our MYOB training courses and our Xero training courses both cover payroll, where you’ll learn how to set up employees correctly, process wage payments and more. Using a cloud accounting program for payroll, saves time and reduces errors. Visit our website for more information.

EzyLearn courses now include real life case studies

managing ad hoc payrollAt EzyLearn we are constantly refreshing the content of our online training courses. Relevant to those of you doing Payroll, might be our Excel Ad Hoc Payroll case study which is part of our Intermediate Excel 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.

 

Posted on by

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!

 

 

 

 

 

 

Posted on by

Why Your Business Needs a Bookkeeping Procedures Manual

Documenting procedures helps keep your bookkeeping up to speed

bookkeeping procedures manual rescue bookkeeping work
Rescue bookkeeping is not ideal – it’s often expensive and shows you’re not in control. A bookkeeping procedures manual will outline what bookkeeping needs to be done, when.

IN A PREVIOUS POST we talked about how to tell when you need rescue bookkeeping, which is basically when a business is behind on its bookkeeping by three months or more and the deadline is looming to lodge their activity statements.

Rescue bookkeeping work costs more than having your bookkeeping taken care of regularly, because it’s often messy and there are no procedures in place to manage the bookkeeping efficiently.

What’s a bookkeeping procedures manual?

bookkeeping procedures manualA bookkeeping procedures manual clearly identifies the regular tasks and activities your bookkeeper needs to take each week, fortnight, month or quarter to ensure your bookkeeping is kept up-to-date. This not only gives you the peace of mind that your bookkeeper is staying on top of your books, but it also helps you to understand what’s going on with your business.

If you require regular P&L statements or balance sheets, having a procedures manual to clearly outline how frequently they’ll be created helps you to stay on top of your business’ financials.

A typical procedures manual will include:

  • Simple steps that are easy-to-understand and succinct
  • Tasks are written up in a step-by-step style, so they can be followed logically
  • References, links or examples are included to help readers understand
  • Contain a number of formats — written steps, flow charts or checklists.

Rather than leaving your bookkeeping to the last minute, so you’re always operating your business in dark, organise to have bookkeeper create a procedures manual to regularly take care of your business’s bookkeeping.

We Can Help You Find a Good Local Bookkeeper

find a local bookkeeper

We have bookkeepers, BAS agents and accountants located across Australia, available to help businesses in need of rescue bookkeeping work. Visit our online bookkeeping directory, National Bookkeeping, to find a suitable and experienced person available to work in your area, or able to work anywhere in the cloud. Alternatively, if you are a bookkeeper looking to expand your client list or find contract work, you can register and become part of our network for free. 

Go to National Bookkeeping for more information, to see our rates or to request a quote.

Online bookkeeping accounting training courses for CPD points

EzyLearn 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.

 

Posted on by — 1 Comment

Honing Skills in PowerPoint Can Turn Your Staff Into Sales People

A simple fine-tune of a PowerPoint presentation saw this employee achieve sales success

learn powerpoint online training video course
Structuring your PowerPoint sales presentation and injecting some interest can make all the difference to how your sales track record pans out.

WE HAVE TALKED ABOUT the many different ways you can use PowerPoint (for resumes, business plans and more), but for many people in business, its primary use is as a sales tool.

Even though a well-crafted PowerPoint presentation is a vital component to any successful sales presentation, very few people know how to create one. In our PowerPoint training courses we show students how to create and structure slides that will take their audience on a journey that’s fundamental to the sales process.

Sales presentations should illustrate a story

The most common mistake even some of the greatest salespeople make is to turn their PowerPoint slides into a transcript of their verbal presentation.

This is boring. And it only distracts the audience from getting excited about your products or services, because they’re just trying to keep up with, or read ahead, of you.

Instead create a PowerPoint presentation that illustrates the “story” you’re telling, or complements your presentation by providing additional information — a graph showing the figures you’re talking about, images of your products, audio etc.

Make your PowerPoint presentations sell for you

If you’ve honed your sales pitch, all it takes is a well-crafted PowerPoint presentation to do most of the selling for you.

One of our team members tried to resign on two occasions, not long after he started working for us, because he thought he wasn’t a good salesperson.

It later turned out that the reason he wasn’t making much headway with prospects was because his sales presentation was unstructured, and frankly, uninspiring.

After he took our PowerPoint training courses he was able to create a structured, compelling PowerPoint presentation. His sales track record notably improved and he’s been with us ever since!

***

learn PowerPoint online training course

Our PowerPoint training courses will teach you how to create persuasive PowerPoint presentations that will turn you and your staff into sales people. There are a host of other fantastic uses for PowerPoint in everyday business — find out more.

 

Posted on by

Should You Take Out a Loan to Avoid Delaying Payroll Payments?

Repayments on a business loan may be less than super and PAYG combined

Small business loan to finance PAYG and super
It’s not uncommon for small businesses to take out a business loan to meet their super and PAYG obligations – but this should never be a knee-jerk reaction to lean times.

IN A PREVIOUS POST we talked about taking out a business loan to cover payroll if you anticipate that you won’t have enough funds to do so otherwise.

Naturally, it’s always better to use your business’ own funds to meet your obligations, whether it’s paying staff or suppliers. This said, getting a business loan to cover payroll can be a good idea for small and growing businesses in certain circumstances. We look at these now.

Loan repayments are usually small

Depending on how many employees work for you, the repayments on a business loan are typically smaller than all of your payroll obligations — this includes superannuation and PAYG — combined. If you get a loan to fund 12 months of your business, payable over a 24 or 26 month period, the repayments will be far easier to manage each month.

Interest is usually a tax deduction

Businesses are able to claim the interest from any business loan as a tax deduction, so even if the annual percentage rate (APR) adds a few additional thousands of dollars to your capital amount over the period it takes to pay the loan back, the interest will still go towards reducing your taxable income.

This is a more favourable option to delaying payment to your employees (illegal) and delaying payment of PAYG and superannuation withholdings, which could incur a Failure To Lodge (FTL) penalty, plus a general interest charge (GIC). Note: Fines and penalties cannot be claimed as a tax deduction and are therefore dead money.

Do your sums first

taking out a small business loanDon’t forget that, while a business loan to cover payroll for 12 months will be easy to repay initially, your business’s profits will need to improve substantially over the next year so that you can continue to meet your loan repayments AND your payroll obligations for that year.

***

You can easily work this out using Microsoft Excel. Our Intermediate Microsoft Excel training courses show you how to determine if you can afford to take out a mortgage, but because all of our fields remain “unlocked”, you can easily modify them to suit a business loan scenario. Visit our website for more information on all of our Excel training courses.

 

learn excel online training course
Our online training courses feature real-life case studies to make our learning more relevant and true to life.
Posted on by

EOFY: Remember to Deduct Your Prepaid Expenses

The Cut-Off for Claiming Deductions is Looming

reduce-your-taxable-income-with-expenses-Xero-and-MYOB
Dive deep into your claimable expenses and don’t forget all those smaller prepaid expenses like magazine subscriptions or domain name registrations – you can only claim all of these during the period in which they occurred.

WE’RE IN THE LAST QUARTER of the 2016/17 financial year, so now is the time to dive in deep and check you’ve included every single business expense — prepaid or otherwise — to ensure all your expenses are in order.

We’ve previously posted about writing off stock and inventory and the reports you’ll need to file your activity statements and tax returns: all of these you’ll learn how to run in our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.

Expenses reduce your taxable income

We all know this, but remember, they can only be claimed for the period in which they occurred. If you forget to claim a major business expense in the financial year that it occurred, you can’t make it up by claiming it the next year.

It’s really important you thoroughly check your credit cards and business accounts to make sure you’ve accounted for each expense. The final quarter of the financial year is also a good time to make any purchases for your business, because you can claim them straight away.  

Prepaid expenses are often forgotten

what are some claimable expensesMagazine or journal subscriptions, domain name registrations, business name registrations, car registrations, website fees, insurances — collectively they add up, but they’re also the easiest to forget.

These deductions are often prepaid and may not come up on your radar and may certainly not show up on your final quarter bank statements.

Make a list and check it twice

Over the next month or so, make a list of all of your expenses as you think of them. This makes it easy to spot them when you’re going through your bank and credit card statements and checking them against the expenses in your accounting software.

***

Learn how to run the reports you’ll need for EOFY with our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.

learn PowerPoint online training course

Want to make your business presentations and publications more eye catching? 

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. 

 

Posted on by — 1 Comment

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 (Excel, PowerPoint, Word) or social media and WordPress web design). 

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

 

Posted on by

We Don’t Lock Our Microsoft Excel Course Content

You Can Use the Calculation Fields in our Excel Exercises as Often as You Like!

learn Excel online training course unlocked calculations and formulas
We keep all the calculation fields in our Excel course exercises unlocked so you can play around with different figures of your own as often as you like.

DESPITE THE POPULARITY OF cloud-based accounting software applications like Xero and MYOB, Excel still remains one of the most indispensable software programs for businesses and individuals alike. That is why we always make it a priority to constantly update our Microsoft Excel Training Course.

You can apply Excel to so much

Accounting software, even robust packages like MYOB, only allow you to perform a finite number of functions that relate to business accounting. However, Excel can be used for a multitude of different purposes — both business and personal, merely one of which is to develop a financial forecast for an investment.

EzyLearn courses provide real-life case studies

learn excel online training course

Our Intermediate Excel Training Course uses the construction of a granny flat for investment purposes as a case study example. We chose a granny flat for the case study because most people construct them as an investment, whether they’re in business or not, so it’s a good real-world example.

It also deals with depreciation, which you can claim in your tax, regardless of whether you’re in business or not.

Our calculation fields remain “unlocked”

But even though, with the current property booms in our major cities, granny flat construction has become more common, it is not so common that every person taking our Excel courses is planning to build a granny flat for their next investment. That’s why we decided not to lock our course content.

What does this mean? It means that all the calculation fields in the exercise files of our Excel training courses are unlocked, so that your education remains unlocked too. You’re free to play around and replicate them as you need, so you can get a proper handle of how to use Excel in business or for work.

***

Visit our website for more information on our Microsoft Excel Training Course, with its new granny flats case study. We provide a range of online Excel training courses for beginners’, intermediate and advanced students.

Online bookkeeping accounting training courses for CPD points

EzyLearn 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.

 

 

Posted on by

EOFY: Organise Your Reports and Records

We Show You The Reports to Generate Now for End of June

profit and loss statements P&Ls
Now’s time to take stock of the reports that need to be generated to keep you GST and tax compliant.

THE LAST QUARTER OF the 2016/17 financial year is upon us, so now is the time to organise your reports and records; including Profit and Loss Statements, Accounts Receivable and Payable, PAYG and Super payments. We’ve previously written about writing off stock and inventory and getting your business expenses in order. In this post we’ll take a look at the reports and records you’ll need for EOFY, which you’ll learn how to produce in our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses.

Profit and loss statement

Depending on the structure of your business, you may be legally required to include a P&L statement with your tax return or activity statements. Your tax agent will be able to advise you if your business will be required to file a P&L, which  requires all of your bookkeeping to be up-to-date before you can run it.

Even if you don’t have to file one with your activity statements or tax returns, it’s still a good idea to run a P&L for your own sake. A P&L statement identifies whether your business has made a profit or loss and which accounting period these occurred.

Accounts receivable, payable

Find out who owes money to your business and to whom your business owes money. This is obviously part of the credit management process, which any good business will have in place already, but it’s a good idea to keep a steady eye on what’s coming in and what’s going out as EOFY approaches.

PAYG, superannuation

The end of each quarter brings a lot of PAYG and superannuation reporting, but EOFY brings a double whammy of activity statements tax returns and PAYG and superannuation compliance. You’ll need to run these reports so your bookkeeper can complete the payroll component of your returns.

Inventory stocktake

If you sell goods, you’ll need to complete a stocktake of your business’s inventory so that any missing stock can be written off, and to ensure you’re starting a clean slate for the new financial year.

***

Learn how to run the reports you’ll need for EOFY with our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.

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 (Excel, PowerPoint, Word) or social media and WordPress web design). 

 

Posted on by — 1 Comment

End of Financial Year: Writing Off Stock

We show you how to write off stock and inventory before the EOFY

how to write off stock before eofy in xero myob
Do you know how to make inventory adjustments? Our Xero and MYOB BAS and GST Reporting courses can show you how.

IT’S A GOOD TIME TO START  looking at any slow-moving or obsolete stock that your business (or your client’s business) may be holding, as we’ve reached the end of Quarter 3 and have now started Quarter 4 for the 2016/17 financial year — which means the end of the financial year is fast approaching.

Writing off stock in MYOB or Xero is known as making an inventory adjustment, and our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses take you through the steps to do this. But first, you need to identify which items aren’t selling. We’ve created this case study to help you understand how.

Understanding your inventory’s performance

Every business needs to understand how their inventory is performing, and how it impacts their business. If the business owner is too busy to stay on top of this, then they should employ a bookkeeper to help.

A good example of why understanding inventory is important to a business is to look at an air conditioning company. This business makes money two ways:

  1. Selling air conditioning units
  2. Installing / maintaining air conditioning units

The margin on the sale of an air conditioning unit is not much, a few percent on top of the wholesale price. Where the business makes its money is in the installation or maintenance of the units it sells.

The business purchases three dozen units, of varying brands, models, price points, etcetera. It now needs to know which units are most popular with customers and why; which units aren’t popular with customers and why; whether it’s profitable for the business to continue to stock the unpopular units; or, conversely, whether it’s profitable for the business to continue stocking the popular units.

Inventory reporting

The business’s bookkeeper regularly runs a number of reports in their accounting software, including profit and loss reports and stock-on-hand reports. These reports are used to identify which units sell quickly, as well as the units that take longer to sell, and the profit margins on each.

The units that sell quickly don’t require a technician to install them. Although they’re responsible for the majority of sales, they don’t generate more revenue for the business. The units that sell slowly, do generate more revenue as they require installation and maintenance, however too many units were ordered and they’ve now been discontinued by the manufacturer. Some units have hardly sold, and, although not discontinued, have been superseded by newer models.

Stock write offs and future orders

Because the bookkeeper regularly runs these reports, s/he has been able to export them into Excel for further analysis. By the end of Q3, the bookkeeper can make suggestions to the business owner about the future of the business.

In particular, the bookkeeper suggests that the units that have been superseded are marked down to clear as much stock as possible, and cease any new orders. Likewise, the discontinued models will be marked down.

Orders for the units that replaced the discontinued models will halve the order volume. Likewise, order volumes for the top selling units will reduced. The profit margin on these units is very low and they result in no additional revenue from installation or maintenance. The profit that would be earned on the additional units is negligible, however by reducing the unit volumes, the business improves its cash flow.

Act NOW for EOFY

If your business sells stock or a combination of stock and services, like the air conditioning business does above, start looking at your inventory now. Markdown any slow-moving stock at the end of Q3, to give your business time to move the remainder of it. If it doesn’t sell, write it off at EOFY.

***

Our MYOB and Xero training courses have recently been updated to include a workbook on how to write off inventory. Learn more about our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses at our website.

find a local bookkeeper

We feature our own online directory of local bookkeepers looking to add to their customers. Visit National Bookkeeping to find a suitable and experienced person available to work in your area, or able to work anywhere in the cloud. Alternatively, if you are a bookkeeper looking to expand your client list or find contract work, you can register and become part of our network for free. 

 

Posted on by

Making PowerPoint “Speak” with Audio

When Should I Use PowerPoint Audio?

using audio in powerpoint
You can get beyond the birds cheeping and insert your choice of quality audio into PowerPoint.

BEING THAT MOST PowerPoint presentations are created as a visual aid to accompany a speech — although there is just so much more you can do with PowerPoint — you may find yourself wondering when it’s ever appropriate to use audio in your PowerPoint presentation, and if it is appropriate, what kind of audio?  

First off, there are two kinds of audio you can use in a PowerPoint presentation: pre-recorded audio and audio you record yourself. You’ll learn how to record and insert your own audio files into PowerPoint in our PowerPoint Training Course.

When you might use pre-recorded audio

using audio in powerpointIf you’ve ever fiddled around with PowerPoint, you’d notice there are a few audio sounds you can use insert into your slides. They’re mostly generic sound effects, like the sound of waves or a bird chirping. To be honest with you, none of these are ever appropriate in a PowerPoint presentation, except in some really obscure instances. Or less obscure ones, like a training course teaching you how to insert pre-recorded audio into PowerPoint!

You can also add pre-recorded audio that you have on your computer, like a song from your music library. Again, there are few instances when this is necessary, but it’s another option nonetheless.

Adding audio you record yourself

And here is where the answer to using audio in PowerPoint really lies. You can record your own audio, using QuickTime if you’re an Apple user, or Sounds Recorder if you’re using an older version of Windows; otherwise you can also record it on your mobile or digital recorder and import it onto your computer.

You would use this audio if you were going to upload your presentation to your website for a webinar, or for people to watch online afterwards. EzyLearn uses it in some of of online training courses. You could use audio in your induction training courses, too.

learn PowerPoint online training course

Brush up on your PowerPoint skills, or learn how you can use PowerPoint to create your own online induction training courses with our PowerPoint training courses.

Xero online training course

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

Choose from our wide range of:

Enrol today!

Posted on by — 3 Comments

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.

 

Posted on by — 4 Comments

When Does Your Bookkeeping Need Rescue Work?

If you’re 3 months or more behind, call in help!

find rescue bookkeeper
Hmmm, so much to do, so little time…

WHEN IT COMES TO YOUR BUSINESS ACCOUNT KEEPING, unless you’re a bookkeeper, bookkeeping is probably your least favourite thing. However, it’s also a fundamentally important part of running a business.

We provide business people with a number of courses in Xero accounting software and we know firsthand that, aside from the legal requirement to lodge regular activity statements, keeping your bookkeeping up-to-date also helps you run a more successful business. This is because it allows you to run regular balance sheets, profit and loss statements and many other financial reports that’ll give you a clear picture of how your business is performing.

However, not every business owner has the procedures in place to manage their bookkeeping regularly. It’s ok, it’s not your fault — you were meaning to, but you were busy running your business and time marched on. Now you have to lodge an activity statement, and you’ve just realised you haven’t done any bookkeeping for three months!

When you need rescue bookkeeping

If you have three months or more of bookkeeping to do before you can lodge an activity statement, then you’re in need of a bookkeeper who can perform rescue work. Some of the common bookkeeping problems rescue work covers includes:

  • Bank accounts or credit cards that don’t reconcile with statements
  • Old un-presented transactions in the bank account or credit card
  • Trade debtors and trade creditors don’t balance with the balance sheet
  • Dealing with outstanding invoices and bills that have already been paid, but still showing as outstanding
  • Incorrect previously lodged BAS
  • Incorrect information showing in payslips, tax tables, super guarantee contributions calculations, payment summaries, etc, due to payroll systems being set up incorrectly
  • Unreliable inventory figures.

Not all bookkeepers are able to take on rescue work, because it’s lumpy and it requires them to perform a lot of work in a short space of time, which can conflict with their other regular bookkeeping work.

Rescue bookkeeping is often more expensive

Because rescue bookkeeping requires a lot of manpower in a short period of time, it’s often a little more expensive than have your bookkeeping attended to on a regular basis. In most cases, you will be asked to prepay for a minimum of 10 hour’s work or however long it’s estimated it will take to get your bookkeeping up to speed.

Do you need help with rescue bookkeeping work?

find a local bookkeeper

We have bookkeepers, BAS agents and accountants located across Australia, available to help businesses in need of rescue bookkeeping work. Visit our online directory of local bookkeepers and bookkeepers who work ‘in the cloud’ at National Bookkeeping for more information. Here you will be able to see the different bookkeepers’ rates or request a quote.

Online bookkeeping accounting training courses for CPD points

EzyLearn 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.

Posted on by

Hiring Someone New? Why You Need to Personally Check their References

Why It Pays to Call the Switchboard When Doing a Reference Check

reference checking
How do you really know the mobile numbers provided for references truly belong to who they say they are?

I recently had a conversation with a colleague who said she’d never once been asked to produce a copy of her university degree or her transcripts, despite stating on her resume that she’d graduated with a high distinction average.

Gee, I thought, not once? Not a single recruiter or employer had ever requested a copy of her degree? I found this fact astonishing, particularly since more professions require, by law, certain qualifications — as BAS agents are, for example. So how people know my friend wasn’t fibbing in her credentials? Fact is, they didn’t.

Check, even if you use a recruiter

I wrote a blog some time ago about recruiting on LinkedIn and why it’s so important to check references for yourself. People often underestimate the importance of checking a person’s credentials, so long as they get a reference from their last employer. Often, though, most people only provide a mobile number for their references, so whether you’re speaking to the candidate’s former employer, a co-worker, or their mum is sometimes anyone’s guess.

I was reminded of how important reference-checking is again, when I was reading a couple of articles on Longreads, and I found myself utterly fascinated by two of the biggest cases of journalistic fraud ever committed (though I admit to having never heard of them before the weekend, despite one occurring more than 30 years ago).

Sometimes people don’t just lie on their resume

In the first instance, a journalist named Janet Cooke fabricated a story for The Washington Post about an 8-year-old heroin addict. She won a Pulitzer Prize for it in 1981, and then had to give it back when it came out that there was no such 8-year-old. In the second case, Jayson Blair, a journalist for The New York Times, was found to have fabricated or plagiarised 36 out of 73 stories written over a 6-month period, in what turned out to be the biggest scandal in the newspaper’s hundred-plus year history.

What I found most intriguing, though, was that neither Cooke nor Blair had been properly vetted before their employers hired them. In fact, it was Cooke’s falsified resume that was ultimately her undoing when, after receiving the highest honour in the field of writing, a former employer noticed something was amiss with her Pulitzer biography — her education and professional achievements had been grossly overstated. (Rather ironically it was Bob Woodward, of Woodward and Bernstein — the journalists who uncovered the Watergate Scandal — who signed off on hiring Cooke.)

The same would prove true for Blair, who, it turned out, never graduated from university, and had a murky work history with the Times’ sister publication, The Boston Globe, where his superiors had been less than impressed with his less-than-high standard of work.

(Of course, the equally interesting case of Australian author, Helen Demidenko, who won the Miles Franklin Award in the early 1990s, only to later be dubbed by the Sydney Morning Herald as a ‘literary hoax’ also springs to mind.)

Benders-of-truth almost always get caught

Plenty of people lie or embellish on their resumes, and while a good majority of them go unnoticed, others are caught out — sometimes very publicly, and often only after the organisation has been very publicly embarrassed, as in the case of Cooke and Blair.

My advice, then, is to always check the references of new hires meticulously. Rather than calling the mobile numbers or direct lines of the candidate’s references, call the main switchboard and ask to speak to that person’s manager or superior.

And always ensure to ask for a copy of any credentials, like university degrees. If you’re employing someone where, by law, they’re required to hold a certain qualification — as is the case for BAS agents, for instance — it’s imperative you can verify the person’s credentials.

***

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 (Excel, PowerPoint, Word) or social media and WordPress web design). 

 

Posted on by — 1 Comment

Linking a Financial Forecast with Xero and Excel

Excel Will Help You Work Out the HOW of Depreciation

learn excel online training courseWe recently updated our advanced Microsoft Excel Training Course content. It now contains a case study, by way of an extra exercise workbook, using a granny flat building project to create a financial forecast.

We chose a granny flat building project for our case study because it’s an investment decision quite a lot of people with or without a business have made. It’s also a capital asset that can be depreciated over time. Therefore it has the potential to affect your taxes in lots of different ways.

Our Excel Training Course, with its granny flat financial-forecast case study, will teach you how to use Excel to create a financial forecast, which you can then replicate for your own investment — whatever that may be.

Your bookkeeper uses Excel to calculate depreciation

When you build a new structure, such as a granny flat, which you intend to rent out or use for businesses purposes — i.e., it’s an investment and not for your own personal use — the building can be depreciated along with some of the fittings and finishes (floorings, curtains, paint, etc). That’s despite the value of the land upon which the granny flat is constructed increasing in value over time.

Once you’ve set up your financial forecasting file in Excel using the correct formulas that will update as the investment progresses, you’ll be able to track all of the future costs, income and depreciation in that spreadsheet.

Input depreciation into Xero

Excel will calculate the depreciation amounts for you, which you should then enter into Xero. We cover how to deal with depreciation in our Xero Bank Reconciliation Course, because lots of businesses own, or will own, a capital asset at some point.

However, this doesn’t tell you how to determine the depreciation amounts, which most business owners have to get their bookkeeper to work out for them. Most bookkeepers work this out in Excel based on the depreciation rates provided by the ATO. However, if you have already created a financial forecast in Excel, you won’t need to get your bookkeeper to do this for you.

Individuals can claim depreciation too

Even if you’re not a business owner, but you’ve still built a granny flat that you intend to rent out, you can claim depreciation in your tax returns. Instead of entering the depreciation into Xero, you’d include it on your annual tax return, so it’s really important that you work this out in Excel first and regularly update it.

***

Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision. Visit our website for more information on our advanced Microsoft Excel Training Course, with its new granny flats case study.

Do you want to brush up your Xero skills? Or perhaps you use MYOB but want to get a handle on Xero? Check out our suite of Xero training courses — all available for one low price. 

Online bookkeeping accounting training courses for CPD points

EzyLearn 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.