Category: Updates

Updates to EzyLearn services or new content

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.

 

Posted on by — 1 Comment

Which Granny Flat is a Better Investment?

A Real-Life Granny Flat Construction Scenario

learn excel online training courseChoosing between a one-bedroom and two-bedroom granny flat is a decision you’ll need to make early on in the project, and it’s largely a financial one.

EzyLearn’s Microsoft Excel Training Course includes a new case study, “Investing in a Granny Flat”, which uses the construction of a granny flat as a real life example to help you to better understand how to develop a financial forecast for an investment.

Determine construction and ancillary costs

How much it will cost to construct both a one-bedroom and two-bedroom granny flat is the first step. You need to work out how much it will cost to get each granny flat constructed to the point that someone can move in, as well as any ancillary costs, like council fees and levies, real estate management fees interest rates and so forth.

Determine rental income

Some granny flat companies will give you rental income estimates, but you’re encouraged to investigate this yourself. Rental incomes are heavily dependent on your local area and the demand for that type of property. In Sydney, the demand for rental property far outweighs the demand in regional NSW. Take into consideration vacancy rates in the area and the types of property that are in demand. Areas with high vacancy rates and low demand for one-bedroom units could indicate there’s little demand for a permanently rented one-bedroom granny flat, which will put the rent down.

Determine depreciation amounts

Both granny flats will be subject to the same depreciation rate, however the amounts will differ due to the differing value of each dwelling. In addition to an annual depreciation rate on the dwelling, consider other elements of the granny flat that will also be subject to depreciation. Floor coverings, for example, can be depreciated over time. Carpeting is typically depreciated at a rate of 20 percent, where tiles are depreciated at 2.5 percent because the latter has a longer lifespan.

Determine the best investment

Add all of these costs into Excel to determine the average annual rental yield, expressed as a percentage of the property value. Rental yields are used to show the return on an investment. The higher the rental yield, the better the return is. Taken in combination with your own personal circumstances and plans for the future should help you to determine which option represents the better investment.

***

Our Microsoft Excel training courses, featuring the new granny flat case study, go into much greater detail. Or view our full suite of training courses. 

***

learn excel online training course

At EzyLearn, we’re committed to helping students of all our courses find better employment opportunities, become their own boss and upskill. To this end, we constantly update our courses with new, highly relevant content — it’s why we provide you with the option of Lifetime access you can always refer back to our courses as you progress in your skills’ development. 

We’re thrilled to announce our new Micro Courses which are be added to our existing courses, or can be purchased alone. These are based on real-life case studies and relate to real people in genuine, real-life scenarios. Subscribe to our blog and be alerted of updates.

 

Posted on by — 1 Comment

Calculating PAYG Obligations Without a Payroll System

Third Quarter is Looming; Are You Up to Date with Payroll?

ad hoc payroll payments ExcelMost 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.

In our recently updated Advanced Microsoft Excel training courses, we have included a micro course on ‘Ad Hoc Payroll’, featuring a detailed spreadsheet for calculating PAYG and superannuation obligations. In this instance, our micro course is a detailed spreadsheet based on a case study, so it’s relevant and applicable to real life.

PAYG and the businesses it applies to

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.

***

We feature a number of real-life case studies, which we have turned into micro courses. You can use the Ad Hoc Payroll Micro Course to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel, rather than paying to access the payroll functions of MYOB or Xero. Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business. Visit our website for more information on all of our Excel training courses.

***

online bookkeeping courses to earn 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

Free Microsoft Word Beginners Training Workbook

Get Your Free Microsoft Word Training Workbook Now

Microsoft Word Beginners Training Course WorkbookWe’ve been hard at work on our Microsoft Word courses in readiness for the launch of our 2016 Microsoft Word courses and I’m happy to let you know that we are offering the first of our Microsoft Word Course Workbooks to you for free. It’s the 201 Course workbook and it includes exercise files that explain all of the different types of tools available in Microsoft Word.

Interested? Register Now for the Microosft Word Beginners Workbook and Exercise Files

Microsoft Word Exercise Files

The image in this blog is of one of the exercise files we’ve created that has loads of different Word formatting, including:

  • Font formatting (colour, size)
  • Paragraph Formatting (alignment, spacing)
  • Heading Styles
  • Headers and Footers
  • Images and Graphics
  • Tabs
  • Background shading formatting
  • Inserting hyperlinks
  • much more..

Sales Letters, Proposals and more

The “Content Marketing for Real Estate Agents” exercise file included with the free Microsoft Word workbook is one of dozens of files we include in our MS Word Courses and as a Microsoft Word student you’ll also get access to new training content we’re including Sales Letters and Proposals.

The exercises in all of our courses and the object for every course is to use software for practical purposes in every business. The Sales Letters and Proposals exercise files we’re working on combine software skills with marketing strategies we go through in our Small Business Marketing Course. Not only will you learn strategies to grow your business by increase your customer base and enhancing your product service offering, you get to create your own marketing materials using Microsoft Word.

Register for the free workbook

Posted on by

Intermediate skills in Microsoft Word can help you create great sales letters

