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: Supervise the closing activities D+3 |
WHY - Describe the objective of the operation
This procedure will show you how to present in a consolidated way the amounts reconciled in I prepare IFG control file
Detail the scope (legal entities, etc.)
This procedure applies to Solvay Energy Services (Company code 3865)
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.
You may copy the previous file and save it on the current drive \\NOHVFS01\Treasury-GAR\SES\YYYY\MM
Example from April 2022:
![]()
First we need to update the periods:

Then we need to update the tables (Trading and Hedge/OCI summary) for F00 (in January only) with December M-1 data, for that goes to previous year and copy paste the figures in the tables accordingly:

![]()
![]()
Every month, we have to update F99 in the tables below:

Once we have started to perform LT/ST reclass and IFG file does not have the split we need to go to "Long_short term DDMMYYYY" file that you will find in the same folder:
![]()
And there you can get the detail from tab
:

![]()
Copy paste the figures from LT/ST file to Summary table file into tab
. This tab is linked to tab BS and so as soon as you copy paste the figures, tab BS will be fulfill with the data accordingly. Make sure the controls are zero at the end of each table.
3.2. I update P&L and cash tab
First copy the M-1 data into the correct columns:

Does the same for each table/flow (F15, F61 and F32)
Next you may copy/paste the tab
from IGF file and then make copy paste values in order to eliminate the formulas and links.
Tab P&L and Cash is linked to this one so in order to update the links replace 'Synthèse Flux M-1' by 'Synthèse Flux M' and the formulas will be automatically updated:

Finally make sure that the controls are also zero as well.
In tab
just perform a retrieve

I inform Finance director of SES, CAM and controllers that he IFG control and Summary files are ready and available on the Treasury GAR drive: