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: Country Accounting

Responsibility area: N/A

Table of contents 


Scope

ERP


Frequency

 

 

References

S_ALR_87012093


Forms


Attachments

Banque de Grance website



Previous OP << FR - ECEIS - Enquête Banque de France (SCo) >> Next OP



. Objective and Scope

1.1. Objective of this Operation

ECEIS - Enquete Complementaire sur les Echanges Internationaux de Services (Complementary Survey on International Trade of Services)

The purpose of the survey is to contribute to the establishment of France's balance of payments by collecting and estimating international trade flows of services carried out by resident non-financial enterprises.

This procedure will explain how to retrieve and treat all the information needed and also how to submit it in the site of Banque de France.

I'ts performed once per year between March and July.


1.2. Scope

This procedure explains how to prepare and submit the ECEIS legal questionnaire.

In addition, this procedure may apply to companies covered by TSA upon PO2 separation on Dec 2023.

2. Definitions

See Finance Glossary:

  • ECEIS - Enquete Complementaire sur les Echanges Internationaux de Services (Complementary Survey on International Trade of Services)


3. Tasks description

3.1. I prepare the data to submit ECEIS 

3.1.1. I retrieve the SAP information for 3471 (example)

Run transaction  S_ALR_87012093 using the correspondent variant:

Variant: FR-ECEIS 

               

Since the survey only concerns international exchanges, so this variant,  excludes the 
country codes FR and ZZ and selects only the collective account 2300000000-suppliers.
  • Select the company code and the correspondent period: 


  • Extract the result to Excel

3.1.2. I open Excel working file

Open the last year working file to use as guide for this year.

The file are stored in: 

\\FREPAFS03\Groupes\SLFINANCE_EPA\SLFINANCE_France\Stés indust\3471 SOLVAY OPERATIONS FRANCE\2020\Enquetes\ECEIS

\\FREPAFS03\Groupes\SLFINANCE_EPA\SLFINANCE_France\Stés indust\3470 SOLVAY SPECIALTY POLYMERS FRANCE\2021\ENQUETES\ECEIS

\\FREPAFS03\Groupes\SLFINANCE_EPA\SLFINANCE_France\Stés indust\5586 RHODIA CHIMIE\2020\Enquêtes\ECEIS


  • On the tab Base de Travail 20XX insert the previous SAP extraction (point 3.1.1) Organise the columns by company code (Sté), Account (Cpt. coll.), Vendor number (Fourn.), Vendor name (Nom 1), country (P), postal code (Cde postal), City (Localité), Address (Rue), code (Rg), Currency (Dev.), Value (Achats)


  •  Copy the information of Base de Travail and updated the formulas. They will get the information from Sheet Table. 
  • Formatting SAP Extraction and updated the threshold if needed (confirm with CAM if the amount changed).
  • On Column Signification, select the (blanks) - (all other amounts are below threshold and will not be included in the declaration)
  • Here we have a filter by threshold to identify the eligible dispenses.



  •  this table contains the vendors data base. Here we updated the type of sales (services, transportation or goods), the correspondent heading (nomenclature) accordingly with the invoices posted on the vendor accounts and some extra useful information. This table will be used to updated other sheets.

    To consult the existing nomenclatures and it's description you can check the PDF file  stored in (\\FREPAFS03\Groupes\SLFINANCE_EPA\SLFINANCE_France\Stés indust\3471 SOLVAY OPERATIONS FRANCE\2020\Enquetes\ECEIS)



  •  Copy the information of Etape 1. Here we will filter the information by Services and transport (SERV and TPT) and we will also add the column of "numenclature". The nomenclature will be updated accordingly with the information added in Sheet Table


  •  - 3A. Purchases of services from non-resident providers.
    Copy the information of Etape 1 here we will filter the information by Services and transport (SERV and TPT) and we will also add the column of "numenclature". The nomenclature will be updated accordingly with the information added in Sheet Table

    With this information created a Pivot table with the sum by Nomenclature and country.

    Note

    This table will allow you to easily fill in Section 3A of the declaration. Here you need the top 3 countries by nomenclature, the total amount and the number of countries by nomenclature.


  •  - 3B. Sales of services to non-resident customers.
    This selection can be done by account or by Tax code. 
    Use transaction F.01 with variant FR BILAN LOCAL to extract the total of the year and FBL3N do get the detail by account and by partner. 

   Select the account in group FH


Then get the detail of each account by partner:



  • All French partner should be excluded.
  • For company 3471 we have an additional file 3471 Répart CA XXXX, where we perform an extraction by profit account in order to identify correctly the sales by country. The detail should be included in this sheet for the declaration

The file can be found in the following folther:

On this file we need to update the sheet  with new accounts that were created since the previous declaration


In case of new accounts you also need to update sheet   to add S for services or B for goods. 

This information will be used in the end in order to facilitate the analyses.

Extract with FBL3N all account in sheet , and copy to sheet  under the grey columns. 


In the green columns we have formulas that will help identify the type of sales.


In sheet  update the pivot tables and check if all extractions are correct so that nothing is missing.


In sheet  update the pivot table and start identifying by partner the type of sale and the correspondent nomenclature. The detail will de declared in Section 3B



  •   - 5 Weight of trade with non-residents.  
    Shares of service purchases from non-resident suppliers - to calculate the percentage you need to fill in Section 5 of the declaration - run transaction F.01 with variant FR BILAN LOCAL. 


  • This way you will get the FS Item that will help on the calculations.

    You will nee the total of FS + FU + FW + GE to add on the file like following print:

  • For the Total purchases from non-resident customers (Total des achats auprès de clients non résidents ) you will go to sheet Section 3A and retrieve the total:



Note

The percentage is calculated by dividing the total of purchases from non-resident by the total of purchases of the year. It's always good to add the values from last year to confirm of there was large variations.


  • Percentage of sales of services to non-resident customers:
    Total sales to non-resident customers (Total des ventes auprès de clients non résidents): information retrieved from Sheet Section 3B - total of sales.


  • Total sales is the sum of FL + FQ extracted from F.01.

    Note

    Add the values from last year to confirm the variations

  • Intra-group exchanges. Copy the information of Etape 3 and select the Intra-goup vendors:


  • To get the percentage of Intra-group exchanges, add the total of the previous selection, plus the total retrieved from sheet Section 3A:


  • Sales of services to intra-group non-residents



3.2. I submit ECEIS

3.2.1. I open Site - Banque de France


  • Confirm the password on the file: Enquetes France (link: )


Note

The password of Banque de France changes frequently, every time you need to change the password, update the file and communicate to the CAM.

  • Select Rapports.


  • Select the report that is open to start the declaration:


  • Select: Enquête Complémentaire sur les échanges internationaux de Services


  • You just have to fill in each paragraph. 
    Once the paragraph is filled in, do not forget to record your answers by clicking on the floppy disk



  •  Depending on the company the declarations may vary. On the print above you have all options that can appear, some companies only have one or too. With the file that you have previously prepared you have all information needed, you will only select the one that is asked.  


  • Submit and save a copy of the declaration in PDF format next to the excel file previously performed.

...


End of document.