ETL & Consolidation

Global company wants an interface connected to its various systems to manage and process data to produce consolidated financial statements.

Healthy drink manufacturer implanted in a number of countries across Asia and Europe.

    goods in transit intracompany ETL and consolidation

ETL & Consolidation

CHALLENGE

The consolidation of financial statements across branches in various regions and different accounting systems was problematic, especially on inter-company transactions. The task is cumbersome and time consuming.

SOLUTION

iExcel set up an interface that extracts and compile data within one database, assigning unique identifiers, and created the required data processes to produce consolidated and accurate individual statements. iExcel also added analytical tools and dashboards for better visualization.

IMPACT

Accounting teams have been saving considerable amount of time. They are able to produce dynamic reports in a few clicks that other members of the organisation can use and further pivot to get insights on specific areas of concern.