The role of Finance is changing. In an ever more disrupted world, the traditional ‘Board Financials’ pack has become a redundant report. Your board reports can be too high-level to provide genuinely useful intel about performance, spend anomalies, and other fiscal deviations, and can be tied to budget data that is often out of date the day it was set.
The problem with budget data
As is commonly observed, budget data is already out of date from the first day of the plan.
It’s an inescapable fact that without dynamic budgeting and forecasting processes, you can’t provide actionable insights from data. If you don’t have a good data infrastructure that incorporates planning processes, how insightful is having just a good visualisation layer?
So, how can a dashboard provide actionable insights that allow the organisation to understand not just what has happened, but why? And then offer crucial guidance as to what actions you can take. (Typically provided in the form of variance analysis).
You need to consider if a variance to plan is a permanent and valid difference — or just a timing difference.
To assist with this consideration, your dashboard should not only hold monthly results, but also include:
- Year to date
- Full-year forecast
- ‘Accumulated variance to date’
These three drivers provide a great way of focusing on whether you need to act. And they’ll also enable you to understand if a monthly performance will cause an impact from the whole year perspective.
Driver-based analytic use case example
This example shows how to deliver actionable insights by linking driver and finance data.
Case: A Profit & Loss report for February for an Aged Care service provider shows a significant variance in salary costs for one of their care services facilities.
Why is this?
To uncover the answer, we first need access to the business drivers in the facility’s time recording system and financial data from the finance system.
These are:
- The typical working shift and penalty rate patterns at this facility
- The number of hours expected to be delivered for care
- The actual hours and financial salary cost to deliver services
With this information added to the mix, you can now see the impact of each variable on the overall financial outcome. You can report on the time expended from the timesheet system, the average cost from the finance General Ledger, and the mix of shift types (timesheet data) for both actual and budgeted values.
Each added driver breaks down and highlights the actual underlying reasons for the P&L salary variance that we see in a typical report.
How do you start delivering more valuable Board Financials?
This level of actionable insight may seem unavailable to you through your current approach to board reports.
But the good news is that the best modern cloud planning applications, such as Workday Adaptive Planning with its dynamic budgeting capabilities, have made a huge difference by enabling SMB companies to benefit from tools that used to be available only to the biggest companies.
LET'S TALK
Great outcomes start with great conversations
Request a consultation today and let our local experts help you to digitise, optimise and automate your way to success.