Posts

Review of Sage 50 Accounts

Choosing new accounts software can be a challenge.  You want something that you can use yourself so that you won’t always be dependent on someone else.  You want it to be reliable so that when your review your Profit and Loss you can believe it and you can be confident when you are submitting your VAT and any other returns. Finally, if you are hiring you want to know that there are plenty of people out there with experience in your software.

On top of that, you may have well-intentioned people giving you advice.  Your accountant may prefer to use a particular package.  Your office staff may be familiar with another package and want you to choose that so that they don’t have to learn something new.  You will hear and see advertisements from companies telling you how good and popular their particular product is.

It can all become very intimidating.  You are running a business after all – an expert in your own area.  You don’t want to have to become a software expert as well.

The bottom line is that you want software that will be a good fit for you and your business.  You want something that will give you the information that you need as efficiently as possible.  I have a separate blog post call “How to choose accounting software” that will help you decide on selection criteria.

For now, I want to look at one particular accounting software package called Sage 50.  I have been working with accounting systems now for more years than I want to remember. I have worked on large sophisticated systems and worked on the smallest systems.  In this article I will draw on that experience to help you understand the features of Sage 50 and make a good decision.

History of Sage 50

Sage 50 is a long established product dating back to the 80s.  For a long time, it was market leader and it is widely used throughout Ireland.  Sage also produce software that helps accountants produce annual accounts in the annual accounts format (Sage Accounts Production).   This software can import data directly from Sage 50 which simplifies the annual accountants task.  For that reason, many accountants will be members of the Sage Reseller plan and will recommend Sage to their clients without always being fully transparent about any possible conflict of interest.

In recent years, there have been a large number of challengers to Sage 50 including Quickbooks and Xero.  Sage have been adapting and updating their product in recent years to meet these challenges.

What’s good about Sage 50

  • The product itself is long established and proven. It does what it is supposed to do – when it is used well it works.
  • The product has a large user base so there is lot of information available to help you use it. There are a lot of articles available on its different features and on how to deal with common problems that might arise
  • There are a lot of people around with experience using Sage 50 so that if you need to hire or replace one of your accounts staff if should be fairly easy to find someone with Sage 50 experience.
  • Most accounting firms will have clients who use Sage 50 so they will be familiar with the software and will be able to help you if you need help.
  • Sage 50 is pretty good at VAT. Because it started out as a UK system and we share similar VAT systems to the UK, Sage probably does VAT better than most other accounting packages.
  • Sage 50 handles Bank Reconciliations well.
    On the reconciliations screen you match transactions against what have appeared on the bank statements.  There are good reconciliation reports available.
  • Sage 50 and Foreign Currency
    Some versions of Sage 50 offer the ability to handle foreign currency.  Basically, you set up currencies and input exchanges rates whenever you want – usually month end.
    The software will allow you maintain bank accounts and suppliers or customers in foreign currencies and revalue at month end.  The only issue seems to be that once you set up a customer or supplier for foreign currency you can only transact in that currency – you cannot handle a once of local transaction for that supplier.

What’s not so good about Sage 50

The underlying technology of Sage 50 – multiusers

Sage 50 was originally developed in the 1980s and the database technology that it uses is not as good as what the newer software is using.  In particular, if you have a multiuser environment you will find that you cannot do certain things while other users are active on the system.  I have often been in office where someone is calling out “Who’s in Sage? Can you log out?”  I have only  experienced that with Sage and its very frustrating for all involved.

Interface for Sage 50

The user interface looks like something from the 80s or 90s.  I know that you will get used to it but its not as neat or as intuitive as modern software.

Year End in Sage 50

One thing that really frustrates me is how Sage 50 handles year end.   At Year End you run a close off procedure which transfers all of the profit and loss accounts to the balance Sheet.  You can only do this once and you should wait until your accounts have been finalised so that you transfer correct figures.

However, many small businesses don’t finalise their annual accounts for several months after year end.  Those several months can run to 9 in many cases.   While you are waiting to finalise last year’s accounts, all of this years transactions are classified as future.  You cannot get a monthly profit and loss for the current year until last year is closed out.

As an accountant who strongly recommends that my clients should produce regular management accounts, I find this to be a major weakness.

Drill down in Sage 50

Drill down is a feature that is now very common is modern accounting software.  What is means is that if you run a report and display it on screen you can drill down ie click on a number in a report to see what that number is made up of.

