Category Archives: Systems

Accounting Software: Cloud or Desktop – the Choice is Yours!

clouddesktopAs we know fashion is a huge driver for change, both in our personal lives and in business. Consider, for example, iPads, which became a must-have business travel accessory even though, in comparison with a laptop, they are very much deficient as a useful business tool if you actually want or need to do some work whilst you’re away. There is also cloud accounting software which, whilst very useful in the right circumstances, does have some downsides in comparison with Desktop software.

The plus side of cloud accounting, in bigger firms (assuming all your software is in the cloud) you may be able to do away with your server or servers, and for businesses of any size there are no problems with back-ups or updates and you are able to access data and work anywhere where there is internet and as well as being able to share access in different locations. On the down side, you will normally pay more, it may be slower, your internet connection may be poor (or non-existent) and the software may not include many of the features we take for granted with traditional desktop software e.g. inventory systems, which has been constantly developed and improved over many years.

It was very interesting then when MYOB launched their new version of AccountRight Live at the end of last year which enables you to work both on and off-line with the system “synching” when you go back on-line (so that any changes made on whilst off-line are adopted on-line). And of course it wasn’t just being cloud-enabled that was a huge advance with AccountRight Live as it also introduced automated bank feeds into the mainstream MYOB accounting software for the first time, an extremely useful and necessary feature and well overdue.

Rather than me talk about this more, there is an excellent post on the MYOB blog, which explains in depth how it all works. So congratulations to MYOB for an innovative solution and let’s hope any initial teething problems are quickly resolved. Sometimes change is useful and not just driven by fashion!

Don’t lose Sight of your Profits

A+BAC’s popular quaterly newsletter, Profits inSight, is now out!

In this edition, we are giving you solutions for when the tax bill is too high, an interesting way to help you buy your first home with Kiwi Saver and explaining why your passwords aren’t safe.

Don’t miss our App selection this season and a hot tip as well: is it time to increase your prices?

WHAT CAN YOU DO WHEN YOU CAN’T PAY YOUR TAXES?
The tax bill comes and as the deadline draws near, there is still no cash to pay it. Yet with the high interest rate charged by IRD, not paying them is not really an option. What do you do then? There are several workable solutions that will save you from the ire of the bank and the certainty of rapidly doubling your tax debt.

KIWI SAVER TO BUY YOUR FIRST HOME
Getting a deposit to buy a first home can be tricky for families. Yet for those who have contributed to the Kiwi Saver scheme for over 3 years, it may get a lot easier. First time home buyers may indeed receive funding for their deposit. And the news keep getting better as these are not a loan so won’t need to be paid back.

WHY PASSWORDS NO LONGER PROTECT YOU
Experts all agree: password technology is dead. Yet it is the only one that is still largely used to protect your most sensitive data, like access to your bank accounts or vital business information. As a business owner, there is a lot you can do to ensure the safety of your systems but as a user of other’s services, what can you do to keep safe?

Free Subscription

Is Your Accounting Package Still A Good Fit?

dreamstimefree_40306For the past few years many businesses have “put off” investing in their accounting system in favour of improving other areas such as sales and production efficiency, i.e. areas that ultimately have an impact on their bottom line. Good old Kiwi ingenuity has seen many businesses “tack on” and “patch up” their system to enable them to keep operating without having to go through the expense of an upgrade.

At a basic level upgrades are released to make our lives easier, improve the customer experience or both. So why would you continually turn your back on them?

Without realising it, businesses have increased their administration tasks and become reliant on this “additional work” to function on a day to day basis. Many companies extract their data into Excel to calculate and/or manipulate the figures into a usable form. In some cases this has been simply to undertake essential functions such as allowing for GST at 15% and accounting for foreign currency transactions.

Believe it or not these types of inefficiencies are not only holding you back, they also add up to a hefty dollar amount.

While some businesses still have a hangover from the recession, low interest rates and a more positive business outlook appear to be encouraging others to review their systems and invest in this area. Businesses have also come to realise that their choice is no longer restricted to choosing between an off the shelf accounting package (that may not totally meet their needs) or an expensive custom built accounting system. Systems have evolved over the past five years and can now be tailored to meet a business’ specific needs and it won’t break the bank.

Today business functions are intertwined and reliant on similar information. Most businesses whether big or small realise the efficiencies that can be achieved from a consistent data source. A good operating system should, where possible, integrate data to avoid duplication, inconsistencies and to minimise input errors.