Microsoft Word Training Course is Being Nurtured With New Content

203 Microsoft Word Beginners Courses for sales letter, flyers, resumes, cover letters and tender proposalsI recently wrote about the content in our Microsoft Word Training Courses and because its a couple years old we’ve been offering the Microsoft Word Courses as a FREE BONUS to anyone who enrolled in our Excel or MYOB courses (with certificate options). If you’re a regular reader (subscribe here) or an EzyLearn student you’d also know that we offer either 12 month or lifetime access to courses and that includes access to brand new content.

[highlight]We’re in the process of create brand new content for Microsoft Word, including training on the creation of great sales letters, resumes and tender proposals.[/highlight]

I’m happy to share with you that we’ve been working on our Word course feverishly for the last 3 months (and there is still a couple months of work to go) to make sure that we have training on the most recent version – Microsoft Word 365 (the clould-based Microsoft Word program that you can purchase on an annual subscription that costs less than the previous versions). The new Word course content is now also aimed at helping you create documents to make sales (for businesses) or find work (for job seekers).

If you’ve always wanted to improve your skills using this popular program and write documents faster, make them look more professional or take advantage of tools like Mail Merge then you’ll get some great value out of this course. We’ll be going through some exercises to help you create

  • A great sales letter to highlight the call-to-action for your direct marketing campaigns as well as
  • A resume for the job you’re looking for (and a focussed cover letter).
  • Proposals and tender documents to win new business for your company

Sales Letters, Resume’s, Cover Letters and Proposals

[highlight]Can you see what they all have in common? They are all marketing focussed.[/highlight]

Each of these documents are used by people EVERY day to show how professional, smart, committed and capable they are. Most companies need to write sales letters and proposals to try to win new business and maintain or increase their annual revenue. Job seekers create resumes and cover letters to convince employers that they are the best person to choose for a job vacancy.

In creating this updated Microsoft Word Course content we’ll also be working on some real life examples of creating marketing materials as part of the Small Business Marketing Courses AND our Career Academy that aims to prepare students to confidently search and apply for job vacancies.

Sales Letters for Bookkeepers and Website Designers

Bookkeepers and website designers need new clients all the time, sometimes because they just don’t have enough work but sometimes because the nature of their work is project driven so it’s [highlight]important to always be spending some time in the sales department[/highlight] (even if you are a one person band). Some people do this with content marketing, or Pay-per-click advertising on Google or Facebook, while others actively seek to meet new people and give them a reason to engage their services.

[dropcap]W[/dropcap]e’ll be working on sales letters as part of a direct marketing effort to reach potential clients and give them a [highlight]reason to act on the sales letter using a special offer and a call to action[/highlight].

You can create sales letters for your marketing campaigns using beginners skills in Microsoft Word, but when you develop the Intermediate or advanced skills you’ll find a dramatic difference in the quality of your documents.

Special Prices & BONUS Courses are for a LIMITED TIME ONLY

free online training course in Xero or Microsoft Word with MYOB or Microsoft Excel CourseAre you planning on doing a Microsoft Word Course in the new year? Why not enrol now and save at least $50?

After we’ve completed all the new course content and support exercise files we’ll be bringing the Microsoft Word Course prices inline with our other course prices, so when you enrol now you can get the Word course free if you enrol into Excel or MYOB (Certification option) or you can enrol directly into Microsoft Word and get the current discounted price. Enrol now and you’ll get the benefit of the new Word course material when it’s published but you’ll get it at today’s price.

 

Posted on by

Why Continuing Professional Education is Important for Bookkeepers

CPD for Bookkeepers is Becoming More Important

CPD CPE and ongoing education is very important to the Tax practitioners board TPB for Registered BAS AgentsEducation is obviously something we think is very important, whether you’re changing careers, starting a new business, or looking to upskill for a promotion. But what about education to keep your current job? The Australian Government thinks that’s equally important, especially for BAS and tax agents.

In March this year, the Tax Practitioners Board (TPB) changed their renewal process to now include continuing professional education (CPE) as a mandatory for all registrations after July 1, 2016. Between now and June 30, 2016, it’s sufficient for BAS and tax agents to merely show they have read and understood the new CPE policy to renew their registration, but this arrangement can only be used once; moving forward those BAS and tax agents will still need to complete further education to register again as a BAS or tax agent the in the future.

Are You a Currently a BAS or Tax agent?

Over the last few years, the Government has introduced a lot of new measures that BAS and tax agents have had to comply with in order to continue to offer their services to clients, namely the changes in 2010 that made it mandatory for all BAS and tax agents to hold a minimum qualification of a Cert IV in bookkeeping.

The new CPE requirement could seem like just another measure that BAS and tax agents need to comply with just to be able to keep their jobs. It’s not. CPE has been introduced to ensure that BAS and tax agents continue to understand, not just their own industry – that of tax and finance – but also how other industries are changing too.