Drill down is really useful for when you are reviewing accounts and trying to better understand why you are getting the results that you are getting.

For many years, Sage 50 did not have drill down.  In recent years they have added it to some reports but not to all.  It’s kind of there – but not fully there.

Correcting Errors in Sage 50

There will always be errors to correct in any accounts package.  People do make mistakes.  At year end, I often find items misclassified and I want to correct them.

For many years, Sage 50 did not allow corrections as they took the view that this weakened the audit trail.  Rather, you had to post a journal to transfer the original figure. What you were left with in your accounts was an incorrect transaction and a correcting transaction.  This makes it harder to follow what had happened.

They have amended that in recent versions but its not perfect.  Some, but not all, transactions can be corrected but often to correct those all other users have to be out of the system – the multiuser issue.  Additionally, finding and editing the transaction is cumbersome.  Overall, I don’t like how they do handle corrections.

Collaboration in Sage 50

If you want to collaborate with your accountant using Sage 50, you have to share a backup. The accountant can make changes, if they also have the software, and then they send you back a backup.  You can’t work on your data while the accountant is working on it as restoring his backup will overwrite the work that you have done.

This is very cumbersome compared to what’s possible with any of cloud packages where the data lives in the cloud and anyone with a browser can work on it, more or less, at the same time.

To overcome this issue Sage have introduced Sage Drive.  I have read about this feature but have not yet met anyone who is using it.   I have been looking at the Sage Guides for Drive and its seem complicated enough.

Reporting in Sage 50

Reporting in Sage 50 is mixed.   They have lots of reports and often many variants of the same reports.  Almost everything that you need is covered within the reports.

Reporting can be slow – you can monitor the status of the report as it is being built and it does seem slow.  The bigger your data base the slower it will be.

Some reports have little settings that can catch you out.  For example, if you are running an aged customer balance report for your year end, the report automatically defaults to including any payments after the year end.  This means that it won’t be showing you the actual customer balances as at the year end.  For me, that’s a strange default.

The Profit and Loss and Balance Sheet Reports all come from an element called Chart of Accounts.  With this the user can edit/configure the Profit and Loss or Balance Sheet to suit themselves.

Once you have set it up, you can add or edit accounts. If you don’t update your Chart of Accounts to allow for the changes that you made, this may put your chart of accounts off.

I regularly see balance sheets that do not balance because of adding new accounts.  Its not difficult to fix but it can take a bit of time and not everyone notices the reports are out of balance so could be working with incorrect information.

If you want to create a new report, Sage provide a Report Builder.  I have yet to come across any one who uses this.  For most businesses, writing a report is a rare requirement and most businesses don’t have the time to learn how to use the report writer to do one report.

One alternative is to outsource the writing of the report.  Another alternative is to export the report to Excel and play around with the data to get the report that you want.   Again, not everyone wants or can do that.

Overall, while there’s a lot that is good about Sage 50 Reporting there remain  a number of problems.

Integrating Sage 50 with other Applications

I am not aware of any applications that integrate with Sage 50.

Sage is a large company with many other products. Sage want you to buy their products so they don’t make it easy for you to buy another module, say an inventory management module, from someone else and integrate it with theirs.  They prefer you to buy their inventory module.

Overall Cost of Sage 50

Sage 50 was always expensive compared to other products.  They seem to have reduced the pricing so that they are more competitive now.

If you are buying it today, you have three options.  Sage 50c Essentials cost € 25 per month.  This is a basic package for 2 users and one company. The next package is the standard package.  This allows for 2 core users and up to 10 companies and allows you to track stock and have multiple departments.

The Sage 50c Standard Package costs € 80 per month.  This allows 2 users work with up to 10 companies and it handles stock and projects/departments.  It doesn’t have multicurrency.

Finally they offer the Professional Version which adds departments, projects, sales orders and purchase orders and foreign currencies.  This costs € 155 euro per month.

The essentials compares reasonably well with competitive products. The Standard seems more expensive than the competition and the Professional is very expensive compared to alternatives.

Is Sage 50 right for you?

If you use accounting software mainly for compliance purposes then Sage will do that for you.  On the other hand, if you want to be more hands on and to use your accounting software to get good information about what exactly is happening in your business then Sage is not as good for that.

In my experience, the way things are developing, business owners are much more comfortable with software and they want software that they can use themselves.  The want to be able to access their business information on a phone or a tablet and Sage 50 is not a good fit for that.

