Success Story with a Major Energy Company

[seonajmulislam00]

The development in levels (Data Capture, Parameter Modification and Loading of Settings and Reclassification) provides a solid base to manage all the stages of the process and the integration of different sources and types of data, and they are also easily manageable, being able to add N applications in each stage of the process.

All information is stored in proprietary QlikView files, which guarantees efficient processing and management of information and offers a high degree of accessibility and speed, regardless of where the end user is located.

The final result of the process provides QlikView analytical egypt number data applications, with the highest level of detail possible, including the detail of the process level in which the accounting entries were generated. In addition, it provides control panels and accounting reports that can be customized by the user, to comply with current regulations.

When starting its relationship with QlikView, this important Argentine energy company faced three clear challenges:
• Integrating accounting information from different data sources.
• Generating accounting entries corresponding to the financial consolidation of a group.
• Creating a model that could be adapted to changes in accounting standards (GAAP, IFRS).

DATA CAPTURE
An application was created for each data source, with visualization in the individual financial statements and control of the captured information.
For Excel spreadsheets, two folders were managed with independent security in order to be able to work with preliminary spreadsheets until having the final ones.
Pampa Energy 1

Benefits
– Flexibility to incorporate N data sources.
– Independence in the loading schedule of each data source.
– Pre-configuration of the captured data prior to the consolidation process.
– Possibility of executing the loading processes on demand by the accounting user.

MODIFICATION OF PARAMETERS
A QlikView application was created to centralize and manage a single chart of accounts for the consolidation process. The user can create consolidation accounts and map the operational accounts of each ERP to consolidation accounts of the process.
Accounting users can define a company code purchase/sale and QlikView will automatically generate the corresponding consolidation entries throughout the current fiscal year.
Another QlikView application allows you to define the relationships between companies and their consolidation methods, or particular conditions to take into account during the process.
Pampa Energy 2 and 3

Benefits
– The chart of accounts is completely managed by the end user.
– No development is required to add new companies to the group, or to modify existing corporate relationships.
– The consolidation process uses user-defined logic to generate the corresponding accounting entries

LOADING ADJUSTMENTS AND RECLASSIFICATIONS
For each type of adjustment or reclassification, a QlikView application was generated to load the corresponding entry, with all the necessary controls and log data required for auditing.
In a QlikView application, a linear adjustment input form was created that QlikView must automatically perform every period, until the addition amount is fully depreciated.
Using an Excel spreadsheet for parameterizing reclassifications of the expense annex, QlikView automatically generates a reclassification accounting entry.