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: Supervise the closing activities D+1

Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)


Scope

3. Remove the icon when not applicable


ERP



Frequency


 

 

 

References

6. Add the link to SAP transaction(s) (when it exists)



Forms

7. Insert the links accordingly and change the link text with the Form name



Attachments

8. Add the link to attachments or external links




Previous operation << >> Next operation



1. Objective and Scope

1.1. Objective of this Operation

WHY - Describe the objective of the operation

We are performing an analysis that allows us to reconcile the difference between two sources of information: DWISE and Newedge, determined on the Pivot CO2 (chapter 3.3.3, caption d) of procedure I prepare CO2 pivot file)


This difference consists from:

a) A price difference between the Newegde market price and the price used by Dwise (curves);
b) A difference linked to the fact that in Newedge we have the impact Fees (that are not managed in Dwise).

1.2. Scope

Detail the scope (legal entities, etc.)

This procedure applies to Solvay Energy Services (Company code 3865)

2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:


3. Tasks description

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.

We start by copying the last month´s file and save it in the month being closed folder in \\NOHVFS01\Treasury-GAR\SES\YYYY\MM

Inside the file you will find 3 tabs:

Please copy each tab and update the period on the tab name.


3.1. I update tab NEWEDGE OTE SES MMYYYY

We need to access Newedge and download a report named "Prior Day(s) Positions by Account" in xlsx format:

You can find the procedure on how to get the reports from Newedge here: I prepare Newedge Reports D+1

Now we need to work the report downloaded before you can copy it to the tab:

a) We only need SES 01 (CO2). In column "Account" delete all other accounts and keep SES 01 due to others belong to other commodities

b) In Business Date column just keep the numbers concerned to the last day of the month. Example: as soon as you download the file you will see a number like this:

 where 2020 (year) 07 (month) 01 (day)

We only need to keep the lines containing the last day of the month (you may delete all other ones). Next please replace the number to a date:

c) Between columns "H" (Contract description) and "J" (Maturity) add a new column. We will designate the type of CO2 in this new column created and we will use the contract description to help us determine this information:

First if you spot "call" or "put" you may delete the lines:

If we now search for "CER" we may add that designation to the new column:

If we now search for "Emissn" they are all for "EUA" which relates to CO2:

d) Please pay attention to columns "Closing Price" and "OTE" because you need to check the format of the numbers (comma and point => I usually replace all points to commas);


How to update the tab 

We need to delete the M-2 information from the tab and add the new data below M-1. Example for July 2020 closing:

On column Y make sure that the formula on column "Y" is also updated.

We need to replace the information on column "U" from number to date: 

a) Copy the information just for the current month from column "U" to "AA";

b) Update the formulas from column "AB" to "AF"

c) Copy the information on column "AF" back to column "U"


3.2. I update tab BDD DWISE MMYYYY

We need to delete the M-2 information from the tab and add the new data below M-1. Example for July 2020 closing:

To add the new information please go to file CO2_pivot mmyy (saved in GAR drive: \\NOHVFS01\Treasury-GAR\SES\2021\11 2021\Other Accounting Files) and copy paste the information tab "Analysis MM YY" of the month being closed. Update the column "A" (Business Date) with last day of the month.

3.3. I update tab TCD MMYYYY

We need to update the two pivot tables:

After this update the maturity dates per commodity should match.



3.4. I analyse écart Newedge vs DWISE

These tables are built with information coming from the pivot tables so we need to adjust the formulas in each column. We also have two ways of analysis:

1 - From columns Q to S: we will determine the price difference (PU difference) and see how much MtM we have has a difference

2 - From columns J to P: we look at the MtM information from each source and determine its difference. You also need the information from SES01 P&L month impact reported on  (\\NOHVFS01\Treasury-GAR\SES\2021\11 2021\Newedge) to update the P&L impact reported here:


In the end both differences should match the difference that we see on CO2 pivot table. Example from July 2020 closing:



In case of differences, speak with CO2 controller or CAM.

The root cause could be price differences in different systems.


End of document.