Tasks to be completed when documenting an operation (from creation to publication)

1. Enter the Title of the operation / page

2. Add the following Labels:

    • Scope of applicability: ww, country_accounting

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam,uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore, new_zealand, emea_transversal, apac_transversal

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)

3. Fill in all fields as described above

4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) -" I do something..."

5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow

Domain: Financial Accounting

Responsibility area:

Table of contents 


Scope

ERP

Frequency

References

Forms

Attachments

 

BFC Reporting - Blocking controls analysis >> BFC Reporting - dashboard



1. Objective and Scope

1.1. Objective of this Operation

The objective of this procedure is to identify and categorize the blocking controls obtained during the month.

 

1.2. Scope

The scope of this procedure is worldwide, applicable to all BFC reporting companies from PF1, WP1 and PI1 systems.


2. Definitions

Deadline proposal: Every Month, on D+6.

See Finance Glossary:


3. Tasks description

3.1. I request for Blocking Controls Extraction

On D+4, send an email requesting the blocking controls report.

Recipients:

Note: Blocking controls from EMEA should be extracted manually


3.2. I perform the Blocking Controls Analysis

3.2.1. I prepare a new sheet to copy new information

Access the Blocking Controls Analysis folder in Google Drive, create a new file for the current month, and use the previous month’s file as a template to ensure formulas are copied.




3.2.2. I update the reference data

Update the GAR List: The GAR List must be updated quarterly or whenever there is a change or a new entity.





3.2.3. I adjust the sheet to gather information

Rename the second tab to the month being analyzed, update the date in column B (Month), and clear columns G and H.





3.2.4. I compile the Blocking Controls received

From the files received from APAC, NAM/LAM, and Treasury, copy and paste the BFC codes and corresponding blocking control codes into columns G and H.








3.2.5. I extract manually the EMEA Blocking Controls

Manually extract the EMEA blocking controls by accessing the "Monthly Upload Robot - Blocking Control Extraction - 2024."


Extract the blocking controls for the countries listed in the "Instructions" document.


For each country, find the files for the month being analyzed, and copy and paste the blocking controls and BFC codes.




3.2.6. I do a sanity check

Some BFC codes may not be found. Verify the correct codes in the GAR list if needed.


3.2.7. I remove the Solvay companies

Filter out the ECO companies and delete it from the file to ensure the analysis is performed only for SCO companies.


3.2.8. I ensure data to be analysed is considered

 In the "Analyses by Control" tab:

  • Clear data from columns I, J, K, L, M, and N starting from row 4 (previous month’s data).


  • Copy data from columns B, C, D, E, F, and G from row 4, then paste as values only into columns I, J, K, L, M, and N starting from row 4.


Ensure the values in column O are divided by the last value in column N.



3.2.9. I ensure consistency

In the "Pivot Table" tab, verify that the total in column B matches the total in column N from the "Analyses by Control" tab.





3.3. I update the Dashboard

3.3.1. I access the Dashboard and feeding file

Access the Dashboard and open the file "Dashboard 05_2022 onwards" to find the "Feeding Data" sheet.






3.3.2. I copy information to the feeding file

Copy the columns B, C, D, E, F, G, H, I, J and L from the tab "07.2024" of the file "Blocking Controls Analysis" and paste it as values only into the file "Production BFC - Blocking Control 2020 DataStudio V3.0" in their respective columns.








3.3.3. I verify all information is being correctly considered in all charts

Verify that the current month information is displayed correctly in all charts in the Data Studio dashboard. If not, check the file configuration, data source, and chart parameters.


On page 2, update the "Topic Prioritization" title with the month being analyzed.



End of document.