Panel

Table of Contents

1. OBJECTIVE AND SCOPE

1.1 Objective of this Procedure

This procedure describes how to manage the ACTUAL0 Category, such as create the Category for a new year or to maintain when there is an operation in Solvay’s scope of companies, as well as the sell of a company; the acquisition of a company; and change in the method of consolidation.purpose of ACTUAL0 reporting category and how it is managed in BFC, as well as other related customizing in other BFC modules.

1.2 Scope

This procedure applies to the BFC Administration team.

2. REFERENCE DOCUMENTS

Content by Label

showLabels	false
cql	label = "bfc_scope"

3. DEFINITIONS

GAR Team

3. DEFINITIONS

GAR team - Group Account Accounting & Reporting Team (Consolidation & Tax team)

BFC-Admin team Team - Team responsible to administrate the Consolidation Tool for the Group Solvay (BFC)

CAM - Company Account Manager

CBCR - Country By Country Report

4. SUMMARY

4.1 Principle and Context

The ACTUAL0 is a Category used to report statutory figures, what enables to build the Shareholding structure of the Solvay Group, which becomes available in the Solvay Shareholding Structure site.

In this category are concerned either Consolidated and Non-consolidated companies. The information collected for each type of company is different, thus the documents available for them are different, as the described below:

Consolidated Companies

L4005 Investment - This document reports thenumber of shares that the company holds per affiliate, as well as the the number of shares that the affiliate has issued, then it is possible to know the percentage owned by the reported company. If there is any variance it is explained by flow.

L4000 Impairment (Statutory data) - This document reports the information for the impairment process on financial assets.

L4020 Shareholder's equity - This document reportsthe numbers of shares issued, split by mother companies. If there is any variance it is explained the variation by flow.

L4060 CBCR - Revenues and headcount - This document reports the Revenues the company had in the previous year split by trading partners.

Non-Consolidated Companies

L4005 Investment - In most of cases, the non-consolidated companies do not have affiliates, hence this document is empty.

L4020 Shareholder's Equity - This document details the information about the mother company of the entity (number of shares hold).

L4050 Financial information – This document reports the Balance Sheet and Income Statement of the entity. No detail is asked, no flow and no activity.

administrating BFC SCO (Syensqo Group Consolidation tool)

General Group Secretary - Team from Legal Corporate communicating changes on Syensqo's shareholding structure (new or change in ownership, mergers, divestments, liquidations...) and managing companies' codifications in both ERP and BFC

CAM - Company Account Manager

FSL SU FA GL - General Ledger team from Service Unit "Financial Accounting" in FSL (GBS Finance Service Line)

IG - Fully Consolidated method

IP - Proportional Consolidation method

ME - Equity Method

NC - Not Consolidated

4. SUMMARY

4.1 Purpose and Content

The deliverables from the ACTUAL0 data collection are :

Syensqo Group shareholding structure – updated and published in GAR SYENSQO AODOC team site Syensqo Shareholding Structure
The financial valuation of the non consolidated companies at Group level (vs Group consolidated figures).
The local equity of legal companies for dividend valuation purpose

Depending on the consolidation method (IG - IP - MEQ - NC) of the reporting companies, the content of their ACTUAL0 reporting package may differ:

Consolidated Companies (IG/IP/MEQ conso methods)

L4005 schedule "Investment (number)" - reports thenumber of shares that the reporting company (as Mother) owns in each of its affiliate (Daughters), as well as the the number of shares that the affiliate has issued, then it is possible to know the percentage owned by each of the Mother (s). If there is any variance compared to opening balance, it is explained by flow
L4000 schedule "Local Gaap equity for dividends valuation" - reports the Dec Y-1 statutory equity information needed to evaluate the dividends distribution at Group level
L4020 schedule "Shareholder's equity" - reportsthe numbers of shares issued by the Daughter company, split per its Mother companies. If there is any variance compared to opening balance it is explained by flow

Non Consolidated (NC) Companies

L4005 schedule "Investment (number)" - same content and reporting principles as for Consolidated companies - To be noted that in most of cases, the Non Consolidated companies do not own affiliates
L4020 schedule "Shareholder's equity" - reportsthe numbers of shares issued by the Daughter company, split per its Mother companies. If there is any variance compared to opening balance it is explained by flow
L4050 schedule "Financial information" – reports the summarized Dec Y-1 Financial Statements (consistent with published annual accounts approved by Board of Shareholders and with equity value after dividends distribution), headcounts and external auditors names

4.1 Reporting Calendar Purpose

Depending on their consolidation status and depending on the quarterly reporting period, ACTUAL0 data to be updated and published are different:

Image Added

Permanent instructions on ACTUAL0 Reporting are issued every year by FSL SU FA team and published in Syensqo GAR Team site "Permanent Instructions" folder, and also inserted in Quarterly GAR closing instructions:

