AMP UP YOUR REPORTING AND PREPARE FOR FREQUENT ASKS
ABILA ARTICLE BY MICHELLE GARCIA 11.7.18
Particularly during a nonprofit’s growth periods, its finance team may be asked to generate reports on the health of the organization at any given moment. And, although most manage and prepare reports quarterly, bi-annually, and annually, the preference is to have the ability to provide reports based on current state. How can you be ready when the ask comes your way?
Before we jump in to potential solutions for more frequent reporting, see below for a few charts we garnered from our “2018 Nonprofit Finance Study” where your peers share their perspectives:
It’s reassuring to learn that a little more than 40 percent of responders don’t feel the burden of frequent reporting to funders. For those who do feel the burden, here’s what they’re saying they must do to respond to funders’ requests:
You can see from the keyword cloud, there are many types of changes getting incorporated to respond to funders during growth periods, even when reporting requirements may be different by funder and/or by grant. Users need more efficient and effective reporting on data. A good place to start is to increase emphasis on program assessment and evaluation – capture metrics to show program impact.
RECOMMENDATIONS FROM A COMMUNITY BRANDS EXPERT
Laura Reifschlager, Community Brands’ Implementation Consultant, recommends the following:
As you increase services, your chart of accounts grows with you. Add the codes you need and budget for those new services.
Growth is planned – that means strategically planning. Use a good a budgeting tool to include money for new services and use that to determine the new funding needed to support the plan.
Make sure your organization and team use a tool that contains powerful reporting capabilities that include:
Visual dashboards to help you spot trends instantly
Drill down of data with filters, permitting you to see details for your key performance indicators (KPIs)
Producing accurate reports to convey transparency with your finances inspires confidence, which is the foundation to maintain funding.
For careful planning for staffing growth, leverage an employee management tool or module, connected to your accounting software to enable efficient management of new employee requirements.
Finally, for quick access to your financials and reporting (for example, anywhere, anytime login), seek out a cloud solution for your accounting system.
Other methods you can incorporate:
Create general ledger (GL) groups for payroll tax analysis or benefits analysis.
Set up groups by budget manager or set up groups by managers and department for easier reporting.
Manage reports with executive view licenses. These license types allow additional users to run their own reports and assist with budget preparation, freeing you to focus on your management tasks.
At the end of the day, reporting should not be painful or burdensome. With an automated solution, you can replace that stress with ease.
If you have interest in learning more from your nonprofit finance peers, we invite you to contact us below for a download of the full study, “Nonprofit Finance Study: The Dynamics and Challenges of Growth,” and take a deeper look.
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, hence spending 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!
CPA’s 2018 Review of Abila MIP Advance Fund Accounting by Mary Girsch-Bock, Contributing Writer on July 23rd, 2018
2018 Review of Abila MIP Advance Fund Accounting: MIP Advance from Abila is cloud-based fund accounting software that is a good fit for small to mid-sized nonprofit organizations and government entities. Users can also download the mobile app for mobile system access.
The 2018 of MIP Advance offers a variety of dashboard enhancements as well as the launch of the brand MIP Idea Portal which allows current users to submit ideas and suggestions on how to improve the product.
Abila offers a flexible, table driven chart of accounts structure, with users able to configure an unlimited number of segments in varying lengths to better track organizational data. Support personnel work with all new MIP Advance users to configure the chart of accounts structure properly during the setup process. The product easily handles all types of transactions including standard accounting transactions such as AP, AR, and GL entries, as well as bank reconciliations, cash receipts, cash disbursements, allocations, encumbrances, purchase orders, and order entry options, as well as extensive budget transactions.
Users can create an unlimited number of fully customized budgets in MIP Advance, with the budgets reflecting any time frame desired, including across fiscal years. A robust forecasting feature allows users to easily forecast future expenditures, and users can also create a variety of ‘what-if’ scenarios to determine the best option for the organization. Warnings can be implemented if users are close to going over-budget, and the budget view allows users to see the status of any budget during the transaction entry process.
Options
Abila offers a variety of optional fundraising modules including Fundraising 50 and Fundraising Online. Fundraising 50 is designed to manage donor cultivation and retention, while Fundraising Online is a good option for organizations that wish to implement online giving platforms, manage events and create peer-to-peer fundraising opportunities. Users can track individual grants using the flexible account structure, and the product includes fund-balancing capability, to ensure that all funds are in balance at all times. The optional Allocations Management module allows users to record both direct and indirect allocations by percentage or transaction.
Security
MIP Advance Fund offers solid system security and the Advanced Security option offers database encryption and the ability to limit access to sensitive data such as employee salaries or budgets.
MIP Advance includes a good selection of preset reports that can customized to suit the needs of the user. A series of built-in reporting tools assist new users in creating new reports as well. Reports can be created across fiscal year, and the product easily produces nonprofit specific reports such as Statement of Revenues and Expenditures, and Statement of Cash Flows. Add-on reporting modules such as Accounts Receivable Reporting allows users to easily create customer invoices and statements, and Drillpoint allows easy customization of financial statements, including the ability to add graphs and formulas. All MIP Advance reports can be displayed on screen, emailed to recipients, exported to Microsoft Excel or Word, or saved as an HTML file or PDF.
As a modular system, all MIP Advance Fund modules work together seamlessly. MIP Advance core modules include GL, AP, AR Reporting, Bank Reconciliation, Budget, Data Import/Export, and Forms Designer. There are also a variety of payroll and employee management modules, Electronic Requisitions, Encumbrances, Fixed Assets, Purchase Order, Advanced Security, Allocations Management, and various reporting modules including Drillpoint, GASB Reporting, and a Data Consolidation module. Optional fundraising and donor management modules are available as well and the Abila Marketplace offers users easy access to Abila business partners, implementation partners, and product partners.
Support
The Abila Support Center offers access to a variety of user tools and resources including access to the Abila Knowledgebase, Community, and Subscription Center. Users can access product support via email or chat and toll-free telephone support is available during regular business hours. There are also a variety of training options available, including a variety of whitepapers and access to Abila product training options which include online, classroom, and instructor-led training options. Just added is the Abila Resource Library, which provides access to a variety of informational webinars and documents, with users able to search for content by Topics, Types, and Products.
MIP Advance Accounting from Abila is an excellent solution for small to mid-sized nonprofit organizations that would like to have a strong core system, as well as an opportunity to add additional product functionality when necessary. Pricing for MIP Advance varies, depending on the number of system users and the modules licensed. A monthly subscription that includes the core modules is $200.00 for a single user and includes hosting fees. Implementation is typically completed by Abila or authorized partners and is extra, with pricing dependent on the cost of the software.
2018 Rating – 5 Stars
Thanks for reading the 2018 Review of Abila MIP Advance Fund Accounting!
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 are rigorously training on Abila products because we spend up to 90 hours each year reviewing new functionality and training procedures. We are your go-to for service, and we also provide user groups, both online and in our offices. All things considered, your satisfaction and ability to get results is our main goal!
To learn more about a formal quote, data conversion and training:
Is your Nonprofit Giving your Summer Interns a Great Experience?
In nonprofit organizations, college interns can be a tremendous resource. Not only are they unpaid, but more often than not they are energetic and eager to contribute. In return for their efforts, they should gain a valuable learning experience from your program. Are you giving your interns the best experience possible? And is your organization getting the most out of nonprofit internships?
The four guidelines below are widely considered the golden rules to make the internship experience mutually beneficial to both your intern and your organization.
Rule 1: Assign a point person to be the intern’s mentor.
This point person should be available for everyday questions and concerns, and should also meet with them regularly- at least weekly- to check in, discuss how things are going and give feedback. Interns need support and supervision just like paid employees, and it’s important for organizations to provide this. If your nonprofit internships involve counseling or other services that can be emotionally charged, allowing interns to discuss and process what they have experienced is especially important.
Rule 2: Provide an orientation process at the beginning.
This should include an overview of your program and basic training on providing services. Although this may take an initial investment of time for your program to develop, it can be used over and over as an orientation for interns, other volunteers, and board members. On the intern’s first day, the point person should also introduce them to everyone and make them feel welcome. Welcome kits with your program logo on them are a small way of making them feel special and part of the team.
Rule 3: Give interns a variety of tasks both large and small.
Of course, this will usually include things like copying and collating, but it should also include skill-building tasks. To think of ideas for intern duties that can be beneficial to both the intern and to you, simply think of things that you wish you could get to. Do you need to research funding opportunities? Is there a community collaboration meeting you don’t have time to attend but could send them to? If they sat in on program services, can you have them complete the required documentation (for you to review and sign) so you don’t have to? Can they write an article for your newsletter? (Don’t have a topic? How about “My Experience as an Intern”?) Can they help with the design and execution of a fundraising event? College students at nonprofit internships may also have skills that your paid staff members don’t; for example, they may be able to expand and update your program’s social media presence better or faster than your staff can.
Rule 4: Show your appreciation.
An important part of showing appreciation for your interns’ efforts is to end with a ceremony that acknowledges their hard work. Thank them for their contributions and review their experiences in a way that gives them a chance to reflect on what they have learned.
Internships are a two-way process: you are there to pass knowledge and experience on to them, and they are there to contribute to your program, not only through their work but also through their fresh perspectives. The more you put into supporting interns, the more you will reap the benefits of their participation in return.
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!
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.
Inadequate Training
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
incident…while smiling.)
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!
To receive more free info on prevention, assistance and software training:
