Using data to tell visual stories to multiple stakeholders
Nonprofit leaders face all types of challenging questions: Do I have enough volunteers? Will my congregation maintain their donations? Are we growing too fast or not fast enough?
Having a system in place to contextualize and form a narrative around data is crucial. Otherwise, numbers can cause more confusion than clarity. Unfortunately, South Fellowship Church learned that the hard way.
“In the past, we relied on Excel spreadsheets to organize our metrics,” says Larry. “But when we tried to present that to board members, their eyes would glaze over—I could physically see them disengage.”
When Xcelerate collaborated with South Fellowship Church, Jessica knew her team could help Larry explain the financial status of the church in a clear snapshot that was simple yet informative. One of the tools Xcelerate used to accomplish that was the cash flow dashboard in QuickBooks Online Advanced.
Cash flow can make or break a nonprofit. It’s also one of the most difficult reports to pull as an accountant because it blends multiple data sets. “You can’t accurately show what’s happening with cash on a profit and loss report or a balance sheet alone,” says Adrienne.
The cash flow dashboard equipped South Fellowship Church with real-time visual interpretations of their data to show how much money was going in and out at any given time. For example, Xcelerate spotted a dip in cash leading up to Christmas, prompting the church to act immediately to stay on track.
“Getting an accurate look in real-time at cash flow doesn’t just give me peace of mind,” says Larry. “It helps our church make evidence-based predictions.”
Moreover, the revenue streams dashboard provided additional clarity by enabling South Fellowship Church to see all of its revenue streams at a granular level in one place: donations, coffee shop sales, and preschool tuition.
“Before we used the revenue streams dashboard, we would send Larry a basic report with the income that came in for the month,” says Adrienne. “Now we send him an easy to view, easy to manipulate dashboard; so he can see not only the total income, but how it’s broken down by event, ministry, or donors.”
South Fellowship Church is accountable to several groups of individuals, all of which need different reports:
- Quarterly reports for board members
- Spending reports for ministry leaders
- Annual reports for the congregation
In the past, gathering the data for these reports took a lot of time. Fortunately, smart reporting consolidates everything into a sleek document that’s easily digested without sifting through columns of data.
All of these features enable South Fellowship Church to make data actionable rather than relying on guesswork and scattered spreadsheets. “QuickBooks Online Advanced takes accounting to the next level because it tells stories that users naturally want and need to see,” says Adrienne.