Image Added

4.2 Responsibilities

General Group secretary: collects and communicates changes in the Syensqo's shareholding structure (new or change in ownership, mergers, divestments, liquidations...)
GAR Team:
communicate changes in Syensqo Shareholding structure through its Structure File in GAR SYENSQO AODOC - "Syensqo structure files"
analyzes ACTUAL0 inputs (Local equity for dividends valuation)
uses ACTUAL0 consolidated data (Financial Information on NC companies / Shareholding tree) to build appendices from the Annual report
BFC Administration team maintains and updates ACTUAL0 reporting category (packages generation, consolidation creation, scheduling and on demand run)
CAM enters the information for the companies under his/her scope:
for NC companies: CAM or CAM from the Mother company
FSL SU FA GL is responsible to perform the quarterly checks on ACTUAL0 data (number of shares declared by Mothers & Daughters) and to manage mass lockings & unlockings

4.3 Overview

At the beginning of the year, ACTUAL0 category has to be created for the current year. By principle, there is only one category per year, using one single December period (ACTUAL0 - YYYY.12).

Package generation :

Starts with should correspond to the perimeter published in the Y-1 annual report with the following updates:
Companies sold / liquidated / merged in Y-1 => no pack to be created
CBCR (based on Y-1 / IG IP MEQ) not needed. If any need, data can be collected out of ACTUAL0
Financial data on Non Conso (based on Y-1) not needed by GAR
Companies entering in the scope in Y (new acquired), package should be generated as soon as the company is created in BFC following the official communication from General Group Secretary.

The packages stay opened along the year to allow the CAM to update the information when necessary and out of the closing periods. However, every quarter the packages have to be published and locked during two days, to allow the FSL SU-FA GL Team to analyze and validate the data at consolidated level.

ACTUAL0 12.YYYY – Quarterly procedure for lockings & unlockings

The table below summarized for each Reporting quarter the scope of mass lockings and unlockings managed by FSL SU FA GL team:

Image Added

ACTUAL0 REPORTING SETUP

The process by which data is reported is defined in the Reporting Organizer and RU Organizer. In these modules it can be defined:

"Reporting Organizer" is the module where BFC Admin will create the ACTUAL0 Reporting category for the current Y defining:
Start/End dates / Package schedules / Set of controls / Source for opening balance / Deadline for 1st submission (D-1 end of March Y) / Integration mode after publication
"RU Organizer" is the module where BFC Admin will insert the Reporting companies and generate their ACTUAL0 package
List of companies to be inserted can be copied from the Y-1 ACTUAL0 category, removing after manually the packages not to be created (sold liquidated merged companies) and adding the new companies expected to report from Y

- Non Conso companies: BFC Admin will adapt their package schedules and set of controls (as they have a different reporting content compared to IG IP MEQ companies)
- Note that package schedules and set of controls to be used are defined in this document "BFC Admin Reporting set up per category and period"

ACTUAL0 SCOPES OF CONSOLIDATION

3 different scopes used for ACTUAL0 consolidations:

SYENSQO - includes IG / IP / MEQ companies only- note that this is the scope also used in IFRS ACTUAL2 consolidation
SYENFULL -ALL companies(IG IP MEQ NC) considered as 100% consolidated (as if they were all IG)
SYENCONSO - IG companies consolidated at 100% / IP MEQ and NC consolidated as IP at their % of interests

These Scopes initiated at the beginning of the year, should be updated all during the year each time a change is communicated (by Group General Secretary or by GAR in its structure file).

ACTUAL0 CONSOLIDATIONS SETUP

Here below the list of ACTUAL0 consolidations required during the year and their purpose.

Image Added

Consolidations under Variant (V) 2 need to be updated on Quarterly basis:

when the Conversion Rates of the period are made available (WD-1)
when the SYENSQO scope of the period is made available (WD1)

ACTUAL0 SCHEDULING (AUTOMATED) CONOLIDATION RUNS

Every quarter on from WD1 till WD4 scheduling of ACTUAL0 for SYENSQO V2 and SYENFULL V2 and their related Reconciliation consos - every hour

5. REPORTING SETUP

5.1 REPORTING SETUP - Reporting Organizer

In the Reporting Organizer module, ACTUAL0 Category for the period (Reporting ID) is created with its reporting characteristics (Deadline, Folder, Set of Controls, Opening Balances...).

The Definition tab indicates the reporting status. It can also be specified the associated category scenario and the start and end dates for the reporting.
Enter the following information:
Version of category scenario: refer to this document "BFC Admin Reporting set up per category and period" to get the category scenario version to be used
Start & End Date: As ACTUAL0 is used from the beginning of the year until the final Year End, enter a large range, e.g. January 1st of current year to March 31st next year.

