Domain: Finance Data & Reporting

Responsibility area: Ensure consistency of Actual 0

Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)

Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable


References

6. Add the link to SAP transaction(s) (when it exists)

ACTUAL 0 Instructions
ACTUAL 0 Working Files


Forms

7. Insert the links accordingly and change the link text with the OP name


Attachments

8. Add the link to attachments or external links

1. Objective and Scope

1.1 Objective of this Operation

The objective of this procedure is to describe the process to perform the adjust of the group hierarchy for impairment process based on Actual 0 information.

1.2 Scope

The scope of this procedure is for Consolidated and Non Consolidated Companies.

2. Definitions

See Finance Glossary.

Deadline proposal:  This task must be performed twice a year on September and December. 

Description of the task: Analyze and update the group hierarchy so that the information is correct.

3. Tasks description

3.1 I request the updated file to proceed with the analysis



Before the deadline (September/December) is close, our team should send an email requesting the updated file so we can work on the update of it.


When receive the updated file, create a new folder in our Google Drive, rename with the currently month being analyzed and past the file received. 

3.2 I extract the report from BFC

Login BFC with your User and Password and click on Reports in Analysis.

Search for the Report CB445 “Portofolio in Investments”.


Fill in the available fields:

Save the report in the new folder created in our Google Drive.




3.3 I perform the check

Access the Sharedholding Structure folder in Google Drive, use as an example a file from the previous quarter for the formulas be copied.

Past the file "Shareholding Structure" and rename with the current month.

Copy data from the report to our working file tab "Extract CB445" > Stretch formula from columns A, B and D (if needed).



Filter column A "Concatenate" where we can see the concatenate of mother and daughters companies and unflag "X" and copy the result.


Paste the information copied in Step 3 in in tab CCode ACT 0 2022.12 (update the name of this tab when needed) in columns A.

Open the file "Financial Assets IFRS - June 2023 in KEuros" sent by Ane Calicis by email and copy the values in tab Solvay SA and subs K€ (IFRS) from columns: 

I > Mother. Code
K > Daughter Cy Nr
AA > % ownership

Paste the information copied in our working file in tab CCode Mother in columns A, B and E.
> The column C contains a concatenate formula, do not change it and stretch the formula if needed.

Paste a new GAR List updated in tab GAR List.



Copy in column A from tab CCode Act 0 2022.12 the information with the concatenate of mother and daughter companies.



Paste values the information copied in tab Check ACT0 vs Mother in column A.
> The columns B and H to M contains formula, do not change it and stretch the formula if needed.



Copy in column C from tab CCode Mother the information with the concatenate of mother and daughter companies.

Paste values the information copied in tab Check Mother vs ACT0 in column A.
> The columns B and H to M contains formula, do not change it and stretch the formula if needed.


In tab Check ACT0 vs Mother filter by column B "Insert in Tree", those are the missing lines to be included in the official file "Financial Assets IFRS - June 2023 in KEuros".





Before updating the official final, send an email to Anne Calicis asking to check if in fact we can include the missing lines.

> Include comments if applicable in column C.

> She will reply and include comments if applicable un column D.



3.4 I update the Tree


Login BFC with your User and Password and click on Package Import in Local Data Collection.

Before uploading, check that ACTUAL 0 packages are not locked or protected, otherwise unlocked the package or ask BFC-Admin for unlock.

Upload your file saved in your desktop by clicking on Upload your file to the local server.

Do not change the other fields and click on Data preview to check that all the lines loaded correctly.


Only select Replace Data.

(warning)NEVER USE THE OPTION "ERASE THE PACKAGE AMOUNTS BEFORE IMPORTING", otherwise you will deleted data included in the other ACTUAL 0 document.


Click on Import.

Send and email to all CAMs and CADs informing that the CBCR report information for the Actual 0 has been uploaded into the BFC and save the working files in Google Drive.