Who doesn’t love a free trial? The great thing about some of the popular accounting software like Xero, QuickBooks, and MYOB is that they provide 30-day free trials where you can use the software at no cost.
It’s great for businesses and contractors wanting to find the right accounting software for them, or for students looking to get experience as they study.
MYOB didn’t used to require any credit card details when signing up for the trial subscription…but now they do. Whilst Xero and QuickBooks continue to offer trials with no credit card required, MYOB has diverted from the pack to deliver this unexpected and unwanted change.
A bookkeeper who’s certified in a particular accounting software may not mean that much for your business. Better to have someone who is simply a good bookkeeper. Period.
Now that virtual bookkeepers have become more common, lots of business owners have started selecting bookkeepers based on their affiliation with an accounting application. Such bookkeepers are often called a Certified Advisor (Xero), Pro Advisor (QuickBooks) or Certified Consultant (MYOB). But are they really the best bookkeeper for your business?
What are Certified Advisors, Consultants and Pro Advisors?
In a nutshell, a certified advisor, consultant or pro advisor is just an individual who has been endorsed by a software company because they’ve demonstrated a high level of knowledge and skill with a particular accounting product.
Hiring a bookkeeper who’s been endorsed by MYOB, say, means you shouldn’t have to worry about whether your bookkeeper has set up your accounting package correctly, or whether they’re using the correct codes. What it doesn’t guarantee, however, is that each consultant or advisor is a highly experienced BAS agent, as the certification relates to their software knowledge only.
Certified Advisors and Pro Advisors go through their certificate, which is often free, because it elevates their own profile. It can also demonstrate that they are committed to that software program more than others. The Xero Certification training (at the time of writing) has a strong focus on understanding how to use the Xero Agent portal to bring clients onto the platform – and not so much about learning bookkeeping or to become a BAS Agent.
If you don’t have an accountant or BAS Agent then you should make that your starting point as everyone needs someone who can perform tasks that relate to tax and GST who acts on your behalf. If you have that setup already you can hire someone who has good bookkeeping skills using MYOB or Xero but is cheaper because they are not registered or licensed. This junior bookkeeper can perform your office admin, accounts and even customer service while your Registered BAS Agent or Tax Accountant can sign off on your financial figures.
Find a highly qualified BAS or tax agent instead
Sure, a bookkeeper who’s experienced in your accounting package is important. It’ll help keep your bookkeeping bill down because they’re able to perform certain functions quickly, while your accountant shouldn’t need to fix any errors, either. But that’s only providing that they’re as knowledgeable in Australian tax as they are MYOB or Xero or QuickBooks.
Unfortunately, however, the two aren’t mutually exclusive. So instead of focussing on a bookkeeper’s software experience, it’s more beneficial to ensure they’re qualified BAS and tax agents, with either a Certificate IV in Bookkeeping or higher.
If you don’t get a bad reference from their current and former clients, then there’s a pretty good chance they’re proficient in the major accounting packages, and if they’re not, most bookkeepers will tell you upfront.
Get the accounting package that’s best for your business, not your bookkeeper
There are lots of reasons a bookkeeper would choose to become certified with a software company, the biggest being that they get their accounting software for free and receive a commission for each new client they sign up to use the accounting package they’ve been certified with.
However, when you hire an independent bookkeeper who’s well-versed in a few different accounting packages, you’re more likely to get better advice about which accounting package is best suited to you and your business’s needs, rather than the accounting package that will generate income for your bookkeeper.
***
Are you looking to brush up your skills in cloud-accounting packages like XERO, MYOB or Quickbooks? We provide a range of online training courses in all of these packages at ONE LOW COST for ALL SKILLS LEVELS. Find out more.
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.
Excel isn’t just for budding bookkeepers; it’s a great tool for all business owners to know.
MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.
A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.
But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:
1. Vertical align: always centre
Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.
2. Build error-checking into formulas
There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.
Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.
3. Print preview your work
Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.
However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!
***
For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…
Managing large amounts of client and business data is not only possible, but also something you can learn fast and with ease with the help of our comprehensive range of online Excel training courses – covering all skills levels.
MICROSOFT EXCEL IS THE most widely-used spreadsheet application in modern computing. It’s ubiquity means most people use Excel on a regular basis, despite never having had any formal training in its many, many, MANY functions.
With its 2013 release, Excel got a serious update, which made it the perfect application to create and manage client and customer databases. Although there are many CRMs available on a subscription that provide the same functions of a database created in Excel, just in a more visually appealing format, they often lack reporting and analysis functions, requiring you to export your data in a Excel sheet anyway.
Flat file databases
Excel’s original ‘flat file’ database still remains the easiest and most basic database to set up and manage, and depending on your business and how you’ll use your database, a flat file database may be all you’ll ever need. If set up correctly, a flat file database will allow you to easily import your customer data into Word, your accounting software, an email marketing service, and so forth.
Relational databases
A relational database is a database that’s structured to recognise relations among the information stored in them. Microsoft offers a relational database program, called Access, which is available with Microsoft Office Professional or higher, or can be purchased separately.
Alternatively, you can create your own relational database in Microsoft Excel, providing you have the 2013 version or newer. When Excel got its update in 2013, it became easier to link charts and cells and to perform searches — all essential features if you’re working with large amounts of business data.
Correct Excel set up is crucial
Once Excel has been set up, it’s as easy as it is powerful to use. Of course, the key is to set it up correctly, so you can avoid errors or having to re-enter large amounts of data to make the format suit another third party software application.
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 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
Magazine 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.
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.
WE’VE ENTERED QUARTER 4 for the 2016/17 financial year, so we’ve been writing about the things your business should be doing this quarter in preparation for the end of the financial year. In our last post we wrote about writing off stock and inventory. Now we’re looking at business expenses.
We show you how to write off stock and inventory before the EOFY
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:
Selling air conditioning units
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.
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.
Third Quarter is Looming; Are You Up to Date with Payroll?
Most businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense.
Every Australian business with employees who are each paid more than the tax-free threshold has a legal obligation to withhold tax on their employees’ behalf. This is known as the PAYG System (or Pay As You Go), where amounts of tax are withheld from each employee’s wage payments.
Businesses that withhold up to $25,000 each year only need to make payments to the ATO each quarter; businesses withholding amounts greater than $25,001 may have to make payments to the ATO each month or as regularly as each week.
At the time of writing, the tax-free threshold is currently $18,200, which is equivalent to:
$350 a week
$700 a fortnight
$1,517 a month
Superannuation contributions
Again, any business that pays its employees more than $450 each month must also make regular superannuation contributions on their employees’ behalf. We’ve written in the past about the government’s clearing house called SuperStream, which allows you to easily make super contributions — for free.
But first, you need to work out how much super you need to contribute for your employees. The superannuation guarantee is currently 9.5 percent of your employees’ gross wages, which is payable on top of their wages — not deducted out of.
Using tax tables to calculate wages
Each year, the ATO produces a range of tax tables to help you work out how much to withhold from payments you make to your employees. In our Ad Hoc Payroll Micro Course, we’ve already added the most current tax tables to the accompanying payroll spreadsheet, as well as the superannuation guarantee tables.
Doing regular weekly bank reconciliations will help avoid confusion or errors later on.
In our Xero Bank Reconciliations and Journal Entries Course, you’ll learn how to carry out each step in the reconciliation process, in particular how to set up bank feeds. Bank feeds are an important function that allows transactions on your linked bank account or credit card to automatically show up in Xero, so you (or your bookkeeper) don’t have to spend time entering the details from scratch.
Incorporating Xero bank feeds will save you time, money and stress.
Cloud accounting software’s greatest innovation was not putting the software in the cloud; it was introducing bank feeds. You’ll learn how to set up bank feeds in the latest version of Xero in our Xero Bank Reconciliations and Journal Entries course. For now however, we’re going to explain why you should — whether you’re a business owner doing your own bookkeeping or whether you’re a bookkeeper employed to do it for your clients — be using bank feeds.
Bank feeds in brief
A bank feed is an automatically created list of the transactions (spent and received) in your bank account that is imported into your Xero accounting software. For this to occur, you have to give Xero permission to access your account. Some people feel funny about this, but bank feeds have been around for so long now that, just like online shopping, there’s really nothing to worry about. I won’t go into how the technology works, but I will say that no one looks at your account data; you’re just allowing the free flow of information between your bank and Xero.
Direct bank feeds save time (and indirectly, money)
There was a time when you or your bookkeeper had to wait until your bank statement arrived before any transactions could be reconciled in your accounting software, usually at the end of the month. For businesses with a lot of transactions, either in the form of receivables or payables or both, reconciling a month’s worth is a finicky job that’s prone to errors.
With bank feeds, transactions will show up in your accounting software as soon as the payment leaves your account or credit card. If you (or your bookkeeper) get in the habit of reconciling your account on a daily, twice weekly or weekly basis, it makes it easier to accurately code each transaction because you’re only dealing with a few at a time. This results in fewer errors and fewer hours spent fixing them, and that saves money (read: time = money).
When it Comes to Your Career, Hopping Around is OK
Those who hop may be the most successful, career speaking.
For many years, young people, particularly Generation Y, were cautioned about changing their jobs too often — or being a “job hopper”. It would give the impression they were flaky or disloyal or unable to commit, they were told,
You want to find a job where you can stay there for at least 10 years, where you can grow and progress through the company.
What To Do So You Don’t Lose Money When Doing Your BAS – 6 steps
If your business is registered for GST, it means you have to file regular activity statements with the ATO, usually each quarter. A lot of business owners export their Business Activity Statement (BAS) data straight from their accounting software, like MYOB or QuickBooks, and quickly prepare their BAS’ that way. But this is an imprecise method, and one that could be costing you money.
It’s Good Business to Set Out Your Credit Management Policy at the Outset
CRITICAL TO THE SUCCESS OF ANY BUSINESS is the ability to maintain a healthy cash flow. But doing so requires effective credit management processes.
Unfortunately, too many business owners feel uncomfortable talking about credit and debt management upfront with new clients.
They (falsely) believe it begins if, and when, a customer doesn’t pay a bill. But, in fact, credit management starts much, much earlier than that — long before the two businesses even agree to work with each other, to be precise. Continue reading Is Credit Management Just About Getting on the Phone?
Because it’s the beginning of the year we are receiving a lot of calls from students who are looking to do an MYOB Course so we are thrilled to confirm that we offer access to ALL of our MYOB Courses for one low price and 12 months course access.
You can follow our journey from operating training centres in Sydney’s Dee Why, to the decision to go 100% online at the About EzyLearn page on our website, but I’ll sum it up in 1 paragraph here:
We can guarantee consistent course content to every student, with MYOB Course content developed over 15 years in teaching people how to use MYOB and from some of the best MYOB Trainers in Australia. By creating our own MYOB courses and updating them we are able to focus on the content of our courses as well as the systems to support it online rather than paying for office rent, computers and software licences, trainers and advertising.
MYOB Course Options
The only decision you need to make is whether you want an MYOB certificate and 12 months or lifetime course access. Remember that unlike some MYOB course providers our students can move freely from one course to the next as they please and use the course as a resource while at their new job or operating their own bookkeeping business.
MYOB Videos, Training Workbooks and Knowledge Reviews
With a 100% focus on MYOB Course content we create every form of training material for MYOB accounting software: Videos, Workbooks (with step-by-step exercises) and Knowledge Reviews that test your skills. You can watch a video and try to replicate it with the free MYOB software or follow the exercises in the MYOB Trainingg Workbooks to perform tasks that bookkeepers perform every day in their working environment.
Money-back Guarantee
When we were the first training company to offer MYOB courses online in 2008 we offered the money-back guarantee because not everybody had great broadband Internet speeds, not everyone knew how to navigate around websites and online learning management systems and people where generally scared to use their credit card online. Now-a-days we find that the biggest reason some students find it a comfort is because many students are Mac users and are not sure that they would learn by using MYOB Course content created for the Windows versions of the MYOB software.
Why Thousands of Students Choose EzyLearn for MYOB EVERY Year
We use the Content Marketing approach to building our brand and product awareness and it takes a lot of effort to put the amount of detail we put on our website and in our blog posts. We do it because it shows an ongoing commitment to openness but also to leave no doubt as to exactly what we offer and how we support it. If you want to get to know more about us read some of our blog posts or watch some sample videos. If you are ready to enrol into an online MYOB course then enrol now online and start by 5pm next business day!
Working for free is often better than discounting your fees.
We’ve spoken about working for free before. In one post about setting prices we discussed why you should outline the free work that you do as ‘added value’, but if that’s still not working, maybe you should consider working for free.
Type the first 3 characters to discover courses, up-skilling programs and CPD articles.
EzyLearn's Career Academy
Enrolled into an EzyLearn course since 2013? Get access to new & updated course content and support by joining the EzyLearn Course Refresher Access membership Program. See how to extend your course life & support.
Xero is a great bookkeeping program for tradies who are on the go and using their phones (or a tablet) all the time. From receipts scanning to creating quotes and invoices, receiving payments and keeping track of project costs.
bookkeepercourse.com.au/produ…
Magazine 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. 
Most businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense. 
Bank feeds are an important aspect of reconciling your (or your client’s) accounts. Our 
