Uralchem OHK JSC (1C: Consolidation)

2013: Building a Budget Management Information System

Project prerequisites

Due to the growth of the number of companies included in the URALCHEM group and the expansion of production, the company's management decided to start a project to create a system for automating the budget process.

Project objectives

As part of the project, the goals were set:

• Reduce the complexity of consolidating budget forms
• Implement a single tool for forming budgets and a plan of actual analysis for the URALCHEM group and for individual companies of the group, for conducting qualitative analysis and subsequent formation of presentation materials for management
• The system should automate the existing budgeting process in the company and at the same time allow you to quickly reflect the changes that occur in the company during the budget process. At the same time, it was important to implement structures and algorithms that ensure the compatibility of systems for the preparation of actual and budgetary reporting, as well as to prepare a system within the terms indicated in the project plan

Project Solution and Progress

Based on the results of the tender, the 1C: Consolidation configuration was chosen as the automation platform, which fully corresponded to the needs of URALCHEM.

At the first stage of the project, the following was implemented:

• Adaptation of URALCHEM budget model to 1C system: Consolidation
• Formalization of calculation of budget forms
• Development and description of VGO reconciliation mechanisms
• Development and description of consolidation adjustment calculations
• Consolidation calculations
• Formalization of final forms

Project results

As part of the development of the budgeting system, the following tasks were solved:

• Batch load budget forms from Excel templates with logging and error messages
• Reconciliation and settlement of intra-group turnover
• Various consolidation adjustments (IUU, Elimination of IHO)
• Generating Final Budget Forms
• Load actual data from an adjacent system for PFA
• Prepare Budget Execution Forecast

During the project, the MKSKOM team created a system that implements functions for the budget process, building an actual analysis plan and forecasting budget execution. The project was completed on time without lag.

As a result of the implementation of 1C: Consolidation made it possible to quickly and efficiently collect, check and consolidate the forms of budgets of subsidiaries and subholdings of the group