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.
"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.
7 Weeks of FTE Saved Annually
$53,820 in FTE Hours Saved Over 3 Years
240% ROI Realized Over 3 Years