CASE STUDY

Automating financial consolidation at WeNet Group

For more than 30 years, WeNet Group has been helping small and medium-sized businesses build their online presence. It was formed by combining two well-known brands, Panorama Firm and PKT, and today it is one of the largest providers of online services for businesses in Poland.

The challenges of consolidating financial statements grew as the Group expanded. Excel was no longer enough: the files were hard to read, format and manage, and the reporting process was time-consuming and lacked transparency. WeNet decided to change this by implementing the FlexiEPM consolidation module.
Automating financial consolidation at WeNet Group

Time cut from 2 weeks to 3 days

The whole process used to take more than a week. Today it all happens in one tool, from the data to the finished report.

Data from Excel straight into Word

With FlexiStatements, data flows automatically into Word templates, in the layout and format auditors expect.

Visibility of adjustments and data sources

The data is complete, compliant with IFRS 16 requirements and ready to use in internal audits and group reporting.

Semi-automated cash flow

A large part of the cash flow statement is calculated automatically, leaving room for the client's individual needs

Project details

  • The project was carried out at the turn of 2024 and 2025 and covered the implementation of the consolidation module and the FlexiStatements tool.

  • The main goal was to simplify the preparation of consolidated financial statements, eliminate errors, structure reporting and automate the combining of data from group entities.

  • Previously, each company worked in a separate Excel file, and consolidation required combining data by hand, which took up to two weeks.

  • With FlexiEPM, the consolidated financial statements are produced as a by-product of preparing the separate financial statements, based on a single data model.

  • WeNet also uses FlexiStatements, which automatically pulls data from Excel and generates reports in Word, cutting the time needed for the final editing of documents.

  • About 5 users from 8 companies are involved in the process. Today the entire process takes about 3 days.

Customer perspective

Ilona Król,
Ilona Król,
WeNet Group
The FlexiEPM consolidation module made a very good impression on us, both in terms of flexibility and speed.
Making adjustments to trial balances, even at the last minute, is no problem at all. Loading a new trial balance and recalculating the data, in the primary statements as well as in the notes and other reports, takes literally a few minutes.
The system handles exchange differences flawlessly. Our Group includes foreign companies reporting in local currencies, and the tool automatically translates both the main data and the additional notes.

Semi-automatic preparation of the cash flow statement is also a big help. Most items are calculated automatically, with the option to adjust them manually when needed.
Entity-level notes are an integral part of the consolidated financial statements. They are built in the background, with no need to copy data.
Finally, the report for the auditor contains detailed data for each line of the financial statements. You can see exactly which amounts come from trial balances and which result from consolidation adjustments.
And the biggest “wow effect” was, of course, Agnieszka. 😊

Challenge

Consolidation in Excel, limited transparency and version control problems

WeNet Group, despite good organisation and an experienced team, prepared its consolidated financial statements entirely in Excel. Each company worked in a separate file, and combining the data was manual and prone to errors. Even reviewing the files became increasingly difficult: formatting was often hard to read, disclosures were less and less transparent, and every adjustment required time-consuming operations.

With more entities and currencies, consolidation in Excel spreadsheets was not only problematic but also hard to hand over, both within the team and to auditors. The key goal was to regain control of the process, automate the calculations and ensure consistency of the final reports.

Solution

Automated consolidation of financial statements in a single FlexiEPM model

WeNet implemented the module for consolidation of financial statements, which makes it possible to prepare separate and consolidated financial statements from a common data model. The system handles group adjustments, exchange differences, cash flow and data reporting in the layout expected by the auditor.

The system also supports foreign companies reporting in local currencies, with smooth currency translation both in the primary statements and in the notes. Adjustments can be made even at the very last stage: you simply load a new trial balance, and the recalculation takes a few minutes.

In addition, WeNet implemented FlexiStatements, which automatically pulls data from the system and places it in a Word template, in the layout the auditor requires. As a result, the data is ready for the final report without manual copying and formatting.

Benefits

Transparency, flexibility and a ready report for the auditor

With FlexiEPM, consolidation at WeNet Group has become a fast, repeatable and easy-to-control process.
The consolidated financial statements are produced as a by-product, in the background while the separate financial statements are prepared.

Adjustments can be made even at the last stage without any concern for data integrity. The tool automatically calculates exchange differences, takes local currencies into account and handles a large part of the cash flow statement. The system shows which amounts come from trial balances and which result from adjustments, which makes analysis and preparing data for the auditor much easier.

The finished data flows into Word templates without manual work, which not only saves time but also eliminates formatting errors and makes the team’s work more comfortable.

Project summary in figures

5

active system users

~3 days

time to prepare the financial statements

8

companies in the Group

66%

less time to prepare the consolidated financial statements

#KNOWLEDGE BASE

Find out more on our blog

Alternative to Oracle Hyperion and SAP BPC
Controlling

FlexiEPM as an alternative to Oracle Hyperion and SAP BPC – a comprehensive EPM system for controlling and consolidation

Many companies running Oracle Hyperion or SAP BPC are wondering what comes next: migration to Oracle Fusion Cloud EPM or another platform? FlexiEPM is a modern EPM system that combines budgeting, reporting and consolidation in one environment, fully integrated with Microsoft Excel and with support close to the user. See what your future after Hyperion could look like.

Read more >
IFRS 16 lease accounting
IFRS 16

IFRS 16 lease accounting

When does IFRS 16 apply? How should a lessee present leases in its financial statements to comply with IFRS 16? How do you measure the right-of-use asset and the lease liability?

Read more >
skonsolidowany bilans / system controllingu HR
Consolidation

How to prepare a consolidated balance sheet?

How do you prepare a consolidated balance sheet for a group of companies? This practical guide walks you through the process step by step: preparing separate balance sheets, local adjustments, capital adjustments and goodwill, and eliminations of intercompany balances.

Read more >

Book a Consultation with an expert

Streamline your planning, controlling, reporting, and consolidation processes in a single system.
Eliminate errors and reduce time-consuming tasks through integration and automation.
Mariusz Sumiński

Mariusz Sumiński

Managing Director, Co-Founder