There are more people leaving their jobs as employees and starting to work for themselves as consultants and freelancers and contract workers, across a wide array of industries. Marketing professionals, for example, no longer simply come up with marketing hooks for companies; they also have to understand how to create websites and how SEO works and social media. In some cases, they even become unofficial spokespeople and sales reps for the companies they’re consulting with, leveraging their contacts on their clients’ behalf.

CPE makes BAS and tax agents more valuable, not less

This vastly complicates a marketing professional’s tax if that marketing professional’s job now encompasses the roles of several other professions within it. Similar changes have been observed in bookkeeping, with registered BAS and tax agents now providing more operational and administrative-type services, in addition to just bookkeeping.

The point, then, of CPE is not to make it more difficult for tax and BAS agents to renew their registration with the TPB, but to help tax and BAS agents to remain as highly skilled as they’ve ever been, in an ever-changing labour market. And the better skilled you are as a BAS and tax agent, particularly those self-employed BAS and tax agents, the more value you’ll be able to provide your clients, and the more work you’ll get from them in return.

To learn more about continuing professional education for bookkeepers, visit the TPB website. Otherwise, to read more about bookkeeping, particularly starting your own bookkeeping business, continue reading our blog.

Are you a Writer and Want to Work from Home Blogging for Businesses?

I write about marketing professionals because they are increasingly important in small businesses as businesses grapple with getting discovered online.  I recently wrote about Blogging for Business and our new training course to help businesses with their content marketing strategy and tasks because it’s something that my team are spending more and more time on. It’s also an area that is evolving every month and requires writers to learn about and adapt to new technology.

Enrol into the Blogging for Business Course now and take advantage of it’s current cheap price. We’ll soon be adding real life exercises where blogging students will be asked to create content and have it edited and published so they can participate in a real world business blogging project!

Posted on by

Is Single Touch Payroll Really Dead?

For a while there it looked like the ATO would introduce single touch payroll for all Australian businesses by July 2016, but after feedback from the businesses community that original plan has been shelved – for now. With SuperStream simplifying the way businesses manage the superannuation contributions for their employees, it’s highly likely that we’ll be seeing some form of the single touch payroll model in the near future.

Single touch payroll was an initiative developed to simplify the payroll process for Australian businesses. Currently, most businesses are burdened with a number of tax and superannuation reporting obligations, which single touch payroll would have put an end to.

What exactly was single touch payroll?

Single touch payroll, like SuperStream, was a proposed interactive tool that would allow a business’s accounting software to automatically report payroll information for their employees to the the tax office, eliminating the need for businesses to report pay-as-you-go withholding (PAYGW) in their activity statements throughout the year, as well as end-of-year employee payment summaries.

There was also a proposed digital service that would have streamlined tax file number declarations and Super Choice forms, which would obviously reduce a lot of the red tape and paperwork associated with employing staff.

Single touch payroll would have integrated with nearly all accounting packages in Australia, including MYOB, Xero and Quickbooks, just as SuperStream does now, so why was it shelved by the ATO until further consultation with the business community?

Single touch could have caused cash flow problems

The main concern for many businesses was that single touch payroll would impact their cash flow by requiring employers to pay the tax withheld from wages and super guarantee payments at the same time they paid their employees’ wages. There were also concerns about whether compliance by July 2016 was realistically achievable for the majority of businesses, especially when the SuperStream changeover is still ongoing.

For businesses with a substantial number of employees, single touch payroll could have been a godsend. Unfortunately, the original proposal alienated smaller businesses by making it necessary to pay both tax and super guarantee payments at the same time as employee wages, when most employers currently make those payments to the ATO each quarter.

But that doesn’t mean the single touch payroll system has been scrapped altogether. The ATO, in consultation with industry groups and the Minister for Small Business, is working on developing another single touch payroll scheme that will make real-time payments for withholding and super guarantee payments voluntary, which will be tested with small business owners before it’s rolled out across the board.

There’s still life in single touch payroll yet

What single touch payroll really highlights is how important it is for small businesses to make sure that they’re using a current accounting software package – and there are many on the market, developed especially for small businesses – that supports SuperStream and will also support any other ATO initiatives, like single touch payroll.

If you’re not using an accounting package for your small business, it’s wise to choose one of the major accounting software providers, which Margaret Carey of Business EEz also suggested when we spoke to her not so long ago about SuperStream.

You can read more about SuperStream and the new measures the ATO has introduced to make payroll and superannuation compliance easier for small businesses by subscribing to our blog. Alternatively, if you’re a small business owner using either Xero or MYOB and you’d like to know how to properly setup and use payroll in your accounting software, enrol in one of our MYOB or Xero training courses today.

Posted on by

How does $20,000 mortgage repayments equate to $47,598.02?

Microsoft Excel Course now includes a mortgage spreadsheet

Microsoft Excel Training Course can help you halve your mortgageA mortgage for your home is a huge debt, particularly for those living in the swelling capital cities with soaring house prices. The pro and cons of buying your own house and living in it are:

  • You don’t pay capital gains tax on a property you live in, but
  • You can’t claim the interest component of your loan

