Business driven Planning and BI tools

Why Oivalo Planning

Tailored Planning

Driver based Planning - Create plans based on your own KPIs and business logic
Combine business targets and P&L forecasts directly within same driver based planning models

Rapid setup

Implementation project should take days not weeks and with Oivalo Planning it is more a business than an IT project.

Simple follow up and control

Follow and steer planning process, approve plans, summarize multiple units or review planned data on your own reporting structure.
Compare plans to actuals, other planning period, last year - in realtime.

Oivalo Planning is for you IF

The current budgeting process is heavy

You have a budgeting model currently in Excel but it is not flexible to handle different budgeting versions, update actuals, compare forecasts, and consolidate numbers from multiple files.

You want to easily create and handle multiple forecast rounds and versions or have "running forecasting" process.

You want to easily move from full year's budget to ACT+BUD forecast and have it as an alternative version.

You want to use multiple currencies and translate your planning model to different languages

You have a lot of users participating and don't want to spend time with multiple spreadsheets

You want to improve your business planning and analytics

Collect and consolidate drivers and planning details from multiple units quickly and easily.

Use complex planning drivers

Create Profit and Loss budgeting and more detailed operative planning – Oivalo Planning will combine sales drivers with Profit and Loss in one model.

Have budgeting and forecasting numbers as references besides actuals in your reporting system.

Do day level planning

See consolidated results in realtime

You want to get it done quickly and adjust everything by yourself

You are looking for an enterprise-level tool for planning which has the flexibility you need in your budgeting process.

You don't want to spend high starting hours with consultants or several months to just to try out a planning tool.

In the most optimal case you already have the reference data ready in SQL, DW or in reporting system and some idea how the planning model should be

You want to take control as much as possible instead of constant outsourced consulting need

Select a customer and read how they are using the Oivalo Planning

Case SYNLAB

SYNLAB is Finland's largest private producer for laboratory examinations and imaging services. SYNLAB takes care of the well-being of Finns by offering advanced, innovative and effective services for regular health monitoring and disease prevention. It produces services for the public and private sector, private healthcare providers, insurance companies, health insurance funds and private customers. The head office and main laboratory are located in Helsinki. SYNLAB uses around 160 cost centers in budgeting.

SYNLAB started using OIVALO's budgeting system during spring 2021. The main reason for the change was to modernize the budget process, that was previously based on a large number of different Excel files. The Excel-based budgeting was considered vulnerable and the management took a lot of time, especially from the responsible persons of group's finance.

Due the differences in Excel sheets, summing up the numbers at the group level was almost entirely done manually. It went so far, that the numbers for the budget had to be recorded to Excel at a higher level, to reduce the time spent on manual combining work.

"Transitioning to OIVALO was so easy that even the most devoted Excel user didn’t resist the change."

The project to transfer to SYNLAB budgeting process into Oivalo platform was very fast. The initial planning was done in a two-hours meeting, and after about a week, everyone in SYNLAB Finland had the opportunity to record their budgeting figures by using OIVALO's cloud-based budgeting system.

There was hardly any resistance to change. Quite the contrary, the new service was especially liked by the most skilled Excel users. In addition, the end users were relieved by the fact that in the new model they could modify the Excel the most suitable time for them -without need to wait while other users had the excels locked for their modifications.

“Budgeting process management is about hundred times easier than before"

At the finance department, the implementation of OIVALO allowed more time to be used for the most important financial and reporting work. There is now a possibility to use much more time to build relevant Power BI reports, and the controllers focus their time on analyzing the numbers. Managing the process is "100 times easier" and enables the budgeting to be a lot faster and forecasting a lot effortless compared when working with Excels.

In SYNLAB, OIVALO's budgeting platform is tightly integrated with Power BI. During the beginning of budgeting and forecasting period, the actuals from previous year are brought from Power BI to OIVALO. And other way around, budgets by cost centers are shown in Power BI next to actuals. As all the numbers are originated from cloud base platform, it’s possible to include both budgeted and actual figures into all reports at the level of different cost centers as well as whole group.