Image Added

The Package tab defines the data entry settings applicable to packages:
Windows and Internet folder / Internet-specific folder: refer to this document "BFC Admin Reporting set up per category and period"
Set-of controls: refer to this document "BFC Admin Reporting set up per category and period"
Control level to be reached: Q - This field needs a special attention, because if any the previous field is changed this one is deleted, always ensure it is filled properly.
Blocking - Flag the option Blocking.
Apply to central manual journal entries - it MUST NOT be flagged
Opening balance:
Category: ACTUAL0.
Data entry period: YYYY-1.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SYENSQO
Variant: 2 (IFRS consolidation taken as reference)

Image Added

5.2 REPORTING SETUP - RU Organizer

In the RU Organizer is defined the companies to be reported in the category.

Then the reporting packages are created in RU Organizer module.

Note that the packages will have the status Image Added, meaning that they are still not available in the Package Manager module.

Warning
Before Generate the packages to the Package Manager module, ensure that all the companies are with the correct Consolidation Method (column Entity Portfolio), and if any company needs either to be added or deleted.

Image Added

Changes required for Non Consolidated companies before Generation: Opening balance + Set Folders & Controls

Before to launch the generation, change the Opening Balance of Non Consolidated companies - scope SYENSQO to SYENFULL (Non Conso are not in SYENSQO scope):
CTRL+A to select Non Conso
Then Properties

In Package Tab, replace SYENSQO by SYENFULL
Then Apply

Before to launch the generation, change the Folder and Set of controls

CTRL+A to select Non Conso
Then Properties

In Package Tab,
Windows and Internet folder / Internet-specific folder: change the folder to ACTUAL0-FI - refer to this document "BFC Admin Reporting set up per category and period"
Set-of controls: change the set to ACT0-NCQ1Q2 (applicable for Q1 and Q2) - refer to this document "BFC Admin Reporting set up per category and period"
Group Control level: set to Q
Then Apply

Back to Home Screen, check that Folders and Set of controls of Non Conso have been updated

Image Added

5.3 REPORTING SETUP - Package Manager

5.4 REPORTING SETUP - Pre-loading of F99 at the beginning of the year

As of 2022, F99 "Closing balance" of L4005 (Investments - number of shares) and L4020 (Shareholder’s equity) is pre-loaded with the F00 "opening data".

To ease the reporting process for the CAM and Accounting Platform managing companies hosting significant numbers of investments or mothers, GAR and FSL SU FA teams requested the pre-loading of F99 in headings XCQ261T / XCQ262T / XCQ101T with the values from previous year (=F00 Opening flow from current year) but keeping the possibility to edit/modify the preloaded data. Change requested for all companies whatever their consolidation status.

At the publication of the packs, CAMs should confirm or modify the values pre-loaded in F99.

As a result, a new formula in the category scenario of ACTUAL0 has been introduced:

Image Added

In order to ensure that this automatic pre-filling is working it is recommended to open 1 package per each consolidation method (IG IP MEQ NC) right after the package generation to check in schedules L4005 and L4020 that the pre-loading is working as expected.

in the Package Manager module, select one of each conso method package.

Image Added

Open schedules L4005 and L4020.

Image Added

Check F99 is equal to F00 and it is editable.

Image Added

Check F99 is equal to F00 and it is editable.

Image Added

6. SCOPES OF CONSOLIDATION

6.1 SCOPES OF CONSOLIDATION - SYENFULL

SYENFULL definition- ALL companies (IG IP MEQ NC) considered as 100% consolidated (as if they were all IG)

One scope SYENFULL per year to be updated all during the year each time a change is communicated (by Group General Secretary or by GAR in its structure file).

Then the scope for the new period is created - in the example here SYENFULL 2024.12.
Note that this scope only allows companies set as Full conso (FC), this way when there is the end of a company and its Consolidation Method is changed to Not Consolidated the company is automatically excluded from the scope.
Even though, in the step Scope, ensure that all companies that left the Group in the previous year are not present in the scope for the current period.

After all the information is validated the scope has to be transferred to the BFC_Prod_SCO platform.

Image Added

6.2 SCOPES OF CONSOLIDATION - SYENCONSO

SYENCONSO definition - IG companies consolidated at 100% / IP MEQ and NC consolidated as IP at their % of interests

One scope SYENCONSO per year to be updated all during the year each time a change (new companies, leaving companies, change in interests %) is communicated (by Group General Secretary or by GAR in its structure file).

Then the scope for the new period is created.
Note that this scope only allows companies set as Full conso (FC) or Proportional Integration (IP), this way when there is the end of a company and its Consolidation Method is changed to Not Consolidated the company is automatically excluded from the scope.
Even though, in the step Scope, ensure that all companies that left the Group in the previous year are not present in the scope for the current period.

