“The Sparkrock solution works really well because it’s fully integrated, right from revenue back into the back end. As soon as you have a piece of information the data is there and you can see exactly where you stand in regards to financials and revenue.”
– Rob Jackett, Director of Administration
Previous to implementing their Sparkrock solution, Canadian Baptist Ministries struggled with providing transparency and accountability from their legacy DOS-based system, Accpac. The software was too cumbersome to allow them to optimize fund and grant management, provide budgetary control, or manage complex reporting requirements, and manual processes were slowing down their efficiencies.
This solution did not integrate well with their other management software, with specific issues arising between their financial and donor management systems. There was a lot of manual intervention needed to manage grant and funding related processes and it was taking them long periods of time to close the books. Not only was CBM’s old system non-integrated, but it was also partially paper-based and involved Excel spreadsheets and the need to import and export large amounts of data from disparate systems. Expenses were coming in from the field mainly in a manual format, and then they would have to manually tie the two together in their systems. Of course, because this process was paper-based and not automated it took a lot of extra time and manual effort to be able to match their expenses and revenues.
Their close dates took anywhere from 4 to 6 weeks beyond receiving the financial information into their organization, and they quickly grew to realize that a world class organization could not accept this delay as a standard any longer. With statutory pressures growing, they realized they needed to be able to understand their revenue streams and budgets in real-time if they wanted to have the maximum impact on their mission and the lives of the people they serve, and this triggered them to begin to look for a system that was better-tailored towards their specific needs as a Nonprofit.
One of the largest advantages of switching to Sparkrock's Finance and Accounting solution is that CBM can now easily access up-to-the-minute financial information. "One of the things we’re able to do now that we weren’t before" notes Jackett, "is that we’re able to get to important data that we weren’t before, or if we could get to it then it was in streams of paper – the report would be 100 pages long. Now we’re able to data mine in a much more effective and efficient manner, so we’ve reduced our cost of administration and reduced our cost of analysis. We’re quicker and can make smarter and more timely decisions."
The project management module implemented by Sparkrock is also very important to CBM’s ministry. All of the history of the project revenue that’s coded within the system is there. There’s a project card which details all of the information regarding the project in terms of the project number, the description of the project, who the beneficiaries of the project are, who the leads are on the project (both from an internal and an external partner perspective), descriptions of what the activities are, along with any reporting that comes back. All of this documentation is able to be easily attached within the module, so anyone who has access to the system - and they have people that access the system from different locations around the world - are able to go in and get the details of the project. This feature, to be able to have that information readily accessible and up-to-date, is critical to their successful program delivery at the management level, the project level, and the program level.Ultimately, the better and easier the administrative team can do their work, the less time field workers have to spend doing admin or paper work, worrying about staff getting paid, or questioning the integrity of their data. This gives them more time and resources to spend on their programs and provides better services and support to the people they serve around the world.