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, singapore, south_korea, thailand, indonesia, new_zeland

    • 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. 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


By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)


Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

June, September & December


References

F.01; GR55-Z4F1


Forms

7. Insert the links accordingly and change the link text with the OP name

CCCC Bridge Equity IFRS LOCAL G mm.yyyy

Attachments



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is help you to justify the difference in Net Equity between Statutory equity (according to Local GAAP) and Reporting IFRS GAAP equity.

1.2. Scope

This procedure applies to the following to Specialty Portuguese companies in PF1:

  • 6414: Solvay Biotecnologia Portugal – Unipessoal, Lda

  • 6424: SLV Specialties Portugal, Unipessoal, Lda


2. Definitions

See Finance Glossary:


3. Tasks description

This procedure consists in 2 parts basically. The first part is to collect the information from SAP and second part is to use that information to justify the difference. 

3.1. Responsibilities

  • ACP – Make the reconciliation to be sent to CAM.
  • CAM - validates the bridge between local and IFRS GAAPs and ensures that all retreatment postings are accurate.

It has, with no exception, to be registered by request in Helix tool..

3.2. Periodicity

This reconciliation have to be done after June's closure. But in September and December it will be part of the Analytical Review.

3.3. I extract SAP information

3.3.1. I fill sheet "F.01 CCCC"  


Use excel files stored in Share drive Y :

\\ptcarfs01\GroupFolders\SU_FA_Other EMEA_ADM\CONTABILIDADE\6424_SLV Specialties Portugal, Unipessoal, Lda\ANALYTIC REVIEW

\\ptcarfs01\GroupFolders\SU_FA_Other EMEA_ADM\CONTABILIDADE\6414_Solvay Biotecnologia Portugal – Unipessoal, Lda\ANALYTIC REVIEW


6424_Bridge Equity IFRS_LOCAL G_MM.YYYY

6414_Bridge Equity IFRS_LOCAL G_MM.YYYY


To have SAP information, click on "Extract Macro" in sheet "Extract PF1". 

Example 6414 


Go to transaction F.01, and use below variants:

  • BALANÇO 6414 
  • BALANÇO 6424


Change the fields marked below (confirm company code, reporting period as current year and comparison period as previous year with period 14)

This variant has the following selection (example 6414) :

copy the information that we got and paste in cell A1.

Save this information to excel with the name "F.01 CCCC".


This report will be used to get the value of “RESULTADO LIQUIDO” and the "TOTAL OUTRAS RESERVAS" so make a print screen from this information, because we will be need it to put in your excel file. 


3.3.2.  I fill sheet "GR55_Z4F1 CCCC"


The Macro that was run in 3.3.1 also fill this sheet. 


Go to the transaction GR55 Report Z4F1 - BFC balance sheet - year overview.

Then put the company code and the period :

Example 6414



 Execute and below report will be display: 



Export all report to Save inside the excel file: 

Before export expand the report fully in View and, go to Settings and choose options. Once inside options, select Type of Output and change from Inactive to Microsoft Excel :

A pop up will appear and select Enable Macros:


Now I'm able to copy ( Ctrl +C ) the information, and  save ( using past special values)  in excel  in Cell B1



This report will be used to get the value of “NET EQUITY” so make a print screen from this information, because we will be need it to put in your excel file.

At the end of the report search for F to G local accounts and take a print screen as well.

3.4. I fill Sheet "YYYY Bridge Equity IFRS_Local G"

In this sheet I will perform the reconciliation.

3.4.1. I update reconciliation Table with Previous year information

So in first place insert in column C the amounts, in values, from the last period we did the report:


3.4.2. I update line " Statutory equity (according to Local GAAP)"

 Take print screen and past the information that you got in step 3.3.1.:

  1. Equity = Total capital próprio ( period 14) = 3.005 k€
  2. Net income = resultado líquido = -45k€ ( In case the company have "Dividends". To make sure , please go to account 3042200000 and check if there is any value with in description "Payment dividends", and put in this column.) 
  3. Other's & OCI =  "TOTAL OUTRAS RESERVAS" = 0k€ (If I have another value for example "OUTRAS VARIAÇÕES CAPITAL PRÓPRIO" I must to sum them.)

3.4.3. I update line " Reporting IFRS GAAP equity"

Take print screen and past the information that you got in step 3.3.2.:

Net equity previous year= 3.050k€ 

Net equity current Year = 3.005k€ ( confirm if formula works properly)

3.4.4. I check the lines with the name "RECONCILING"


The lines with the name "RECONCILING" are formulated with information that comes from GR55 Report Z4F1 - alphanumerical accounts. 

 This information its summarized in below mapping, which is formulated inside the reconciliation Table.

Check if there is new accounts, and if yes perform the mapping.  

To help on the mapping, take a print screen of alphanumerical accounts and compare it.


Detail by each reconciling Item: 

assign new accounts according to corresponding reconciling item # 

3.4.5. I perform a final check of the controls 

The control must be zero ( rounding's are allowed) this means that all information was correctly considered in the reconciliation process. 

In the end the value in column mm-yyyy,  must be similar to GR55 Report Z4F1 "Net Equity"


3.5. I inform the Accounting Manager

I send this information to CAM by mail.  


3.6. I save all information in Share Drive


It's very important save all information in shared drive, inside each reporting year and period. 

\\ptcarfs01\GroupFolders\SU_FA_Other EMEA_ADM\CONTABILIDADE\6424_SLV Specialties Portugal, Unipessoal, Lda\ANALYTIC REVIEW

\\ptcarfs01\GroupFolders\SU_FA_Other EMEA_ADM\CONTABILIDADE\1_SCO\6414_Solvay Biotecnologia Portugal – Unipessoal, Lda\ANALYTIC REVIEW


End of document.