The big problem with this is the interest charge – you can’t claim the cost of it yet it’s a massive component of each and every payment you make on your mortgage. You’d need your house price to go up at least at the interest rate you are paying to make it a good investment – and right now you’d be doing fine (perhaps except in Perth now).

Bigger payments reduce the interest paid

Our Microsoft Excel Training Course now includes an Excel spreadsheet file that will help you see just how much money you’d save if you paid even a small amount off extra each month!

You can use the mortgage comparison file to compare two mortgages, make extra payments or even shorten the term of the loan to see how much you’d need to pay each month if you want to pay your mortgage off quicker.

If you are an existing Excel Course student you’ll find the new file at the end of our Microsoft Excel Advanced Course 309.

Take 10 years off your mortgage while its easy to

I don’t want to turn this into a financial education blog, but there are several reasons to open this spreadsheet and start seeing the resulting figures to workout the best way to allocate the money you earn. Interest rates are at record lows, house prices ‘may’ be peaking, some people say that Australian banks are so highly leveraged to the residential property market that they’ll need to hold more capital reserves.

Either way you look at it, why not use your Microsoft Excel skills and play with some calculations to see how much better off you could be if you are financially prudent now. You can also use this Microsoft Excel file to do a stress test and see how much your mortgage would be if interest rates do go up as many people expect they will.

free online training course in Xero or Microsoft Word with MYOB or Microsoft Excel CourseFree Microsoft Word Course (or Xero Accounting) when you enrol in Excel Certificate Course

Note that if you enrol into Microsoft Excel Courses and choose the certificate option you’ll receive a BONUS course in either Microsoft Word (to create a professional resume) or Xero Accounting! Read our BONUS course offer announcement.

Posted on by — 2 Comments

What is SuperStream?

Does SuperStream streamline superannuation payments?

SuperStream Superannuation Start Dates for small businesses with under 19 employees and contractorsIf you’re a small business with nineteen or fewer employees, then come July 1 this year you’ll need to begin making superannuation contributions for your staff using SuperStream, the government reform introduced last year to improve the efficiency of Australia’s superannuation system.

The purpose of SuperStream is to ensure employer contributions are paid in a consistent and timely manner, while also setting a common standard for how super contributions should be managed, which had previously been lacking from legislation relating to superannuation contributions. Medium-large businesses with more than twenty employees have been able to use SuperStream since July 1 last year and have until June 30 this year to become compliant. From July 1 this year, small businesses with nineteen or fewer employees will until June 30 2016 to meet the SuperStream requirements for their business.

What’s the benefit to employers?

Prior to the reforms, there was no standard for making super contributions. This meant that employers could choose to make superannuation contributions as frequently or infrequently as they liked, providing they made them at some point over a the course of an employee’s employment with them. SuperStream now makes regular contributions mandatory and easy to comply with. Other benefits to employers include:

  • The opportunity to use a single channel when dealing with super funds, regardless of how many funds your employees contribute to
  • Reducing the time spent dealing with employee data issues and fund queries
  • Offering greater automation and reduced cost of processing contributions and payments
  • More timely flow of information and money in meeting your superannuation obligations.

What measures will businesses need to adopt to use SuperStream?

Businesses can use software that conforms to SuperStream requirements – MYOB released a software update for most of its products, which is SuperStream compliant, for instance – or a provider who can meet the SuperStream requirements on their behalf. The ATO recommends investigating the following options:

  • Upgrading payroll software
  • Using an outsourced payroll function or service provider
  • Using a commercial clearing house or the Small Business Superannuation Clearing House (for businesses with fewer than twenty employees).

We haven’t made any updates in our MYOB Training Payroll Course for this, but we’re keeping a watchful eye.

What if your business mainly uses contractors?

If you employ contractors to work for you, either on a one-off or ongoing basis, you will still need to make super contributions on their behalf, which means you’ll also need to make sure you’re compliant with the SuperStream requirements. You’ll need to make superannuation contributions to a contractor if they have a contract with your business where:

  • The contract is wholly for labour and skills
  • They perform the work personally
  • They are paid for the number of hours worked

In this case, they’re considered an employee for the purposes of the superannuation guarantee, so you’ll need to ensure you’re also compliant with SuperStream, even if that contractor has an ABN and invoices you.

You won’t have to pay the superannuation guarantee for a contractor if the person is hired to complete a specific task for which they are paid to complete only, and they are responsible for fixing any defects to the work.

If you hire contractors to provide mainly labour services on a regular basis, where they are paid for the time they spend working, rather than on a project basis, for the purpose of SuperStream, they will be counted as employees. If you have more than twenty contractors that fit this description, you need to ensure you’re compliant wit SuperStream by June 30 this year; if you’ve fewer than twenty, you have until June 30 2016 to become SuperStream compliant.

It’s a good idea to review the SuperStream section of the ATO’s website for more information on SuperStream or visit the section on contractors if you’re unsure whether you should be making super contribution on your contractor’s behalf.

Posted on by — 1 Comment

Saasu, Westpac, St George Bank Can Help Reach Independent Contractor Clients

SAASU and the Big Four

SAASU online cloud accounting free trial and prices

