We're All In This Together

The first accounting system I had to supervise was an IBM product called MAPICS. I was an inexperienced newbie and knew nothing, so I joined a user group. Every couple of months we would meet at someone's office and someone would bring donuts. We would talk about our experiences with the product and try to answer people's questions. I got some excellent advice about how to handle program patches from IBM as well as where to go for programming assistance. Joining the user group was the best $25 I ever spent.

If there is one piece of advice that I can offer to everyone, regardless of the size of your company, your industry or the type of software you use, it's to join a user group. There is no better source of unbiased, practical information than other users of the same software. If there is a feature you would like to see added, getting a group of users together to request the change is the best way to get a developer's attention. If you are looking for trained staff, another user may be able to point you in the right direction. If you want to change your consultant, what better way than to ask for references from other users?

Many user groups are organized by software implementation consulting firms. I have heard these groups dismissed as being no more than upselling by the consultant. Of course consulting firms are interested in selling more software and services, but the ones I know go to great lengths to put useful content into the sessions. They know that providing practical, useful information is the only way they will get users to come back the next time.

Traditionally, however, user groups are started, organized and run by users. Vendors are often invited to make presentations, but user meetings are not about sales. When my Microsoft rep suggested I start a Dynamics NAV (Navision) user group in my area, my first thought was about all the administration of running the group. Then he told me about Dynamic Communities. They take all of the work out of running a user group, so you can concentrate on the meeting content.

All Dynamic Communities does is manage user groups, whether for Dynamics AX (Axapta), GP (Great Plains), NAV (Navision) or CRM. They just need one local person to lead and they will set up a local chapter. They will even give you a list of their members in your area. If you work through your local Microsoft rep, you can get help finding other users. Microsoft will also provide speakers if you give them enough notice. There is a sliding membership fee depending on the size of your business.

The typical local chapter has 10 - 15 members at any given meeting, with larger chapters averaging 30 - 35 members. The typical meeting goes from 10:00 am to 2:00 pm, with a networking lunch. The morning session is usually a formal presentation, with break out sessions after lunch. I asked about the split between technical and accounting members and Bonnie, the Member Services Manager, noted that chapters started by IT Managers tended to have more technical members, where chapters started by accountants had more user members. You need both.

One of the problems with user groups is their small size. A huge advantage of a centralized organization is that it's possible to put on a conference. Dynamics Communities is hosting a 2 day conference (The link is to the NAV conference. The others have similar pages.) in Las Vegas for $499 per person, with optional additional training either before or after the main conference. When you add that to the user forums available at mibuso and Dynamics' webinars, we've come a long way from a box of donuts after work!

The Most Advanced Accounting Software on the Planet

"Tally 9.0 has been dubbed the most advanced accounting software on the planet." That claim is obviously more marketing spin than carefully researched fact, but it points to a trap that we so frequently fall into: comparing accounting software as though there were some perfect system against which all others must be measured.

Anyone who knows me will tell you that I'm a Microsoft fan. In my quarter century of accounting, I have spent a decade implementing Dynamics GP (Great Plains) and Dynamics NAV (Navision). But I still wouldn't claim that it's the most advanced accounting software on the planet. The issue is not how advanced it is, but how well it fits the client's needs and budget.

"Unlike other accounting software, Tally accounting software makes sure all data is protected and backed up automatically" (further on in the same article). If someone starts comparing two accounting packages, stop them right there. There is no standardized language in accounting software upon which to base a fair comparison. Two packages may claim to have advanced inventory features, multi-currency, role based security etc. etc., but when you investigate, you find that they have addressed these features in very different ways. Furthermore, there are hidden assumptions included in the words. I would challenge anyone who claimed that their system automatically backs up data. How can their system ensure that backup media are being properly rotated and taken off site? These are both critical aspects to the back up process. The word "automatic" sends up red flags for me, as do the words "easy", "user friendly" and "at the click of a button".

Frankly, we accounting software implementers have done ourselves a lot of harm by raising people's expectations to unrealistic levels about how easy it is to change accounting systems. Yes, the software installs quickly. Yes, everything is menu driven. Yes, the manuals are online and there's an extensive help system. All of those features do not change the fact that accounting is done very differently in different companies, even those in the same industry. The bulk of the time spent in an accounting implementation is in marrying the new system to the company's procedures and requirements, as well as migrating the historical data to the new system, not installing the software. One thing I admire about Microsoft is the way they insist that all customers work with a local firm ("Partner"), so that there is someone familiar with the customer's business environment on the ground to deal with specific issues.

