Hide If

group	confluence-users

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

Panel

bgColor	#F7F7F7
titleColor	#ffffff
borderWidth	1
borderStyle	none

Domain: Treasury Reporting

Panel

bgColor	#F7F7F7
borderWidth	1
borderStyle	none

Responsibility area: Ensure Financial Instruments monthly closure.

1. Objective and Scope

1.1. Objective of this Operation

The purpose of this procedure is to prepare and share with the CAMS CAMs the Cash Flow Hedge (CFH) allocation per company code, for FX currency.

In order to optimize the process, CFH in future sales is centrally managed by 2232 then, on a monthly basis, the realized result/settlements are reinvoiced to the affiliates based on a key % of allocation, per GBU, which is defined by Corporate Treasury team. On the other hand the MtM is booked and reported only in 2232 accounts and that is why we share with the CAMs on a monthly basis the amounts that belong to their companies in case they need to perform any statutory booking related to OCI.

1.2. Scope0231, 3865 and related affiliates.

Syensqo entities contracting Cash Flow Hedge (CFH).

2. Definitions

See Finance Glossary:

...

3. Tasks description

3.1. I prepare the information for CFH FX currency

Go to a previous month and copy the files from folder "CFH company allocation" located herein:

\\capfs01lucapfs01sco.oxo.priv\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\1 - Financial Instruments\20222024\0407. AprilJuly\CFH company allocation

This procedure must be done until D+10 and shared with CAM'sthe CAMs.

3.1.1. I get the % of allocation per currency pair and company code

In order to get the % of allocation per company code go to Quantum and get the report that shows the CFH allocation per currency pair and company code:

Select Analytics , -> Queries:

Image RemovedImage Added

FX Management:

Image RemovedImage Added

Cash Flow Hedge:

Image RemovedImage Added

CFH version 2:

Image Added

Image RemovedImage Added

Run the query and as soon as you get the report, go toImage Added, remove the GBU Market and add the Entity (company code:) in the second position. Adjust the information levels accordingly:

Image Added

Image Added the changes

Image AddedImage Removed

Export the report to excelExcel. Delete the columns that you do not need (keep just the total hedge per month and the Syensqo companies) and at the end sum the total for the unrealized part (months not realized/settled yet) and find the percentage per currency pair and per company.

Image RemovedImage Added

Save the file in the folder : Image RemovedasImage Added

3.1.2. I prepare the file CFH

company allocation

allocation FX MM YYYY

_SCo_Support file

Open the file and copy the MVI information Copy the information from MVI file regarding CFH HP sales strategy , 0231 for company only, into this file. 2232 only and paste it in the tab Image Modified

Update the pivot table in tab "Allocation":

Image Removed

Image Added

And ensure that the information and make sure it is in line with SAP:

Image RemovedImage Added

Get the % of allocation from the file Image Removed file Image Added previously done, through a vlookup Vlookup formula:

Image Removed

Check if there are new companies to be included.Image Added

The table below is linked by formulas to the CFH pivot table and the % in order to perform the calculation accordingly:

Image RemovedImage Added

Check if the control at the bottom is zero, if not it is because most probably a company is missing.

ThenAfterwards, update the rates concerned to this procedure in tab Rates through a bfc BFC retrieve:

Image Removed

Image Added

It is required We need to get the rates because we will share the figures will be shared at the affiliate currency, not only EUR (0231 2232 reporting currency).

Finally, in tab "Company Allocation", refresh the pivot table in order to get the amount per company code, for assets Assets and liabilitiesLiabilities:

Image RemovedImage Added

Below, in this the same tab you will find the tables we will use to share with the figures to be shared with CAMs in the google file located here

Image Removed

. The sharing will be done in a dedicated gdrive folder.

Image Added

These This tables are linked to the pivot table above and the exchange rates in tab rates so we can show "Rates" so that the figures are displayed in each company's currency and not in EUR. Check Always check if the formulas are properly linked.

After preparing the file CFH allocation FX MM YYYY_SCo_Support file, copy paste (values only) the information in tab "Company Allocation" to a new tab in file FX MM YYYY_SCo_Summary (this format will allow an easy consultation in gdrive)

3.2. I share the information with the CAMs

Now that files are ready, go to Financial Instruments folder and create the google file for the month being closed with this information. The files are located here.

You may copy the file from previous month Image Removedand update the figures accordingly.

Tab FX:

Image Removed

Save the excel files into the drive as evidence and in case CAMs would like to get further details:

Image Removed

When the files CFH allocation FX MM YYYY_SCo_Support file and CFH allocation FX MM YYYY_SCo_Summary are ready, the information is shared with the CAMs in a dedicated folder in the following gdrive location:

Image Added

After entering the folder "Yearly Process" select the year and create a folder for the month being reported and upload the Summary and Support files.

Image Added

Finally send an email to all the CAM's under the scope of this procedure with the link to the folder.

Image Added

End of document.

Viewtracker

hide	true

Space shortcuts

Page tree

Versions Compared

Old Version 2

New Version Current

Key

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

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

Table of contents

Scope

Please remove the icon when not applicable.

ERP

Please remove the icon when not applicable.

Frequency

Please remove the icon when not applicable.

References

Forms

Attachments

1. Objective and Scope

1.1. Objective of this Operation

2. Definitions

3. Tasks description

3.1. I prepare the information for CFH FX currency

3.1.1. I get the % of allocation per currency pair and company code

3.1.2. I prepare the file CFH

allocation FX MM YYYY

_SCo_Support file

3.2. I share the information with the CAMs

End of document.

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 2

New Version Current

Key

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

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

Table of contents

Scope

Please remove the icon when not applicable.

ERP

Please remove the icon when not applicable.

Frequency

Please remove the icon when not applicable.

References

Forms

Attachments

1. Objective and Scope

1.1. Objective of this Operation

2. Definitions

3. Tasks description

3.1. I prepare the information for CFH FX currency

3.1.1. I get the % of allocation per currency pair and company code

3.1.2. I prepare the file CFH

allocation FX MM YYYY

_SCo_Support file

3.2. I share the information with the CAMs

End of document.