Saasu recently announced a new partnership with Westpac bank to deliver direct bank feeds to Saasu and Westpac customers, including those with St George business accounts. Among the new features, the Westpac/Saasu partnership promises ‘real-time insight into cash-flow with online invoices, expenses, banking, budgets, payroll, inventory and financial reports.’

We’ve been following emerging trends in accounting software to ensure our training courses meet current market demands. It’s why, in addition to our flagship MYOB Training Courses, we offer training courses in Xero and are currently developing an Intuit Quickbooks Online Training Course.

As a St George customer, one of our team members was interested in what this new partnership would mean for Saasu customers, and even wondered whether it would be worthwhile making the switch from MYOB, given Saasu’s relatively cheap offering of cloud-accounting software.

SAASU could easily replace Reach Accounting

I recently wrote of the sad news of Reach Accounting software shutting down and there might be some good news for independent contractors who operate their own business. SAASU – a privately owned Australian company has a $15 per month plan aimed at helping small business manage their bookkeeping in the cloud with cheap accounting software.

Direct bank feeds without the use of third-party providers

What I discovered was promising. For Westpac customers, the partnership brings the ability for Saasu to provide direct bank feeds for free, without the use of a third-party provider, which so many other cloud-accounting platforms use – even MYOB utilises BankLink, for example. For non-Westpac customers, little will change in terms of bank feeds; Saasu will continue to utilise the services of Yodlee for bank feeds just like Xero and Zoho.

Bank feeds eliminate nearly all of the data entry associated with bookkeeping, and they’ve been a revolution for small business owners and bookkeepers alike. As the most time-consuming, yet crucial, part of the bookkeeping process, automatic bank feeds, which pull your bank transactions into your accounting software, allow BAS agents to get on with actually preparing a client’s BAS, while business owners have an up-to-date picture of what’s happening with their cash-flow as it’s happening.

Bank feeds are changing the role of the bookkeeper

Note that I’ve mentioned BAS agent, rather than bookkeeper. Technically, the BAS agent I’m talking about is a bookkeeper, but with bank feeds now pretty well commonplace among most cloud-accounting apps, there’s really no need for them to engage in that tedious data entry process, freeing them up to take on more clients and earn more money.

So will our team member be switching to Saasu? No, not just yet. The latest Westpac partnership is promising and our independent contractor certainly liked the pricing, but Saasu lacks one major feature that our independent contractor couldn’t live without: a mobile app, or at least a well-functioning one. The current Saasu app hasn’t been updated since 2011, and doesn’t work on an iPhone running IOS 5 or higher, so despite the volume of small businesses that invoice from the road (think: tradies), Saasu appears to have neglected it’s mobile properties.

Mobile is the future of cloud-accounting

MYOB has the MYOB OnTheGo app that businesses can use to check outstanding payments, create invoices, and even update customer records. The app allows users to manage their accounts when they have the time – like in the few minutes waiting to meet with a business associate for lunch, for instance – rather than forcing them to set aside large portions of their time to stay on top of their accounts, which is really why bank feeds and cloud-accounting have become so popular. Of course, MYOB isn’t the only company to offer a mobile app – Xero, Quickbooks, and Zoho all offer mobile apps to compliment their desktop offerings.

As for Saasu, they’re certainly the ones to watch. For what was once a nimble Aussie startup to have partnered with one of the big four banks, it shows that there’s a new frontier of cloud-account nearly upon us.

Posted on by

Beginners to Advanced Microsoft Excel Course for $197 inc Exercise Files

$197 Beginners to Advanced Microsoft Excel Course includes Exercise Files

Microsoft Excel Training Course exercise files

One of the best ways of learning how to use a program is to use that program during your training. Some people can sit with programs like Microsoft Excel and learn by trying something out and making mistakes and then trying again.

[box type=”tick”]We’ve discovered that Microsoft Excel course students want to work with real world files in a logical step-by-step method that uses the exercise files for the basic skills and then keep using that file for the more advanced skills.[/box]

By the end you’ll have a powerful Microsoft Excel spreadsheet using advanced skills and because you learnt in a logical and methodical way, using gradually more complicated tools, you’ll have learnt most of the Microsoft Excel skills you’ve wanted and won’t even notice the time go by.

Real World Use of Microsoft Excel Spreadsheets

Excel training course exercise filesThe main uses for Microsoft Excel are as a:

  • Worksheet that enables you to lay out information in a logical fashion and then perform calculations with that data
  • Database that lists all of the information in a tabular format that can then be filtered and manipulated into a format that can be used in mail merges etc, and
  • Charts and graphs that visually present the information in a worksheet or table so that we humans can make sense of the information

Here are some of the ways that we use Microsoft Excel for our training business.

Present information for use in newspaper ads

In Microsoft Excel Course 303 we look at formulas and formatting and one exercise file we share with students and an example of what’s possible using Excel is the artwork we created for the newspaper ads for our courses at our training centres in Sydney. The table structure of Excel enables us to lay the information out precisely and if we need to change the dates

What costs us the most money

