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. 

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.

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).

Open the file sent by HR and copy the full information from columns A and B regarding the code of companies and name.

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 the new tab downloaded in Step 1 3 in in tab Data from HR File  CCode ACT 0 2022.12 (update the name of this tab when needed) in columns A and B.

Open the file "Financial Assets IFRS - June 2023 in KEuros" sent by Payroll team Ane Calicis by email and copy the full information from from Y-1.

1. Example:
   - We received from Payroll the amounts from 2022 and we'll upload into BFC in 12.2023.

For this example, column AW: 12.2022.

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 the new tab downloaded in Step 1 in in tab Data from HR File in column C: Active Internal Workforce.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.

Only import values for active companies and IG - Fully Consolidated.

In tab Data from HR File, make a VLOOKUP with the Group company status of GAR List.

> If Deactivated or Non conso: do not import any value and delete from our data base.

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.

In the new tab created for the currently year, fill in the columns as below:

Leave the next available fields blank:

• D_T1    
• D_MO    
• D_T2    
• D_MARK    
• D_CGU    
• D_PMARK    
• D_MVTCA    
• D_ZADM    
• D_PAYS
• D_BKAC
• D_SITE
• D_YEAR

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.

Save the file in your Desktop or in the folder you prefer → Save the file in CSV.

Once salve, the file should not be opened as it changes the formatting of company code, if any change is needed open with Notepad.

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.

Image Added

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.

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.

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.

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.