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+2


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 perform a reconciliation on the result of CO2 activities for the controller. We provide him with the monthly variation between the different nature of results:

Realized impact

Unrealized impact

Options

Commissions+Écarts

CO2 stock valorization


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 will use as a reference file  from the July 2020 closing. You will see that the file contains 6 tabs:

Each tab will provide relevant information to determine the monthly result that we see in KE30 on B31:

MB5B tab - Stock movements in SAP and cost of good sales

DWISE tab - Stock movements in DWISE and realized result in exchange market

KSB1 tab - Impact from Cost centers postings

Analysis tab - Final result from the outcome of the previous tabs

3.1. I update MB5B tab


Tab 

The transaction MB5B allows us to see the stock movements occurred on a specific period and we will be able to examine the impact on KE30 D00:

How to get the information:

a) Go to MB5B in SAP

b) Fill accordingly

c) We need to change the layout and insert two new columns:

d) Download the information to excel:

Save the file as an excel workbook. We will also use this excel file to build the rest of the analysis.


Tab 

You may move/copy the information to the new file you downloaded. This will helpful to determine the customer/vendors where the stock went to.


Tab  

Copy the information from tab MB5B and create four new columns:

Go back to SAP and from each line, go to the PO to get the customer/vendor number to put in our tab. How?

a) Position your cursor on the document number ==> double clik

b) Click on 

c) Double click on

d) Get the information you need. Example for customer

Example for vendor

e) Associate the name to the number using the information on tab "VendorCustomer"

3.2. I update DWISE tab

From the file CO2 pivot copy paste the information from DWISE in to our file. Add a new column "Year/Month" from the maturity dates to allow us to filter the information when necessary.


3.3. I update KSB1 tab

In SAP go to KSB1 transaction:

And download to excel the result. You transfer the tab in to our analysis file and perform the following adjustments:

a) Create two new columns

b) Delete all lines with reference to "ORBEO":

c) Build the category column according to the name column. We have the following association table but please bear in mind that it may appear postings that we need to investigate what they are:

d) For column KE30 we are differentiating the amounts that the cycles allocate to each amount:

Cost center: 2295-1110 KSB1 = KE30

Cost center: 2295-1140 KSB1*0,24 = KE30


3.4. I perform analytical review

We will now justify the result that we see in KE30 (180keur):


How to get this table from SAP?

a) Go to KE30 and use the following operation:

b) Select

c) Fill accordingly

d) Filter according to magnitude market "GYON":

e) We need to see B00 and D00 reclassified to B31. To make sure that´s the case please see column "Manual Posting":

B00 (359keur) - D00 (218keur)= = B31 (141keur)

Contact Finance operations if you don´t have this reclassification. Please find an example of the request:


We have the information coming from tab "Data"


Here we are able to see the stock movements. Overall an increase of stock of CO2 in 16.329Ton with a cost of good sales of 218keur:

This is another view on the stock variation where we reach the same conclusion:


We have the information coming from tab "DWISE"


We have the same conclusion. This means that all contracts matured had an impact on stocks in SAP. Its important to understand that the impact of this realized result (OtC market) does not come from our postings with CO2 pivot.

For July we do not had any matured result for exchange market, otherwise you would see something like this as well:

In this case this realized impact is posted with CO2 pivot and we will see the impact coming from the cost centers section. All deals in exchange market are back to back which means that we have no stock impact in SAP.


We have the information coming from tab "KSB1"


This result matches with the information we see in KE30:


We have the overall impact of the month


End of document.