Learn Xero in less than 5 days

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

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

Continue reading Learn Xero in less than 5 days

Just be yourself

If you’re looking for a job it’s a daunting process because you have to sell yourself to an employer and most people don’t have to do this very often. Parents returning from parenting can find it particularly daunting because they’ve found themselves surrounded by nappies, cleaning, cooking and washing and the thought of presenting themselves to other adults can be scary.

I’ve spoken to some EzyLearn students in the last couple weeks about our Accounting Course Tutor Initiative and have been impressed at how capable many of them (you) are!

Continue reading Just be yourself

Are You Living Your Best Life?

COULD YOU EARN a second income by running a website? Thousands of Australians already are; if you have bookkeeping or creative skills, perhaps it’s suited to you too.

Most people now know that the old way of working — long hours in an office at a job they don’t really enjoy — is not living their best life. And simply dreaming of a better one simply won’t cut it, but there is a way. Continue reading Are You Living Your Best Life?

Receipt Scanning, Automatic Coding – Boon for Bookkeepers or Job Killer?

DO YOU GET frustrated when you see the little box at the bottom of the BAS lodgement form? You know, the one where they ask how long it took to complete the form because I feel like writing, “It took 10 minutes to complete the form, but 4 hours to do the data entry and bank reconciliation work!”

Junior bookkeepers, accounts receivable and accounts payable clerks, and office administrators will all share that their most time-consuming work is data entry, coding and bank reconciliations. However, there is software available which almost totally automates this work — and it’s becoming increasingly accurate and speedy.

Continue reading Receipt Scanning, Automatic Coding – Boon for Bookkeepers or Job Killer?

I’m a Bookkeeper – How Do I Find Good Work?

As mentioned in an earlier post, job boards offer the best-quality jobs for people in professions that translate to any industry; and this includes bookkeeping and accounting jobs.

And as another post showed, there’s a vast number of bookkeeping jobs posted to those sites every day, be it for casual, part-time or full time work. In this post I’m going to explore some ways to do well in the job market. Continue reading I’m a Bookkeeper – How Do I Find Good Work?

What Do Employers Want From Bookkeeping Job Sites?

THE ULTIMATE GOAL of a job site (and they are not all created equal!) is to deliver the highest volume of candidate applications to the job poster (the recruiter or employer), while also providing candidates (job-seekers) with access to the highest volume of top-quality job listings.

Since recruitment classifieds moved online more than two decades ago, the ease with which job-seekers could apply for jobs increased.

Job posters went from getting a handful of applications over the course of a few weeks to hundreds all at once. This spawned the need for businesses to best manage and dare I say it, automate and systemise the hiring process. Continue reading What Do Employers Want From Bookkeeping Job Sites?

The Best Job Sites for Accounting & Bookkeeping Jobs

JOB SITES ARE IN ABUNDANCE in Australia. The market leader is Seek, which controls 85 percent of the online recruitment market. Most job site advertisers use Seek because they will get the widest and potentially best range of job applicants and job seekers.

Typically, if you’re looking for a good-quality job that doesn’t tie you to a specific industry — the way journalism ties journalists to the media industry, or construction work ties builders and plumbers and cabinet-makers to the construction industry — you’ll find it on Seek. But here are 8 more website you can use.

Continue reading The Best Job Sites for Accounting & Bookkeeping Jobs

How to Become an Office Administrator

AN OFFICE ADMINISTRATOR, or administration officer, will provide an array of general administrative tasks for a business or organisation.

These include filing, archiving, calendar & project management, reporting and customer service. Some office administrators carry out basic bookkeeping tasks, such as creating and recording invoices and expenses and the more skills you have the more valuable you become.

Continue reading How to Become an Office Administrator

How to Become an Accounts Payable Officer

ACCOUNTS PAYABLE OFFICERS are responsible for paying invoices owed by a company to its suppliers or vendors.

They typically work in medium to large-sized businesses, where they may also be called an accounts officer and be responsible for investigating the cost of wages, materials, overheads and other operating expenses.

Here are some of the other common tasks you’ll find in an accounts payable officers job description.

Continue reading How to Become an Accounts Payable Officer

How to Become a Payroll Officer

WE HAVE FOUND it particularly useful to talk about the kinds of job outcomes they might expect from enrolling in our online training courses. If you’re after a job as a Payroll Administration Officer, or working with payroll generally, then you’ll need to be able to conduct payroll processing, tax and superannuation calculations and the payment of staff within a company.