Sage 50 is not a product that I recommend to my clients.  If you have read some of my other blogs, you  will realise that I encourage my clients to “own their own accounts”.  In my opinion, Sage 50 doesn’t support that approach as well as the competition.  For the money they are asking, you will usually get a better solution elsewhere.

Over to you

What do you  think?   Have you experience of Sage 50?  Am I missing something?  Let me know if you agree or disagree.

Xero Certified Advisor

Is Xero right for your business?

What is Xero?

Xero is a cloud accounting application that provides similar functionality as most of the standard accounting packages such as Sage 50 or QuickBooks.

Being a cloud service, the data resides in the cloud and the application is accessed via a web brower.   Xero is  an example of software that are classed as Software as a Service (SaaS) and you pay a monthly fee for the use of the service.  Being a cloud service it has some advantages that traditional desktop applications don’t have.

What are the advantages of Xero?

1.     User friendly

The first and the main advantage of Xero is that it is quite easy to use. The online accounting packages tend to be designed for non accountants and they focus on the key actions that the user needs to complete, for example creating sales invoices and logging purchase invoices.  Xero is designed so that its fairly intuitive to use.

2.     Accessibility

As the software is a cloud application, it is accessible anywhere. You can use Xero from your desktop browser.   You can use it from your tablet such as the iPad or an Android tablet.  You can have Xero on your smartphone.

This allows you to check your accounting information wherever you are.  I’ve had a TV documentary maker who was out on one of the Aran islands and needed to check a balance.  He had his iphone and a signal which allowed him to just go online and check it on his phone – that is a big advantage for some clients!

3.     Software is always up to date

The software is always updated, unlike a desktop where you buy an application which you may get as a download or on a disc, and then that application doesn’t change unless you choose to update to the latest version. With Xero, updates are being introduced regularly, so you always have got the latest, most up to date version and it is all included in the price. And every time new features are added, you have access to those features almost immediately.

4.     Integration with other Cloud applications

As Xero is in the cloud, it can easily be connected to and exchange information with other cloud applications. There are lots of cloud applications that can work with Xero such as inventory management applications, CRM applications, banking applications.  Xero has the ability to push data out to these applications or pull data in from them.
Several years ago I had a client who did a lot of work online.  The nature of the work was that he had a lot of small transactions for which he got paid very small amounts of money – usually cents. This money was paid through PayPal.  He was able to set up his accounting package to connect to PayPal and this high volume of small accounting transactions were pulled in, immediately on login, into his accounting application.  This really streamlined his online operation and made it a whole lot more efficient for him.  So the ability to talk to other could applications can be very useful.

5.     Your accountant can help you remotely

Xero makes it easy for your accountant to access your data remotely.  Let’s say my client is using Xero, and they are having a problem. He or she can ring me up, we can go onto a Skype call or use some sort of other conferencing type call.  We can share our screen, so they can be looking at my screen or I can be looking and his/hers screen, whichever we want.  Using these tools we can resolve the question fairly quickly.   This could save a trip out to the clients’ premises for me which then makes the service less costly for the client if all they need is five or ten minutes of my time.

6.     Safe data back-up

Xero is always backed up.  The software provider will have the application and data stored in a number of different data servers, so if anything happens to one data centre, they have a backup  and can be accessed from another  data centre.  You won’t be aware of this happening. You won’t have the need to take backups or store them off site.  With Xero you also have the option of downloading data, just to be sure, to be sure, but in fact, that is not not needed.  They have it backed up better than you would probably do yourself.

7.     Functionality

Xero is a mature product  and at this stage, it has a lot of very useful functionality.  It offers reccurring invoices, multi-currency processing and automated bank reconciliations among other features.

A big advantage of Xero is that it has some very basic “intelligence” built in to the software. For example if a payment goes through your bank that might be for Three or Vodafone, you can set up a rule that this is a telephone bill, and that is normally a subject of VAT of 23%.  Every time that comes through, Xero will let you know it thinks that’s a telephone bill with VAT at 23% and you can accept or reject/edit the suggestion.  You don’t have to do any more with it.  You set up the rule initially, and once Xero recognizes that it’s a payment for Three or for Vodafone, it will code it properly.  It makes the process of coding at month end accounting simpler, easier and faster.

What are disadvantages of Xero?

