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 make a reconciliation between SAP vs Posting files (Trade, Arbitrage, Asset Management 03rd parties, Hedge) to guarantee the consistency result booked in accounting

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.

Example file from closing 07.2020:  File saved here:\\NOHVFS01\Treasury-GAR\SES\2020\07 2020

3.1. I retrieve open items from SAP

In SAP (WP1), use FBL3N with open items for the current month with the view called "/LUIS":

Using the following selection of GL accounts that are related to Financial Instruments or choose variant /Energy D+2 C

46110000
46112000
46112010
46112560
46113562
12805000
46910000
46912000
46912010
46912060
46112060


Create a pivot table with the following criteria: Download the list to excel and create a new column where you can identify the source of information. The column is at the end of the file. Select the column and change the formula replacing the month from M-2 to M-1

Arbitrage- file arbitrage (folder Official Accounting files)

Hedge - file hedge  (folder Official Accounting files)

Trade - file Trade (folder Official Accounting files)

Asset Management - file Asset Management 3rd party (folder Official Accounting files)

CO2 pivot - file CO2 pivot (folder Other Accounting files)

Options -  file CO2 pivot (folder Other Accounting files)

Prov volume - file provision volume  (folder Other Accounting files)

RP - reserve policy (folder Other Accounting files)

TMS - Check file Quantum F99 FI MM stored here \\capfs01\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\1 - Financial Instruments\2021\11. November\CICC (accounts liked to TMS 46112560, 46113562, 46912060, 46112060)

GL account 12805000 is OCI account so it remains blank in column "File"

Report Filter

Trading partner => "Blanks"

Row Labels 

Files | Account 

Values

Amount in local currency


3.2. I retrieve all items from SAP

In SAP, use FBL3N with all items from a YTD perspective:



Using the same selection of GL accounts mentioned above (3.1. I retrieve open items from SAP) or use the variant /Energy D+1YTD

Download the list to excel and create a new column where you can identify the source of information. The column is at the end of the file. Select the column and change the formula replacing the month from M-2 to M-1

Create a pivot table with the following criteria:

Report Filter

Trading partner => "Blanks"

Row Labels 

Files | Account 

Column Labels

Transaction type

Values

Amount in local currency

3.3. I check flows vs MtM figures

From each chapter above you will end up with something like this:

F99 - tab PT open MM.YYY (update the data source and refresh pivot tables)


Intermediate flows - tab PT flows MM.YYYY  (update the data source and refresh pivot tables)

You may open each accounting file and compare each summary flows with these tables. 


3.4. I prepare tables for IFG control check

Create two additional the pivot tables based on the ones created on chapters 3.1 and 3.2:

F99

Intermediate Flows

The only difference from the other pivot tables is the trading partners: here we are considering everything. Why? This chapter will only be concluded as soon as you prepare chapter 3.5.5 of I prepare IFG control file where we are reconciling the official databases with accounting:



End of document.