All businesses need to manage their financial affairs and report their financial results to tax and reporting authorities so they need staff or contractors from junior level bookkeepers for accounts receivable and payable and accounts reconciliation as well as Accounts and Office Managers who look after GST and BAS tasks as well as Payroll Administration.
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.
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!
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.
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 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.
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.
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.
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.
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!
We show you how to write off stock and inventory before the EOFY
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.
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.
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.
We’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!
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.
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:
Include an image – it makes you stand out and brings the reader closer (make it a selfie where you’re smiling 🙂
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
It’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
I 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.