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: Perform cash reconciliation 2232 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 the cash reconciliation for 2232. >>



1. Objective and Scope

1.1. Objective of this Operation

Reconciliation of the cash balance between Corporate Treasury and Accounting at the end of each month.

This task should be performed after the exchange position process is finished.

1.2. Scope

This procedure is applied for the entity 2232: Syensqo SA - Treasury Division in PI2 System.

2. Definitions

See Finance Glossary:

  • ...

3. Tasks description

3.1. I receive the Quantum cash balance from Corporate Treasury Team for 2232 at month closing.

3.1.1. Cash position file

We receive on D+2 an email from the Corporate Treasury Team with the cash position file of the month to compare the total amount of the cash balance with our cash file.

3.2. I update the file "cash reconciliation 2232" with information downloaded from PI2.


3.2.1. Use transaction F.01 and select variant "BS CASH CHECK"


3.2.1.1. Select the following layout:  

3.2.1.2. Extract the information to excel:


3.2.1.3. Filter and delete blanks in column A

3.2.1.4. Remove the following accounts of the report because they are not included on the Cash Position file received:


3.2.2. Copy information in tab "BFCash", add the month being closed in the column B and drag down the formulas in columns F and G.

3.2.2.1. Select the accounts with this symbol and choose convert to number and update the columns F and G.


3.2.2.2. Add the accounts without classification on columns F and/or G, like follows:

                      F      in column M and L of the same tab

                      G     in tab "Banks Grouping"


And classify them.

3.3. I check the consistency between updated file "cash reconciliation 2232" and file "cash position 2232" received from Corporate Treasury Team.

3.3.1. Update all the pivot tables in tab "Summary":

  • Refresh all the pivot tables.

  • Update date in cell C2.

  • Update amount in cell C42 based on the report received from Corporate Treasury team (e-mail with subject "Cash movement, position and forecast Month Year") --> this report must also be saved in our shared drive.

The delta should be less than 1%.

The initial difference on the Threshold can be related to the cash concentration of 4044 on the account 5080900000 which value date from 2232 has a gap of 1 day, so we need to consider this difference on the report:


After this analysis if we still have an huge difference on the currencies between our report on F.01 and the report received from Treasury Front Office we need to contact them and request an updated report and after we receive it we update the new amount on the field "Treasury Report"





3.3.2. Copy from "Summary" tab to "Previous months" tab the values from C5 to C46 

3.4. I inform Corporate Treasury Team about the reconciliation and place the file in G Drive: 

After the file is complete, I save the file in G Drive and send an email with subject "Cash movement, position and forecast Month Year" with the information of the delta in % and justify the variation.