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: Worldwide
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
- 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)
- Labels to be used: country_accounting, france, financial_accounting
- E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
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
Responsibility area: Ensure Net Indebtedness 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 "Net Indebtedness". >>
Objective and Scope
1.1. Objective of this Operation
- To ensure Net Indebtedness monthly consolidation closure, I retrieve the data from BFC for the net indebtedness of all companies of the Group. We refresh the Net Indebtedness YYY MM file on D+6/D+7.
- After all tabs are updated, I analyze the full net indebtedness data to ensure compliance and accuracy.
- Treasury will use the information on D+5 and D+10. Net indebtedness provides visibility on the cash available per affiliate. This helps the corporate treasury to centralize understand the cash at Group level.
- We use the data from Trapped Cash tab for Liquidity reports.
- It is a part of IC with external auditors quarterly.
1.2. Scope
ww, treasury_reporting
| Accounts analyzed in this report: | |
| AC=L16100 | Long-term bonds |
| AC=L16800 | Other long-term financial debts |
| AC=L56000 | Long-term loans payable - Short-term portion |
| AC=L57000 | Short-term loans payable |
| AC=L47200 | Accrued interests payable |
| AC=L51900 | Banks - Credit |
| AC=L58200 | Treasury accounts - Credit |
| AC=A26000 | Long-term loans |
| AC=A26900 | Long-term deposits |
| AC=A47100 | Accrued interests receivable |
| AC=A53000 | Long-term loans receivable - Short-term portion |
| AC=A54000 | Short term loans receivable |
| AC=A55100 | Marketable securities > 3 months |
| AC=A55101 | Bonds and treasury bills > 3 months |
| AC=A59510 | Other current financial assets - Write-down |
| AC=A51100 | Banks - Debit |
| AC=A59100 | Provision Banks |
| AC=A52000 | Term deposits - Cash equivalents |
| AC=A55000 | Marketable securities < 3 months |
| AC=A55010 | Bonds and treasury bills < 3 months |
| AC=A58100 | Treasury accounts - Debit |
| AC=A59200 | Provision for short term deposits |
| AC=A59500 | Cash & Cash equivalents - Write-down |
2. Definitions
See Finance Glossary:
- BFC
3. Tasks description
3.1. I retrieve the data from BFC for the net indebtedness of all companies of the Group
3.1.1. I update "Historical" tab
Purpose: to update the financial figures for the reporting month.
Steps to execute:
Go to the tab 
, copy the columns from the previous month - change the color of the columns from the previous month and copy past values. The purpose is, when doing the retrieve from BFC, only the information from the current month is retrieved.
3.1.2. I update the "Input" tab
Purpose: to update the dates to the reporting month. This dates will be used to extract the data from BFC.
Steps to execute:
The file is located: 
\\lucapfs01sco.oxo.priv\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\2 - Treasury and net debt\2025\07.2025\Net Debt
Go to Input tab 
and update the month's data.
M - > reporting month
M-1 - > previous reporting month
Y- > reporting year
Y-1 - > previous reporting year
Example:
3.1.3. I retrieve the information from BFC
In this step we will retrieve the information from BFC. For this, we should:
- Import data "In Sheet" for tab "Rates"
- Import data "In Sheet" for tab "Cash For Treso"
- Import data in "Cell Range" for tab "Historical" selecting only the cells corresponding to the current month
3.1.4. I check and validate the information in "Detail" tab
For each heading, we should validate the accuracy of the amounts reported and justify uncommon or big variations or amounts .
At the bottom of each heading, there is a "check" that should be "zero", to make sure that all legal entities are included. If not "zero" it means that a new legal entity is missing in our report and it should be included.
When validating heading L51900, there will be an amount related to the cut of the cash pooling between 4044 and 2232. At the end of the day, the cash from 4044 is pooled to 2232. However, due to the different time zones, the cash from US only arrives in 2232 in the next day. In order to have the correct balances at the end of each month, we do a Top Entry in BFC Consolidation (TSE). The instructions are in the Net Debt File.
3.1.5. I check the information in "Summary Reporting" tab
After all the updates and validations, we check the report in 
This report will be used also in the quarter Presentation prepared by the team and stored in G Drive (SYENSQO Financial Instruments and Financial results Reporting - QQ.20YY).
3.1.6. I check and inform Treasury about "Cash"
Purpose: Treasury will use the information on D+5 and D+10. Net indebtedness provides visibility on the cash available per affiliate. This helps the corporate treasury to centralize and understand the cash at Group level.
After the top entries posted, we need to retrieve again the information from BFC. For this purpose, import BFC data "in sheet" in tab "Cash for Treso".
After retrieve the data from BFC for the month being closed, make sure that "check" is zero. This means that all entities are included.
If not "zero", include the company that is missing. The info on the column "Control" is taken from List of Companies.
The info in the "label" column can be checked with Treasury Front Office.
Mainly M&As or some countries can be considered as Trapped Cash due to it is difficult to repatriate cash to the headquarters due to the legal reasons.
Insert the line in the correct place of the report to respect the sequence.
Copy the formulas from the line above or below and change the new legal entity number in the column A only.
Re-do the new BFC retrieve.
Check the name and other columns of inserted cell is correctly updated for the new legal entity.
After the data is updated, due to the treasury does not have access to BFC, we need to copy the sheet to a new book and save it without formulas.
After, send to Treasury Front Office team (email subject "Cash for Treso MM/20YY").
End of document.