Search
Close this search box.

Case Studies

Multi-Department Finance Dashboard in InsightOut Delivers 240% ROI for Wolf & Company

Darton S. Rose

ABOUT THE AUTHOR

Darton S. Rose

Principal

Read Bio

Share

LinkedIn
Facebook
Threads
X
Reddit
Email

Wolf & Company is a national accounting and advisory firm, serving clients for over 100 years. Guided by professionalism, dedication, and respect, the firm provides tailored services and industry-specific expertise to support clients’ long-term goals.

Like many organizations, Wolf & Company continuously seeks to bridge communication between different departments to unify data and reporting. However, many obstacles can stand in the way of that vision: different tech stacks, diverse user groups and user needs, and disconnected data sources, to name a few. The firm encountered these same challenges when tracking budget-to-actual financial transactions.

But unlike most organizations, Wolf & Company benefits from two powerful in-house resources: Data Solutions and InsightOut. Data Solutions is Wolf’s team of data scientists who untangle messy data, connect systems, and build a plan for better reporting. This professional service is complemented by a software solution, InsightOut. With the InsightOut platform, companies can rely on a single source of truth for their data, enabling users to easily visualize and analyze key data insights.

Wolf & Company sought to leverage the Data Solutions team and the InsightOut platform to create a multi-purpose financial dashboard, serving three distinct user groups across the organization: Finance, Marketing, and Talent Development.

Quote Icon

"Partnering with InsightOut to build an automated dashboard for tracking our Learning & Development expenses has been a game-changer for our Talent Development team. We’ve moved away from messy, error-prone Excel spreadsheets and now have real-time visibility into budgeted versus actual costs. This platform has empowered us to make faster, data-driven decisions, stay aligned with our financial goals, and focus more on strategic initiatives. InsightOut’s solution has brought clarity, efficiency, and confidence to our budgeting process."


Anna G. Thompson

Senior Manager, Talent Development, Wolf & Company, P.C

Challenge

To understand the needs of each department, Data Solutions held three comprehensive discovery sessions. The goal was to understand the current state workflows of all potential user groups and work together to design a future state solution that would benefit each department.

Critically, all three departments lacked real-time access to financial data, and the method for tracking variances against budgets and prior periods was largely manual. This could lead to delays in decision-making at both the executive and department level.

Finance Team Challenges
The Finance department faced the most significant burden, so the Data Solutions team started with this user group first. When stakeholders needed financial updates, data would be manually pulled from Business Central, transferred to Excel files to create pivot tables, and finally, reports were distributed via email.

During month-end closing periods, when journal entries changed frequently, this process became even more cumbersome and time-consuming. And because stakeholders couldn’t self-serve this information, any delays could create an operational bottleneck for decisionmakers.

“My team used to spend 10 to 15 hours per month on this process – pulling reports from Business Central for our internal team review and then pulling the budget-to-actual reports for all the budget owners,” said Maureen Magee, Director of Finance. Automating this process was estimated to give Magee’s team back anywhere from 3 to 4.5 weeks per year.

Marketing Team Challenges
Meanwhile, the Marketing department struggled with tracking unbudgeted expenses and campaign spend that wasn’t properly categorized.

“As marketers, we have to be able to demonstrate our impact by measuring the return on investment of our events, campaigns, and overall marketing spend,” said Shauna Archer, Director of Marketing. “For our events function specifically, we need to be able to track budget-to-actuals – including travel and expenses – to get an accurate read on our spend and calculate ROI.”

But a largely manual process was holding the department back. They relied on scattered documentation methods, using various Word documents and notes to track event-related information. They combed through travel & expense spend manually, then tied the spend back to marketing campaigns in Salesforce. The process was time-consuming, and prone to human error. “I estimate that I spend approximately 8 hours each month manually tracking down and organizing travel and expenses associated with our events,” said Elisa Pelchat, Events Marketing Manager.

Talent Development Challenges

Much like marketing, the Talent Development department was managing learning and development (L&D) expenses using a series of disconnected Excel spreadsheets. This manual process was time-consuming, error-prone, and lacked the real-time visibility needed to make informed budgeting decisions. Additionally, as the firm’s L&D initiatives expanded, so did the complexity of tracking budgeted costs versus actual costs.

Solution

With each discovery call, the Data Solutions team gained a clearer picture of each department’s workflows and data sources. “A collaborative approach is the key to a project like this,” said Ron Quidatano, VP of Operations in the Data Solutions practice. “It’s exciting to put a solution in front of people and watch them begin to imagine what could be.”