After all the information is validated the scope has to be transferred to the BFC_Prod_SCO platform.

Image Added

6.3 SCOPES OF CONSOLIDATION - SYENSQO

SYENSQO - includes IG / IP / MEQ companies only (Non Conso excluded)- note that this is the scope also used in IFRS ACTUAL2 consolidation

One scope SYENSQO per month to be updated every WD1 (new companies, leaving companies, change in consolidation methods or in interests %) following the information received during the month (by Group General Secretary or by GAR in its structure file).

In the step Scope, the following procedure describes how to update the companies (insertion & deletion) Companies management in BFC - section 6.ScopeManagement

After all the information is validated the scope has to be transferred to the BFC_Prod_SCO platform.

6.4 SCOPES OF CONSOLIDATION - Transfer from BFC_Top_SCO to BFC_Prod_SCO

BFC _Top_SCO

7. CONSOLIDATIONS & INTERCO SETUP

7.1 CONSOLIDATIONS SETUP

There are 4 consolidations required for the ACTUAL0 category:

SYENFULL V2.
SYENCONSO V1
SYENSQO V2

This table summarizes purpose and usage of each:

Image Added

To create a consolidation it can be done from scratch or with reference to the version of the previous year through the Save As option.

7.1.1 CONSOLIDATIONS SETUP - SYENFULL V2

7.1.2 CONSOLIDATIONS SETUP - SYENCONSO V1

7.1.3 CONSOLIDATIONS SETUP - SYENSQO VARIANT 2

7.2 INTERCOMPANY RECONCILIATION SETUP

Purpose of this reconciliation performed using ACTUAL0 scopes is to compare and check consistency between shares declared by mothers (schedule L4005 from ACTUAL package) versus the ones declared by daughters (schedule L4020 from ACTUAL0 package) using BFC report "CD190_8".

7.2.1 INTERCO SETUP - using consolidation SYENSQO V2 (IG IP MEQ only)

7.2.2 INTERCO SETUP - using consolidation SYENFULL V2 (Non Conso cnies included)

7.3 CONSOLIDATIONS SETUP - Quarterly Update

On a quarterly basis:

Periods of the Conversion Rate in the consolidation SYENSQO V2 and SYENFULL V2 should be updated to the ones applicable on the quarterly period.
In SYENSQO V2, the Scope must also be updated every quarter with the latest SYENSQO available

7.4 CONSOLIDATION & INTERCO - Run scheduling

Purpose of this scheduling is to run automatically both consolidation and reconciliation on a given period and at a defined frequency.

4 tasks created to run each quarter from WD1 till WD4 every hour:

Based on SYENSQO scope / variant 2:
Consolidation => ACT0-SYEN-V2
Corresponding interco reconciliation (comparing shares numbers declared by mothers & daughters) => A0-INT-SYENS

Based on SYENFULL scope / variant 2:
Consolidation => ACT0-SYEFULL
Corresponding interco reconciliation (comparing shares numbers declared by mothers & daughters) => A0-INT-SYEF

Image Added

8. COMPANIES OPERATIONS

8.1 COMPANIES OPERATIONS - New Companies

When the group acquires a new company, whatever its consolidation status, a package has to be created in the ACTUAL0 Category.

To create the package ensure that the company has already been created in BFC, otherwise follow the instructions in the Procedure related to Companies management in BFC:

The package will be available in the RU Organizer module, and information needs to be confirmed before generate to the Package Manager module.
Open the package information and validate if the settings are in accordance to the Consolidation Method of the company.
By default, when a package is added through the Insert Reporting Units option, the definitions are the same than the Category created in the Reporting Organizer module, it means, the package has the definitions of a Consolidated company. Then if the new company is a not consolidated, the definitions have to be changed.

Image Added

In the tab Package it will be informed what determines the documents that are shown at the company's package, as well as the set of rules (Validations), opening balance, and the Scope that the company is assigned on this phase.
Since the schedules collected for a Not Consolidated and a Consolidated (IG IP MEQ) company are different, this tab has some specification for each type of company. Set of schedules per type of company are defined in this document "BFC Admin Reporting set up per category and period"

Non Consolidated Company

Windows and Internet folder: refer to this document "BFC Admin Reporting set up per category and period"
Internet-specific folder: refer to this document "BFC Admin Reporting set up per category and period"
Set-of controls: refer to this document "BFC Admin Reporting set up per category and period"
Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

Blocking - Flag the option Blocking.
Apply to central manual journal entries - MUST NOT be flagged

Opening balance:
Category: ACTUAL0.
Data entry period: YYYY-1.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SYENFULL - This scope is taken into account all the companies in the Group's structure.
Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.
Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.

Image Added

Consolidated Company (IG IP MEQ)

