Abstract

Everyone is aware of the fact that accounting and ERP software selection projects seem to have an excessively high failure rate. A month doesn’t go by without hearing that a customer has sued their ERP vendor or implementer/reseller for a failed project. While this is certainly an issue, some of the blame may need to be placed on the shoulders of the buyer and for any number of reasons. While reimbursement could be collected, the lost time and lost productivity can never be recovered. Maybe the following can be used as a checklist to reduce the likelihood of failure.

Introduction

If I attempt to list every step in a typical accounting/ERP software selection project, I could publish a book. Instead, I want to concentrate on those steps you should take before you actually launch the formal project. If you are organized for success, the likelihood of failure will be reduced significantly.

Share the Responsibility

Never launch a software selection project thinking that the vendor/reseller is 100% responsible for the outcome. That almost guarantees failure. Your primary objective in any ERP software selection project should be a successful outcome and that means you need to take whatever steps are necessary to do what needs to be done.

This philosophy also applies to the purchase decision making process. While there is no doubt that you need to appoint a project manager to make sure things get done, no one person should be totally responsible for an ERP software selection project. Every person should be responsible for the final outcome and therefore each person must make the “selection”. The only way this project is going to stand a chance of succeeding is for each person to participate equally in the final decision. The key concept here is mutual responsibility.

Secure Buy In or Kill the Project

It’s really quite simple. If you do not have the active support of each significant stakeholder, go no further. Your ERP software selection project has been significantly compromised.

Educate Yourself

Selecting a new accounting / ERP system isn’t something to be taken lightly. Any project of this magnitude and critical importance can fail simply because you get off on the wrong foot. Start this ERP software selection project by taking no direct action. Instead, spend some time educating yourself so that the decisions you make as you proceed will be based on realistic facts, not dreams or the marketing hype of software vendors. One of the most important steps you can take is learning how a software selection project should be organized. If you don’t understand what needs to be done and by whom, how can you possibly know whether you are on the right track?

Construct a Foundation for Greater Success

Rather than duplicating what you are doing today, take your business apart and create a stronger, more effective structure. While formal Process Improvement should not be undertaken lightly, maybe you don’t need such radical change. Maybe you do. The key concept here is creating an organization that is more efficient, more effective, more productive and therefore more profitable. Then you can determine what you need in terms of business functionality that will help you move to this future vision.

Assess Your Ability to Change

Even though you may have recognized the need to change, and have identified specific areas of the business or business management system that need to be changed and to what degree, if you cannot manage effectively such a n ERP software selection project, or your management and employees are not ready to change to the same degree you believe is required, the project’s basic foundation will be compromised.

Develop an Understanding of what’s Possible

This is to some extent an educational step, but focused more on the software functionality you might need. The more you know about the potential that can be released through current accounting / ERP systems, the better prepared you will be to define exactly what you require to improve your own operations. Learn what other people are doing. Contact prospective vendors or resellers to learn more about what’s possible in terms of functionality. At this stage make it very clear that you are conducting research, not buying.

Remember to Include your Customers

Since your customers are your most valuable business partners next to your employees, involve them in this process. Ask them how you can serve them more effectively.

Build from the Bottom Up

One of the mistakes firms make is driving software selection from the top down. Executives, managers and project leaders will all contribute significantly to this project from defining requirements to making the purchase decision. What about everyone else? Is their input important? Are they ready to change? Will they accept the new system? Any person who will be using the new accounting/ERP system is a vital contributor to the firm’s success and the success of this project. Their contribution may shed light on important software requirements or business improvements. If you want to increase the likelihood of failure, leave these people out of the process.

Answer the Critical Questions

Your first step is giving people the ability to critique their own jobs as well as the organization as a whole. Give people the ability to describe their job objectives as they see them, critique the information that flows into them from other sources, critique their portion of the accounting/ERP system, and put into their own words what they believe the organization does well or does not do well. Maybe you should ask and answer the following questions.

• What do we do now?
• What works and doesn’t work?
• What can we do individually to improve?
• What should we be doing that we are not right now?
• What changes should be made in the business management system to help us work more effectively?
• What can other people do to help us do better?
• Are these goals or changes reasonable?
• Where is the organization today?
• Where should it be in the future?

