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: Ensure Financial Instruments monthly closure.

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

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

Detail the scope (legal entities, etc.)

0231, 3865 and related affiliates.

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.

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 here:

\\capfs01\LUCAP-USERS\Financial Controlling & Cash Accounting process\7 - Financial Controlling\3 - Monthly closing\1 - Financial Instruments\2022\04. April\CFH company allocation

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


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:

Analytics, Queries:


FX Management:


Cash Flow Hedge:


CFH version 2:


Run the query and as soon as you get the report, remove the GBU and add the company code:


Export the report to excel. Delete the columns that you do not need (keep just the total hedge per month) 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:

3.1.2. I prepare file CFH company allocation  MM YYYY

Copy the information from MVI file regarding CFH HP sales strategy, 0231 company only, into this file.

Update pivot table in tab "Allocation":

and make sure it is in line with SAP:

Get the % of allocation from the file previously done, through a vlookup formula:

Check if there are new companies to be included.

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 probably a company is missing. 

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

We need to get the rates because we will share the figures at the affiliate currency, not only EUR (0231 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 this tab you will find the tables we will use to share the figures with CAMs in the google file located here

This tables are linked to the pivot table above and the exchange rates in tab rates so we can show the figures in company currency and not EUR. Check if the formulas are properly linked.


3.2. I share the information with 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 and update the figures accordingly.


Tab FX:


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

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

End of document.