Looking through Seek for data entry jobs yesterday reminded me of the training courses we offered when we operated our Dee Why training centre. It was the dotcom boom and MYOB Accounts Receivable and Payable courses were our popular weekend courses but most students needed more basic data entry skills.
Data entry skills include typing, editing documents, entering data into spreadsheets, saving files and then opening, editing and saving them again!
More job seekers have data entry skills but there’s so much more to know about basic Word and Excel usage that employers need you to know.
Are you chasing money? If so, you’ll probably know the hard way that credit management is about chasing money owed TO a business (Accounts Receivable) and managing the money owed BY a business (Accounts Payable).
Credit can be a very scary thing when money and cashflow is tight! Machines and software are replacing humans for many data entry type tasks, but nowadays this is also the case for chasing money owed (Accounts Receivable).
This Xero Accounting and PayPal training workbook is our free gift to you. It’s designed for all tradespeople — and anyone else — who does the bulk of their work (and their pricing) ‘out and about’.
It’s designed to help people who just want to get the financial aspect of their work sorted out — so they can get back to doing what they do best. In the case of these tradies, it was doing a great job on the tools.
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.
Xero has quickly gained momentum in the accounting software space, and while it’s important for bookkeepers to be skilled in MYOB, it’s becoming increasingly important that they’re also skilled in Xero as well.
Upskilling to Xero
We developed a Xero training course for bookkeepers who’d like to add another skill to their CV, or for business owners looking for an alternative to MYOB. Like MYOB, you can add bank feeds to your Xero package, something that is very popular because it saves you time and money.
Here, Xero Certified Advisor, Jacci Quinlivan, talks us through setting up the bank feeds function in Xero:
“Automatic Bank Feeds are becoming increasingly common and if you are using Xero, it has never been so easy to automate them and make your data processing even easier.
When you are initially setting up your bank account details in Xero, the program will automatically tell you if your bank has the availability to get live data feeds (most banks are Xero partners these days). This involves pre-populating a form with your bank account information and sending it off to Xero’s bank feeds department (a scanned, emailed copy does usually suffice). The turnaround time from when you email or post the form usually takes between 7-10 working days.
You will receive an email from Xero once this has been completed and your data feeds will automatically sync with your bank. There is now no more uploading manual bank statements and the like from the new processed date. If your accounts aren’t quite in sync there may be a variety of things to check from the accuracy of your opening balances, or maybe you had missed a few transactions when you were manually importing them.
If you need to go back with your data feeds you may need to do this manually as a once off until you reach your current live bank feed date. This will involve you obtaining your banking history in a CSV format (OFX and QIF is fine), ensuring the columns are in the correct format and uploading to your Xero AIS. This may seem daunting, especially if you have hundreds or even thousands of transactions to reconcile, but by using the “cash coding” tab within your program, this can be done much quicker than imagined.”
We cover setting up bank feeds along with many other aspects to get you working proficiently in Xero in our online Xero Training Course.
What we’ve discovered during this R&D process is that an increasing number of accountants have told us that they use a service called BankLink, so we thought we’d take a closer look at BankLink to see how it works and what it means for the bookkeeper.
BankLink for Bookkeepers
BankLink is an accounting service that delivers bank transaction data from banks and financial institutions and directly to an accountant, which the accountant then uses to code their clients’ transactions.
For any uncoded data, there are number of online tools that allow an accountant to request additional information from their clients; the coded data is then used for GST, end-of-year tax reports, management reports and various other reports required for tax compliance.
In short, BankLink eliminates all of the data entry usually performed by a bookkeeper, and in June of 2013, BankLink was acquired by MYOB to further facilitate accountants as they manage their clients’ books.
For sole traders and very small businesses that have neither a bookkeeper, nor the time to manage the data entry side of their accounts, their accountant can now manage this for them easily and efficiently, without the added cost of employing an external bookkeeper.
One accountant, extolling the virtues of the BankLink software on the MYOB website calls Banklink his “extra employee; one that never makes mistakes, gets lots done and doesn’t cost much.”
BankLink is being billed as the future of accounting; the inexpensive future of accounting, where people are being replaced by machines and pieces of software.
So what might that mean for the humble bookkeeper? We look at this in our next post.