1.     Slow with high number of transactions

There are some disadvantages to Xero.  You are using an online piece of software and if you have a lot of transactions and/or a slow connection, you may be waiting for a while until the screens re-build.  So if you have a lot of transactions, Xero might not be for you.

Book-keepers who come into a company once per week or month to bulk enter the transactions often find it doesn’t suit the way they work.

2.     Lack of support in Ireland

The Irish Banks don’t support the online accounting packages very well right now.  Elsewhere around the world, banks are providing feeds to Xero, so the bank statement can be pushed straight into Xero and then when you log into Xero, the application will tell you that you have these transactions waiting to be posted, and will use its intelligence to suggest to you what it thinks the posts should be.

There is a  workaround to overcome the lack of a feed – exporting the transactions from the bank and importing them to Xero but its more cumbersome.  Having said that, I use the workaround and I have dramatically reduced the amount of time I spend on monthly accounts.

3.     Cost

Xero costs more than a traditional desktop accounting software.  If you use something like QuickBooks online, you may have bought that for maybe €180-€200 for the licence, and you may get three to four years out of that before you decide to upgrade. So it could cost you €50 a year.

Xero typically costs around €25 a month, so you would be spending maybe about €300 a year on your software, which is a little bit more than you might be used to be spending.

How do you decide if Xero is right for you?

First of all you should look at the number of transactions that you have. If you have a low number of transactions – a low number of sales invoices and a low number of purchase invoices, then I would say Xero would be well worth looking at. If you have a high number of transactions, it might slow the process of entering these transactions down when you try and enter them all into the system.

Think about your  broadband.  Is it fast enough?  If it can handle something like Netflix, then it’s ok and can handle Xero comfortably.  If you speed is 1MB/s or less then maybe no.

If you are already using some cloud apps, like a CRM app or an inventory app or maybe something like Expensify for managing expenses, Xero can integrate with those cloud apps, and can make transferring data from one to the other a lot more streamlined.  If you are using any of these applications, I would strongly consider looking at Xero.

You would have to be comfortable with .csv files.  In Ireland at the moment the banks don’t provide the banks feeds for us, so what you have to do is use the workaround mentioned above where you go into your bank account and export you bank statement into a .csv file, which excel can work with. Then you have to tidy up that file, to make sure that the columns are in the right order and that it is ready to be imported into Xero.  So if you are not comfortable doing that process manually, you should probably shy away from Xero

If you do your own books, you will find that Xero will give you a lot of insight into what is going on in your business.  Xero will help you to really understand your accounts.  Completing the tasks of entering your costs and your invoices, knowing where they go, and being able to run the reports and drill down, will all make a whole lot of difference to how well you understand your accounts.

There are some businesses where Xero would be a good fit because of the type and number of transactions that they have.  For example, I am aware of furniture retailers that use Xero and they don’t have a till system or a point of sales system, all they have is an iPad. They can walk around the shop, they might have a small number of high value transactions per day and they can easily process those with an ipad and Xero. They can be with a customer, enter the sales invoice there and then, print it off on a wireless printer, give the sales invoice to the customer, and that transaction is already in their accounts.

Alternative applications

Xero is not the only online accounting package.

There is also Kashflow – a product that initially came out around the same time as Xero, but hasn’t grown as fast as they chose to grow organically rather than by investing loads of money into marketing as Xero did.  I think it is a bit simpler and a bit more user friendly, but it hasn’t developed functionality to the same extent that Xero has.

A newer product is Quickbooks online.  You may be familiar with QuickBooks – one of the bestselling desktop accounting packages in the last number of years. I heard recently that QuickBooks has made a decision to move online totally and that they will no longer be updating the desktop versions. At the moment I feel that QuickBooks and Xero will be the two main competitors of the online accounting packages. They will probably fight it out. I think they will probably end up having similar functionality.

SAGE have also introduced an online accounting package. The initial feedback was very poor, I know it has gradually been improved but I think they are a bit behind Xero and QuickBooks online.

Some of these online packages are a little behind, and don’t have as many integrations yet. Whether Xero will stay as the main player in the future, I am not sure. But right now, it is definitely the main player and should be considered if you are thinking of an online package.

We have worked with all the main SME accounting packages.  We also have significant experience helping select and implement software for larger businesses.  If you are thinking of going with Xero, or another cloud accounting package, feel free to contact me at jim@accountsplus.ie.