Yes, you can see the costs of running a business in a simple table, but when you put it in a chart you can visually see the differences in costs and in our 305 course on charting we’ll show you how to create the various different types of pie, line and bar charts as well as many other types. You’ll learn how to format the charts to make certain areas stand out and you’ll learn how to demonstrate trends.

Budgets and forecasting

It’s great when you have historical information to work with because you can spend a lot of time working out percentages, margins, budgets etc to try to figure out how you will go in the future. We include many exercise files in Microsoft Excel Course 306, including files to help you:

  • Maintain a household (or business budget)
  • Calculate sales margins and commissions for sales people (we have several different versions of this file to demonstrate how the file should look at the various stages of creating it).
  • Create a price list (including all wholesale product costings – that will be hidden from view)

 Making the right decisions

When we operated our training centres in Sydney we spent a lot of our time scheduling courses. We had to allocate training rooms, roster on our great trainers, print training materials and we needed to know when people where coming to courses. We discovered that most people who wanted to learn Microsoft Excel did a night class. We had these variables to work with:

  • The courses
  • What days people had come to these courses in the past
  • The time of the day that students had enrolled into these courses: morning, midday, evening or weekend.
  • Different training methods (class-based and Flexible Learning)

By discovering the best days and times that students had enrolled into courses from the past we were able to better schedule our courses to get the most students. It means we didn’t need to cancel courses.

See the contents of Microsoft Excel Course 308 for more information.

Figure out how to make more profit

In a business you can build a bigger business and make more profit by

  • increasing sales,
  • cutting costs,
  • focussing on your most profitable customers,
  • focussing on your most profitable products,
  • decreasing the time it takes to get your money (cash sale or terms).

Using Goal Seek in Microsoft Excel we discovered something that’ll help all independent contractors run a better more profitable business.

 

Posted on by

Did I Mention a Free Excel Beginners Course?

Free Excel Beginners Course

I recently wrote about our Microsoft Excel [link]  Training Courses and how they have the features that make all of our online training courses popular, but I forgot to mention that we make the Excel Beginners Course available for free. These free training videos AND Excel Course workbook will give you the confidence to understand the main uses for Microsoft Excel.

Microsoft Excel can be used for lots of different things, but the main uses are:

  • Worksheet (to do calculations)
  • Chart (to visually show the data)
  • Database (to store data)

Our Excel Beginners Course videos will give you the basic Microsoft Excel knowledge very quickly, but the Excel Beginners Course workbook and exercise files will give you the chance to replicate what you see in the videos and LEARN BY DOING. You’ll get the training workbook to print out and we’ll also send you the excel files that we use in our demonstrations.

Excel Intermediate to Advanced Courses

Don’t worry, once you master the basics you’ll either want to know as much as you can about Microsoft Excel or decide that you’ll just use the software when you need it.  Either way, with our LIFETIME course access option you can complete and repeat the course as often as you want and with all skills levels (from Beginners to Advanced Excel) you’ll be covered.

We’ve been teaching people how to use Microsoft Excel since we started at Lane Cove in Sydney in 1996 and we look forward to helping more people learn Excel to become more productive, more employable and more successful.

Make sure you share our free Excel Beginners Courses with your friends on social media.

