2.1.1 Reporting Organizer

In the Reporting Organizer module it is created the Reporting ID and it is defined the common data for the packages, as the Deadline, Folder, Set of Controls, Opening Balances, etc.

An option to create the Reporting for a new period is through the option Saving As based in the last version available.

In this procedure it will be created the ACTUAL1-TAX category for the period 2022.03, so the Reporting ID to be entered as reference is ACTUAL1-TAX - 2021.09.

The General tab defines the general properties of the reporting ID.

Enter the following information:

• Category - ACTUAL1-TAX
• Data entry period - 2022.03
• Short & Long description - Phase Tax Reporting- 2022.03

The Definition tab indicates the reporting status. It can also be specified the associated category scenario and the start and end dates for the reporting.

Enter the following information:

• Version: ZZA2103
• Start & End Date: It can be specified the scheduled start and end dates. The reporting status depends on these dates. Enter a large range, e.g. January 1st of current year to Jan. 1st next year.

The Package tab defines the settings of the data entry environment for the packages.

Enter the following information:

• Windows and Internet folder: PROJ-ETR - The documents that will be available for the company in this phase.
• Internet-specific folder: PROJ-ETR - The documents that will be available for the company in this phase.
• Set-of controls: TAXCTR - The controls that are set to check the package data for this phase.
• Control level to be reached: LEV1 - This field needs a special attention, because if any the previous field is changed this one is deleted, always ensure it is filled properly.

• Blocking - Flag the option Blocking.

Opening Balance data:

• Category: ACTUAL2.
• Data entry period: YYYY-1.12 - Inform the period which the opening balances are retrieved. Always December of previous year.
• Scope: SOLVAY14- This scope is taken into account just the consolidated companies.
• Variant: 2 - This information is related to the consolidation rules, in this instance is the variant 2, which considers the IFRS Norms.

The Restrictions tab defines the data entry restrictions which are applied when the data is entered.

The flow F00 (Opening Balances) must be informed in Read-only Flows, this way it will not be available for edition in the package.

Data entry restrictions SSCONSO.

The Operation tab defines the settings to publish the packages. 

In the Deadline it has to be informed the date that the packages will have to be published.

It has to be changed each quarter, according to date defined in the Calendar available in the GAR AODOCs Library.

The Translation tab defines the object descriptions for the selected language. 

Both French and English should be informed.

2.1.2 RU Organizer

In the RU Organizer we define the companies to be reported in the category.

Select the IG and IP packages in the RU Organizer module from category ACTUAL2 / previous period and copy (through the icon  or Ctrl+C). 

Change the period to the one that is being created and paste packages (through the icon  or Ctrl+V).

Then the reporting packages are created in RU Organizer module.

Note that the packages will have the status , meaning that they are still not available in the Package Manager module.

2.1.3 Package Manager

To make the reporting available in the Package Manager module, select all packages and with the right click choose "Generate Package at Current Site".

The package status changes to , meaning that the package are now available in the Package Manager module.

2.1.4.1 Download package data

To pre-load March, 12.YYYY-1 (ACTUAL2) package data should be extracted to csv file.

 Select all packages and Export.

Select the destination folder and name the file following this rule:

ACT2 T1-1 12.YYYY-1 export.csv   (to pre-load 03.YYY)

ACT1-TAX T1-1 03.YYYY export.csv  (to pre-load 06.YYY)

ACT1-TAX T1-1 06.YYYY export.csv   (to pre-load 09.YYY)

In order to extract only the Tax rates accounts we must restrict the selection by using filter TXA0015 on account dimension and flow F99.

Files should be saved here:

https://drive.google.com/drive/folders/1bCP53W8tgw1KP2LVrXtf0k3LSbpq4nye

Check the import Status and Finish.

Exported files should be saved here:

https://drive.google.com/drive/folders/1bCP53W8tgw1KP2LVrXtf0k3LSbpq4nye

2.1.4.2 Prepare the import file

From the export file do a Save as to a new file and name it following this rule:

ACT1-Tax YYYY.03 - T1-1 import.csv

ACT1-Tax YYYY.06 - T1-1 import.csv

ACT1-Tax YYYY.09 - T1-1 import.csv

In the new import file we need to REPLACE:

• dimension CA ACTUAL2 by ACTUAL1-TAX

• both dimensions DP and PE with the period we want to import.

To avoid data rejection in the import we also need to format cells of columns D_RU and D_ORU as Custom / Type "00000".

Files ready to be imported should be saved here:

https://drive.google.com/drive/folders/1bCP53W8tgw1KP2LVrXtf0k3LSbpq4nye

2.1.4.3 Import the file

In Package Manager open File menu and select Import.

Select Replace

Indicate the path to the file to be imported

Preview and check the data to be imported

DO NOT select checkbox Publication and select Import.

Check the import Status and Finish.

Package Status should be Modified 

2.1.5  Communication End users and GAR process owner

Once all packages have been generated, pre-loaded and status checked an email should be sent to Tax Reporting Manager informing that Tax packages are available. 

In BFC web a message on the Homepage should be created 

2.2 Hard Close Tax opening

Hard Close and Year End are managed under a single category ACTUAL2 and a single December period (yyyy.12).