So what are the signs that your business is ready for an upgrade? Here are a few key questions to get the ball rolling:

How easy is it for you to generate your financial reports today?

Are your monthly reports always pushing your reporting deadlines? Are you reliant on a team to combine/manipulate data to enable your reports to be produced? While you may think you are saving money on the upgrade and/or system review, you need to consider the extra resources that you devote to the accounting and finance function.

How much double/triple handing of data is there?

Does your month end process involve pulling data from one system and re-entering it into another? Do you rely on Excel spreadsheets for job-costing/work in progress calculations? You need to consider how much time you or your team is wasting that could be better utilised elsewhere in the business.

Has your business recently gone through an expansion phase?

This may be a growing customer base, expanding into new markets and/or projects or simply an increase in your staff numbers. A small business can get by with a more basic accounting system. However, as your customer base/number of locations and/or projects and employee base grows, there is a greater need for access and sharing of key data.

How do you assess sales, finances, and other business functions to evaluate your performance?

If you rely on information pulled from all different sources your data is bound to be plagued by errors caused by manual entry. Tying up your resources and timeliness is also likely to be an issue.

Is your financial data difficult to audit or unreliable?

You may rely on a few key team members simply because they are the only ones who know how the system works. This leaves you exposed if they go on extended leave or leave the business completely. There may also be the risk of incomplete records or discrepancies as it is unlikely their work has been reviewed before.

It is important to remember that a new and improved accounting system is not much use on its own. You need to ensure that your accounting team has the right level of experience for the role, and that you provide them with training as required.

You may recognise the above signs or have your own growing pains that simply need to be dealt with. If you have identified the symptoms, you can contact us to discuss your options.

Reducing Your Accounting Fees

One of the best ways to reduce your accountancy fees is to get some decent accounting software and use it properly. It doesn’t matter that much what brand of software (we accountants are happy with MYOB, Quickbooks, Xero or any other software with a full general ledger) you use, as long as you use it properly. This means:

  • Making sure you reconcile the balance on the bank register to the balance on the bank statement at each month end, NOT the last statement date which is often part-way through the month. If you don’t know how to use the bank reconciliation routine don’t worry, just make sure all the transactions on the bank statements are accurately reflected on the software.
  • Ensure the amounts showing for Accounts Receivable and Payable agree to the balances showing on the general ledger/trial balance for these accounts or at least any difference is very small.
  • Clear out any accounts like undeposited funds or the electronic payment clearing account and reconcile the amounts in accounts for supplier or customer deposits or similar.
  • If you can BEFORE you prepare your GST returns reconcile the amounts recoverable or payable in GST ledger accounts.
  • Your accountant should be adjusting the balances on your accounting software for the balances showing on the Annual Financial statements as otherwise you cannot prepare any interim or regular management accounts which are so useful for managing your business and telling you on a timely basis whether you’re making or losing money.
  • MOST IMPORTANTLY of all you must LOCK the period after you’ve prepared each GST return to the date of the last GST return. It’s so easy to enter transactions in prior periods which makes a mess of the GST and probably means income or expenditure will be omitted from your Annual Financial statements.

Now many accountants more interested in feathering their own nests will tell you that you can’t use accounting software because it’s far too complex and that you’ll never get to grips with it. Well, in rare cases yes, but I find the great majority can if they invest the necessary time and effort. And the outcome? It’s wonderful – a one-stop shop for invoicing, your customer & supplier database, tracking your Accounts Receivables and Payables, time billing, job costing (the list goes on and on here) as well as reducing your accountancy fees!

Year-End Computer Detox

This is another article that was suggested to me and that I found worthy sharing with my readers. Happy New Year and see you all again next week with a new post from yours truly.
-Nick

–Comes January and everyone starts experiencing the after-effects of over-indulging. Your computer too feels the pain.  Perhaps it isn’t so much Christmas wine and chocolate but the result of viruses, document hoarding and other accumulative hangovers.  Detox your computer to get it working faster, safer and more efficiently.

  • Clean it.  Literally.  You’ll be amazed what appears when you tip that keyboard upside down (only use anti-static wipes or a soft brush.  NOT water!)
  • Remove clutter, delete unwanted documents off the desktop  and tidy up your folder structure
  • Remove any programs that are no longer required
  • Empty your recycle bin!
  • Check that all necessary updates have been installed
  • Is it time to look at upgrading to Microsoft Office 2010 or 365…?
  • Update your security passwords!
  • Double check your antivirus protection is up to date and won’t expire while you’re on holiday
  • Make sure your firewall is active
  • Perform a last minute virus scan – check out Spybot Search & Destroy
  • Perform a disk cleanup and disk defragmentation (set this to run overnight as it may take several hours)
  • Perform routine backups of all files and settings
  • Archive files offsite