People working as payroll administration officers, or payroll administrators, can also work as bookkeepers, or even BAS agents, who specialise in payroll only; either within the payroll department of a business or accounting / bookkeeping firm.

Here are some common Payroll Administration tasks in a job description.

Continue reading How to Become a Payroll Officer

How to Become a Bookkeeper

BOOKKEEPERS PROVIDE ESSENTIAL services to businesses by processing and recording everyday financial transactions, and keeping accurate records.

They usually work in small to medium-sized businesses, where the scope of their role and responsibilities will vary based on the size of the business.

Many bookkeepers are also required to prepare and lodge business activity statements (BAS). To provide BAS services for a fee, bookkeepers must be registered with the Tax Practitioners Board (TPB).

Continue reading How to Become a Bookkeeper

Sometimes “Real World” Marketing, Not Digital, is More Appropriate

start your own business
It’s not unusual to obtain new work because people in need of your services spot you working on your current job. But chance is one thing – how can you improve the odds of making this happen?

IF YOU’RE A TRADIE, working as a plumber, builder or carpenter, handyman, gardener or electrician, then you probably already know that some of the best jobs come by referral.

Identify “real world” marketing opportunities

During my recent renovation of an investment property in Newcastle, most of the good tradies would tell me, “Someone you’re working on a job with on Monday will ask you to do a job for them somewhere else on Friday, or a neighbour of a client will ask you to do some work for them.” I soon saw from other tradespeople how “work can come to you just because someone happens to be walking by while you’re on the job” — gardeners get a lot of work this way, for example.

The important thing in this scenario is to act efficiently in finding out what the potential client needs, finding out what else is important, and then selling them on your services. I recently had the pleasure of interviewing Kristine Seymour, an experienced sales person and business builder, for the Sales Training Course at the Australian Small Business Centre (ASBC). She spoke in detail about how to act when your future income depends on how well you can sell. This Sales Training Course is available on the EzyLearn LMS.

Take advantage of business opportunities

This course is also available to new licencees for the National Bookkeeping Business Opportunity. The key to getting new clients is to be proactive and take advantage of these on-the-spot business opportunities by using some “real world” marketing tactics. These skills can be used even if you are just looking for part-time clients or doing bookkeeping or marketing as a side hustle — more on side hustles in a forthcoming blog. 

Some “real-world marketing” examples

Another good example of a real-world marketing tactic is to conduct a letterbox drop in the local area where you’ve just started work. Clearly, this lets residents in the area know you’re working there, what you do, and that you are available.

This alone may lead to thousands of dollars in additional revenue if even just a few people get in touch. But always, it’s vital to keep track of what marketing you do and where leads are coming from. It’s vital to schedule quotes and start dates for work and so forth, and have a handle on Office Productivity Software like Microsoft Office or Google G Suite. These will not only help you organise your workload, but you’ll also appear organised and professional to your clients.

***

Learn more about both digital and face-to-face (networking) marketing in our EzyStartup Training Course. Visit our website for more information or to enrol.


learn online training Xero courses videos for less

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.


REF #688

3 Things You MUST Do in Excel!

Business owners and job seekers take note!

learn xero myob excel online training course videos
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…

Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn xero myob excel cheap online training courses videos

At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development


 

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


 

Is Your Resume Costing You a Bookkeeping Job?

It’s easy to spot bad Microsoft Word skills

203 Microsoft Word Beginners Courses for sales letter, flyers, resumes, cover letters and tender proposalsWe’ve had several hundred bookkeepers Pre-Qualify for our National Bookkeeping, Bookkeeper Directory and most of them upload a resume demonstrating their qualifications, experience and references but I’m baffled at how bad the formatting is in these resumes!

To help our students do the best job presenting themselves on paper we’re including the Microsoft Word Course for free when you enrol into either the MYOB Courses or Microsoft Excel Courses (when you choose the all courses and 12 months access with Certificate option). That’s a saving of $267!

Resume writing tips for bookkeepers

Here are some tips we’ve published in the past:

The problem with making mistakes with your Microsoft Word formatting is that questions could come up in an interview. The Interviewer might throw in a question about software skills, particularly if you’ll be writing some detailed reports or proposals, forecasts etc. in the new job.

Online Training Course special offers for MYOB, Xero, Excel, Word and more
Click the image to see our current special offers!

Here are some extra tips for Bookkeeper resumes