Please keep in mind the fact that everyone needs to be involved in these initial questions. Leave people out at your own risk.

Build an Effective Information Management System

Let’s admit that it’s now possible to track anything you want. That isn’t the issue. Modern accounting and ERP systems can analyze data and spit out reports and graphs and dashboards that have the potential to either overwhelm people or give them information that they don’t need. Instead, you need to use this power to your advantage. As I have discussed in previous posts, what we need is a truly effective decision management system, not multi-page status reports or meaningless metrics and useless dashboards.

• Start by designing a targeted reporting system. Ask yourself why you need the information. If it doesn’t lead to a decision, then you don’t need it.
• Build a system of business metrics that gives people the ability to “see” where they need to concentrate their attention and to “see” if decisions they have made are leading to improved results.
• Finally, design truly effective Exception Management systems that give people the ability to identify and address issues that need to be addressed.

Summary

I have chosen to address only those software selection tasks that should be undertaken by the buyer and only the most important steps that precede  any form of needs analysis and product evaluation. While I would certainly hope that vendors and resellers would help people understand what needs to be done and by whom, I choose to follow the maxim “Let the buyer beware”. If you are contemplating the purchase of a new accounting or ERP system, you need to take responsibility for the project. If you organize yourself for success, it’s very likely you will succeed.