Microsoft actually goes one step further. They design their systems in layers, the top layer being the changes needed to make the software fit the individual client. They don't claim to be the most advanced software on the planet. They claim to provide a set of flexible tools so that you and your Partner can make the system fit your needs.

Specialized vs. Multipurpose Software

"Overseeing and managing costs on the construction of a new facility with eight buildings is much too complex for traditional accounting software," said Jerry Fye, deputy director of finance for the Austin Children's Shelter, in a release.

Foundation Software, a developer of customized software for construction contractors, donated software, training and support to allow the Shelter to manage its construction project.

This raises the question of when to go with "traditional" or multipurpose software and when to go with a system designed for a specific purpose or industry.

If I were developing software for a specific industry and I wanted it to link into an accounting system, I would NOT try to reinvent the wheel. I would build the links to one or more packages that are popular with the companies in my target market. Rather than build yet another general ledger for medium sized businesses for example, I would bridge to Great Plains or Navision (Microsoft Dynamics GP or NAV). That way I get to stick with what I know (e.g. construction projects) and take advantage of someone else's success.

This goes for custom development as well. One of my clients was in the entertainment industry and wanted to sell tickets to customers online. Part of the project design was to integrate tightly to the accounting system so they would not have to re-key the transactions. They also decided that they did not want to have to do the programming to calculate all the taxes when the accounting system (Great Plains) already did such a good job of it. So they had their web site pass the information to the accounting system once the customer had placed the order. The accounting system then calculated taxes and shipping charges and passed the information back to the web site so the customer could enter the payment information. The result: a system where every piece does what it's good at and the headache of updating the tax tables is left to the experts: the accountants!

M.E.S.S. Revisited

From my earlier post, you know that Manually Entered SpreadSheets ("M.E.S.S.") are my nemesis. Not only are they time consuming to create and maintain, but they are also difficult to audit. As anyone who has been through a Sarbanes-Oxley (Bill 198) review knows, spreadsheets represent a significant control risk because of how easily errors can be introduced without detection. For example:

At this point you should ensure that there are the appropriate backup procedures for the spreadsheet. Ideally you will have documentation to support the spreadsheet as well. Then on an annual or biannual basis spreadsheets should be revisited, comparisons run on the tested versions and the audit trail reviewed to ensure that it is still functioning as required. Needless to say, any significant changes made to the model should be carefully considered, documented and re-tested at the time the changes are made.

In short, spreadsheets need to be considered as a separate financial computer system and all the controls associated with a financial system need to be applied to the extent the spreadsheet is to be relied upon for financial reporting. All of a sudden your "simple" spreadsheet is expensive to audit!

Currently I am working on a project to eliminate financial spreadsheets for an international client. Significant areas include:

• Multilevel consolidations,
  
• Canadian & US GAAP adjustments, and
  
• Tax valuations.

Luckily, this project is part of a larger implementation so I was able to participate in the re-design of the chart of accounts. We have come up with a way to isolate the international subsidiaries' raw data from the different GAAP and tax adjustments, all within the same Microsoft Dynamics GP (Great Plains) general ledger. When the client wants a US GAAP statement, they just add the US GAAP adjustments to the raw data using a pre-coded report in the FRx report writer. No M.E.S.S.!

Getting the Message Across

[source]

They say that confession is good for the soul. I have a confession to make: I never understood the value of graphics in financial reporting. I never created graphs in Excel. I even thought that it was all just window dressing for the published financial statements or sales presentations.

I missed the point.

Accounting is all about communications and, as an accountant, it is my responsibility to be sure that the message is understood. It isn't enough to expect that the users will look at my tables of numbers and draw the same conclusions that I have.

I attended a communications session by Eagle's Flight a few years ago. The trainer made the point that people tend to put their message out there and take the attitude "Well, I've done my part." If you want effective communications, you have to take responsibility for both the sending and the receiving of the message. You have to take into account how your stakeholders take in messages. Some people are just confused by spreadsheets. Take sales statistics for example. Rather than just presenting a list of customer sales sorted by city and decreasing amount, you can now plot your customers on a map of Canada with larger circles for higher sales and create a powerful visual that has an immediate impact.