Benefits of OIVALO identified by SYNLAB
  • More time spent on financial analyses than Excel validation
  • Reducing human errors during budgeting
  • Speeding up the budgeting process
  • Comparison of actuals to budgeted without added manual work

Case NoHo Partners Plc

NoHo Partners Plc is a Finnish restaurant group behind more than 250 restaurants, bars, pubs, nightclubs and entertainment centres in Finland, Norway, Denmark and Switzerland.

Oivalo Planning allows NoHo to take control of nearly 300 cost centers requiring Profit&Loss budgeting and forecasting in four currencies. Previous model was Excel based and was time consuming to fill, version handling and consolidation was practically impossible.

Key success factors for NoHo with Oivalo Planning
  • Group consolidation of planned numbers with easy steer and control of the process
  • Capability to handle great amount of users from single restaurant manager to a group and division level executives
  • Delivery of reference numbers to the end user in an environment which requires strict data access restrictions (PLC)
  • Easy data integration from and to internal masterdata (like Cost center structure, actuals) and BI system
  • Running forecast enabler with versioning
  • Handle planning in different currencies
  • Combined with Oivalo Account Manager – a SaaS software for PL report control – it is possible for the users to see the planned values with reference actuals on familiar P&L report models

Case HopLop

HopLop is children’s indoor exercise and adventure park chain in Finland and Germany with 17 parks in total.

HopLop needed a planning tool for daily sales and Profit and Loss budgeting. The requirement was to combine planning from daily sales to monthly revenue with same input numbers - one input to one sales and to one revenue. One driver, usually the amount of children, gives the best understanding about business, rather than separate sales and revenue budget.

Key success factors for HopLop are:
  • Easy versioning of budgets and forecasts
  • Complex, but understandable drivers.
    • Amount of children per day * Ticket price * Days when park is open = Entrance sales.
    • Amount of employees * Average salary = Salary expenses
    • etc...
  • Aligned with sales and bookkeeping data
  • Data integration back to internal BI system (Qlik) with Oivalo PL extension

Case Nevel Oy

Nevel operates more than 130 energy production sites and manages over 40 district heating networks in Finland, Sweden and Estonia

The company was recently separated from Vapo Group and carveout of systems and processes had to be done. To take control of financial planning, Nevel chose Oivalo at the end of Q3 2021 due to proven concept of fast deployment and advanced features required to align with Nevel’s business model and planning logic. The project was finalized in time and 2022 budgeting was completed for over 200 cost centers with Oivalo Planning just in few weeks after the project kick-off.

Key success factors for Nevel with Oivalo Planning

Nevel controller summarizes that: “Driver based modeling was our key requirement to enable planning on site level. Megawatt hours, fuel amounts and other input are converted to full profit and loss plan for each site in Oivalo. Support for multiple currencies and possibility to quickly create new forecasts based on previous planning values and current actuals was also very important and we have found that it is easily done in Oivalo.”

Case Mehiläinen Oy

Mehiläinen Group is a well-known and highly valued private provider of social and healthcare services, offering comprehensive high-quality services in Finland and internationally providing service at 820 locations

Mehiläinen is not a typical customer for Oivalo. They have succesfully utilized Oivalo's Table Manager to control data conversions within company acquisitions requiring data integrations. History and current data must be transfered to Mehiläinen's system when another company is merged. Table Manager software has provided an easy interface in limited manner for each expertiese area to modify their own data.

Our Customers

for Planning

for Oivalo Datamanager and other

Planning Main features

Multi costcenter collect data from all costcenters/departments/units etc from many users. Supports easily thousands of cost centers

Multi currency and multi language - Support for organizations having companies in different countries. UI is in Finnish and English and can be translated if needed

Multi round - Manage multiple planning rounds or versions

Flexible planning model Combine sales drivers and P&L into same model, do it easyway or advanced way. Oivalo Planning supports various driver based planning schemes and P&L structures.

Versions Use previous forecast or actuals as base data for new planning round. Create forecast with actual and existing budget, like 3 months actuals, 9 months forecast

Reference values Use history actual or other planning round values as reference numbers.

User hierarchy for approval flow, versatile commenting. Manage user access rights and hierarchies to show data with correct user easily. No risk for Excel leaking company actuals.