Computer systems vary.   If you use an external IT provider to manage your computer requirements then liaise with them as to what they have planned and what you can carry out yourself.  And remember… your computer needs a holiday too – make sure to shut down and turn off before you leave the office!

Cash Collection

A large part of keeping cash flow under control is managing your debtors. In these challenging times businesses will generally take as much time as possible to pay their accounts, after all, why pay interest on an overdraft facility when they can use your cash for free?

Good debtor management starts with a very simple calculation to measure ‘debtor days’. By dividing the month end balance of your debtors by your average daily trading, you get a simple measure that you can monitor on an on-going basis. If the number of days goes up, you know that people are taking longer to pay you, prompting to you to investigate why. If the number of days goes down, you know that you’re becoming more efficient at collecting your debtors.

As a simple example, let’s say a business is turning over $10,000 per day and has a month end debtors balance of $600,000. This would equate to having 60 days trading revenue tied up in receivables. If, over time, you could get this down to say 45 days, the business would have another $150,000 in the bank account rather than tied up in debtors.

So how do businesses get people to pay on time? Here are a few practical points that may help:

• Make payment expectations clear on all your invoices and Terms of
Trade.
• In your Terms of Trade include a time frame within which any queries
relating to your invoice must be raised. It is always frustrating for a
query with your account to only be raised when payment is already
several months overdue!
• Reserve the right to charge interest on all overdue accounts and
specify the rate that will be charged. You should also advise that any
other costs incurred in the collection process will be passed on.
• Send invoices out promptly, preferably at the time of supplying the
goods or services or if invoicing monthly, very shortly after month end.
• Make it as easy to pay you as possible. Many businesses no longer
have chequebooks, so providing your bank details on invoices and
statements is essential. Allowing payment by credit card is also a valid
option, which can have great results, although take into account the
fees that you will incur.
• Make sure that you have a documented collections system and follow
it. A standard process will include a time line of follow-up letters, emails
and phone calls that ultimately lead to interest and collection costs
being added and the account being handed to a collections agency.
• Get tough! If you give someone a final date on which the account will
be handed to a collections agency, actually hand the debt over for
collection if it remains unpaid. Many businesses talk tough but will then
not actually follow through.

As with all things in business, a bit of common sense and compassion also goes a long way and while not ideal sometimes you may have to bend your own rules on collections when a good client or customer is struggling and needs a bit more time than usual to pay. As long as your customers are communicating with you, being honest and making the payments that they have committed to, then be prepared to cut them some slack occasionally to preserve good relationships. However, the moment those commitments are broken or communication stops, it’s time to move quickly to secure payment.

How KPI’s Can Transform Your Business

I once assisted a business in the UK that couldn’t understand why they had no money in the bank and couldn’t pay their bills. 

The business owner used a traditional accountant, who just prepared the annual financials some months after the year-end, and as is typically the case, the excellent accounting software purchased was used solely for the GST returns. What does that mean? Yes, you guessed it – no management information or regular reporting of any kind which means the business owner was, totally unnecessarily, operating completely in the dark with no idea of what was happening in the business

After discussing things with the business owner I said that what we needed was a two-fold approach, firstly to work out what the current trading figures were, and secondly, if things had gone wrong, why.

To start-off with, easy-peasy, interim management accounts (which was like falling off a log) comparing the trading results for the current year-to-date with the comparative period the year before. These were produced not on the accountant’s externally located accounting reporting software, but on the client’s accounting software (which was more than capable) to save both time and cost. This showed a substantial decline in sales, a reduction in the gross profit margin and overheads which had not been reduced fast enough to cope with the decline in sales and gross profit.

So far, so bad! But why had things gone so bad? Reach for your Key Performance Indicators (KPI’s) which measure the key elements in any business, those which are critical to business survival and success. These are the things that MUST go right for your business to be able to deliver your core products or services in a cost-effective manner which meet or exceed the customers’ needs, which are often called your Critical Success Factors. Having worked out what these are, you need to start measuring these since what you can measure you can manage and then work out how to improve. Often, these are few in number so it’s normally possible to restrict the reporting to 8 or 12 what are known as Key Performance Indicators.

