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: Treasury Reporting

Responsibility area: Perform Financial Charges Cash monthly closure.

Table of contents 


Scope

Please remove the icon when not applicable.


ERP

Please remove the icon when not applicable.
Frequency

Please remove the icon when not applicable.
References



Forms



Attachments


 

 

<< I update the file "Financial Charges Cash". >>



1. Objective and Scope

1.1. Objective of this Operation

This objective of this reporting is to control and explain the cash flow from financing at Group consolidated level.

1.2. Scope

WW Solvay Group (consolidated perimeter)

2. Definitions

See Finance Glossary:

  • ...


3. Tasks description

3.1. I retrieve the data from BFC for the Financial Charges Cash of all companies of the Group

3.1.1. I update the reporting periods in the "input" excel sheet

Open file "FI cash MM20YY" stored in \\lucapfs01sco.oxo.priv\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\2 - Treasury and net debt\2025\MM.20YY\Financial Result


3.1.2. I refresh the data to be analyzed in sheets YTD M 


3.1.3. I copy the information in AB column (paste special values) to AC column in sheet YTD M

After retrieve data from BFC, copy the information in column AB to column AC by pasting values, so we have the data before we perform the top entry (in the next step).


3.1.4. I prepare the top entry to cancel the non cash impact of the amortized costs for the closing month

The purpose of the top entry is to eliminate the non cash items from the cash flow from financing.

Extract the information from SAP. Go to FBL3N (for all companies that have senior bonds) and extract the information YTD by selecting "All items" since 01.01.20YY until the date of the reporting closure. The extraction needs to include all the accounts of Senior bonds headings (L16100 and L56000).

Save the information in the file "TOP_ENTRY_FI_CHARGE_CASH MM20YY" stored in \\lucapfs01sco.oxo.priv\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\2 - Treasury and net debt\2025\MM.20YY\Financial Result and post the top entry.

After the top entry done in BFC, add the amount of the calculation to the reporting file.



An refresh YTD M sheet.


The column with the delta should become zero.


Note: only recurring items are included in this procedure. Every month we should analyze if there is any new situation that should be considered on the top entry calculation. 


3.1.5. I analyze the results

Once all is ready, analyze the data in sheet "Summary actual vs BDG" and make sure that they are in line with the expected forecasts/budgets.


End of document.