Windows and Internet folder: refer to this document "BFC Admin Reporting set up per category and period"
Internet-specific folder: refer to this document "BFC Admin Reporting set up per category and period"
Set-of controls: refer to this document "BFC Admin Reporting set up per category and period"
Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

Blocking - Flag the option Blocking.
Apply to central manual journal entries - MUST NOT be flagged

Opening balance
Category: ACTUAL0.
Data entry period: YYYY-1.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SYENSQO- This scope is taken into account just the consolidated companies.
Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.
Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.

Image Added

The tab Restrictions is automatically filled, but it is necessary to confirm that the option Read-only flows is set for the F00, this means that the opening balances are not available for edition.
Then save Image Added.

Info
All the other tabs are automatically filled.

Image Added

8.2 COMPANIES OPERATIONS - End of Companies (liquidated / merged / sold)

Generally, for the companies that left the Group during the course of the year, the packages remain in the ACTUAL0 - YYYY.12, however at the beginning of the next year the packages should not be generated.

Along the year YYYY the packages of these companies should stay Protected, instead locked, this way it is possible to identify the companies that left the Group.

When a company left the Group, the company should be updated in the Scope of Consolidation.

The companies should be set as Not Consolidated and their Financial and ownership interests set to 0 in the three scopes:

SYENCONSO
SYENFULL
SYENSQO

Note that in SYENCONSO and SYENFULL scopes, it is not necessary to create an intermediate package for the company in the tab Incoming/Outgoing of the scope.

While in the scope SYENSQO there are only Consolidated companies, it means that just the companies IG, IP and ME can be excluded from this scope, and it should be created the intermediate package for these companies in the tab Incoming/Outgoing of the scope. For more details of operations in the scope SYENSQO, scope, refer to the Procedure related to Companies management in BFC.

Image Added

8.3 COMPANIES OPERATIONS - Change of Consolidation Method

The change of the method of consolidation concerns the transition from the Not Consolidated/ Equity Method/ Proportional to Full Consolidated, or vice versa. In other words, this transition is assimilated to either an increase or decrease in the rate of integration.

The change of consolidation method should be communicated by the Syensqo Corporate Secretary as well as available in the Structure File within the GAR SYENSQO AODOCs Library.

As a consequence of such change, content of their ACTUAL0 package may have to be amended, as well as the reporting setup and the scope of consolidation.

In the tab Package it will be informed what determines the documents that are shown in the company's package, as well as the set of rules (Validations), opening balance, and the Scope that the company is assigned on this phase.
The information in this tab has to be updated according to the new consolidation method.

Company moving to Not Consolidated status

Windows and Internet folder: ACTUAL0-FI - refer to this document "BFC Admin Reporting set up per category and period"
Set-of controls: either ACT0-NCQ1Q2 or ACT0-NCQ3Q4 depending on when it occurs during the year - refer to this document "BFC Admin Reporting set up per category and period"
Control level to be reached: not to be changed - remains Q

Blocking - Flag the option Blocking.
Apply to central manual journal entries - MUST NOT be flagged

Opening balance:
Category: ACTUAL0.
Data entry period: YYYY-1.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SYENFULL - This scope is taken into account all the companies in the Group's structure.
Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.
Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.

Image Added

Company moving from Non Conso to Consolidated status (IG or IP or MEQ)

Windows and Internet folder: refer to this document "BFC Admin Reporting set up per category and period"
Internet-specific folder: refer to this document "BFC Admin Reporting set up per category and period"
Set-of controls: refer to this document "BFC Admin Reporting set up per category and period"
Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

Blocking - Flag the option Blocking.
Apply to central manual journal entries - MUST NOT be flagged

Opening balance
No change. If we change to SYENSQO, no opening will appear as the company was not in this SYENSQO conso previous year

Image Added

END OF PROCEDURE

4.2 Responsibility

The Corporate Secretary is responsible to communicate the changes in the Solvay's structure that are performed in the PRS System.

The GAR team communicate through the Structure File, available in the GAR AODOCs Library, the changes in the Solvay's Structure.

The BFC Administration team is responsible to maintain any necessary update in ACTUAL0 category.

The CAM is responsible to enter the information in this category for the companies under his/her scope.

4.3 Overview

At the beginning of the year the ACTUAL0 category has to be created for the current year. By principle, there is only one category per year, which is set for December (ACTUAL0 - YYYY.12).

The packages stay opened along the year to allow the CAM update the information when necessary. However, every quarter the packages have to be published and locked during two days, to allow the GAR Team to analyze the data and update the Solvay Shareholding Structure.

ACTUAL0 REPORTING SETUP

The process by which data is reported is defined in the Reporting Organizer and RU Organizer. In these modules it can be defined:

Which reporting units should send packages and when.
This consists of establishing a work schedule (start and end dates for sending packages), in the Reporting Organizer, and a list of the reporting units sending the packages, in the RU Organizer.
Define the data entry environment.
Define the data entry schedules, opening balances, processing operations, controls and restrictions.
Manage how opening packages are generated.

After the Reporting Organizer and RU Organizer are defined the packages should be transferred to the Package Manager module, to allow the user to enter the necessary reporting data.

The Packages have to be added for a new company or deleted for a company that left the group, according to the operations of companies along of the year.

ACTUAL0 SCOPES OF CONSOLIDATION

Then the Scopes for this Category has to be created. A Scope enables to group together the reporting units to be included in the consolidation process and select the consolidation method to be applied.

For the ACTUAL0 there are two specific scopes of consolidation:

SOLFULL - Contain all Solvay Companies (consolidated or not). All companies are integrated at 100%.
SOLCONSO - Contain all Solvay Companies (consolidated or not). The companies are integrated at their ownership rate.

These Scopes should be updated according to the operations of companies along of the year.

ACTUAL0 CONSOLIDATIONS SETUP

It has to be defined three Consolidations for the ACTUAL0 category:

SOLFULL - To consolidate all the companies of the Group at 100%.
SOLCONSO - To consolidate all the companies of the Group at their ownership rate.
SOLVAY14 - To consolidate all the Consolidated companies.

All the Consolidations need to be updated on Quarterly basis, when the Conversion Rate Period should be changed to the one in reference.

Additionally, the Consolidation SOLVAY14 needs to have the Scope Period updated, as well, to the one in reference.

5. REPORTING SETUP

5.1 REPORTING SETUP - Reporting Organizer

In the Reporting Organizer module it is created the Category for the period (Reporting ID) and is defined the common data for the packages, as the Deadline, Folder, Set of Controls, Opening Balances, etc.

To create a new Reporting ID for the period, select the one of the previous year in the field Select Reporting IDs.

In this example, it is being created the category for 2017, so it was select as reference the category of 2016 (ACTUAL0 - 2016.12)

Then in Reporting Organizer module Open it and Save As.

Image Removed

The General tab defines the general properties of the reporting ID.

Enter the following information:

Category - ACTUAL0
Data entry period - 20XX.12
Short & Long description - Shareholding - 20XX.12

Image Removed

The Definition tab indicates the reporting status. It can also be specified the associated category scenario and the start and end dates for the reporting.

Enter the following information:

Version: A1403.
Start & End Date: It can be specified the scheduled start and end dates. The reporting status depends on these dates. Enter a large range, e.g. January 1st of current year to March 1st next year.

Image Removed

The Package tab defines the settings of the data entry environment for the packages.

Enter the following information:

Windows and Internet folder: ACTUAL0 - The documents that will be available for the company in this phase.
Internet-specific folder: ACTUAL0 - The documents that will be available for the company in this phase.
Set-of controls: ACT0-IG - The controls that are set to check the package data for this phase.
Control level to be reached: Q - This field needs a special attention, because if any the previous field is changed this one is deleted, always ensure it is filled properly.

Blocking - Flag the option Blocking.

Category: ACTUAL0.
Data entry period: 20XX.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SOLVAY14- This scope is taken into account just the consolidated companies.
Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Image Removed

The Restrictions tab defines the data entry restrictions which are applied when the data is entered.

The flow F00 (Opening Balances) must be informed in Read-only Flows, this way it will not be available for edition in the package.

Image Removed

The Operation tab defines the settings to publish the packages.

In the Deadline it has to be informed the date that the packages will have to be published.

It has to be changed each quarter, according to date defined in the Calendar available in the GAR AODOCs Library.

Image Removed

The Translation tab defines the object descriptions for the selected language.

Both French and English should be informed: Shareholding - 20XX.12

Image Removed

5.2 REPORTING SETUP - RU Organizer

In the RU Organizer is defined the companies to be reported in the category.

Select all packages in the RU Organizer module from the previous year (Ctrl+A), and copy (through the icon Image Removed or Ctrl+C).

Image Removed

Change the period to the one that is being created and paste packages (through the icon Image Removed or Ctrl+V).

Image Removed

Then the reporting packages are created in RU Organizer module.

Note that the packages will have the status Image Removed, meaning that they are still not available in the Package Manager module.

Warning
Before Generate the packages to the Package Manager module, ensure that all the companies are with the correct Method of Consolidation (column Entity Portfolio), and if any company needs either to be added or deleted.

Image Removed

To make the reporting available in the Package Manager module, select all packages and with the right click choose "Generate Package at Current Site".

Image Removed

The package status changes to Image Removed, meaning that the package are now available in the Package Manager module.

Image Removed

5.3 REPORTING SETUP - Package Manager

After Generate the Package to the Package Manager module, they will be available for the users to enter the data for the companies under their responsibility.