Together with their stakeholders in finance, marketing, and talent development, Data Solutions designed a new future-state solution: one real-time financial reporting dashboard that meets the needs of three very different user groups.

The project plan followed Wolf Data Solutions’ proven agile methodology, emphasizing continuous collaboration and iterative development. Following discovery, the team conducted weekly meetings that included both visualization reviews and project status updates. Each week featured:

  • One 60-minute session for reviewing and refining data visualizations with stakeholders.
  • Live, interactive user acceptance testing results reviews where users could provide real-time feedback.
  • One 30-minute administrative meeting for project status and planning.

“The approach we take is simple and agile,” Quidatano said. “An agile approach means you’re constantly showing your clients the progress and working to incorporate their feedback. And if the client doesn’t see something real until six months later, that’s not agile,” he cautioned. “We find an agile approach keeps us better aligned with our clients’ needs. Better alignment leads to better efficiency, and ultimately a better ROI on the project.”

“The Wolf Data Solutions team was easy for the Finance department to work with,” confirmed Magee. “We formed a great partnership and met every week to get it done.”

During each weekly meeting, end-users watched the dashboard come to life. “Our goal is for clients to begin interacting with an initial version of the platform within two sessions,” said Quidatano. “After that, we’re in the user acceptance testing phase, and we’re making changes based on their feedback.”

As development progressed, the team discovered additional needs unique to each user group. For the Finance department, the Data Solutions team created the ability to drill down from high-level executive reports, all the way to individual ledger entries. The solution also automated the previously manual process of data extraction from Business Central, and the hourly data refreshes give the platform near real-time accuracy.

Additionally, the automated dashboard centralized and streamlined tracking for L&D expenses. The real-time access to financial data enabled the Talent Development department to monitor their budget with greater accuracy and efficiency. Finally, for the Marketing department, the team created specialized views to identify unbudgeted campaigns, track variances, and log explanations.

InsightOut’s flexibility allowed these customizations to be integrated seamlessly into the platform without disrupting the core functionality needed by all teams. This collaborative approach allowed each user group to request functionalities specific to their needs, with the reassurance that their financial data is accurate and consistent.

Result

This financial dashboard was built to accommodate diverse user needs within a single platform. At the executive level, it provides decisionmakers with a comprehensive 50,000-foot view of the firm’s performance relative to the budget. At the same time, the Finance, Marketing, and Talent Development departments can review more granular details for deeper analysis.

This multi-team approach promoted data accuracy and consistency across each function. All teams now access the same authoritative data source – simply filtered and presented according to their specific operational needs.

“Partnering with InsightOut to build an automated dashboard for tracking our Learning & Development expenses has been a game-changer for our Talent Development team. We’ve moved away from messy, error-prone Excel spreadsheets and now have real-time visibility into budgeted versus actual costs. This platform has empowered us to make faster, data-driven decisions, stay aligned with our financial goals, and focus more on strategic initiatives. InsightOut’s solution has brought clarity, efficiency, and confidence to our budgeting process.”
— Anna G. Thompson, Senior Manager, Talent Development, Wolf & Company, P.C.

Additionally, the automation of manual workflows created a more tangible return on investment. Prior to this solution, the Finance department spent between 10 and 15 hours a month pulling reports, and the Marketing department estimated losing 8 hours every month manually merging travel and expense reports with event campaign reports. Between these two teams alone, InsightOut’s data automation saves Wolf & Company up to 7 weeks of full-time equivalent per year – a 240% return on investment realized over 3 years.

7 Weeks of FTE Saved Annually

$53,820 in FTE Hours Saved Over 3 Years

240% ROI Realized Over 3 Years

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Get the insights that matter.

Stay informed with priority news and key industry updates by filling out the form to subscribe.
Name*
This field is hidden when viewing the form

Connect with a Wolf Expert

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Wolf Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

Newsletter (Insight & Case Study | Wolf Website

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Get the insights that matter.

Stay informed with priority news and key industry updates by filling out the form to subscribe.
Name*
This field is hidden when viewing the form

Data Solutions | LinkedIn Ads Form

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Data Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

Get back to business with accounting support from Wolf & Company.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Outsourced Accounting Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

Data Solutions | Page

Get back to business with accounting support from Wolf & Company.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Fill out the form below and our team will reach out to you soon.
Name*

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Data Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

Connect with a Wolf Expert

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Wolf Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

Fintech Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name(Required)

Fintech Inquiry Form

Fill out the form below and our team will reach out to you soon.

Get back to business with accounting support from Wolf & Company.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Outsourced Accounting Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

DenSecure Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*

We’re here to help.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Fill out the form below and our team will reach out to you soon.
Name*
This field is hidden when viewing the form