Responsibility area: Ensure consistency of Actual 0
Table of contents
Scope
ERP
Frequency
References
ACTUAL 0 Instructions
ACTUAL 0 Working Files
Forms
Attachments
8. Add the link to attachments or external links
Before the deadline (September/December) is close, our team should send an email requesting the file so we can work on the update.
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
STEP 2
Search for the Report CB445 “Portofolio in Investments”.
3.3 I perform the check
STEP 1
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.
STEP 2
Copy data from the report to our working file tab "Extract CB445" > Stretch formula from columns A, B and D (if needed).
STEP 3
Filter column A "Concatenate" where we can see the concatenate of mother and daughters companies, 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.
STEP 4
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.
STEP 5
Paste a new GAR List updated in tab GAR List.
STEP 6
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.
STEP 7
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.
STEP 8
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".
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.
STEP 1
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.
STEP 2
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.
STEP 3
Paint the lines included in yellow, send an new email informing that the file is updated and send the file in attach.