Most of the Microsoft Word skills you need to write a good resume are covered in our Word Intermediate Courses, but we’re including the entire 9 courses so you can become a power Microsoft Word user! Here are a couple other things to think about when writing you resume:

  1. Include an image – it makes you stand out and brings the reader closer (make it a selfie where you’re smiling 🙂
  2. Use tables or “Set tabs” to make columns line up
  3. Headers and Footers demonstrate a sophisticated knowledge of Word
  4. Include your full name and desired role in the filename (we’re all using files these days! use it to your advantage)

The last one about filenames is a big one because if interviewers are like me they’ll put all the resumes for one role into a folder and I find myself renaming most of them!

FREE Microsoft Word Workbook

We spend a lot of time on marketing so I assume that you know we offer free samples of our training material, but I should mention again that the Microsoft Word sample is actually the entire Word Beginners Course 201 Training Workbook, make sure you get it! Get it now.

Quickbooks Course Update

intuit-quickbooks-accounting-software-training-courses-logoIt’s been a while in the making, but we have the final draft of our Quickbooks Course workbook! Unlike some training companies, we write up a detailed course story based on a real business scenario and use that as the basis for recording our screen videos that demonstrate how to use the software. We’ve had a huge number of Course Alert Registrations and they’ll ALL receive a free copy of the workbook, so if you haven’t already registered do it NOW!

EzyLearn Wholesale Partner Update

earn money working from home using and teaching how to use MS Office, MYOB, WordPress, Facebook, Xero and moreI made a brief reference to our new Enrolment Voucher system in a recent post about BAS deadlines and we’ve got an update. The new enrolment voucher system is now in beta testing which means we’ll shortly be inviting EzyLearn students who love our courses to receive a massive wholesale discount on selected courses. Make sure you register your interest.

Bad Payers Cost 12 Working Days to Collect $13,200

Credit Management is an Extra Job

credit-management-training-assessment-management-and-enforcementI’ve always believed that as soon as you offer credit you’ve got yourself another business – a credit management business. When we first created our MYOB Daily Transactions course we designed it to take students through the cashflow process of where money goes when it first leaves your bank account and these are the main steps:

  1. Money in the bank (cash asset)
  2. Buy stock (inventory asset)
  3. Products sold on account (accounts receivable asset – Trade Debtors)
  4. Customer pays their account (cash asset)

The interesting part of this business process to me is the marketing (choosing the products, pricing, marketing message and advertising) and the credit management to get the money back. Each of these stages and their tasks carry a certain amount of risk but the credit risk part is actually something you can manage to try to eliminate altogether, but it takes work and a system.

Well the good news is that we’ve created a Credit Management Training Guide that goes through the different parts of your business where you can put measures in place to reduce this risk significantly – even if you are in the trades or building industry.

Credit Management is a Job for Contractors

credit-management-accounts-receivable-payable-and-data-entry-are-jobs-for-contractors-with-their-own-bookkeeping-businessMany tasks in businesses these days is actually contracted out to independent contractors because of the flexibility and credit management is a great example because it can be performed a day a week (for smaller businesses) and it can even be performed by a remote contractor (virtual assistant) working from their own home office. See Credit Management Services at Natbooks! 

Since we’ve started working with local bookkeepers at National Bookkeeping we’ve realised that credit management and daily transactions type work is by far the most common form of task performed by a bookkeeper. The rate of pay for bookkeepers performing this work is generally lower, but it’s a great option for people like working mums or dads who want to fit their work into their children’s school schedules as well as corporate accountants who want to make a start on their own bookkeeping business in their local area.

The corporate accountants or accounts managers we speak with often start performing this work in their new bookkeeping business but as their business grows they fill this position with a contractor of their own. Pre Qualify to join National Bookkeeping

Paypal and Quickbooks

Quickbooks Online is back and they want to beat MYOB and Xero
Stop tearing your hair out chasing money 

Last year I wrote about the joint venture between Quickbooks (Intuit) and Paypal and how they want to help businesses get paid faster. They commissioned a study last year found that Australian small businesses are owed a collective $26 million in unpaid invoices. That’s roughly $13,200 owed to each business at any given time, for which business owners will spend an average of 12 days chasing them each year.

It’s a lot of time and effort to earn that kind of money particularly if you’ve actually already earned it by supplying your products and services!

Check out our Credit Management information page and watch out for the announcement when we include it as a student inclusion for ALL students. We created this guide to help businesses use their accounting software to better manage the credit risk in their business. We’ve included information for builders and contractors about the Security of Payments Act.