Rehoboth Christian Ministries Gains Speed and Clarity with Microsoft and ERP Integration

Before switching to Sparkrock, their finance and payroll departments were overwhelmed with manual tasks and disconnected systems. Payroll took 2-3 days to complete due to using paper timesheets, no scheduling solution, and the need to import Excel spreadsheets into their previous finance system.

The lack of integration also made reporting a tedious task. Like many nonprofits, Rehoboth must provide regular reports to its board of directors and the government. These reports were time-intensive and error-prone.

Their leadership team created an RFP and evaluated five different ERP systems. Ultimately, they determined that Sparkrock was able to provide everything Rehoboth needed.

They successfully migrated to an on-premise version of Sparkrock in 2016 before upgrading to Sparkrock in the cloud in 2022. Sparkrock's partnership with also Microsoft was a key driver in their decision-making process. It allowed them to integrate other Microsoft 365 applications, such as Outlook for email and Microsoft PowerBI, a data visualization platform for advanced reporting.

"It's so seamless going from one application to the next. It's all there. You don't need to jump around to get information. Sparkrock took it to another level when partnering with Microsoft as greatly as they did. That made all the difference for us," said Janice Gerbrandt, Director of Corporate Services at Rehoboth.

Before Sparkrock, the finance team would spend hours getting reports ready. This means Janice and her team were constantly buried in manual tasks instead of focusing on more strategic tasks. With Sparkrock and Microsoft Power BI, the system automatically generates quarterly reports and bi-monthly financial statements for Rehoboth's Board of Directors. And with the drill-down functionality, users can dig in to find even more information if needed. This makes it easier for Rehoboth to assess the most impactful programs, where additional resources might be required, and ultimately provide a higher quality of care to those they serve.

Janice also mentions that there's been a big payoff with Sparkrock and significant organizational adoption from when they first got the system up and running. The permission-based roles give users access to what they need to do their job correctly.