| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Domain: Finance Data & Reporting |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: Ensure consistency of Actual 0 |
Table of contents
| Table of Contents | ||
|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
Scope |
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
| Status | ||||
|---|---|---|---|---|
|
Search for the Report CB445 “Portofolio in Investments”.
| Status | ||||
|---|---|---|---|---|
|
Fill in the available fields:
Save the report in the new folder created in our Google Drive.
3.3 I perform the check
| Status | ||||
|---|---|---|---|---|
|
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.
| Status | ||||||
|---|---|---|---|---|---|---|
|
Copy data from the report to our working file tab "Extract CB445" > Stretch formula from columns A, B and D (if needed).
| Status | ||||||
|---|---|---|---|---|---|---|
|
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.
| Status | ||||||
|---|---|---|---|---|---|---|
|
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.
| Status | ||||||
|---|---|---|---|---|---|---|
|
Paste a new GAR List updated in tab GAR List.
| Status | ||||||
|---|---|---|---|---|---|---|
|
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.
| Status | ||||
|---|---|---|---|---|
|
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 C "Missing on ACT 0", those are the lines that are in the control that are divergent in Actual0 and therefore should be deleted from the Tree, as the accurate information is the Actual0.
> 0% or less than 1% - To keep in the three.
| Status | ||||||
|---|---|---|---|---|---|---|
|
In tab 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".
If the daughter company is a Non Conso, update the check to "OK" as it will not be included in the Tree.
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.
| Status | ||||
|---|---|---|---|---|
|
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.
When received a new file from Anne, check her comments to see which lines will be included in the official file Financial Assets IFRS - June 2023 in KEuros.
In the example, we should include 6 lines that are missing and we received the confirmation from Anne with an "OK" in column D.
After including the missing lines, insert a comment in column E with the number of the lines that were included as showed in the example. The color mentioned is regarding the level of each company.
| Status | ||||
|---|---|---|---|---|
|
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.
Dowload and open the file Financial Assets IFRS - June 2023 in KEuros as the changes should be performed in a Excel file due the retrieves.
Include the new lines companies in the Tree following the rules of levels and update the retrieve so we get the updated information.
The colors in the Tree are based with the level that the company belongs.
| Status | ||||
|---|---|---|---|---|
|
Only select Replace Data.
NEVER USE THE OPTION "ERASE THE PACKAGE AMOUNTS BEFORE IMPORTING", otherwise you will deleted data included in the other ACTUAL 0 document.
Paint the lines included in yellow, send an new email informing that the file is updated and send the file in attach.
Status colour Blue title Step 4
Click on Import.
Status colour Blue title Step 5
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.
