| Hide If | ||
|---|---|---|
| ||
Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. 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 |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Domain: Country Accounting |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: N/A |
| Table of Contents | ||
|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
ScopeERPPF2 FrequencyYearly
ReferencesFormsAttachments
<<
|
1. Objective and Scope
1.1.
Objective of this OperationObjective
To be able to fill a Survey called “SPE - Inquérito aos Serviços Prestados às Empresas” for a public entity of statistics (INE).
- The purpose of the Business Services Survey (SPE) is to harmonize the sectoral statistics on services in 8 specific areas of activity:
- Architecture, engineering and related techniques;
- Accounting, auditing and consulting;
- Technical tests and analysis;
- Market research and opinion polling;
- Informatics and related activities;
- Legal activities;
- Publicity;
- Employment activities;
1.2. Scope
This procedure applies to the following Portuguese company:
- 6424: SYENSQO PORTUGAL - UNIPESSOAL LDA (PF2)SLSLV SPECIALTIES PORTUGAL, UNIPESSOAL, LDAV SPECIALTIES PORTUGAL, UNIPESSOAL, LDAECIALTIES PORTUGAL, UNIPESSOAL, LDA
2. Definitions
See Finance Glossary:
- CAM – Company Accounting Manager
- PF2 – Syensqo Legacy's SAP system
- ACP SL - Accounting Platform Service Line
- IS - Information Services.
3. Concepts
- What is a COPE?
COPE are external transactions conducted by the entity itself. Transactions intermediated by the resident banking system, transactions directly with non-resident entities through external accounts or clearing accounts, and transactions in current accounts should be communicated. Within the scope of such reporting, end-of-period positions on loans, trade credits or external deposits/deposits abroad are also considered.
2. What is a COL?COL are transactions communicated by the resident banking system on behalf of customers. External settlements on behalf of resident customers and transactions on behalf of non-resident customers should be communicated.This
information should be communicated on an individual transaction basis, not specifying any statistical classification.COL are made available to enterprises for consultation or use to create COPE, through the Collection Application on the Corporate Area.
4. Tasks description
This procedure consists in 2 parts:
- The first one is to verify and correct the data in SAP before extracting the XML file.
- The second part is to submit the information to Banco de Portugal.
4.1. Responsibilities
- CAM – To correct information, Check it and submit the report.
- IS – To edit tables if needed.
4.2. Periodicity
This report must be delivered every month until 15º useful day /M+1.
The COL it's available in " Aplicação de Recolha" on the 8º useful day.
5. I check and correct data in SAP
5.1. I analyze the Output Types - P (payments) & O (open Items)
5.1.1. I analyze the output type - P (Payments)
To analyze the rows that are Payments in Output Type:
Check if the Vendor/Customer is from Syensqo;5.1.2. I analyze the output type - O (Open Items)
To analyze the rows that are Open Items in Output Type:
Check if it is a Vendor or a Customer and if it is a Group or External company (Check on Trading Partner and Description of the Customer/Vendor);5.2. I edit the table Z1F_CBR_ENTITIES
To check for new vendors, go to S_ALR_87012086 using variant “SCO VENDORS BP”:
To check for new customers, go to S_ALR_87012179 using variant “SCO CUSTO BP”:
In both variants, in the dynamic selection, update the period range for the year you are reporting.
| Note |
|---|
If the customer/vendor is not Portuguese and has open items, do not add it to the table. All the other customers/vendors we need to add to the table. |
To correct the missing SCB Codes, go to transaction SM30 and in field Table/View fill with:
Z1F_CBR_ENTITIES ( in PF2)ZFI_CBR_ENTITIES ( in WP2)
Then, select Maintain and you will have the following table:
To add the new customer/vendor to correct the missing SCB, click on “New entries”
With your analysis, you are able to fill the table:
We need to fill the following fields:
- CoCd: 6414 / 6424
- AccTy: Vendor / Customer
- OutType: Open Items / Payments
- Partner: Vendor number / Customer number
- SCB Code: Check table with the codes on 3.3.1.
- SCB Cod Cr: Check table with the codes on 3.3.1. (same code as field SCB Code)
- Acc. Type: If OutType is Open Items, select "Sem movimentação" & if OutType is Payments, select "Outra Conta Externa"
| Warning |
|---|
Please pay attention to the duplicate information in this table. We cannot have duplicate rows, otherwise, it gives an error. |
Depending on the Country, Value Type, Account Type and Output type, the movements can assume the following codes:
PT Vendors / Customers
Any Output
All
Z1020
Vendors / Customers
Payments (External)
Services
D7190
Vendors / Customers
Payments (Group)
Services
D7140
Vendors / Customers
Payments (Group or External)
Stock
A1010
Customers
Open Items (Group)
Open Items
N1031
Customers
Open Items (External)
Open Items
N1011
Vendors
Open Items (Group)
Open Items
N2031
Vendors
Open Items (External)
Open Items
N2011
statistical operation, aims at the production and dissemination of information in the following areas:
Quantification and typification of the production of services in 8 areas;
Distribution of the value of the service rendering, by type of service, according to the Statistical Classification of products by activity.
4. Responsibilities
- ACP SL
5. Periodicity
This Survey has to be filled from 03/03 to 27/03 of the YYYY+1.
6. I submit the SPE in INE website
6.1. I entry in INE website
Go to INE Website → and then insert the access credentials -» press "Entrar"
6.2 I submit the information in INE website
Select SPEYYYY below "Inquérito" to access the survey.
Be attention to due date mentioned in "Prazo"
In the next window, the questionnaire will be displayed and can be completed as shown in the images below:
Tab "Início":
- BC005 = Em actividade
- BC007 = 12
- BC015 = Não
Tab "B":
- V321 = 100
Tab "D":
- C160 = 100
- C162 = 82
- C164 = 18
After you fill the information click in "Validar/Guardar" --» "Responder".
| Info |
|---|
The information used for this report is always the same every year |
After make the submission you need to get the proof of submission to archive in Drive.
So inside of INE website go to "Entregas", select the name of report and press "Pesquisar"
In "resultado," all the reports are listed. Then, select the most recent (last) one.
The report will be like this:
6424 SPE_202400_517159325 referência dos dados.pdf
7
Now, save and the missing SCB Codes will be corrected.
Run in PF2 transaction Z1F_BANK_PT and in WP2 transaction ZFI_BANK_PT again, add all columns to layout, do a subtotal by SCB Code, collapse and check if there are any missing SCB Codes left.
It must be like in the following example:
5.3. I run in PF2 the SAP transaction Z1F_BANK_PT and in WP2 the SAP transaction ZFI_BANK_PT
5.3.1. I run in PF2 the SAP transaction Z1F_BANK_PT
Go to transaction Z1F_BANK_PT to retrieve the report with clients and vendors movements in CICC account.
Inside the transaction, go to variants and you will find variants for PT companies.
The variants CCCC ALV, being CCCC the company code.
In these variants, the selection is:
Chart of accounts: COCA
G/L accounts:
505DEEUR72 - BNPP FORTIS LISBON (EUR) CREDIT TRFS ISSUED TR
505DEEUR76 - BNPP FORTIS LISBON (EUR) CREDIT TRFS RECEIVED TR
591EUR0231 - C/Cp SOLVAY CICC Finance-EUR
2300250000 - AP-TP-TRADE SUBIBA
2200250000 - AR-TR-TRADE SUBIBA
591EUR2232 - C/Cp SOLVAY CICC Finance-EUR
Check in F.01 - Financial Statements if its needed to add or remove accounts.
Company code: 6414 & 6424
Vendor: (Exclude Ranges) P000000000 to P009999999
Posting Date: 01.M-1.YYYY to 31.M-1.YYYY (Automatic and Dynamic Selection)
Select Payments, Partner Open Items and Bank Accounts.
Run the transaction with CCCC ALV variant.
Add all possible columns to the layout:
After Run select layout COPE
Do a Subtotal by SCB Code, collapse and expand only the row with missing SCB Code:
Save the information in excel file with name ALV CCCC. This information will be necessary to fill excel PT SCO CCCC Banco de Portugal MM.YYYY, in sheet "SAP CCCC".
5.3.2. I run in WP2 the SAP transaction ZFI_BANK_PT
Go to transaction ZFI_BANK_PT to retrieve the report with clients and vendors movements in CICC account.
Inside the transaction, go to variants and you will find variants for PT companies.
The variants CCCC ALV, being CCCC the company code.
In these variants, the selection is:
Chart of accounts: Z001
G/L accounts:
40100900 - AP-TP-TRADE SUBIBA
41100900 - AR-TR-TRADE-SUBIBA
50060970 - BNPP FORTIS LISBON (EUR)00340109 OUTGOING TRANSFER
50050970 - BNPP FORTIS LISBON (EUR)00340109 INCOMING TRANSFER
58EUR100 - TREASURY FUND SOLVAY CICC (0231) EUR
58EUR500 - TREASURY FUND SOLVAY CICC (2232) EUR
Check in F.01 - Financial Statements if its needed to add or remove accounts.
Company code: 6414
Vendor: (Exclude Ranges) P000000000 to P009999999
Posting Date: 01.M-1.YYYY to 31.M-1.YYYY (Automatic and Dynamic Selection)
Select Payments, Partner Open Items and Bank Accounts.
Run the transaction with CCCC ALV variant.
Add all possible columns to the layout:
Do a Subtotal by SCB Code, collapse and expand only the row with missing SCB Code:
In 10. Appendix it is explained the description for each column.
We must analyze each item that does not have a SCB Code.
5.4. I Request IS to update Other Tables
If for some reason it is necessary to modify the other tables, please request IS :
for PF2 Z1F_CBR_SCB or Z1F_CBR_BANKS
for WP2 ZFI_CBR_SCB or ZFI_CBR_BANKS
In Service One choose 
Example:
6. I extract SAP information
Go to Transaction Z1F_BANK_PT in PF2 and ZFI_BANK_PT in WP2.
Choose Variant CCCC XML , being CCCC the company code.
Choose where you want to save the XML in "Directory Path".
This variant will create a XML document like 
and will be saved in "Directory Path" chosen (in this example in Downloads).
This is the document that will be submitted in the Banco de Portugal Website.
7. I fill the excel file "PT SCO CCCC Banco de Portugal_MM.YYYY"
Fill the excel file from previous month as template saved in Google Drive. Please follow paths below:
| Note |
|---|
Before starting to upload the information in the excel file from last month, we must copy from the previous month column and paste formulas in the current month column. The column from the previous month must not have formulas, just numbers. |
The files have each other 5 sheets and the following topics will explain how to fill them.
7.1. I fill the sheet "SAP CCCC"
Fill this sheet with information from file ALV CCCC that you extract in step 5.1.:
7.2 I fill the sheet "XML CCCC"
To fill this sheet we need to extract the information from the XML file created in step 6.
Open a new excel document and open the file XML as a XML Table:
It will open a table and you will have to copy that information to the XML CCCC sheet:
After having copied all the information, you must refresh the pivot table on the right side to update it with the new information.
7.3 I fill the sheet "BP Resumo CCCC"
7.3.1. I fill the period of report
Update the date that you are reporting in cell B1.
7.3.2. I update the pivot table
We must refresh the pivot tables with name "ALV" and "XML":
| Warning |
|---|
Cell AA9 should be zero because when we fill the information in step 7.2. Sheet XML CCCC, the table from line 8 to 36 is automatically filled with that information (sheet XML). However, it can have only the difference regarding France Cash polling (BNP bank accounts). Example in the image above (Cash pooling difference of 1.751€). |
7.3.3. I check some items
Now we need to check:
1) SCB Code L0224
Go to transaction FS10N and check if accounts, in PF2 7510030000 & 6500030000, in WP2 98532100 and 98531100, have any amount. There will be a row with code L0224.
2) SCB Code L1131-P / L2131-P
Go to transaction FS10N and insert in account, in PF2 591EUR2232 and in WP2 58EUR500. Check if the amount on Cum. balance of the current month matches the amount in row L2131.
The control in cell E90 must be zero. If you have a difference, it can be from accounts in PF2 2200250000 or 2300250000, and WP2 41100900 or 40100900.
If you need to perform any correction, please add the new information in "Acertos":
Note: It can happen that we need to perform one correction in code Z1020 OS. If indeed we need to make this correction, the report in Banco de Portugal site also needs to be manually corrected.
8. I submit in Banco de Portugal website
8.1. I entry in Banco de Portugal website
Go to Banco de Portugal Website → Aplicação de recolha → Empresas
↓
Select "Utilizar dados do Portal das Finanças" and then insert the the same access credentials from "Portal das Finanças":
8.2 I submit information in Banco de Portugal website
Import the XML file that you extracted from SAP to Banco de Portugal Website.
Select "Importar Ficheiro"/ "Choose file":
And select the file 
that you extracted form SAP in step 6.
In this case there was no need to perform any correction. However, if it was needed, I would have to look for the Code that needed correction, select
and make the necessary changes.
P.s. Be aware that you can have more than one page.
In Banco de Portugal Website, copy all the information in table "Comunicação de operações e posições com o exterior - COPE":
And paste the information in excel file PT - Banco de Portugal yyyy-mm, in sheet BP CCCC:
8.3. I submit
Click in "Submeter"
And it will appear the following message:
Add the print in sheet "Print CCCC".
9. I save all information in Drive
Save all information in drive:
For 6414:
For 6424:6424 - COPE
SPE108. Appendix
10.1. Table Z1F_BANK_PT
Company Code
Value Type
It can assume three values:
S – Saída (Export)
E – Entrada (Import)
P – Posição (Open-Item)
Acct Type
It can assume three values according to the field account:
K – vendor
D – customer
S – G/L account (bank account)
Indicates the amount for each document
Output Type
It can assume two values:
P – movements (Entradas and Saídas)
O – open-items (Posições)
SCB Code
It’s the statistical code provided by “Banco de Portugal”
SCB code description
Legislation
The response to the Survey on Services Provided to Enterprises by the National Institute of Statistics, IP (INE) is mandatory under paragraph 1 of article 4 of Law No. 22/2008, of May 13 (Law of the National Statistical System), and paragraph 5 of article 4 of Decree-Law No. 136/2012, of July 2 (Organic Law of INE). Failure to respond constitutes a serious administrative offense punishable by a fine.
10.2. Table ZFI_BANK_PT
Company Code
Value Type
It can assume three values:
S – Saída (Export)
E – Entrada (Import)
P – Posição (Open-Item)
Acct Type
It can assume three values according to the field account:
K – vendor
D – customer
S – G/L account (bank account)
Indicates the amount for each document
Output Type
It can assume two values:
P – movements (Entradas and Saídas)
O – open-items (Posições)
SCB Code
It’s the statistical code provided by “Banco de Portugal”
SCB code description
11. Legislation
INSTRUÇÃO N.º 27/2012 - (BO N.º 9, 17.09.2012) - Estatísticas de Operações e Posições com o Exterior Instrução (Histórico) n.º 56/2012 - Estatísticas de Operações e Posições com o ExteriorMANUAL DE PROCEDIMENTOS
End of document.
| Viewtracker | ||
|---|---|---|
|