2.2.1 Pre-load of package data

2.2.1.1 Export ACTUAL2 YYYY.09 packs

Export massively the ACTUAL2 YYYY.09 packs for IG & IP companies* filtering on P&L and tax accounts (“Accounts” filter to be used: HC-PLTX - see content).

File exported should be named as 09.YYYY ACT2 export.txt and saved in this folder: 

https://drive.google.com/drive/folders/1nsMddg06K3TwHB2L0IAY6VNR9y9a_CCD

2.2.1.2 Convert the exported file into the HC tax import file

From the exported file a new file must be created by save as and named as 12.YYYY ACT2 HC import.csv.

In this new file we need to clean/change some data as follow:

• Remove all lines for entities expected to leave the consolidation scope between October and Year End - list of companies to be confirmed from GAR team.
• Remove all lines where D_FL column are not F99; F99AJ; F99EX
• Remove all lines where T1 column is not empty
• Remove all lines where D_MARK and D_PMARK columns are not empty
• Remove all lines where D_PAYS column is not empty
• Remove all lines where D_MVTCA column is not empty
• Remove all lines where D_ZADM column is not empty
• Replace YYYY.09 by YYYY.12 in columns D_DP and D_PE
• Formatting of columns D_RU and D_ORU must be with 5 digits (to keep company codes under 5 digits and not to miss the “0”). Format cells of columns D_RU and D_ORU as Custom / Type "00000".

The import file should also be saved in this folder:

https://drive.google.com/drive/folders/1nsMddg06K3TwHB2L0IAY6VNR9y9a_CCD

2.2.1.3 Open ACTUAL2 YYYY.12 reporting period

Choose set of folders and controls applicable for HC Tax - available in reporting set up table Reporting set up

Adapt the deadline for submission according to date defined in GAR calendar 

2.2.1.4 Insert Reporting Units and generate the packages

Select the reporting units from ACTUAL2 September (yyyy.09) excluding:

•  the MEQ (Equity method companies) 
• entities that might have left the conso scope from September and in a near future - this is subject to confirmation from GAR team (Anne Calicis)

Copy through the icon  or Ctrl+C:

Paste through the icon  or Ctrl+V:

2.2.1.5 Import the 12.YYYY ACT2 HC import.csv file

Consult and check the type of rejected data - Should be only calculated data

2.2.1.6 Final checks on the data imported

2.2.1.6.1 Massive Controls through Excel retrieves

In order to ensure that the data imported is correct BFC Admin must run the following excel retrieval file which is comparing P&L and Tax rates in both ACTUAL2 packages: 09 and 12.

If there are companies leaving the scope the following adjustments must be done in the excel file:

• In tabs YYYY.12 TXxx HC F99 / YYYY.12 TXxx HC F00 / YYYY.12 ETxx HC F99 remove the lines for the reporting units that have left the scope.
• In tab P&L HC, column CHECK should only show differences in case there are companies that have left the scope. In this case, add more columns to retrieve 09.YYYY data for these companies and confirm the difference in column CHECK is  equal to the total of companies leaving the scope. 

Link to the excel retrieval file:

https://docs.google.com/spreadsheets/d/1oW1NiskiqqzItybbcWmzLNS5qW7lULHP/edit?usp=sharing&ouid=101127428078004514097&rtpof=true&sd=true

2.2.1.6.2 Selected controls directly in packages

Controls to be made consulting directly packages of the most significant companies:

• 00001 Solvay SA
• 04274 Rh Operations
• 57230 Solvay France

Open the related packages and consult P&L L2018 and each tax schedule to check that:

• Schedule T1-1 is filled with data and other tax schedules are empty and ready for input;
• consult P&L schedule L2018 to check that data is filled

Tax rates check (tabs YYYY.12 TXxx HC F99 / YYYY.12 TXxx HC F00 / YYYY.12 ETxx HC F99)

P&L check ( tab P&L HC):

 2.2.2 Conso definition 

The consolidation definition for HC Tax should be created by a save as of ACTUAL2 09.yyyy / Variant 2.

Scope and exchange rates from period 09 should be kept as latest known when HC Tax starts.

 2.2.3 Communication End users and GAR process owner

A global message has be set up to be displayed in WEB BFCProd Homepage letting BFC users know that HC Tax packages are already available.

An email has be sent to the Tax Reporting manager in GAR (Anne Calicis) informing that packages have been generated and conso created.

2.3.1 Back up of Hard Close Consolidated data

2.3.2 Massive export of ACTUAL2 YYYY.12 packs reported during Hard Close process

2.3.3 2nd massive export of ACTUAL2 YYYY.12 packs filtering on Rxxx headings

2.3.4 Create the massive Import file with purpose of cleaning L2018 (P&L) data

2.3.5 Unlock massively the existing ACTUAL2 YYYY.12 packs (to allow after massive import)

2.3.6 Import massively the “Import file” to clean both P&L HC data and comments

2.3.7 Control that P&L set to 0 and that HC data still there in tax schedules

2.3.8 Switch set of folders and controls from HC to Year End ones 

2.3.9 Add and create the MEQ (equity methods) packs

2.3.10 Create packages for companies entering in the conso scope

2.3.11 Generate all packages and final control