[button link=”http://ezylearnonline.com.au/courses/microsoft-excel/free-microsoft-excel-beginners-course-training-videos/”]FREE Excel Beginners Course[/button]    [button link=”http://ezylearnonline.com.au/enrol/” bg_color=”#99050c”]Enrol Now[/button]

Posted on by

Forecast a Positive Future Using Microsoft Excel

Time to Reflect, Thank and Plan

sales-forecasting-using-microsoft-excel-training-courseWe had our office Christmas party (for our Sydney team) this week and I went through and individually thanked each of my team for their contribution during the year. I’m very lucky to be working with a great bunch of people – although, you know what they say:”The harder I work the luckier I get” – and I used our Christmas lunch to thank each of them publicly (in front of their peers) for their efforts because I think it’s important.

We started a lot of diverse and interesting projects during the year and they include:

  1. Assembling a course to teach people how to create their own course – ideal for sites that want to create their own online Inductions for contractors,
  2. Worked with the Australian Small Business Centre to create new sales and marketing courses for their Business Management Course.
  3. Created a MYOB Bookkeeper Directory to help our students start their own bookkeeping business and find new clients
  4. Established the StartUp Academy to help ordinary people start their own business working from home

Treat Yourself as you Plan for Success in 2015

Sales forecasting using Microsoft Excel Training Courses and MYOB DataOne of our team members said she’s going on holidays and really needs the time off because she will be studying VERY hard next year. She’ll have 5 weeks off and she’s 21. I started to wonder if I am a workaholic, am a little twisted in my opinion of what makes a good holiday or that I just love what I am doing, but I offered to give her work to do while she was on holidays overseas for that long period of time – after all, isn’t it great to earn some money working from your computer, using the internet for a couple hours each day and then getting into the festivities!?

I was thinking about my ideal holiday – work a couple hours every morning (early if possible so no one is awake to distract me), then feel rewarded and REALLY enjoy the rest of the day and night. It gives me the feeling of still being connected to the world at home, while achieving something workwise and then cutting off completely from work for the rest of the day.

When I think about the festive season and the quiet time between Christmas and when most people come back to work (5th January 2015 or later) I see an opportunity to stay in Sydney where it almost becomes a pleasure to drive on the roads and spend the time in thought and contemplation to plan for the coming year. It’s usually the time when I write down my major goals for the coming year and start to clearly define them, how they’ll look and operate and what is needed to achieve them. It’s the time when I end up getting on my computer and powering up Microsoft Excel to do those once a year checks on the past and forecasts for the future.

Microsoft Excel Course for Financial Forecasting

Export Sales Report information from MYOB AccountRight to Microsoft Excel
Export Sales Report information from MYOB AccountRight to Microsoft Excel

Forecasts are those interesting things that investments are based on. Someone with a spreadsheet and a business plan will guess how much they’ll earn in the forthcoming year/quarter/month etc and back it up with all their evidence in the business plan. To many people it’s a waste of time because “who can really predict the future”, but to those people who do it it’s a way of crystalising your plans into monthly or quarterly objectives that are based on the past (in most cases) and on intelligent estimates of what the market needs.

Export Your MYOB Reports

If you already use MYOB Accounting Software to manage your bookkeeping and accounts you can easily export a report about last periods sales and use that as a basis for next years forecasts. Many slight changes can result in more sales and higher profits in 2015, including:

  • new products,
  • expanded services or
  • price increases

But your decision to no longer provide 30 days credit terms or be more diligent with late payers can help you earn your money twice as fast. Either way you do it, now is a great time to export that data from MYOB, or Xero or Quickbooks and get it into a spreadsheet (worksheet) so you can start to do some mathematics to show how much more you’ll earn in 2015.

Online Microsoft Excel Training Courses

If you’ve followed our blog posts you’d know that we have a very popular MYOB training course. I wanted you to know that we have a popular Excel Training Course too and it comes with the same benefits as most of our online courses:

  • 12 months or LIFETIME Excel Course access
  • Assessment and Certificate Option
  • Includes 9 skill levels from Excel Beginners to Advanced
  • Includes exercise files to practice
  • Includes multiple version of the Microsoft Excel Software
  • Each of the 9 courses includes an Excel Training Workbook with step-by-step exercises
  • Comes with a 30 day money back guarantee

 

Posted on by — 1 Comment

MYOB AccountRight Live Looks like MYOB-of-old + Dropbox

MYOB AccountRight Live OR in the Cloud?

MYOB AccountRight Live Basics - is it really cloud-based accounting software or MYOB and Dropbox 2
This is where you can see the myMYOB login and the Live wording in the cloud

We were asked by one of our MYOB course students recently how you can manage user access to your MYOB accounting file and we did some looking around, spoke to our MYOB course creator and came up with the following useful information.

MYOB AccountRight Live Basics - is it really cloud-based accounting software or MYOB and Dropbox 5 - manage admin and users
Click on Image to Enlarge – How MYOB AccountRight Live enables you to manage users

You can go to the MYOB website and click on my.MYOB to get to the details of your “participation” with MYOB AccountRight –

[quote]sorry, NERD ALERT! I happened to be reading the MYOB Terms of Service and “Participate” is the term that the MYOB legal team use to describe how companies use the MYOB AccountRight service -[/quote]

which enables you to choose your administrators as well as who you want to be able to access your file (like your bookkeeper or accountant). But you can also manage users from within the software. Note the out of place word here? – Software – Yes, when you launch the software and Open your Online data file, you can setup users and be much more prescriptive as to what they can access or not, but also which areas they have read only access as opposed to full access (read and write).

MYOB AccountRight User Access Managed in the Software

MYOB AccountRight Live Basics - Modifying User Access 2 - Role Based User Access
MYOB AccountRight Live Basics – Modifying User Access 2 – Role Based User Access

The silly part of this is we would expect cloud-based software to enable you to do everything in the cloud! If you look at the current MYOB model for their AccountRight Live product you still need to download the software to use it and you still need to update the company file if you update the software version!? We thought that this day had passed when the concept of cloud based accounting arrived.

Is it Designed to Help Current MYOB Users?

When I look at the way that MYOB AccountRight Live is managed at first it looks like it was built for people who are used to having a software program on their computer. Then when you see the capability to Open company data files that are stored “Online” you get the feeling that it would be just as easy to use Dropbox to store your datafile. The worst news comes when you expect the MYOB AccountRight Live software (that has a little cloud around the live) to work just like other cloud-based account programs like SAASU, QuickBooks Online and Xero you get dissappointed in having to install and use software on every computer you use – and I haven’t even tested to see if they have a program for the iPad.

MYOB AccountRight Live Basics - is it really cloud-based accounting software or MYOB and Dropbox 6 - company file needs upgrading
MYOB AccountRight Live Software – Company file still needs upgrading

If you are the kind of person that loves storing a local version of your datafile (and take the risks of protecting your own computer against, viruses, crashes or other corruption) this might seem like a good feature. I bet we see this product evolve until the point where it is finally an all online accounting solution.

How to change User Access Rights using MYOB Account Right Live

Although you can make some rudimentary changes via my.myob.com the best way to add users and make specific choices about what they can see as well as what they can edit and see, you need to launch the software (make sure you’ve downloaded it of course) and then go to Setup, User Access.

We used a current version of AccountRight Live Basics to perform our tests and any new content we create and publish for our MYOB Training Courses are available to existing students – whether you are on a 12 month course access program or LIFETIME course access. Feel free to enquire with us if you have any questions about our online MYOB Training Courses, or enrol today, start by 5pm tomorrow and be comforted by a 30 day money back guarantee.

Posted on by — 1 Comment

The Power of the Homegrown Australian Business

When ‘Aussie’ is a gold winner

Reach Accounting free course from EzyLearnIN ADDITION TO OUR MYOB and Xero online training courses, we also offer an online training course in Reach Accounting, the cloud-accounting software by Aussie-owned company, Net Registry.

Not many people are aware of this, and I’ve been quite remiss when it comes to talking about it on this blog. In fact, I’ve spent more time talking about Zoho and QuickBooks recently, than I have spent time talking about Reach.

This is partly because I’ve been quite interested to see how QuickBooks has been resurrected by it’s American-owned parent company, Intuit, as it attempts to take on Xero and MYOB in the Australian marketplace again.

Zoho is both comprehensive and cheap

My interest in Zoho, meanwhile, stems from one of my contractors, who uses Zoho Books to manage her business accounts; she was telling me about Zoho’s many features, and I surprised to learn just how comprehensive the Zoho Books software is for such a low price.

Zoho and QuickBooks are both positioning themselves as low-cost accounting packages to appeal to the substantial small business market in Australia, but there’s just one thing they can’t compete with Reach Accounting on, and that’s ‘Australianness’.

Reach Accounting is an Australian owned and operated business, and as the owner of an Australian owned and operated business, I like to support other Australians in their business ventures. Reach Accounting focus their accounting software towards people who start a business as a website designer.

Why it’s harder for Aussie businesses to compete

I’m always saddened when I hear of Australian businesses being sold to overseas conglomerates, which take the Aussie jobs back overseas with them, where the wages and materials are cheaper. It makes it all the more difficult to compete for customers in the Australian marketplace when your once-Australian competitor is now producing products or services at a much lower price at their offshore headquarters.

It’s also difficult to compete with the increasing number of overseas-owned businesses entering the fray, now that the Internet has unlocked a global marketplace. What many Australian businesses don’t realise, however, is that they possess a power those overseas businesses don’t: they speak Aussie.

Whether you’re a home-based bookkeeper or virtual assistant, one of your greatest assets is that you’re an Australian and that means you have a deep understanding of what it means to be Australian – from the accent to the vernacular, you get it.

The power of ‘G’day’

It’s also a lot easier to call an Australian company than it is to call an overseas one. My Zoho Books-using contractor was telling me of a complex situation she was experiencing with her account. Unfortunately, the nearest customer service office she could call was located in China, so she had to email.

Several confused emails later, she finally realised what had happened with her account, and managed to resolve the issue herself. She later told me: “It’s a good thing I studied semiotics at university, because deciphering those emails was like trying to interpret hieroglyphics.”

I suddenly thought about Reach Accounting, which is based in the Inner Sydney suburb of Ultimo. For the same price as Zoho Books – possibly even cheaper now, thanks to the fluctuating Aussie dollar – it would have been much easier to say “G’day” to one of the guys at Reach than it was to email China or India or Japan or wherever in the world Zoho’s customer service offices are based.

Don’t be afraid to say “G’day”

As an Australian business, don’t hide your Australianness from view. Wear it proudly, because it makes a big difference to customers trying to decide between your company and the multinational after their business.

For more information on any of our cloud-accounting courses, visit our website.

Become a Virtual Assistant and Start a Business

start a bookkeeping business
Business Opportunities for Ordinary People

While we are on the topic I want to mention our StartUp Academy because we are planning some fantastic ways of helping ordinary people start a business in 2015.

We’re using a combination of our Small Business Management Course and business opportunities from established companies who want to find people who can work from home and sell and support their products.

We’re also using our Small Business Management course to help our existing students start businesses using the skills they learn in their EzyLearn course – namely MYOB and WordPress. If you’re interested in starting a bookkeeping business read on about National Bookkeeping.

Posted on by

Get Paid Faster Using Your Mobile Phone!

get paid faster using your mobile phone
You can use your mobile phone to get paid – great for tradespeople as well.

No doubt about it, one of the biggest hurdles you face as a small business owner is managing your cash flow. A big part of this is ensuring your clients and customers pay your invoices on time.

Setting up email alerts to remind customers when your invoices are due is a great way to ensure you’re never – or at least, rarely – paid late, which we’ve written about on this blog and even cover in our MYOB training courses. Continue reading Get Paid Faster Using Your Mobile Phone!