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
- 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)
- Labels to be used: country_accounting, france, financial_accounting
- E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
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
Responsibility area: Ensure Financial Instruments monthly closure.
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
<< I prepare CFH allocation for Currency Reporting. >>
1. Objective and Scope
1.1. Objective of this Operation
The purpose of this procedure is to prepare and share with the 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. Scope
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 in:
\\lucapfs01sco.oxo.priv\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\1 - Financial Instruments\2024\07. July\CFH company allocation
This procedure must be done until D+10 and shared with the 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:
FX Management:
Cash Flow Hedge:
CFH version 2:
Run the query and as soon as you get the report, go to
, remove the GBU Market and add the Entity (company code) in the second position. Adjust the information levels accordingly:
the changes
Export the report to Excel. 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.
Save the file in the folder as
3.1.2. I prepare the file CFH allocation FX MM YYYY_SCo_Support file
Open the file and copy the MVI information regarding CFH HP sales strategy for company 2232 only and paste it in the tab 
Update the pivot table in tab "Allocation":
And ensure that the information is in line with SAP:
Get the % of allocation from the file previously done, through a Vlookup formula:
The table below is linked by formulas to the CFH pivot table and the % in order to perform the calculation accordingly:
Check if the control at the bottom is zero, if not it is because most probably a company is missing.
Afterwards, update the rates concerned to this procedure in tab Rates through a BFC retrieve:
It is required to get the rates because the figures will be shared at the affiliate currency, not only EUR (2232 reporting currency).
Finally, in tab "Company Allocation", refresh the pivot table in order to get the amount per company code, for Assets and Liabilities:
Below, in the same tab you will find the tables with the figures to be shared with CAMs. The sharing will be done in a dedicated gdrive folder.
These tables are linked to the pivot table above and the exchange rates in tab "Rates" so that the figures are displayed in each company's currency and not in EUR. 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
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:
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.
Finally send an email to all the CAM's under the scope of this procedure with the link to the folder.
