CASE STUDY

Reporting and consolidation of 10 companies in the Automotive segment of Boryszew Group

Ten manufacturing companies in eight countries, different currencies and time zones. Plus one person at head office responsible for consolidation. The Automotive segment of Boryszew Group replaced reporting and consolidation in Excel files with FlexiEPM. Today, the companies report in the system themselves, check their data and reconcile intercompany transactions. Head office can focus on analyzing results.
Reporting and consolidation of 10 companies in the Automotive segment of Boryszew Group

Data ready for analysis

The companies enter their data themselves, so head office analyzes results instead of copying files.

Error checks at source

The validation report and checks in the forms show inconsistencies before the data reaches head office

Monthly intercompany reconciliation

The companies compare their balances in intercompany reports and explain differences before consolidation.

Management reports in one place

The companies report sales, volumes, headcount, CAPEX and free cash flow in the same system as their financial data.

Project overview

Boryszew Group is one of the largest private industrial groups in Poland and is listed on the Warsaw Stock Exchange. Companies in its Automotive segment manufacture, among other things, air-conditioning and brake lines and plastic components for car manufacturers.

  • 10 manufacturing companies in 8 countries: Poland, the Czech Republic, Spain, Italy, China, India, Brazil and Mexico
  • 11 currencies in the system and 30–40 users, mainly in the manufacturing companies
  • Financial consolidation with translation of local currencies into PLN
  • Monthly intercompany reconciliation
  • Management reporting: sales, volumes, headcount, CAPEX, free cash flow and a summary report for management
  • Implementation in two stages: first reporting and consolidation, then management reporting (about 3 months)
  • The companies have been reporting in FlexiEPM since February 2026

"We shifted the workload from copying data to analyzing it"

Iwona Czech
Iwona Czech
Head of Controlling, Automotive segment of Boryszew Group
We shifted the workload from copying data to analyzing it. Previously, head office collected Excel files from all the companies, copied the data and prepared the consolidation manually. Today, the companies report in FlexiEPM, and even before they submit a report, they can see in the validation report what needs to be corrected. They reconcile intercompany balances among themselves. We receive ready-to-use data, start the consolidation process and only have to explain any differences. With this many companies, going back to manual reporting and consolidation in Excel is out of the question.

Challenge

Reporting and consolidation based on Excel files

Before the implementation, the organization had no dedicated reporting and consolidation tool. The manufacturing companies prepared reports in Excel, and head office copied the data manually into a consolidation file. The files existed in many versions, so every change meant further corrections and a risk of error. Collecting, reconciling and consolidating the data took several days.

All companies used the same report template. Sometimes, however, a company added a column or a row, or changed a formula. Head office had to catch such changes before the data went into consolidation. In addition, companies from eight countries reported in local currencies and worked in different time zones.

At our head office, consolidation is handled by one person. At this scale, the risk of making a mistake in Excel was too high for her. That is why we were so keen to have this tool.

Intercompany transactions without monthly reconciliation

Intercompany transactions were the most difficult area. In practice, the companies did not confirm them every month. They had no shared place where they could compare balances and explain differences. Unreconciled balances made consolidation harder and reduced confidence in the consolidated data.

Solution

System selection and a two-stage implementation

Cost and functionality played a major role in choosing the system. The organization prepared a list of requirements, based in part on Iwona Czech’s previous experience with another system of this class. FlexiEPM met every requirement on the list.

The project had two stages. The first covered company reporting and consolidation. Since February 2026, the companies have reported their income statement and balance sheet in the system. The second stage took about 3 months and extended the reporting package with management reporting.

On the client side, the project was led by Iwona Czech and one other person, with the support of the CFO. The Boryszew team met the FlexiSolutions team every week. Together, they reviewed progress and resolved questions as they arose. Preparing the manufacturing companies to report in the new system took the most work. According to Iwona Czech, the implementation was exemplary: no conflicts, no going back to earlier arrangements and no significant corrections after go-live.

The project's success came above all from the fact that the client knew what it wanted and set out its expectations clearly. Both sides kept to the schedule, and the project teams stayed in constant contact. As a result, there were no hold-ups or misunderstandings, and we did not have to guess anything and then correct it later.

A fixed report layout and data checks in the companies

Each manufacturing company generates a trial balance from its accounting system. It then enters it into FlexiEPM in an agreed format. The templates have a fixed layout, so no one can add a column or change a formula. As a result, head office can be sure that all companies prepare their data using the same template.

Before submitting or saving a report, the company checks its data in the validation report. It corrects inconsistencies straight away rather than after questions from head office. The validation report cross-checks data from different reports. Among other things, it compares:

  • sales by customer with sales in the income statement,
  • profit in the income statement with profit in the balance sheet,
  • costs from the headcount form with costs in the income statement.

The forms also have basic built-in checks. Users immediately see discrepancies or the value the data should match.

Intercompany reconciliation and consolidation at head office

Each party to a transaction enters its intercompany balances into the system. Intercompany reports in the system show discrepancies. The companies contact each other and explain them before the data goes into consolidation.

Head office receives ready-to-use data, starts the consolidation process with translation of local currencies into PLN and explains any differences that arise. Different time zones are no longer an obstacle. The companies enter data during their own working hours, and head office reviews it once it is ready.

Management reporting in the same system

In the second stage, forms and reports on sales, volumes, headcount, CAPEX and free cash flow were added to the package. Management receives a One page report that brings together key figures and ratios in one place.

The companies also use the Bridge form. In it, they explain variances between scenarios, for example between budget and actuals. It is one of the forms that help head office understand the data received from the companies.

Business impact

More reliable data and more time for analysis

The most important change concerns the division of work. The manufacturing companies are now responsible for preparing the data, so head office no longer copies files. It starts the consolidation process, explains any differences that arise and can focus on analyzing results.

Management receives key figures and ratios in a single report. The companies explain variances from the budget in the system.

Data consistency and accuracy have also improved. The validation report shows errors while the data is still in the companies, and the companies reconcile intercompany balances every month before the data goes into consolidation.

Data consistency and accuracy have clearly improved. The errors that used to arise when copying data between files are simply gone.

The risk of consolidation depending on one person has also decreased. The fixed template layout and the checks in the system limit mistakes that previously had to be caught manually.

No gaps or significant errors appeared after go-live. The organization defined all its needs at the implementation stage, and since February 2026 it has reported and consolidated data in FlexiEPM. Once head office receives a complete set of data from the companies, consolidation takes about 1–2 days.

Project in numbers

10

manufacturing companies in one system

11

currencies handled in the system

8

countries in Europe, Asia and the Americas

30–40

users in the companies and at head office

#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