The objective of this procedure is to describe the specific actions required when starting a new year to be carried out by the BFC Admin team.
Beginning of January, BFC IT team asks BFC Admin team to inform the dates for the BFC production database quarterly backups (performed by AWS team).

In order to be able to determine the appropriate dates, BFC Admin should consult Solvay's Financial Calendar published in https://www.syensqo.com/en/investors/financials web site - Investors → Financials → Agenda

and propose as back up dates the week end before each quarter/year earnings announcement.

The BFC Admin Calendar is a planning for the year covering all BFC Admin activities as well as Group's deadlines and milestones related to reporting cycles. Other events, such as Group financial press releases/dashboard publications or quarterly back ups of BFC Prod done by IT, should also be included in the calendar.
This calendar must be prepared at the beginning of January and aligned with GAR Financial Accounting Closing calendar as soon as it is available in GAR SYENSQO Aodocs.
To prepare the calendar the following methodology should be applied:
WD-9 - ACTUAL1-TAX package generation - Q1, Q2 and Q3
WD-4 - ACTUAL2 Period opening to allow GAR Conso team to anticipate the posting of its top entries - monthly
WD-3 - GAR List check - to check there are no missing updates /missing info for the companies that have been acquired, merged, sold or liquidated in the last month - monthly
WD-2 - ACTUAL2 & ACTUAL3 package generation - ACTUAL2 monthly and ACTUAL3 quarterly in Q3 and Q4
WD-1 - ACTUAL(REEL) Exchange rates update - monthly
WD1 - Scopes + Consos definition + Consos runs scheduling update - monthly
WD1 - ACTUAL0 packages massive lock + consos definition +consos run schedulings update - quarterly
WD4 - ACTUAL2 publication (exception in December and January - WD5) - monthly
WD5 - ACTUAL0 packages massive unlock - quarterly in Q1, Q2 and Q3
Hard Close Tax - package generation in the 2nd week and publication in the 3rd week of October - dates to be checked in GAR Financial Closing Calendar
ACT2 Switch HC/YE - around Dec. 15th - precise date to be validated in December with GAR Tax team
Quarterly back up - According to the dates communicated by BFC Admin to BFC IT team early January for the whole year
GAR dashboard publication / GO for Conso Back Up to be asked - According to dates defined in GAR Financial Accounting Closing Calendar.
Group press releases - According to Financial Calendar /upcoming events announced in Syensqo Investor website
BFC Internal Control SEC-10 - Audit trails on critical activities - Quarterly
Once the calendar is ready or anytime there is a change it should be communicated/shared with BFC support external providers.
In addition to BFC Admin calendar, BFC Admin team creates a table listing packages generation dates for each Category of reporting cycles. This information is used by GAR in the timetable section of its Quarterly closing instructions.
The table/file should be published in GAR Syensqo Aodocs and named PACKAGE GENERATION PLANNING YYYY.
Refer to the procedure for January is described in this section Beginning of the year (in January YYYY) - creation of the new file for year YYYY
Refer to the procedure for January is described in this section Creation of SIMULATION tables and control on Y-1 Rates at the beginning of the Year (January)
Companies deconsolidated during Y-1 (sold, merged or liquidated) must be excluded from Y scopes.
BFC Admin should check if all the entities sold, merged or liquidated (SYENSQO structure file) have been automatically excluded in every first Y scopes for ACTUAL2 and ACTUAL0 categories.
This is automatically done by BFC as long as the company has been declared as Non consolidated (NC) at closing in Y-1 scope and Y opening scope has been properly setup.
Example: The entities below will be automatically excluded from SYENFULL 2024.12 scope as deconsolidated end of Y-1 (2023.12)

Specific cases - DISCOP & AHFS companies:
Below is described how this process should be done for ACTUAL0 scopes SYENCONSO and SYENFULL and at the same time how to get the initial set of companies for which ACTUAL0 packages should be generated in February.
UPDATE PRINT SCREENS BELOW IN FEB 2024 WHEN DOING THE PROCESS FOR SYENSQO FOR 1ST TIME
1) In BFC_Top_SCO, create YY SYENCONSO and SYENFULL scopes by a save as from YY-1 scopes and put YY-1 scope as the opening scope.

2) Export these 2 new scopes to Excel

3) add 1 more sheet with the list of ACTUAL0 packages generated in YY-1 and name it YY ACT0 packs

4) add the following columns:
In SOLFULL scope? To search for this company in SOLFULL sheet using a VLOOKUP function (Y/N)
In SOLCONSO scope? To search for this company in SOLCONSO sheet using a VLOOKUP function (Y/N)
2022 pack? Y - for companies found in both scopes / N - for companies NOT found in both scopes

5) Cross check in Solvay structure file that the companies for which ACTUAL0 package will not be created are declared merged, sold or liquidated and put that justification in column comment

6) In addition, take the opportunity to check if the YY-1 packages of the companies no more in the scopes in YY are protected in BFC and put the information in the Gsheet in column YY-1 pack protected.


7) The excel file should be stored here
The Oxygen companies are the entities for which reporting simplification measures are implemented for ACTUAL2.: packages are copied from previous period and published by BFC-Admin on non-quarter months.
For January, this procedure is slightly different as we cannot import P&L accounts and BS heading L12000-Profit/Loss from previous period/year.
The special procedure for January is described in this section Oxygen companies - Special procedure (January.YYYY)
Purpose of BFC Work_SCO database is to allow a safe testing of complex or sensitive customizing, ensuring it does not bring any regression. In such cases, usage of large actual data is required and BFC_Work_SCO (being a dump of BFC_Prod_SCO) is the place to do it without any impact on Production database.
BFC_Work_SCO database refresh can be requested to BFC IT team each time there is a need for updated/recent set of actual data for testing purposes.
Such refresh makes full sense beginning of the year when Year End Y-1 results are finalized and 1st reporting of the starting year (January one) is generated, allowing to get in BFC_Work_SCO the Y-1 source for Y openings. as well as 1st exercise of reporting for starting year

Business structures management is entirely documented in a dedicated section Business Structures management in BFC SYENSQO.
Process of updates is organized yearly through a "3 steps / waves" cycle.
Wave 1 - October Y-1: 1st set of expected changes needed for Budget (Controlling cycle)
Wave 2 - December Y-1: 2nd set of changes (late answers from GBU's) / Creation of New objects in BFC
Wave 3 - end of January Y: Activation/Deactivation in BFC for Y reportings
END OF THE PROCEDURE