Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. 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. |
WHY - Describe the objective of the operation
This objective of this reporting is to control and explain the cash flow from financing at Group consolidated level.
Detail the scope (legal entities, etc.)
WW Solvay Group (consolidated perimeter)
Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary
See Finance Glossary:
WHAT and HOW - Main content of the operation
The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.
Select the level of heading in the "Paragraph" option.
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

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).

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.
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.