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: 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 monthly closing activities.

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

Please remove the icon when not applicable.


ERP

4. Remove the icon(s) when not applicable

Please remove the icon when not applicable.
Frequency

5. Remove the icon(s) when not applicable

Please remove the icon when not applicable.
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

Margin Call account is the amount that must be available in a trader's account to keep the trade open so basically it is the initial margin requirement to be able to trade in the market through a clearinghouse (broker) and this procedure will show you how to get the detail of Margin Call accounts and which commodities are contributing for the that. 

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.

You may start by copying the file from previous month and update the amounts based on files/postings files used for closure.  In this procedure we will use April 2022 as example. So go to \\NOHVFS01\Treasury-GAR\SES\2022\04.2022 and copy file  

Then go to SAP, transaction FS10N and take a screenshot of the amount in Margin Call accounts (55100100 - MARKETABLE SECURITIES-OTH CURRENT FINANCIAL ASSETS + 57000100 - SHORT TERM LOANS:

 

Note: For the postings related to margin calls we are using GL account 55100100 for assets and 57000100 for liabilities but in order to present the net value, that in this case is a liability we perform a posting to transfer the balance from GL account 55100100 to 57000100, which we call net of margin calls and it is described in the procedure I net margin calls accounts D+2 (2) (2)


In order to update the pivot tables in tab  we need to get the figures from Energy Official file and CO2 official file or we can display both accounts mentioned above through FBL3N make a subtotal by assignment and check which posting files contributed to the postings done under margin call accounts:





Usually, the files that contribute to margin calls accounts are Energy trade, Arbitrage and CO2 pivot.

Please check below how to get the figures from each file.


Note: In the file we always show the variation from the beginning of the year until the month being closed so please do not delete the information already there but copy at the bottom in order to keep the figures from Dec Y-1 and the cumulative balance of the year being analyzed. The last 4 columns in the file are not copy paste from other files so please updated them accordingly:

Date: insert manually the end of month being added;

Quarter: insert manually the quarter of the month being added;

Year and Month: linked to column "Maturity Date" by formula in order to get the month and year of each deal.


3.1. I update the data from the file SES FI - YYYYMMDD Energy Trade.


You can find the Energy Trade file in the folder Official Accounting Files, in this example: \\NOHVFS01\Treasury-GAR\SES\2022\04.2022\Official Accounting Files


Open the file and check if you have amounts in the table related to Newedge (exchange deals excluding transfer deals), tab :


In this example there are no postings in Margin Calls related to Trade file but in case there are figures you may perform the following selections/filters in tab Analysis M in order to get the detail per deal:

  • Deal type: select only exchange deals (Future, Future Power and PX Future) 
  • Counterpart: Exclude Transfer Deals
  • Risk Date: select After today

3.2. I update the data from the file SES FI - YYYYMMDD Energy Arbitrage.

You can find the Energy Arbitrage file in the folder Official Accounting Files, in this example: \\NOHVFS01\Treasury-GAR\SES\2022\04.2022\Official Accounting Files

Open the file and check if you have amounts in the table related to Newedge (exchange deals excluding transfer deals), tab :


The first 3 lines in SAP are the net amounts for SES03, SES04 and SES06:

In order to find the detail per deal, go to tab Analysis M and perform the following selection: 

  • Deal type: select only exchange deals (Future, Future Power, Forward Clear, PX Spot and PX Future) 
  • Counterpart: exclude Transfer Deals
  • Risk Date: select After today

Then check if you get the same amount in column MtM Uncertain (€ 86.798.022 in this example) which mean we have all the deals.

Copy the lines selected and paste in SES - Margin Calls MMYYYY, tab Database. Check if the columns are aligned.  

3.3. I update the data from the file CO2 pivot MMYYYY.

You can find the CO2_pivot file in the folder Other Accounting Files, in this example: \\NOHVFS01\Treasury-GAR\SES\2022\04.2022\Other Accounting files

Open the file and go to tab TCD, pivot tables related to exchange deals. Check if the MtM in the pivot tables match with the amounts in margin calls accounts in  SAP:




Open the detail of each pivot table, copy the lines selected and paste in SES - Margin Calls MMYYYY, tab Database. Check if the columns are aligned.  


After having all the information in the Margin Calls file, check the column MtM Uncertain to make sure the amounts match with the figures in SAP. Refresh the pivot tables in order to get the proper details by month and per commodity:


Additionally, add also the screenshot of pledge cash account, a request from Corporate Treasury team for their reference:

3.4. I send the file SES - Margin calls to the reporting team and corporate treasury.

Now the file is ready, send the it to reporting team and corporate treasury team by email:



And save it in the reporting drive as well: \\NOHVFS01\Treasury-GAR\Reporting\2022\04.2022



End of document.