Their Mission

The District of Nipissing Social Services Administration Board (DNSSAB) is committed to promoting and enhancing healthy communities, and strengthening and empowering their citizens. With a wealth of in-house experience, they carry out their mission in a citizen-focused manner, and by offering the best quality of services possible.

What was holding them back?

DNSSAB was using an outdated and costly system that made them rely on Excel spreadsheets to complete most tasks. Reporting was a hassle since the legacy software did not easily support basic accounting transactions and reporting, like providing aged Accounts Receivable listings.

“Everything took a long time,” explains Sara Tonks, Director of Finance and Administration. “It took two Finance Officers to handle the many workarounds we developed. On top of that, the system was not user friendly and delayed the simple process of retrieving financial information.”

With more than 75 funds to manage, the organization was searching for a solution that catered to their specific needs and could handle complex reporting to 4 different Ministries. The top 3 goals set out by Tonks were flexibility to use dimensions, user-friendliness, and flexibility in reporting and accessing of information.

How we helped

The Sparkrock solution that was implemented solved all of the problems that DNSSAB was facing when it came to reporting. They can now add many different dimensions to their data, allowing them to slice and dice information and arrange it exactly the way their Ministries want it.Furthermore, their new system can integrate with other systems to make importing and exporting data simple and fast, while providing real-time numbers. Workflows also streamline processes to ensure that funds and grants go through the proper approval process before being allocated to one of DNSSAB’s programs.

How they now leverage technology to serve more people

After implementing their new solution, DNSSAB reduced the immediate accounting costs by $20,000 and realized significant improvements in efficiency. They virtually eliminated human errors of keying in information, and their reporting became a breeze! What’s more, their month-end reports used to not be ready until the 3rd week the following month; now they are able to run reports any time, in real-time. They’ve reduced the reporting time from a month to usually less than 2 days. Overall, because of these new-found efficiencies, DNSSAB estimates saving about $50,000 per year, which can be reallocated back into their services.