From Excel to a modern planning and reporting environment
During the COVID-19 pandemic, the urgency for a modern way of planning and reporting became clear. Facility closures had major financial consequences, but calculating the impact using complex Excel sheets required enormous time and effort. It became evident that there was a need for a solution that provided faster and more direct insights into financial and operational scenarios.
The choice fell on Vena Solutions, thanks to its familiar Excel look & feel, flexibility, and ability to guide users step by step in process-driven workflows. cpmview was selected as the implementation partner due to their open attitude, critical perspective, and pragmatic approach.
The challenges
- COVID-19 impact: rapid insight needed into the financial consequences of closures.
- Limited tooling: reporting and budgeting still distributed as static PDFs via email.
- User adoption: employees were used to tailored Excel models and needed guidance through the change.
- Implementation choices: balancing customization with the Vena standard.
The solution
Together with cpmview, Sportfondsen implemented Vena Solutions as a modern platform for planning, reporting, and analysis. Key elements included:
- Online reporting environment: managers now have access to up-to-date information on a daily basis.
- Self-service reporting: facility and regional managers can generate their own reports, drill down into data, and quickly answer questions that previously went through Finance.
- Digital budgeting: budgeting processes are now managed entirely online instead of through separate Excel files and PDFs.
- Pragmatic guidance: cpmview acted as a sparring partner, challenging assumptions and saying “no” when needed to ensure the right choices were made.
The results
The implementation quickly delivered tangible benefits:
- Faster insights into the financial impact of scenarios such as closures or changes in facility use.
- More efficient processes: from manual PDF distribution to a centralized digital environment.
- Increased adoption: managers can independently find answers and are less dependent on Finance.
- Better decision-making: thanks to timely, reliable, and accessible data.
Lessons learned
Looking back, Sportfondsen highlights two important insights:
- Change management: involve end-users earlier and more actively to reduce resistance.
- Stay closer to the standard: less customization leads to faster implementation and lower maintenance costs.