Avoiding Nonprofit Accounting Software Mistakes
A recent LinkedIn conversation related to new nonprofit accounting software system implementations and the various systems on the market, brought out many ideas on this topic. Clearly several users had their favorites. But after many indicated which system they liked best or had used, the real issue came out. That is that no nonprofit accounting software system will perform satisfactorily without proper design and implementation. Avoiding nonprofit accounting software mistakes is as important as ever.
Whether implementing a new nonprofit accounting system or improving an existing one, there are several design and procedural issues that need to be addressed.
Inadequate Codification for Nonprofit Accounting Software
One of the most important issues is coding, particularly the chart of accounts in a nonprofit accounting environment. If transactions are not coded in a way that allows for easy sorting and selecting for reporting, you find yourself extracting (or rekeying) data into spreadsheets and manipulating it there. In fact, one of the symptoms of an inadequate or poorly designed system is over dependence on spreadsheets. If you’re using spreadsheets for routine reports (weekly, monthly, quarterly), that is probably an area you should look at automating. Look at your reporting and work backwards to make sure your account code can support your reporting needs.
Beyond the chart of accounts make sure vendor and customer ID’s are consistent and make sense for the end-user. For instance, if your system looks up vendors by alpha numeric codes, don’t use numbers to identify them. Use a consistent variation of their name so they are easier to find. And use the same logic with employees.
Not reviewing processes/procedures
One if the greatest misconceptions’ regarding software is that it will fix broken business processes. It will not, but it may bring them to light! As an example if you are entering invoices AFTER the checks go out, most software will NOT accommodate your process (I actually have encountered this scenario). Please don’t blame the software! Avoiding nonprofit accounting software mistakes involves effortful attention on your part. Review your process and see how it might be changed to allow the software to improve your accuracy and efficiency.
Not taking advantage of nonprofit accounting software features
Oftentimes software is purchased with the intent of utilizing advanced features, but inertia takes over and things revert back to the “old” way. Areas like auto reconciliation, reporting, automated budgeting processes, workflow, and document management all sound great, but are indeed HARD to implement. On the other hand, there is certainly a cost/benefit to the time and effort it takes to accomplish these tasks. It is very much like a “mini-conversion” of that task you are undertaking. So first, make sure it’s an effort for which you’ll realize a return on investment. Indeed, some features may not work as demonstrated. Talk to other users who have already implemented that feature, and can validate its usefulness. Then make sure that you are clear on what is required for a successful implementation, and then properly plan and execute on it.
Not creating documentation
We’re not talking about User Manuals here. We’re talking about customized documents for every transaction and process you execute throughout the system, from GL entries to system backups. While these procedures are time consuming to create, their value in insuring consistent processes and results is invaluable. In addition, they make great training references for new staff as well as reference guides when filling in for someone on vacation.
Whether it’s a new system or a new version release, learning how to fully use them system insures optimal return on investment. Training also allows your staff to ask questions of the system that they may need clarification on. The key to avoiding nonprofit accounting software mistakes is in your preparedness.
Overly Complex Systems
A nonprofit with a single revenue source and a single program area may be able to use a fairly simple system like QuickBooks. However, as transaction and reporting complexity increases (allocations, cross fiscal year reporting, multiple Net Asset classifications, etc.), the need for a system that offers those features and benefits increase. Avoiding nonprofit accounting software mistakes for companies with multiple revenues is more important than most these companies will realize until it is too late.
Conclusions Regarding Nonprofit Accounting Software Systems
The discussion brought to mind some of the favorite comments heard in 20 years of consulting on non-profit system implementations. My top 6:
No. 6 – “I’m not too concerned about reporting. I do most of mine on Excel.” (The same ones you designed on VisiCalc?)
No. 5 – “I won’t need any help implementing, I’ve done several. In fact I’ve implemented three different accounting systems here in the past 5 years!” (Say no more.)
No. 4 – “We won’t need to involve any staff in the process. I’ll tell them what to do and they’ll do it.” (The beatings will continue until morale improves!)
No. 3 – “We don’t need any SOP documentation. It’s all up here (points to head).” (While I prefer to use “what happens if you win the lottery” scenario, staff keep referring to an unfortunate bus
No. 2 – “Just show me how it works and I can teach everyone else what to do.” (Because nobody knows their job better than you, and you obviously have tons of free time.) And the No. 1 Comment – “I’d like to keep my chart of accounts / vendor coding / employee ID because that’s the way we’ve always done it!” (At least that explains your “vintage” wardrobe.)
Yes, intense planning, procedure review (including staff input), training, documentation, and a willingness to accept change are critical components of a successful implementation. Nonprofit
accounting software itself will not fix broken business processes, but it will often bring them to light! There is no better time to start avoiding nonprofit accounting software mistakes through 1st Choice Advisors!
About the Author
John S. Francis graduated with his MBA from Southern Illinois University – Carbondale in 1985. Since that time he has worked in various accounting professions. From 1996 to 2009, he was founder and President of one of the country’s leading accounting software implementation firms. Acknowledged as a “Top 100 Technology Pacesetter” and a “Killer VAR” by Accounting Today magazine, and a “Top 100 Value Added Reseller” by Accounting Technology magazine, his firm successfully managed accounting system implementation and training engagements for thousands of clients worldwide. In 2009 he began working on accountingsoftwaresuccess.com, a site dedicated to assisting accounting professionals with their search, selection, implementation and use of accounting systems. He now heads up 1st Choice Advisors, a value-added reseller service organization who works with various technology solutions.
Why Use an Abila Business Partner?
1st Choice Advisors is a Select Business Partner for Abila products and services. Our consultants also have over 30 years of experience working with nonprofits; real-world experience with a variety of different types of fundraising needs and requirements as a result. We rigorously train on Abila products. Why? We spend up to 90 hours each year reviewing new functionality and training procedures. We are your go-to for service, providing user groups, both online and in our offices. All things considered, your satisfaction and ability to get results is our main goal!