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: 1. Enter the Domain identified in OPD matrix (for Country specific operations, Domain = Country Accounting)

Responsibility area: 2. Enter the responsibility area described in OPD matrix ("N/A" for Country Accounting Operations)

Table of contents 

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

 

References

6. Add the link to SAP transaction(s) (when it exists)



Forms

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



Attachments

8. Add the link to attachments or external links




Previous operation << >> Next operation



1. Objective and Scope

1.1. Objective of this Operation

This document explains the carry out of the update and upload the Foreign Currencies for Brazil Companies using the information available in the "Banco Central do Brazil".


1.2. Scope

This procedure applies to Brazil Companies in WP1 and PF1.


2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:


3. Tasks description

For legal reason is necessary to update the system with the rates from "Banco Central do Brazil". The exchange rate defined in PF1/WP1 cannot be used for other companies.

This procedure describes:

  • How to get the exchange rate in the website of "Banco Central do Brazil."
  • How to input the data in SAP - transaction ZRATEMOD / /PWS/ZYCIT174
  • How to check if exchange rates are right -transaction : ZRATE / /PWS/ZYCIT174
  • How to save the report image - transaction: OB08 / /PWS/ZYCIT174


4. Periodicity

The exchange rate should be updated performed every working day at 10 a.m. in Curitiba time, using the rate of the current working day.

For the closing monthly rate, it should be performed every first day of the current month.

These process is described in detail in the sections below. 


5. I update the rate - Daily.

5.1. COMEX.

5.1.1. I CHECK THE DATA.

5.1.1.1. I retrieve the data.

5.1.1.2. I upload the file: Conferência TAXA COMEX - 2021_2022.

5.1.1.3. I check the exchange the rate.

5.1.2. I CORRECT THE DATA - If necessary.

5.1.3. I DELETE THE WRONG DATA - If necessary.

5.2. LBRD - PF1

5.2.1. I upload the file: Conferência OB08 - TAXAS BRASIL - 2021_2022

5.2.2. I check the exchange rate - Daily

5.3. LBRD - WP1

5.3.1. I upload the file:  Conferência OB08 - TAXAS BRASIL - 2021_2022

5.3.2. I check the exchange rate - Daily

5.5. LBRR - WP1

5.5.1. I upload the file: Conferência OB08 - TAXAS BRASIL - 2021_2022

5.5.2. I check the exchange rate - Daily

6. I update the rate - Monthly.

5.4. LBRR - PF1

5.4.1. I upload the file: TCURR-LBRR MENSAL 2022

5.4.2. I check the exchange rate

6.2. LBRS - PF1

6.2.1. I upload the file: TCURR-LBRS MENSAL 2022

6.2.2. I check the exchange rate

6.3. LBRS - WP1

6.3.1. I upload the file: TCURR-LBRS MENSAL 2022

6.3.2. I check the exchange rate










LBRD - PF1 

4.1.1.I update the rate - daily

Access the website: https://www.bcb.gov.br/estabilidadefinanceira/historicocotacoes

Click on the 2nd option of quotes, then click on search

Download the file to the desktop.


Open the file.



4.1.2. I upload the file: Conferencia OB08 - TAXAS BRASIL – 2021_2022

When opening the worksheet Conferencia OB08 - TAXAS BRASIL – 2021_2022, open a tab and name it with the date of the previous day, after that click on the LBRD tab and insert a column after the last column, change the date of the first row, consequently the second line will also change, in the third line change the date in the formula and click on it and drag to the last line to be filled in the column, so the information will be fed. Set the column parameters in the same way as the previous day's column.



I go to SAP to check if the rates are correct, both in PF1 and WP1.

4.1.3. I check the exchange rate - daily

Access SAP: in TRANSACTION OB08


SELECTION, BY CONTENTS


Select VALID FROM (previous day's date) and EXCHANGE RATE TYPE (LBRD)


When the rates appear, check if they are correct based on the tab of the respective consultation day, checking if the values in the last column match the values of the report presented. If everything is ok, give a PRINT.



Save the report image, and paste it into the Conferencia OB08 - TAXAS BRASIL – 2021_2022 worksheet, on the LBRD tab.



4.2. LBRD - WP1 

4.2.1.I update the rate - daily

Access SAP: in TRANSACTION OB08


SELECTION, BY CONTENTS


Select VALID FROM (previous day's date) and EXCHANGE RATE TYPE (LBRD)



When the rates appear, check if they are correct based on the tab of the respective consultation day, checking if the values in the last column match the values of the report presented. If everything is ok, give a PRINT.


 Save the report image, and paste it into the Conferencia OB08 - TAXAS BRASIL – 2021_2022 worksheet, on the LBRD tab.



4.3. LBRR - WP1 

4.3.1.I update the rate - daily


When opening the worksheet Conferencia OB08 - TAXAS BRASIL – 2021_2022, open a tab and name it with the date of the previous day, after that click on the LBRR tab and insert a column after the last column, change the date of the first row, consequently the second line will also change, in the third line change the date in the formula and click on it and drag to the last line to be filled in the column, so the information will be fed. Set the column the same as above. I went to SAP to check the rates, in WP1.



Access SAP: in TRANSACTION OB08


SELECTION, BY CONTENTS


Select VALID FROM (previous day's date) and EXCHANGE RATE TYPE (LBRR)


When the rates appear, check if they are correct based on the tab of the respective consultation day, checking if the values in the last column match the values of the report presented. If everything is ok, give a PRINT.



Save the report image, and paste it in the Conferencia OB08 - TAXAS BRASIL – 2021_2022 worksheet, on the LBRR tab.




Exchange rate data for BR (Brazil) are entered daily in a spreadsheet, follow the link for access if a conference is required: Conference OB08 - TAXAS BRASIL - 2021_2022


End of document.