Thursday, 10 May 2012

What's so good about QuickBooks Enterprise ?




There is an awful lot good about QBE as we like to call it.  But the single best thing about QBE is its price.  It is four times cheaper than the average mid-market accounting system.  Four times, not four per cent, four times !  A 20 user version of a Sage or Iris Exchequer mid-range system will cost about £20,000.  QBE costs £5,000.

Having got your attention I hope to keep it before you start thinking about what to do with the remaining £15k in your budget.

For me the remaining top 4 benefits are:

  1. Easy to use.  Yes they all say that but some systems really are very difficult to use.  QBE is well designed to make it simple, it has an active technical community forum and it has tips and movies for most of the functions. 
  2. Well connected.  Quickbooks has a huge base of users, most in the US but nevertheless this has resulted in a large number of independent business applications that connect to QuickBooks and the Enterprise system, QBE. They all connect through the QBE web connector so it’s a consistent and fairly simple set up.  We use an on line web time sheet system which took about 2 hrs to set up.  It has connections to CRM systems like Salesforce, Sage CRM, Sugar and a few CRM applications designed specifically for QuicBooks.  There are also a number of plug-in ecommerce applications and point of sale systems. 
  3. Great filing.  QBE has an integrated document management system.  You can drag an email attachment onto the transaction or account and its available for look up at any time.  Besides this, QBE provides a click through to the original transaction from all of its reports. 
  4. Smart financial report writer.  Its called QSW.  It completes the reporting job that many other systems leave undone.  Apart from enabling you to create the report through a designer in Excel it recognises the need to pull a number of reports into a financial pack.  Typically this would be a Balance Sheet, P&L, Cashflow, some divisional reports, a commentary etc,  Each of these are on separate tabs,  Once you are ready you run the report and it combines the lot into a PDF.

There are many other benefits and in the next post I will cover 6 – 10.


It’s important however to point out some negatives.

1.      You won’t look so good at a dinner party with other business leaders when the subject of ERP systems come up.  The others who preside over SAP, Sage, Microsoft and Exchequer may have a guffaw at your expense when you tell them that QBE is running your multi million pound business.  You will have to wait till the end of the evening for your payback as you drive off in your Porsche paid from the saving in switching to QBE. (Calculated saving over 5 years including maintenance and consulting fees).
2.      There is only one field that controls the fiscal period allocated to a transaction.  That is the document date.  For those of us who are used to the older systems this is a big weakness.  Typically, almost half of the supplier invoices are not posted into the period that corresponds to the date of the invoice.  There are two main reasons for this;

·         invoices are received late
·         there is a delay in getting them approved and entering them in the system. 

To a large degree, businesses are sending invoices out promptly, particularly in this economic climate, so it’s not as big a problem.  Nevertheless we would still opt for a separate fiscal period field.

3.      Certain accounts are fixed, their position cannot be changed.  This applies to the Exchange Gain or Loss account.  We would like to split it by currency and between gains and losses. 

Overall QBE is an amazing system because of its price and functionality.  It will make your staff more productive too.  There is very little need for on-going support once you are set up but, we will try our hardest to recommend add ons and reports. We have to do something !

Monday, 23 January 2012

What is so good about Accpac (Sage 300)


If ever you found yourself at a Sage convention in North America you would think that the Accpac contingent were made up of Australians abroad.  They are in the minority but they make more enthusiastic noises than the rest of the Sage acquired accounting system supporters put together ( MAS, Simply, Peachtree, Platinum and Vision (all under new names of course.))

So what really is so good about Accpac ?  When you take a look at the screens they are nothing special. They are due for a makeover this year but there is nothing that grabs you at first glance.

In the case of Accpac it’s not the outward appearance that is the attraction but what is discovered inside.  Accpac was developed in the early 1980’s in Vancouver Canada which seems to have been a place of accounting excellence. But if I start tracing the steps from there then this article will win awards for boredom.

So what is so special about Accpac ?  What makes it different from the other mid-range accounting systems in the market like Microsoft Dynamics, Sage 200 and SAP BusinessOne ?

  •  A GL account code that can be as big as 45 characters split into 16 segments.
  • A GL ledger that can keep 99 years of data.  If you want to post an entry into a previous year you just unlock the period and enter the transaction in the normal way.  Retained earnings accounts and open balances are adjusted automatically.
  •  Unlimited optional fields.  You can add these anywhere. At the account level, at the transaction level and at the detailed line level.  You can chose the type and content and whether they are mandatory or not.
  • Crystal Reports as the standard form and report application.  Crystal is the global leader in report design software and with its conditional logic and the ability to link other databases external to the accounting system in one report means that you should be able to present everything the way you want it.  A standard invoice for instance can have a different language, design and logo purely based on a customer attribute.


So 4 rock solid reasons why us old “Accpacers” believe that it is one of a kind.

You will notice that I did not mention the words like “it empowers your employees” or “it gives you a 360 degree view of your business”  because that’s what the marketeers have been saying at Sage and they have missed the real point.