Sometimes, it's just a question of presentation. I watched a demonstration of an Excel add-in for Microsoft Dynamics GP (Great Plains) where the sales person showed how the sales table with last year comparison figures could be automatically uploaded from GP and summarized for viewing and querying. Then he turned it around and asked, "Which customers didn't buy from me this year?" He then showed a graph of all the customers where sales this year were less than last year. There were audible gasps in the audience because the impact of the graph was clear: send a salesperson out to each of these customers. I could be cynical here and say that the table and the graph said exactly the same thing, because they did. The difference was that the table was just statistics produced by accounting and the graph was a call to action.

So, if you are an accountant and you feel your message to management is not getting across, I highly recommend you try a graphical approach. You'll be glad you did.

Competitive Edge: Your Accounting System

The Toronto Globe and Mail ran a story about Analytics, saying that a company's statistics can be a powerful tool in the right hands. Harvey Schachter, the Globe's "Monday Manager" quoted from Competing On Analytics, a Harvard Business School book by Davenport and Harris, which highlights the need to have the right data and the right management support in order to reap the rewards of good analysis.

How well I know that story. Every time I implement Microsoft Dynamics (Great Plains or Navision), I offer the client the ability to integrate operational data in the accounting system, but I am rarely taken up on the offer. One glowing exception was a felt manufacturer where the President had a one page report of key performance indicators that he used to run his business. It was quite a challenge to make the new system fit the summary cash, balance sheet, income statement and statistics (with a separate column for each subsidiary) onto one page, but it was worth it!

Try this: picture your company as a sports franchise competing in the major leagues. What statistics would help you manage the team? Think in terms of:

• Output: How much do you really earn per unit, after all discounts?
  
• Input: How much waste is there, and at what stage does it occur?
  
• Human Resources: How many hours go into your product or service? How high or low is your utilization?
• Equipment: How long do your machines sit idle?

Often managers feel they know the answers to this type of question already. As the Production Manager of a tool and die shop said to me, "You're not going to replace me with a computer!" when I implemented a job tracking program for the General Manager. But that same manager was really surprised at how busy his plant turned out to be. He had been considering whether to replace his older drill presses with computer aided equipment, but he ended up keeping both the old and the new equipment when he saw the report of his order backlog.

Even if you have an older accounting system, you would be amazed at the quality of report that can be obtained from standard microcomputer software such as Crystal Reports or even Excel, when they have detailed financial and operational data to work with.

What Do You Use?

Remember the old saying that the shoemaker's kids go barefoot? I was reminded of that recently when reviewing my own accounting system. When I first selected it, in 1994, I narrowed the choice down to Quickbooks and Mind Your Own Business (MYOB). I chose MYOB because it had both a Mac and a PC version and I was a bit of a MacHead back in those days.

MYOB could continue to record my revenues and pay my bills, but I started thinking about hiring my son to do some of the mailings, particularly when I'm on the road. I'm currently looking at Net Suite because it is:

1. Accessible via the web,
2. Bundled with a web site interface and CRM, and
3. Aimed at small business and the mid market.

I can use it for myself and offer it as an alternative to Microsoft Dynamics GP and NAV (formerly Great Plains and Navision). I'll let you know what happens.

Great Plains Announces Workflow

Great News: In version 10 of Microsoft Dynamics GP (formerly Great Plains), the electronic approval of transactions has been significantly expanded. To quote from the What's New documentation:

The workflow approval process expands existing workflow functionality provided in both Microsoft Dynamics GP and Microsoft Office SharePoint Server. This feature provides a consistent, comprehensive solution to the approval of purchases, credit limit overrides, sales quotes, and batch posting for payables, receivables and general ledger transactions. Integration with Microsoft Office SharePoint Server helps to ensure an efficient, centralized administration point, and allows the use of user roles to help you efficiently manage security of the approval process. The Workflow feature allows users to approve business processes, even if they’re not Microsoft Dynamics GP users.

So you can now set up a Purchase Order (for example) and have the system send it to a supervisor for approval or, if it exceeds the supervisor's approval level, have it go to both the supervisor and the vice-president.