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: Ensure consistency of data until 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

Reconciliation of cash out/in transfers between newedge and SES. This consistency check makes sure that all transfers occurred during the month are well booked in accounting of SES.

1.2. Scope

Detail the scope (legal entities, etc.)

This procedure applies for company 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:

SES / IBA / CAM


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.

3.1. I check cash transfers

3.1.1. I retrieve report from newedge

First access pulse website and click on reports:

Enter the date (from the first working day until D-4)


Then select "Listed Derivatives"


Then select "Activity" and download the file has a xlsx format


Go to \\NOHVFS01\Treasury-GAR\SES\2020 and get the excel file from previous month and create a new file for the current month: 

Copy the tab to the new file.

3.1.2. I show how to prepare the file and reconcile the cash

In file "D-3 - Cash transfers check" you may now update the data source of the pivot table or in case you copy paste the new data into the tab "Activity" and replace the previous one, just refresh the pivot table in tab "3865 - Cash Activity".

Once the pivot table is refreshed we will only look at the description that starts with "FUNDS PAID" and "FUNDS RECEIVED". Each element matches to a cash transfer reported in newedge. The following print screen will show you 20 cash transfers made during the period being analyzed:

Our next move will allow us to see if we have in the books of 3865 the same amounts waiting in a transitory cash account.

Go to GL account 52000100 through FS10N, select the period being analyzed and on assignment filter the information with *mprq*. Separate the EUR from the USD and you can take a print screen to put inside the file:

If both amounts matches it means that our accounting = newedge reporting = no cash transfer is missing from reconciliation. However sometimes its not the case. Please find the following scenarios where we can have discrepancies:


Scenario 1 - Funds received in 0231 company not yet allocated to 3865

Usually all cash transfers, in & out, are made through company 0231. Our starting point of investigation is the IBA 591+++3865 in 0231. Here we can go after the AR accounts where we usually receive the funds from newedge.


Scenario 2 - Funds received/paid in 3865 but not yet allocated to 52000100

Finance operations team are in charge of clearing the transitory accounts related to IBA transfers. Usually they receive instructions from the CAM to allocate the funds to 52000100


Scenario 3 - Funds allocated to account 52000100 with wrong assignment


Scenario 4 - Funds not allocated properly to Solvay account (newedge side)

SES sends funds to newedge and they do not allocate them properly to our account. Whenever this happens we need to check the statement of SES01 and see if all movements are reported in the books of 3865 matches. You may send an email to the CAM of SES and middle office explaining your difference. Middle office will then contact newedge to solve the issue.


Last but not least please update the date on the tab the date on the pivot table as well:

End of document.