Now it does have decent sales order processing modules, purchase order and receiving modules and job costing but they are much the same as the competitors.

It is in these 4 areas that it stands alone which is why it should appeal to the type of business that needs all or some of these features, multi-level account code, additional data fields and perfect reports.

The thing is that the sort of businesses that have multiple divisions and complex reporting don’t even consider Accpac but buy into the next level ERP application spending almost twice as much as Accpac.

We have been lobbying for Sage  to recognise these strengths of Accpac and its appeal to the larger global finance departments.  So far there has not been much take up but as Sage need to start differentiating their 50+ accounting systems around the world I think that this may find some traction.

In the meantime we have added Accpac’s capacity for catering to the larger global office by developing routines that centrally control things like the group chart of accounts, user roles and security, fiscal periods and group wide reporting.

Accpac has 4 key strengths.  Any group  and multinational business that does not consider Accpac will miss out on significant savings.

Thursday, 5 January 2012

Where should accounting system purchasing be headed in 2012 ?

Within the last three years of economic stagnation something quite different is emerging in the accounting systems arena.

In the past an accounting system was something like a prized possession. You had to have the latest innovation, be highly tailored to the business, talked about at dinner parties and noted in the director’s report to impress bankers and shareholders.

It was going to be expensive but that went without saying. If you were a Financial Director or CIO it felt good to say that your company used SAP, Oracle or Microsoft. You would quickly find another topic if your company’s system was SAGE or QuickBooks and the question was coming your way.

But things have changed. Dinner party discussion at exciting financial and IT get togethers is more about dashboards and IPADs. The accounting system is not really mentioned. It’s a given. Like plumbing, you have to have it and you are only reminded of the name when you need to use it.

There are four reasons for this. The first is that the packaged accounting system is no longer at the frontier of business applications. It’s been 25 years since the first packaged systems for the PC were developed by Sage, Opera, Accpac and others so it’s not surprising that they are well entrenched. If it was not for the advent of the windows operating system and a move to a common relational database in Microsoft SQL which both took place about 10 years ago, this plateau would have been reached much sooner. The result is that those systems that have remained are very good at the job that they do.

The second reason is the economy. Businesses are keen to spend less now that they have had lots of experience with systems. They are now much more cautious and wise buyers. Businesses do not trust the tag lines of “empower your employees”, “leverage your business”, “computerise for the bottom line” – used in promoting the next greatest must have accounting system. Actually I made the last one up but I am sure that there was something like that somewhere. These were tag lines into the unknown and if presented by an able salesperson with impressive looking brochures they were a guarantee of system security. Now businesses understand the jargon and they are in a cost reduction mode of decision making. I believe that this is going to generate a significant wave of change for the accounting system developers who have not provided value for money to their customers for some time. (But that is for a later discussion.)

The third reason is reliability. Have you noticed that those IT scares of a few years ago of companies losing millions on failed IT projects have diminished? Apart from one last year concerning the NHS they are the exception. Yes accounting systems are much more reliable, like good plumbing. And when the problem goes away the emphasis on the system does to.

The fourth reason is improvements in integration. The systems of today now share common databases and many of them cater for integration connections with other systems. Which means that you no longer need to think of a “one package to fit all” approach. While these do exist they don’t do everything well and those that do, come at a hefty price. So this means that your accounting system should be thought of as a very sturdy set of ledgers that record all the transactions from specialist systems like point of sale, professional services, manufacturing, warehousing, membership etc. Add to this mix a top of the range reporting application that can report from all databases at the same time and you have a fully functional system that has the best features from the top developers in their field.

So what is likely to happen this year ?

We predict that businesses who are looking to replace their systems will start looking downwards and not upwards. Instead of moving up to the next version of the same system or possibly even at the next level, they will look downwards.

So a £100 million business who may be thinking of moving up to a large ERP system would do very well in looking at a mid range accounting system. We recommend Accpac (Sage 300). A large business is likely to need the adaptability to accounting requirements outside of the UK and the US. If this is not the case then Sage 200 would do equally well. The key benefit ? Cost. These systems that can happily cope with 100 users will cost around £150k and an annual charge of £15k. Compare this to a large ERP system and the price is close to six times as great. £900k and £90k annually.

This gap is similar if your business is in the mid-range size of £5 to £30 million turnover. A 30 user version of the Enterprise edition of QuickBooks will cost a mere £8,000 which compared to a Sage, Microsoft or SAP mid range application of £35,000 represents a handsome saving. Add to that the reduced support costs and annual fees it’s a very compelling position.

A few years ago the big guns; SAP, Oracle, Peoplesoft and JD Edwards announced plans to enter the mid range market. The top ERP space was becoming too crowded and there was business to be had in the sector below. No one really predicted that smaller systems would appeal to business in the higher sector.

They have and I see this on the increase.

Thursday, 8 December 2011

Sage Announces new Accpac GUI

Sage announced a new GUI for Accpac OE screens.,