Business Reporting has always been one of the many soapboxes I love to jump on (http://www.accountinglibrary.com/blog/category/business-intelligence/, http://www.accountinglibrary.com/blog/category/business-alerts/, http://www.accountinglibrary.com/blog/category/exception-management/). While there is no doubt that sound business decisions are based primarily on the person making the decision, these decisions need to be based on sound information. Seat-of-the-pants decisions might work for small firms where the experience of the decision maker is the key element, but there is just too much information spread over too many decision makers for this practice to work in larger firms. In this case accurate and timely information must serve as the foundation upon which sound decisions can be based.

Why do you need this information?

Accounting and ERP systems can store and regurgitate just about anything you want. Actually it’s possible that for every transaction posted there can be 20, 30 or 40 fields that will allow you to slice and dice data any number of ways. The fact that you can carry reporting (intelligence?) to this level of detail doesn’t necessarily mean you should do it.

Start by asking yourself why you need the information. If it doesn’t lead to a decision, then you don’t need it.

In what format should this information be presented?

With the exception of audit trail reports, rows and columns are out. In no case can they lead to a decision.

Pie charts and bar chart are out as well. They, like row/column reports, are no more than a snapshot of a specific condition at a specific instant in time. People should never make snap decisions and that’s all this information can support.

Having said this, there is one use to which some specific data can be applied. Exception Management or Business Alerts are usually triggered by a specific value, but only if that condition falls outside an expected range. As an example, if a customer’s account exceeds its credit limit or a specific invoice becomes “x” days overdue, that condition should be brought to the attention of a named individual. Business Alerts handle the notification process while Exception Management gives users the ability to deal with an alert in a contact manager like application.

If rows and columns, bar charts and pie graphs are not acceptable, what’s left? Line charts are the only form of reporting that actually lets users develop a sense of the history and future of business conditions that can then give people the total picture. It really doesn’t matter where a company is today, nor does it matter where a company has been. All of that has already happened and cannot therefore be changed. What can be changed is the future and that’s where people need to concentrate their thoughts.

Think of a line chart as a beginning, a middle and an end. Historic values form the anchor upon which the line chart is constructed. The last current piece of data (the most recent value) is the jumping off point and the extension of the line formed gives us an idea as to where our future “might” be.

Once we see the total picture, we can determine if it’s heading in the right direction. Well, that’s part of the analysis, but not everything. The extended line chart gives us a hint of our future, but we still haven’t figured out if that’s where we want to be. You need a second line chart that acts as our target. Now we can see in an instant our past, one possible future and our target.

There are still two adjustments we might need to make. If the volatility of the data is significant, we may have to utilize some form of smoothing to make the data more understandable. Second, data does not follow a straight line path. Sometimes it’s increasing/decreasing over time. If that’s the case we may need to utilize some form of analysis that let’s us see these trends.

Now we can “see” the data and make a decision. If the trend seems to be within the acceptable range or budget we created, then no decision is required. If the trend seems to be heading in a negative direction, then we know we need to take action. No data analysis will ever tell us what to do, but this approach will help us determine if we need to do something and most importantly if the decisions we have taken seem to be having a positive affect.

What information needs to be extracted and displayed?

While it’s certainly easy to create graphs once the data values have been identified, the hard part is determining what you need to track. Remember, you can create any number of fields than can be used to feed your data analysis engine. Picking the right fields is the tricky part.

Think of an Income Statement. It’s got lots of data that could be graphed. Now think of virtually every accounting and ERP system’s ability to support drill down. If you can drill down from a data value to underlying information, then the information is of no use to you because it is being influenced by other data. Since you cannot track everything, you need to identify those basic factors that have the most influence on your business. Identify your Profit Drivers.

Maybe inventory turns in a distribution environment can be thought of as a Profit Driver. Don’t forget though that it’s not going to be possible to track every single item your carry. Maybe start with inventory turns as a whole, then by product line or possibly region. Where you start is not as important as your ability to quickly see where you may have a problem developing. Then you can drill down to a more detailed analysis.

Summary

Efective business decisions drive business profitability. These decisions need to be rooted in facts that can be brought to light instantaneously. People do not have the time to guess. They need to know where to place their attention. They also need to know whether the decisions they make are having the desired effect. If there is too much data, the issues may remain clouded. If there is no way to compare actual results against targets, how can you ever know if you are where you want to be or need to be. Finally, people need to identify those Profit Drivers that have the most significant impact on their organization or on their specific area of responsibility.

Forget about columns and rows. Forget about bar charts and pie charts. Adopt a proactive system that helps you track not just where you have been or where you are today, but where you could be tomorrow.

Introduction

Let’s say you are the leader of a software selection initiative for your firm. What should you expect from resellers of the products in which you have an interest? Conversely, what should resellers expect from you? The selection of a new accounting or ERP system is a bit like a dance competition with well rehearsed partners that can take your breath away or so bad that you want to change the channel. If you are one of these participants, who do you want for your dance partner?

The Prospect Profile

If I am a prospect, what should I bring to this dance competition to enhance my chances of success? Perhaps the most important attribute is a commitment to the project. I’m not just talking about the project manager, but every level in the organization.

The CEO has to back the selection team 100% and take an active role (not just passive interest) in the project. In addition the CEO and other executives have to define exactly what they require from the system to assist them measure their progress toward the achievement of their strategic goals. If they do not, then the system will be of little use.

Similarly individuals and groups from each level in the organization need to define exactly what they want. It doesn’t have to be an exhaustive list of specific functions, but rather a definition of how the system needs to help them do their jobs more efficiently and more effectively.

The CIO or IT Manager needs to take an active role in the project, but should not direct it. The CIO needs to make sure that the technology of the system is appropriate and that it will carry them forward for many years.

Knowledge is perhaps one of the most important success factors. In many instances people might have formed a picture in their minds (sometimes a very fuzzy picture) regarding where they want to be, but they may not know how to get there. Prospects need to admit that they don’t have all of the answers, but they do have a thirst for knowledge. They need to learn as much as they can before they start this project (industry requirements, strengths and weaknesses of their current system, functionality that is available in today’s systems that might be of interest and of course how to manage a successful software selection project).

Now this is the ideal prospect!

The Reseller Profile

Most accounting and ERP systems are sold and supported by resellers so let’s just pick on resellers.

While an intimate knowledge of the products they sell are a critical requirement, that’s not what’s important initially. Prospects need a firm that will lead them to success. In this case the definition of success is going to be different for each prospect. Since many prospects have not been through this process, their lack of knowledge is the most important initial issue.

Most firms are not an ideal prospect as described above. They may not even understand that their business processes might be one of their restrictions, and they may not understand what’s possible in terms of modern business management systems. Prospects need a reseller that understands business or at least understands that every firm needs to evaluate its business processes.

Prospects also need a reseller that offers as its most important selling point a detailed process roadmap that will literally take a user by the hand and lead them through every stage of the knowledge acquisition, business process analysis, software selection and implementation project. Notice that I have said absolutely nothing about an evaluation of the attributes of the product or products offered by the reseller. The answer is simple. How can you properly evaluate a software product if you don’t have a solid basis for comparison?

In the end prospects need a business partner that will help them acquire the knowledge necessary for them to create a foundation for business success. Yes, prospects need a business management system that will do the job, but more importantly they need the knowledge and cooperation that only the best reseller can provide.

Why does one business prosper and another business in the same industry fail? Does the victor know something the loser doesn’t? Each may offer the same products or services. Each may have the same type of client base. Each may have the same level of expertise with respect to the mechanics of their products, services and industry. However, one may possess a jewel more precious than many people realize. That jewel is a well defined management philosophy.

“That set of rational principles which form the basis for guiding or controlling the operation or performance of a business activity“.

The key concept contained in the definition above is the identification of the rational principles and that’s our primary task. Our secondary task is the testing of each principle to insure that it’s applicable to all phases of business life and action.

After considerable thought and experience (What better way to test this definition than in the cold light of reality?), I would like to propose the following list of business or management principles. This isn’t an all inclusive list, but presents what I consider to be the leading candidates.

1. The objective of any business is the generation of profits: While some might dispute this statement as not being applicable for non-profit entities, I would counter that all must generate profits, for it’s only through profits that any business can sustain itself. We should not be afraid of being profitable. We should strive to be as profitable as possible without violating any of the other business principles. That’s the key concept.
2. The most important asset of a business is its employees: No business operates without employees. No business can achieve its potential unless each employee has the ability and the right to achieve their individual potential. Each employee must feel as though they are a part of the total organization. Each employee must feel as though they matter. It’s just that simple.
3. Customers are just as much a part of a business as employees: While this might seem to be an obvious statement, far too many businesses fail to recognize just how important their customers are. Products and service must meet the actual and perceived needs of the customer. Notice that I have used the plural form of the word “need“. The physical product or service is but one need. The process of selecting the initial supplier of a product or service, and the continuation of the relationship be­yond the first order, involves the identification and satisfaction of a whole host of needs. The only manner in which this can be accomplished is the inclusion of the customer into the daily life of the business. This is exactly the same goal the business should have with respect to its employees (and let’s not forget suppliers too).
4. Management gets paid to think: Consider for a moment the example of the business that fails and the business that succeeds. Consider also the examples everyone can cite of businesses that appear to place their management in a position of “doing” rather than “thinking“. Could it be that the management of the failing company chose by default the wrong fork in the road, simply because it was so busy taking care of business that it didn’t even rec­ognize that there was a fork in the road. I’m not suggesting management must live in an ivory tower, for to do so ignores the realities of the practical side of business life. What I am suggesting is that management must recognize subtle changes in the environment in which it competes, and alter the life of the business to reflect these changing circumstances. It can do so only if it has the ability and the time to think.
5. No business operates in a vacuum: Vacuums come in many forms, and each can be as dangerous as the other. The specific vacuum to which I am referring produces a form of insulation between the business and the outside world. Our world is changing rapidly. While management might con­sider itself to be very capable, nobody has all of the answers. Management needs contacts in the outside world to test its competency. It should hunger for knowledge, and welcome the testing of its principles against others. It cannot be afraid of this process, but should encourage it. Management cannot afford to be wrong, and should recognize that it might be wrong. That’s what this testing process is all about.
6. Business conditions are in a state of constant change: While everyone might agree with this statement, the successful business uses it as one of the cornerstones of growth and longevity. The successful business assumes it must change, and looks for opportunities to change. Change here isn’t change for the sake of change, but rather changes that will enable the business to become more efficient, move into new markets, take advantage of new technologies, or reduce the impact of downward movements in the economy.
7. Information is the key to the identification of strengths and weaknesses: This statement might be considered to be a corollary of the one dealing with operating in a vacuum. The former dealt with an outside vacuum, while this statement deals with the vacuum of inside information. The increasing importance of Business Metrics has led many companies down the path of excessive informa­tion, and ultimate strangulation in their own data. Information systems should be based on maximizing the effectiveness of the data generated. As I stressed in my blog post about Business Metrics (http://www.accountinglibrary.com/blog/business-metrics-creating-a-framework-for-success/), managers must define those “few” critical values that represent the driving forces that lead to success. If the information generated does not lead to some form of decision or reaction, then it has no meaning and should be discarded. If a business concentrates on its most important common denominators, then the income statement will take care of itself.
8. Organization must be taken to its lowest level: Each business function is important. Some may be identified as more important, but none is inconsequen­tial. Each person in a business is important. Each customer is important. The company must be structured so that each person or department has the tools it requires to achieve maximum effectiveness. The busi­ness is, in many respects, a living organism, and it’s the responsibility of management to insure that each cell or body part receives equal attention. Without this, that part could become diseased, and could drasti­cally affect other body parts.

Conclusion

Each business must go through the process of identifying its individual philosophy. Once these statements have been created and adopted fully at all levels of the organization, they must be reviewed regularly to insure that they are being followed. All other actions of the company must be rooted in this philosophy, and must be tested against it. The successful company will acknowl­edge that it requires a philosophy. The less than successful company will not recognize this need. While this might sound simple, it isn’t. Successful companies know they are not perfect, and will strive to identify their strengths and weaknesses. They are not afraid to measure themselves, for they know that in doing so, they move one step closer to their goal. Maybe you should consider if any of these statements can assist your company?

The following article was included in a recent newsletter for AccountMate (www.accountmate.com), publisher of AccountMate software, a leading middle market source code accounting system. David Dierke, the author and president of AccountMate is a close business friend who thinks a lot like me. I enjoy his musings.

We all want to “get stuff done”! Whether this ‘stuff’ is the work we have to do so we can get on with what we want to do or the projects we feel are our purpose in life. To that end, here are the 10 tips that I have collected over the years that might just help you “get stuff done”.

1. Most Important Tasks (MITs): At the start of each day (or the night before) highlight the three or four most important things you have to do in the coming day. Do them first. If you get nothing else accomplished aside from your MITs, you’ve still had a pretty productive day.  
2. Big Rocks: These are the big projects you’re working on at any given moment. Set aside time every day or week to move your big rocks forward.  
3. Inbox Zero: Decide what to do with every email you get, the moment you read it. If there’s something you need to do, either do it or add it to your to-do list and delete or file the email. If it’s something you need for reference, file it. Empty your email inbox every day.  
4. Wake up even earlier: Add a productive hour to your day by getting up an hour earlier – before everyone else starts imposing on your time.  
5. Forget about #4 and get more sleep: Sleep is essential to health, learning and awareness. Research shows the body goes through a complete sleep cycle in about 90 minutes, so napping for less than that doesn’t have the same effect that real sleep does (although it may make you feel better). Get 8 hours a night, at least. Learn to see sleep as a pleasure, not a necessary evil or a luxury.  
6. Brainstorming: It is the act of generating dozens of ideas without editing or censoring yourself. Lots of people use mind maps for this: stick the thing you want to think about in the middle (a problem you need to solve, a marketing concept you want to pursue, etc.) and start writing whatever comes into your mind. Build off of each of the sub-topics, and each of their sub-topics. Don’t worry about whether the ideas are any good or not – you don’t have to follow through on them; just get them out of your head. After a while, you’ll start surprising yourself with some really creative concepts.  
7. SMART goals: A rubric for creating and pursuing your goals, helping to avoid setting goals that are simply unattainable. SMART stands for: Specific, Measurable, Attainable, Realistic and Timely.  
8. Remember the 80/20 Principle: Generally speaking, the 80/20 Principle says that most of our results come from a small portion of our actual work, and conversely, that we spend most of our energy doing things that aren’t ultimately all that important. Figure out which part of your work has the greatest results and focus as much of your energy as you can on that part.  
9. Review: Schedule a time with yourself every week to look over what you’ve done that week and what you want to do the next week. Ask yourself if there are any new projects you should be starting, and if what you’re working on is moving you closer to your goals.  
10. Eat the Frog: Do your most unpleasant task first. Based on the saying that if the first thing you do in the morning is eat a frog, the day can only get better from then on (unless you enjoy frog that is…).