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: Supervise the quarterly task |
WHY - Describe the objective of the operation
The auditors requested a reconciliation of the P&L where they can see the impacts coming from each source of information (DWISE vs NEWEDGE) registered in SAP.
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.
This procedure will be based on the closure of December 2021. You may find the file saved here: \\NOHVFS01\Treasury-GAR\SES\2021\12 2021\Audi:
![]()
Update the OTE tab with the excel report retrieved from Newedge (just last of the month being closed):
![]()
You will need to input December N-1 report and the month being closed. This tab will feed this table (on TCD MM YYYY):

On this tab we will retrieve information from SAP. Go to FS10N with GL accounts 98300811 and 98300814 and download the YTD perspective in excel. Copy paste the detail in tab
. The last two columns are not from SAP, column activity is a classification done based on the assignment so follow the same classification done in the previous file as well as for column Newedge (Yes/No).
This tab will feed this table (on TCD MM YYYY):

Update the P&L tab with the excel report created from Newedge called "3865 - Purchases & Sales MM.YYYY". File saved here: \\NOHVFS01\Treasury-GAR\SES\2021\12 2021\Newedge
You will need to input a YTD perspective which means you need to have put altogether the different periods into the same table. This tab will feed this table (on TCD MM YYYY):

First refresh the pivot tables in tab TCD and make sure the data source is updated, then we need to update the figures related to ownuse:
![]()
For that go to CO2 pivot file, that is in the same folder, and get the figures from tab Writing:

The information related to SAP are linked to tab
so make sure the formulas are ok and reading the proper information.
At the end check column Ecart and in case there is differences we need to analyze them.
Finally update columns K (F00) and M (F99) with the figures coming from IFG file:

Like mentioned in the file use the colors to better find the information in IFG control. Copy F00 and F99 figures from there and check if the variation is the same as the one in the pivot table in the left side.
The file is sent to auditors through AoDocs.