My accountant has asked I enter an alignment journal before I roll over. What is this about and what is the point?
The purpose of end-of-year (EOY) adjustment entries is to get your ducks in a row and align your MYOB file with your accountant’s end of year tax accounts. Their job is to check over your file and make various adjustments (corrections, depreciation and tax entries). To put you back on the straight and narrow they will want your MYOB to match their financial reports. This will help you for management reporting and be necessary if you need to visit your friendly bank manager – they inevitable want to study your Balance Sheet & Profit & Loss statement. It is very important your reports read correctly.
Your accountants may provide the EOY adjustment journals by paper form or as an Excel spreadsheet. If they don’t give you anything it is recommended you do a general journal to correct the Balance Sheet figures to the Lodged Balance Sheet provided by the Accountant.
So how do I enter in MYOB?
Once posted print your Balance Sheet at EOY and check it matches your accountants Balance Sheet (do not assume the entry will line you up).
Everyone wants the perfect person in the office. One that comes with a high level of understanding and experience in both accounting and payroll. One that has knowledge of the software you use PLUS competencies using a computer AND a working knowledge of Microsoft Office. As well as that you want them to fit in with the dynamics of your office and get on with other staff, customers and suppliers. It's a big ask.
Appoint the wrong person and it can cost your business dearly. If you take on someone with minimal knowledge of accounting & payroll and leave them to their own devices then it is likely the following may occur:
Any of the situations above will cost your business. We regularly see unqualified and/or inexperienced people taken on to do accounts. As there is no formal qualification for a bookkeeper, people profess to know when they don't. Applicants will say anything to land the job. We have been asked by new recruits to have training the day before they start the job. This is scary stuff.
To avoid this problem and mitigate the likelihood of having a tidy MYOB file destroyed by an incompetent bookkeeper we recommend you use a recruiter to short list and help appoint your accounts staff.
We like recruiters who work with MYOB software and understand both accounting and payroll. Recruiters who can quickly source and select candidates to fit the required roles. Recruiters who have skin in the game and work with you and the candidate to ensure there is a good fit. We also strongly believe that candidates should be assessed to test their capabilities. A good recruiter will do that.
What roles should you use recruiters for?
Pay clerks - for IMS, ACE, MYOB Payroll or EXO Employer Services Payroll. Good experience with one payroll certainly helps learning another payroll. Understanding NZ legislation is a must.
Bookkeepers/Accounts people - part or full time bookkeepers to process accounts receivable and payables, complete and reconcile cash books, maintain inventory and job costing where required. These positions may be sole charge and include payroll and other responsibilities.
Accountants - fully or semi-qualified part and full time accountants to process and complete end of month reconciliations for management reports, prepare and file both GST and PAYE summaries.
If you are looking for new staff and want advise on where to go then please call us. We can direct you to a recruiter who can help.
We get asked all the time... “Is Xero better?”; “What about MYOB?”; “Should I use Xero?”; “Is MYOB online?” and so on. It seems that everyone has an opinion (informed or otherwise), when it comes to answering these questions. MYOB has a range of solutions to suit micro businesses all the way up to larger businesses. We focus here on AccountRight.
The fact is that MYOB AccountRight and Xero are very different beasts. For a start they work quite differently - Xero is 100% browser-based *, while MYOB AccountRight is a hybrid model which means the software is installed on your computer but the data's in the cloud meaning you can access it online or offline. (* MYOB Essentials is similar to Xero being browser based).
Xero and MYOB AccountRight each have pros and cons. As professional accounting software consultants we’re very familiar with both - here are some of the things we like about each:
Some Chartered accountants insist you must use Xero. They do this because it suits them. Our philosophy is that you use the software that suits you best. That may be Xero or it may be MYOB. It may be Quickbooks, Infusion, Cash Manager, MYOB Advanced, Great Plains, Net Suite or some other package. Your accountant exists to do your end of year accounts, advise on tax and business structure, and provide advisory services. They are not there to dictate what car you drive and what business tools you must use. A good accountant should be able to open any accounting program and run the reports they want. They should use software which imports the data and we are able to assist them if required.
Accounting as a practice has never changed in hundreds of years and manual systems taught in secondary school is the same as ever. We still have source documents, journals, ledgers, and trial balance, final reports (Balance Sheet, Profit & loss). Apparently the word ‘ledger’ comes from bookkeepers who wrote transactions in their ‘book’ with their feet rested on a ledge.
The programs that help you do your accounting are thoroughly different now to 10 years ago. Software (and hardware) has changed heaps and the change will continue. In times to come I think we will use voice recognition to make entries to our accounting programs. The truth is that bookkeeping & accounting work will take less & less time.
We often come across bookkeepers who used MYOB years ago. Those people need refresher training otherwise they go back to their old (and slow) ways of doing things.
What are some of the changes in MYOB Live?
Are the changes good for my business?
Yes – they mean you can spend less time than ever doing accounting and more time & resource in the production and marketing side of the business. What we see is that the ‘progressive’ companies have cut out the overhead cost of accounting by adopting new technology. They embrace the change and use technology to make their lives easier.
As a business owner how do I embrace change?
We think ongoing training is necessary plus having people who are prepared to learn. There is all sorts of self training as well as professional training that we offer. No excuses - people must keep themselves relevant.
We have been inundated with employers asking the question as their employees have been asking them the question.
Last week we did an audit for one such business. The unpaid holiday pay on bonus and commissions for the last 7 years was in the region of 8% of $1,450,000 which equated to $116,000! The underpayment made our eyes water but the employees (and ex-employees) were happy.
Payroll software works out the annual leave rate for you. It is important the rate is adhered to and not changed. If you employee people who work on a roster (every week they work different days and hours) then it can be more tricky. We recommend employers in the hospitality industry have in writing the procedures they use and follow them.
Your payroll program will work out this calculation for Annual Leave:
For other leave (Sick, Bereavement, Public holidays)..
Payment should be at the rate the employee would ordinarily be paid on the day leave is taken (relevant daily pay) or their average daily pay where applicable (see calculation above). For example, an employee who normally works eight hours Tuesday to Friday is sick on Tuesday, a payment of eight hours would be due under relevant daily pay.
Where the employee works continuously but to an irregular pattern, sick leave would be payable if the employee was rostered to work on the particular day leave is taken, or could have expected to be rostered. The sick leave would be paid at the employee’s relevant daily pay or average daily pay. Payment for sick leave is made in the normal pay cycle.
You’ve entered everything in your accounting system and are ready to send it to the accountant for end of year. What checks should you make first? Follow our step-by-step guide and you won’t miss a beat.
Accounting software lets you record transactions in the 2017 year without having to finish recording transactions in the old year. Don’t stop entering sales, purchases, doing bank feeds and other everyday stuff in the new year, and take a few weeks to make sure that all transactions are spot on in the old year. We suggest you get on with the jobs below early – the longer you leave it the more you forget what happened.
Once the alignment journal is entered:
Final note: If some of these points fall into the too-hard-basket, then call us. We can sort your out-of-balances and do the checking for you plus enter the alignment journal if your accountant hasn’t provided one.
Some find AccountRight Live slower than your old desktop version of the software. Some find AccountRight Live faster mainly those who have been using MYOB Premier. Generally it is slower but the enhancements to the software reduce the time we take to do accounting.
|Possible cause||Try this solution:|
|Your computer might not be suitable for running AccountRight.||Make sure your computer meets the minimum system requirements to run the new AccountRight. You should have at least 4 GB RAM and an i5 processor running at 2.6 GHz is recommended. The type of processor in your computer is the most important factor. Not all computer chips are equal.|
|If sales or purchases take a while to record, you might have an abundance of contact logs.||Try purging your contact logs as described in the support note Purging contact logs in the new AccountRight|
|You might be using an older AccountRight version.||Check for updates – if you see an orange ribbon around your program then it is time to update. You should always be on the latest version of AccountRight. Each version gets progressively faster as the MYOB technical team speed up particular areas|
|Your computer’s hard disk might not have enough free space.||Download and run CC Cleaner. You can get this useful tool free and its purpose is to defrag your hard drive and free space by deleting unnecessary files. Seehttp://www.piriform.com/ccleaner/download/standard|
|You might have software on your computer which you no longer need.||Remove unwanted software to free up some of your computer’s available resources. Uninstall Programs you no longer use.|
|Your computer may have spyware, malware, or viruses.||Remove spyware and check for viruses. How you do this will depend on the antivirus and anti-malware software you use. Refer to that software’s help documentation for instructions on how to perform a full scan of your computer. If you don’t have antivirus and anti-malware software, speak to an IT person.|
|Your antivirus software might be interfering with AccountRight.||Add an exclusion in your antivirus software for AccountRight – see Antivirus exclusions for help on this.|
|Check your internet download and upload speed||Go to your browser and paste http://www.speedtest.net/Without downloading any software run the speed test which measures download and upload speed. You should download at minimum 8 Mbps & upload at 6 Mbps. Speak to your internet service provider about options to speed up your broadband.|
|Your Windows might not be up to date.||Check for Windows updates. Click the Start button and choose All Programs then choose Windows Update.|
PS You don’t need to have your file in the cloud to get bank feeds. Some users prefer to have their file on a local pc or network drive and backup daily to a cloud service. With AccountRight you have that option. Note that speed varies tremendously between sites and at certain times of the day. If the speed is driving you to drink then contact us so we can advise.
Written & Published by MYOB NZ Ltd
Auckland-based business consultant Lynley Averis of Accounting Training has been named the 2013 MYOB Partner of the Year. She’s the first Approved Partner in New Zealand and Australia to win the award twice.
Lynley, who was Partner of the Year in 2010, was surprised, saying, “I was really delighted, as I wasn’t expecting to be chosen for the second time. We are a small consultancy, so it was a real achievement.”
Although Lynley established Accounting Training in 2009, she has worked with MYOB software for over 15 years and supports hundreds of MYOB clients. She also won the top sales performer award for the North Island for the second year in a row.
MYOB CEO Tim Reed said Lynley exemplifies the qualities of the business experts in the extensive nationwide MYOB Partner network.
“Lynley is very deserving of her record second win as MYOB Partner of the Year 2013,” he says.
“Her tireless dedication, service focus and commitment to making life easier for local business people highlights the difference our partners make for SMEs throughout the country. With partners in every corner of New Zealand, MYOB can provide help anywhere businesses are.”
Lynley attributes her success as a consultant to her empathetic customer focus, saying, “I always look at everything from my customers’ point of view. You have got to put yourself in their shoes and understand what their needs are.
“Communication is really important. Having a rapport with your client and being able to relate to them on a personal level is essential. While we can provide all the knowledge and expert advice possible, at the end of the day it’s about people.”
The team at Accounting Training are MYOB training specialists who provide a range of services and business consultancy, from software set-up and training, to bookkeeping and payroll.
“We understand that accounting is not easy,” says Lynley. “Training is essential for anyone who wants to use accounting software well. You need to start simple with the basics of MYOB and then add to their knowledge and skills later on. I have two other skilled consultants working with me and we have a lot of experience between us. We are very focused on providing the best MYOB solution for each customer.”
Lynley specialises in payroll, accounting and retail POS systems and has written a number of technical workbooks. Her background includes lecturing at the Auckland University of Technology and teaching at Epsom Girls Grammar School, prior to running her first company, JumpStart.
“I am thrilled to be named Partner of the Year for 2013,” said Lynley. “I really enjoy providing business owners with high quality support that helps them run their businesses more successfully as well as saving them time and money. It has been a challenging year and it is wonderful to gain recognition for all of the dedication and hard work that has been put in.”
This is relevant for all of us who report GST on the Payments (cash) basis. MYOB AccountRight clocks up GST on the invoice basis – i.e. every time you enter a sale or purchase the GST content adds to the GST Collected or GST Paid account. To ensure you have claimed or paid the correct GST amount, do the following at the end of each GST period. You aim to prove that the total of all your GST accounts (GST Collected, GST Paid, Customs GST and GST Payments/Refunds) EQUALS your GST actually Paid (for the period). It should take you less than 10 minutes if you follow the instructions below.
1. Run the Balance Sheet as at 31/3/xx or end of GST period. Write down the Total GST (all GST accounts). In the example below it is $7,585.95
2. Print the report under Sales called Receivables with GST.
3. Run the report as at 31/3/xx or end of GST period. Write down the GST Figure.
4. Run the report under Purchases called Payables with GST at 31/3/xx or end of GST period. Note the GST amount.
5. Run the GST form as pictured below.
6. The calculation is as follows:
And if it doesn’t balance? You could go hide in a bush but better still, have a conversation with your accountant. It is highly likely they have done the rec for you at end of year. It should balance then. You can then run the reconciliation at the end of each GST period from then on to see where things go wrong. The most likely reason not to balance is you have made entries to prior (closed periods) AFTER you have filed your GST return.
Lock your Periods
It is essential to lock your periods once a GST period is completed. The reason for this is so you don’t continue to enter transactions into the period which is essentially ‘finished’.
Any adjustments or missed entries must now be made in the current (new) GST period.
Automated bank feeds completely change your MYOB work flows and with it, improve accuracy and reduce the time you spend doing accounts. As the MYOB user, you get Bank Feeds on a daily or other basis. All entries come into MYOB since the last time you clicked on Get Bank Transactions. Unlike other online programs we request our feeds when we want them (we rule the feeds; they don’t rule us).
From the Bank Feed screen you enter a Customer Payment, Bill Payment, Spend Money, Transfer Money or Receive Money. Rules may be set up for regular entries (much like recurring). You can also Match an entry made manually. The window you get looks like that pictured below:
Unlike some accounting programs, MYOB retains the traditional bank reconciliation process. We insist you reconcile your bank account to the statement and print the bank reconciliation for the file. Never assume just because the bank said, that things are right!
MYOB Bank Feeds are an absolute pleasure. The reliability of bank information is the best you can get as MYOB Feeds use BankLink Ltd which has supplied software to NZ and Australian accountants for 25 years. You won’t suffer from missing entries or duplicates.
Note: To use Bank Feeds you must use MYOB AccountRight Live or Essentials. With AccountRight Live the company file can live either locally on your PC or be hosted in the cloud. There is no limitation to the number of bank feeds you get or the transaction limit on your bank accounts.
Training: We recommend some on-line training to go with bank feeds. Once they start you need to deal with them and your systems and processors will be different than before. Generally you need 20 mins to learn the basics of bank feeds.