Microsoft Azure AD (Office 365) SSO support Existing users from Azure can be used with Single Sign on.

Easy data integration Outcome of Oivalo Planning is easily integrated into any BI tool (Qlik, Power BI, etc) or DW that reads data from REST API.

SaaS Oivalo Planning is SaaS and mainly requires business competence to setup. Not an traditional IT project at all.


It is simply fast End user actions are instant - and realtime

Oivalo Planning

Several planning input methods:

Absolute valueP&L accounts, amount of customers, business days
Driver basedMultiply amount of customers with avarage spend, Plan salaries using hours and hourly salary, Use reference value like number of weekend days in a month multiplied with another value
Percentage planning modelsPersonel side costs with pre defined percentage, product category sales margin as a percent from planned sales, set a cost based on sales etc
Summary and info rows can be used in the planning model to give user information how for example Gross Margin % will set, how many weekend days are in planning round.
Monthly or annual inputPlan on annual level and distribute values to monhts using pre-defined multipliers, previous year actuals, previous input or evenly. Or change individual month manually.
One account - multiple costcenters inputSet numbers to one account over multiple costcenters at once.
Graphical inputSee numbers in graphs and edit values from graph with reference line.
Dimensional planningSplit one account into several named or unnamed entries like persons, customers etc
All values are updated realtime and user will see end result all the time! Simple reporting consolidates.

Easy and fast to setup. No X00k€ project or constant need for outsourcing of consulting work.

Simple integration for the planned data wit BI tools through Rest API. Very easy to integrate with Qlik On-premises, Qlik Cloud, Power BI and other

SaaS - no other IT costs

For controller and admin use: Export planned values to CSV/excel for further analysis, read planned data easily to existing BI system. Import planning values, copy planning round data to another round, update actuals, use actuals or other planning round for reference numbers, monitor planning progress. Manage defaults, translations, users, access rights...

No extensive training required!

Oivalo Data Manager

Spreadsheet replacements

Effortless Master Data Management in the Cloud with Seamless BI Integration

Generic master data platform to replace spreadsheets which are not always so easy to use with reporting. Up-to-date data from source system's dimension are available in the Data Manager for the user to set the required new meta data. For example adding new organization level on top of costcenters will not just give users controlled manner to update required information but also shows the new items from source system needing the organization definitions. When just using the spreadsheets this process requires first analysis of missing costcenters, adding them to the spreadsheet and updating the spreadsheet for BI system

Standardized approach to managing Profit & Loss and Balance Sheet visualizations, with a straightforward "no consultant" model for reporting modifications. Ideal for reporting financial data across multiple account combinations to various stakeholders, our solution simplifies the process without the need for summary accounts or complex data models.

Detailed Insights: Enable row-level drilldowns fron summary rows without relying on Data Warehouse (DW) calculations.

Qlik Sense: Visualize data and export to Excel or clipboard with ease.


Easy Integration: Read metadata from to BI so that no datawarehouse or other temporary storage is not needed.

Data Manager Components


Table Manager

Replace spreadsheets on network drive with cloud based solution where latest data is waiting for classification.

Keep master data in order all the time

Integration with ease for BI or DW system

Always structured data input, no typos or other user related errors, user access rights, Azure Single Sign On

Account Manager

Control account mappings and Profit and Loss or Balance Sheet formulas between accounting systems and different hierarchies.

Access and provide data through API

Can be used with Oivalo Planning to show planned figures with reporting structures used elsewhere

Tested with Qlik and Power BI

Qlik Sense P&L Extension

For Qlik Visual P&L lookalike reporting in Qlik Sense optimizing Qlik features.

Other services



Oivalo Oy is a Qlik Partner.
Qlik Extensions - SimpleFieldSelect An open source extension for all your selection needs using the Qlik Sense SimpleFieldSelect. Download it from Qlik branch or GitHub

In case of need for experienced CFO, Business Controller...

Weather Data Hub

Use actual and forecasted weather data from observation stations. Then, seamlessly link weather data to your business in a BI tool.

Team

Minna Jokisalo

Partner

Mikko Laine

Partner

Teppo Ojala

Sales

Matti Punkeri

Partner