CONSOLIDATION AND REPORTING
Lucanet creates a common foundation for consolidated financial information from different companies and structures. We prepare the relevant data for Power BI and develop tailored financial analyses that incorporate additional approved company data as needed.
DIFFERENT FINANCIAL STRUCTURES
Subsidiaries often use different ERP and financial accounting systems. Chart of accounts, general ledger accounts, account descriptions, and local financial structures may also differ from one another. As a result, comparable business transactions are not automatically recorded and reported in the same format.
To obtain a consolidated view of the group, it is therefore not enough to simply aggregate the financial data of the individual companies. First, different accounts and financial items must be classified according to their business functions.
ERP system
Local Chart of Accounts
Financial System
Custom Account Structure
Financial Accounting
Local Names
Comparability can only be achieved through a common technical classification.
CONSOLIDATION AT LUCANET
If local accounts and financial positions are assigned to a common corporate structure, the financial information for the individual companies can be viewed in a consolidated manner in Lucanet. This provides a comprehensive view of the corporate group without losing sight of the underlying corporate structures.
In this context, consolidation does not simply mean adding up the companies' values. Depending on the existing Lucanet structure and the business requirements, relationships relevant to consolidation are taken into account.
A · Individual Financial Statements
B · Individual Financial Statements
C · Individual Financial Statements
Common Group Structure
Consolidation Logic
Reconciliated Financial Information
Consolidated Income Statement
Consolidated Balance Sheet
Statement of Cash Flows
The common corporate structure enables comparability. Consolidation brings the financial information together to provide a harmonized view of the group.
ADVANCED FINANCIAL ANALYSIS
The consolidated financial foundation provides a unified view of companies, periods, and key financial metrics. With Power BI, this information can be prepared for in-depth analysis and presented in interactive reports tailored to specific audiences.
Depending on the available data, you can analyze trends over multiple periods, compare companies with one another, and contrast planned, actual, or prior-year figures. Which perspectives are most useful depends on the available Lucanet data and the business requirements.
Schematic illustration using arbitrarily chosen demo data.
Power BI does not replace consolidation in Lucanet. It expands the consolidated financial foundation with customized analysis and reporting perspectives.
REPORTING WITH POWER BI
Based on a suitable and technically coordinated data foundation, consolidated Lucanet data can be prepared for various financial and controlling purposes. Which analyses are appropriate depends on the data provided, the existing reporting structures, and the specific requirements.
Income statement line items can be analyzed across selected time periods, companies, and group perspectives and can be prepared, for example, for regular monthly reporting or a consolidated P&L dashboard.
Revenue
Total Output
Expense Items
EBITDA or EBIT
Annual Results
Deviations
Trends by Period and Company
Selected balance sheet items can be viewed by period, company, and available reporting structure. This makes changes in the asset and financial structure visible and allows them to be categorized in both consolidated and company-level views.
Fixed Assets
Current Assets
Equity
Liabilities
Total Assets
Structural Ratios
Trends by Period and Company
Once the necessary data and reporting structures are in place, items from the cash flow statement and selected cash flow perspectives can be visualized in Power BI. This provides insight into trends in cash flows and liquidity across periods and companies.
Operating Cash Flow
Investment Activities
Financing Activities
Cash and Cash Equivalents
Liquidity Ratios
Trends Over Time
If appropriate planning and forecast data are available, planned, actual, and forecast values can be viewed together. Depending on the data set, this may also include rolling forecasts, budget-forecast comparisons, various forecast statuses, and perspectives from P&L planning.
Target value
Actual value
Forecast
Rolling Forecast
Budget vs. Forecast
Achievement of Targets
Consolidated financial information can be supplemented with selected company-specific perspectives. Based on common financial accounts and reconciled key metrics, it becomes clear how individual companies are performing and what contribution they make to selected Group figures.
Earnings by Company
Revenue by Company
Expenses by Company
Contribution to Group Value
Company Comparison
Trends Over Time
Common definitions provide consistent perspectives for Group Controlling, Finance, FP&A, and management.
FINANCIAL AND CORPORATE DATA
Consolidated financial information shows how key financial metrics are trending at the Group and company levels. For further analysis, these figures can be linked to selected operational data from other enterprise systems.
This allows financial trends to be analyzed in conjunction with relevant business and performance drivers. The data included depends on the specific question, the existing system landscape, and the information that has been made available.
Not every available data source needs to be included. What matters is which information usefully complements a specific financial or controlling question.
EXAMPLE VIEW WITH SAMPLE DATA
The following sample view combines consolidated financial metrics, trends over time, selected income statement items, and corporate perspectives in a single Power BI report. This allows key group figures and existing benchmarks to be viewed on a consistent basis.
The values shown are sample data chosen at random. The report structure, key metrics, comparison periods, and level of detail are tailored to the available data and business requirements for each project.
JOINT APPROACH
Together, we determine what financial information is needed, how it can be provided, and what analyses should be generated. Building on this, we gradually develop a reporting framework that aligns with the existing data, technical definitions, and intended recipient groups.
To begin with, we’ll review the existing Lucanet environment, current reports, and the relevant financial and corporate structures. Together, we’ll determine which issues are key and which target audiences should be considered.
Next, we review which Lucanet data can be made available for reporting and how financial positions, companies, periods, and comparative figures are structured. The appropriate method of data provision depends on the Lucanet environment, the scope of the data, and the update requirements.
Based on the analysis, we develop a transparent data model for Power BI. Financial positions, key figures, companies, time-based entries, and comparative figures are structured so that they can be used consistently across the intended report views.
Building on this, we develop customized Power BI reports and review key metrics, filters, comparison periods, and report views in collaboration with the relevant business units. Feedback is incorporated into the further development in a transparent manner.
FREQUENTLY ASKED QUESTIONS
Which Lucanet data can be made available to Power BI and how the reporting solution is structured depend on the existing environment, the business requirements, and the planned analyses. Here, we answer key questions about data provision, analysis, and expansion.
Depending on the available data, consolidated information from the income statement, balance sheet, and cash flow statement—as well as corporate structures, periods, financial positions, budget figures, and forecast data—can be prepared for Power BI. The specific Lucanet environment is used to determine which content, key metrics, and levels of detail are available and appropriate for the intended analyses. Based on this, solutions such as regular monthly reporting, P&L views, or customized KPI reporting can be developed.
The appropriate deployment method depends on the existing Lucanet environment, the required data, and the planned analyses. Depending on the initial situation, for example, a BI database, a data model prepared for analytical purposes, or an existing reporting platform can be used. The required financial positions, companies, time-based entries, and key metrics are then structured in Power BI for analysis.
Not necessarily. Depending on the Lucanet environment, a BI database can be a suitable way to provide financial data for Power BI. Alternatively, you could use, for example, a data model prepared for analytical purposes or an existing reporting platform. The most suitable approach depends on the data required, other data sources, and the technical requirements.
Yes, provided that appropriate and technically comparable planned, actual, budgeted, and forecast data are made available. In Power BI, this data can be used, for example, to create budget-forecast comparisons, rolling forecast views, comparisons of different forecast statuses, and absolute and percentage variances. Before implementation, planning statuses, definitions, time frames, and required levels of detail are coordinated with the business team.
Yes. If necessary, consolidated financial data can be linked to selected and approved information from other enterprise systems. This may include, for example, order, sales, project, product, or volume data. This requires suitable linking attributes as well as standardized terminology, time references, and organizational structures. This additional information enhances the analysis in Power BI but does not automatically become part of the consolidation process in Lucanet.
No. The consolidation and financial logic remains in Lucanet. Power BI uses the data provided for this purpose to supplement the existing reporting environment with interactive and customized analyses. This may include, for example, group-wide views, company comparisons, trends over time, and combined analyses of financial and business data. Which reports and tools continue to be used depends on their respective purposes.
Yes. With a role- and permission-based model, Power BI reports can be configured so that users see only the data intended for their company or area of responsibility. Row-level security, for example, can be used for this purpose. The specific implementation depends on the required organizational views, user groups, and permission requirements.
YOUR LUCANET REPORTING
Whether it's consolidated financial information, different corporate perspectives, or supplementary data from other business systems: Together, we'll determine what information you need for your analyses.