In this module it is done the follow-up on the package status (Empty, Changed, Publish or Integrated). Then it is possible to check if any company is missing to report the necessary information.

Image Removed

6. SCOPES OF CONSOLIDATION

6.1 SCOPES OF CONSOLIDATION - SOLFULL

6.2 SCOPES OF CONSOLIDATION - SOLCONSO

6.3 SCOPES OF CONSOLIDATION - Transfer from FC_TOP to FC_Prod

7. CONSOLIDATIONS SETUP

7.1 CONSOLIDATIONS SETUP - SOLFULL

7.2 CONSOLIDATIONS SETUP - SOLCONSO

7.3 CONSOLIDATIONS SETUP - SOLVAY14

7.4 CONSOLIDATIONS SETUP - Quarterly Update

8. COMPANIES OPERATIONS

8.1 COMPANIES OPERATIONS - New Companies

When the group acquires a new company a package has to be created in the ACTUAL0 Category.

To create the package ensure that the company has already been created in BFC, otherwise follow the instructions in the Procedure:

Content by Label

cql	label = "bfc_scope"

After the communication from the Corporate Secretary, the information about the concerned company should be available in the Structure file within the GAR Team site.

GAR team site link: http://teamsites.solvay.com/sites/DCFI-CC-GAC/default.aspx > BFC Doc and Training > 04. Solvay Structure

As example, it will be used the company 63280 COGENERATION ROSIGNANO S.p.a., which was acquired in January 2017.

Image Removed

At the tab Package it will be informed what determines the documents that are shown at the company's package; as well as the set of rules (Validations); opening balance; and the Scope that the company is assigned on this phase.

Since the information collected for a Non-Consolidated and a Consolidated company is different, this tab has some specification for each type of company

Non-Consolidated Company

Windows and Internet folder: ACTUAL0-FI - The documents that will be available for the company in this phase.

Internet-specific folder: ACTUAL0-FI - The documents that will be available for the company in this phase.

Set-of controls: ACT0-FI - The controls that are set to check the package for this phase.

Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

Blocking - Flag the option Blocking.

Category: ACTUAL0

Data entry period: 20XX.12 - Inform the period which the opening balances are retrieved. Always December of previous year.

Scope: SOLFULL - This scope is taken into account all the companies in the Group's structure.

Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.

Image Removed

Consolidated Company

Windows and Internet folder: ACTUAL0 - The documents that will be available for the company in this phase.

Internet-specific folder: ACTUAL0 - The documents that will be available for the company in this phase.

Set-of controls: ACT0-IG - The controls that is set for the company for this phase.

Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.

Blocking - Flag the option Blocking.

Category: ACTUAL0

Data entry period: 20XX.12 - Inform the period which the opening balances are retrieved. Always December of previous year.

Scope: SOLVAY14- This scope is taken into account just the consolidated companies.

Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.

Image Removed

The tab Restrictions is automatically filled, but it is necessary to confirm that the option Read-only flows is set for the F00, this means that the opening balances are not available for edition.

Then save Image Removed.

Info
All the other tabs are automatically filled, but ensure that the data are correct.

Image Removed
Outside the package creation/edition screen, make sure all the information is compliant.
At this stage the package is created at the "RU Organizer" module.
Its status is: The package has not been generated.
Image Removed
To generate the package, choose with right click the option: Generate Package at Current Site.
Image Removed
Then status will be changed, meaning that the package is now available at the "Package Manager" module, thus available for the users that have access for this company at this phase.
Image Removed

8.2 COMPANIES OPERATIONS - End of Companies

8.3 COMPANIES OPERATIONS - Change of Consolidation Method
The change in the method of consolidation concerns the transition from the equity method to integration (global or proportional) or vice versa. In other words, this transition is assimilated to either an increase or decrease in the rate of integration.
As soon as a company change its consolidation method the information to be reported is different, hence its set-up needs to be updated accordingly.
The change of consolidation method should be communicate by the Corporate Secretary and they information available on structure file on GAR team site.
Then on BFC_FCprod, enter on the phase for the correspondent period, in this instance, should be ACTUAL0 – 2017.12.
Within the “Operation” domain select the “RU Organizer” module and select the company to be updated.
Image Removed
At the tab Package it will be informed what determines the documents that are shown at the company's package; as well as the set of rules (Validations); opening balance; and the Scope that the company is assigned on this phase.
The information in this tab has to be updated according to the new consolidation method; as follows:

Non-Consolidated Company
Windows and Internet folder: ACTUAL0-FI - The documents that will be available for the company in this phase.
Internet-specific folder: ACTUAL0-FI - The documents that will be available for the company in this phase.
Set-of controls: ACT0-FI - The controls that are set to check the package for this phase.
Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.
Blocking - Flag the option Blocking.
Category: ACTUAL0
Data entry period: 20XX.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SOLFULL - This scope is taken into account all the companies in the Group's structure.
Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.
Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.
Image Removed
Consolidated Company
Windows and Internet folder: ACTUAL0 - The documents that will be available for the company in this phase.
Internet-specific folder: ACTUAL0 - The documents that will be available for the company in this phase.
Set-of controls: ACT0-IG - The controls that are set to check the package for this phase.
Control level to be reached: Q - This field need a special attention, because if any the previous field is changed this one is deleted, always ensure it is fulfilled properly.
Blocking - Flag the option Blocking.
Category: ACTUAL0
Data entry period: 20XX.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
Scope: SOLVAY14- This scope is taken into account just the consolidated companies.
Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.
Consolidation currency: EUR - The Group Consolidation Currency, always EUR, regardless the company currency.
Image Removed

When a company change its Consolidation Method no action is needed in the Scope SOLFULL, since all companies are set as Full Consolidated.

9. PACKAGES QUARTERLY BACK-UP
After the publication of all consolidated companies (IG, IP and ME) on ACTUAL0 phase, a back-up of the reported data has to be saved for the given period, e.g. in March/YY a back-up has to be saved as ACTUAL0 - 20YY.03.
Then the packages of ACTUAL0 - 2017.12 have to be reopened.

10. OTHER ACTIONS
10.1 OTHER ACTIONS - Add New Companies to the Users

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 11

New Version Current

Key

1. OBJECTIVE AND SCOPE

1.1 Objective of this Procedure

1.2 Scope

2. REFERENCE DOCUMENTS

3. DEFINITIONS

3. DEFINITIONS

4. SUMMARY

4.1 Principle and Context

4. SUMMARY

4.1 Purpose and Content

4.1 Reporting Calendar Purpose

4.2 Responsibilities

4.3 Overview

5. REPORTING SETUP

5.1 REPORTING SETUP - Reporting Organizer

5.2 REPORTING SETUP - RU Organizer

5.3 REPORTING SETUP - Package Manager

5.4 REPORTING SETUP - Pre-loading of F99 at the beginning of the year

6. SCOPES OF CONSOLIDATION

6.1 SCOPES OF CONSOLIDATION - SYENFULL

6.2 SCOPES OF CONSOLIDATION - SYENCONSO

6.3 SCOPES OF CONSOLIDATION - SYENSQO

6.4 SCOPES OF CONSOLIDATION - Transfer from BFC_Top_SCO to BFC_Prod_SCO

7. CONSOLIDATIONS & INTERCO SETUP

7.1 CONSOLIDATIONS SETUP

7.1.1 CONSOLIDATIONS SETUP - SYENFULL V2

7.1.2 CONSOLIDATIONS SETUP - SYENCONSO V1

7.1.3 CONSOLIDATIONS SETUP - SYENSQO VARIANT 2

7.2 INTERCOMPANY RECONCILIATION SETUP

7.2.1 INTERCO SETUP - using consolidation SYENSQO V2 (IG IP MEQ only)

7.2.2 INTERCO SETUP - using consolidation SYENFULL V2 (Non Conso cnies included)

7.3 CONSOLIDATIONS SETUP - Quarterly Update

7.4 CONSOLIDATION & INTERCO - Run scheduling

8. COMPANIES OPERATIONS

8.1 COMPANIES OPERATIONS - New Companies

8.2 COMPANIES OPERATIONS - End of Companies (liquidated / merged / sold)

8.3 COMPANIES OPERATIONS - Change of Consolidation Method

4.2 Responsibility

4.3 Overview

5. REPORTING SETUP

5.1 REPORTING SETUP - Reporting Organizer

5.2 REPORTING SETUP - RU Organizer

5.3 REPORTING SETUP - Package Manager

6. SCOPES OF CONSOLIDATION

6.1 SCOPES OF CONSOLIDATION - SOLFULL

6.2 SCOPES OF CONSOLIDATION - SOLCONSO

6.3 SCOPES OF CONSOLIDATION - Transfer from FC_TOP to FC_Prod

7. CONSOLIDATIONS SETUP

7.1 CONSOLIDATIONS SETUP - SOLFULL

7.2 CONSOLIDATIONS SETUP - SOLCONSO

7.3 CONSOLIDATIONS SETUP - SOLVAY14

7.4 CONSOLIDATIONS SETUP - Quarterly Update

8. COMPANIES OPERATIONS

8.1 COMPANIES OPERATIONS - New Companies

8.2 COMPANIES OPERATIONS - End of Companies

8.3 COMPANIES OPERATIONS - Change of Consolidation Method

9. PACKAGES QUARTERLY BACK-UP

10. OTHER ACTIONS

10.1 OTHER ACTIONS - Add New Companies to the Users