1. OBJECTIVE AND SCOPE
This procedure describes the Tax Reporting process in BFC and the further actions required.
Tax data collection is requested for fully and proportionally consolidated companies on March, June and September trough ACTUAL1-TAX packages, on October (Hard Close) and December trough ACTUAL2 packages.
BFC Admin team is in charge of the reporting set-up and package generation as well as the pre-loading of the packages trough excel (csv) files.
2. REPORTING SETUP
2.1 REPORTING SETUP March, June and September
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.
In the following table (Reporting Set-up) are defined the Folders and Set of Controls to be used for each type of company in each Category.
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.
Before Generate the packages to the Package Manager module, ensure that all the companies are with the correct Consolidation Method (column Entity Portfolio), and if any company needs either to be added or deleted. |
Companies entering or leaving the Solvay Group are registered in the following file Solvay Structure.
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 Pre-load of package data
In order to facilitate CAMs work, BFC Admin pre-loads the tax rates in schedule T1-1, flow F99, as follow:
ACTUAL1-TAX 03.YYYY = 12.YYYY-1 (ACTUAL2)
ACTUAL1-TAX 06.YYYY = 03.YYYY
ACTUAL1-TAX 09.YYYY = 06.YYYY
This pre-loading consists in a manual procedure of export and import package data trough csv files.
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.4.4 Communication
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 REPORTING SETUP Hard Close (October)
Hard Close and Year End are managed under a single category ACTUAL2 and a single December period (yyyy.12).
2.2.1 Reporting Organizer
2.2.2 RU Organizer
2.2.3 Package Manager
2.2.4 Pre-load of package data
2.2.4.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