In any trades business, the Critical Success Factors are normally very similar, so I knew what to look for and so I produced a KPI report highlighting the areas where I thought the problems were occurring, a simplified version of which is reproduced below. No budget figures of course, because at that point we hadn’t set targets, but at least these could be filled in later when we had worked out what we wanted to aim for.

XYZ Ltd
Monthly KPI Report for Feb 2011

For the Month YTD

Actual Last Year Budget Actual Last Year Budget
Sales $74,554 $104,889   $887,656 $1,201,876  
Cash Collected $65,222 $93,445   $796,101 $1,180,665  
Gross Profit % 52% 53%   52% 55%  
Overheads $38,101 $46,123   $481,774 $571,331  
Net Profit $667 $9,468   $20,192 $89,700  
Labour Productivity % 81% 86%   82% 89%  
Value Added on Parts $6,512 $7,998   $84,116 $106,117  
Average Labour Hourly Charge $47 $53   $46 $52  
Number of Jobs Completed 199 233   2403 2711  
Average $ per Job $375 $450   $369 $443  
No. Of Customers *


6421 5158  
Average Sale Per Customer


$138 $233  
Job Enquiry Conversion Rate 74.00% 84.00%   81.00% 93.00%  
AR Days Outstanding 52 44   51 42  
Work in Progress Days Unbilled 43 34   41 37  
* Invoiced in the last two years

And what did the KPI report show us? That there had been a serious decline in virtually all the key areas:

  • Whilst the number of customers had increased significantly, the average sale per customer and the average $ per job had reduced substantially, meaning a lot more running around, more administration costs, and more working capital tied up in the business.

  • The job enquiry conversion rate had reduced by 12% meaning that more time was spent talking to customers with nothing in return.

  • Both labour productivity and the average labour hourly charge had reduced which indicated the business had become much less efficient.

  • More working capital was tied up in the business as both Accounts Receivable days and unbilled work in progress days had extended outwards.

  • Not surprisingly, cash collected had reduced substantially too.

The next step was to set some targets to get the business back to its former level of profitability by implementing a number of specific strategies for each problem area such as billing work in progress more frequently, collecting Accounts Receivable quicker, working to improve the job enquiry conversion rate by scripting and improved quoting techniques and moving the customer’s focus away from price to the benefits of using the business in the longer term, as well as introducing a powerful guarantee and re-inventing the USP (Unique Selling Proposition) of the business.

So, all this just from a quick, inexpensive look at Key Performance Indicators – a truly simple, but powerful, underutilized business improvement tool you can use to transform your business to success!

If you need help with yout business performance contact Nick on 0800 ASK NICK or email nick@abac.co.nz.

Retailers Let Down by Software Developers

In my role as Business Mentor with Business Mentors NZ I meet quite a few retailers struggling with systems. The problem is always the Point of Sale software which has been designed as a stand-alone POS system and which won’t do the bookkeeping and the GST. Typically the software, will in theory, export to MYOB or Quickbooks but either “they don’t recommend it” or you can’t find anyone who knows how to make the export routine work and in any case, who would want to pay for and get to grips with two systems rather than one?

The latest retailer I’ve met is typical. They’ve been sold an expensive POS system but just a year later had to appoint an outsourced administration firm to handle their bookkeeping and GST at a huge cost of $450 pw (which in Hawkes Bay would pay for a full-time employee!) who enter all the purchase invoices again on the accounting system which they use – crazy or what? When the accountant gets involved he uses a third system!

They recognise their problem but are reluctant to dump the POS system and start again but that is what I’m going to advise as there are POS systems available which will do the bookkeeping and GST and even more importantly, enable the business owner to prepare regular interim accounts and measure Key Performance Indicators to see how the business is tracking.

If you’re starting afresh it’s easier but if you no longer have the cash to pay for the up-front software licence fee the answer is to choose a cloud-based system (with only monthly fees) which either has an integrated General Ledger or integrates seamlessly with an accounting software with a built-in perpetual inventory system.

As usual when choosing any software it’s essential to:

  • Ensure you can trial the software for free
  • Speak to other users AND their advisers (as often the users won’t know what know what they’re missing)
  • Make sure you can get meaningful support
  • Find out of you can import existing data en-masse
  • Will it work on your existing hardware?
  • Make sure it’s easy to use
  • Ensure it provides you with ALL the data you need to run your business effectively

If you need help with your systems contact NICK on 0800 ASK NICK or email nick@abac.co.nz before it’s too late to make a difference!