Oivalo

Business driven Planning and BI tools for success

Services

Oivalo Planning

A SaaS planning software for forecasting and budgeting.

Oivalo Finance Bundle

Modern way to present, analyze and control Finance reporting - no more SQL hasling of summary accounts!

CFO services

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

Weather Data Hub

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

Qlik Partner

Oivalo Oy is an Official 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

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 just spend time with multiple Excels

You want to improve your business planning and analytics

You want to collect and consolidate drivers and planning details from multiple units quickly and easily.

You want to use complex planning drivers

You need to create Profit and Loss budgeting and more detailed operative planning – Oivalo Planning will combine sales drivers to EBITDA in one model.

You want to have budgeting and forecasting numbers as references besides actuals in your reporting system.

You want to get started quickly

You are looking for an enterprise-level tool for planning which has the flexibility you need in your budgeting process without high starting costs on the project and software investment.

You don't want to spend 100k or several months to just try out a budgeting tool

Why Oivalo planning

Effective business planning and leadership

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.

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 approximately 250 restaurants, bars, pubs, nightclubs and entertainment centres.

Oivalo Planning allows NoHo to take control of nearly 300 cost centers requiring Profit&Loss budgeting and forecasting in three 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 from Norway and Denmark too
  • 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

Our Clients

Planning Main features

Multi costcenter - collect data from all costcenters from many users. Supports easily hundreds of cost centers

Multi currency and multi language are supported natively

Multi round - Manage easily planning rounds and versions without technical support

Fast rolling forecasting process - use previous forecast or actuals as base data for new planning round. Create planning model with for example 3 months actuals, 9 months forecast

Flexible planning model Simple or more advanced planning model, you choose! Combine sales drivers and P&L into same model. Oivalo Planning supports various driver based planning schemes and P&L structures. It is always customer specific planning model.

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) integration 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) that reads data from REST API.

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

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 edited values are updated realtime and user will see end result all the time!

Easy and fast to setup. No X00k€ project and no high annual maintenance costs.

Simple integration for the planned data wit BI tools (Rest API) - Qlik and Power BI tested.

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 (Prodcution environments done with Qlik and Microsoft Power BI, works with other too). Import planning values, Copy planning round with values, update actuals, use actuals or other planning round for reference numbers, monitor planning progress...

Oivalo Finance Bundle for Reporting

Standardized way to handle P&L and BS reporting with easy "no consultant" reporting model modification

Best when you have to report Profit and Loss, Balance sheet and other Financial numbers in several different ways to many different stake holders.

Simple to setup when access to row level accounting (or other) data exists for the Qlik or Power BI setup

Allows fast modification, duplication of required reporting structure

No summary accounts or any other fancy data models behind nor DW calculations - allows row level drilldown.

Visualization and export to excel and clipboard with numbers (Qlik Sense only)

Oivalo Finance Bundle - components

Use all together or separately with your current system

Account manager

Control account mappings and P&L formulas between accounting systems and different hierarchies.

Tested with Qlik and Power BI

Access data through API

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

Qlik Sense P&L Extension

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

Ready Qlik data models

YTD, MTD, LTM, LY, etc models

Team

Minna Jokisalo

Partner

Mikko Laine

Partner

Teppo Ojala

Sales

Matti Punkeri

Partner