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:

Responsibility area:

Table of contents 


Scope


ERP

PI2

WP2

PF2


Frequency


 

References



Forms



Attachments


 

 

<< WW: GAR Report - Denetted positions for vendors/customers >>



1. Objective and Scope

1.1. Objective of this Operation

Every quarter a report is sent to GAR with the denetted positions for trade payables and receivables. (D5)

 

1.2. Scope

For all Legal Active entities

PF2

WP2

PI2


2. Definitions

See Finance Glossary:


3. Tasks description

The implementation of F101 in WP2 will allow us to see these balances in specific accounts in the balance sheet, however the report to GAR still needs to be prepared, either using these 2 transactions or with other transactions to report account balances.

3.1. Create the template

I use the Templates of before quarterly closing as example.

3.2. Update the template

Update both files (Payables and Receivables)

1 - Update the GAR list.

2 - Update the exchange rates based in the file sent by BFC Admin.

3.3. I run the reports


1- Extract all company codes from F FINANCE LEGAL ENTITIES MANAGEMENT - SCo

2- Exclude all the companies that are not Fully Consolidated (IG) on the "Consolidation Method" column

3- Update variants with company codes by system

4- Export to excel


Transaction:

S_alr_87012082 vendors balances in local currencies (Payables)

PF2 variant: DEB BAL SCOPF

WP2 variant: DEB BAL SCOWP1

PI2 variant: DEB BAL SCOPI1


S_ALR_87012172 customers balances in local currencies  (Receivables)

PF2 variant: CRED BAL SCOPF

WP2 variant: CRED BAL SCOWP

PI2 variant: CRED BAL SCOPI


** Period

1 to closing quarterly closing


After run the transaction, in the end of the report will be the data that you need, export the data to excel;

After running the transaction, the requires data will appear at the end of the report.

Export the data to Excel by selecting List → Save/Send → File → Text with tabs

The required data will be located in the last rows of the Excel file. Adjust the number format, then paste it into the Google Sheets file (Payables or Receivables).

A good way to verify if the report was generated correctly is to compare the number of companies in the current report with those from the previous quarter and check if they are similar


3.4. I Consolidate data into the Final File


1 - Copy the data from the individual files (Payables and Receivables) to the consolidated file (Denetted Trade Payables and Receivables)

2 - Verify if the formulas are working correctly.


If everything is correct, you can send it via email to the recipients listed below:


Jean-philippe Terrasa <jean-philippe.terrasa@syensqo.com>

Nicolas Bourgois <nicolas.bourgois@syensqo.com>

SCo-$BFC-conso <bfc-conso@syensqo.com>


In CC:

João Saramago <joao.saramago@syensqo.com>



End of document.