Versions Compared

Old Version 2

changes.mady.by.user Nathally de Camargo Gantzel Vieira

Saved on

compared with

New Version Current

changes.mady.by.user Carolina Faria

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Hide If
groupconfluence-users

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 


Panel
bgColor#F7F7F7
titleColor#ffffff
borderWidth1
borderStylenone
Domain: Country Accounting
Panel
bgColor#F7F7F7
borderWidth1
borderStylenone

Responsibility area: N/A

Table of contents 

Table of Contents
maxLevel2


Panel
borderStylenone
Scope

Image Modified


ERP


Frequency

 

References

ZRATEMOD


Forms


Attachments



Previous OP <<

Page_title
>> Next OP



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 Peru using the information available in the Superintendecia de Banca, Seguros y AFP.

1.2. Scope

This procedure applies to Peru in WP1 ERP.


2. Definitions

See Finance Glossary:

ERP


3. Tasks description

For legal reason is necessary to update the system with the rates from Banco de México. The exchange rate defined in WP1 cannot be used for Peru Companiesdo Peru. 

This procedure describes:

  • How to get the exchange rate in the website of Banco de do Peru;
  • How to input the data in SAP - transaction ZRATE_UPLOADZRATEMOD;
  • How to change the information if necessary check if exchange rates are right -transaction ZRATEMOD: ZRATE; 
    For Mexican companies have the only type of exchange rate to be managed.
3.1
  • How to save the report image - transaction: OB08.


4. Periodicity

The exchanges rate LPED should LPED and LPES exchange rate must be updated in a daily should and must be performed carried out every working day at 09 a.m. in , at 9:00 am Curitiba time, using the rate of the previous working day. LPES should be update in closing period.



Info
titleObservation

If the exchange rate and/or the site is unavailable please, contact Pilar Galarza from (e-mail: Galarza@solvay.com ), in order to request the support and/or informing that the exchange rate will be update as soon as possible.

3.2

5. I

update the exchange rate - daily3.2

UPDATE THE RATE - DAILY

5.1. I retrieve the data.

To use the exchange rate Dolar and Euro:

  • Go to the following Link.

These process is described in detail in the sections below.

Copy the option "Tipo de Cambio".

Image Removed

For use exchange rate Pesos Chilenos and Mexicano

The next screen should select the option "Ver lista" (Peso Chileno and Peso Mexicano) (diarios)".

  • Go to the following Link.

The rate is retrieved for Dollar (USD); Euro (EUR); Peso Chileno (CLP) and Peso Mexicano (MXN) in a daily basis. 

Warning
titleImportant
The date used to retrieve the correct exchange rate must be always the previous working day (for this reason the upload must be done at 09 a.m. Curitiba Time), for instance: 

Access the website: https://www.sbs.gob.pe/app/pp/SISTIP_PORTAL/Paginas/Publicacion/TipoCambioPromedio.aspx

Use the VENTA column values for USD, EUR (LPED), and use the COMPRA column values for USD, EUR (LPES)

Image Added


and, access the website: https://www.sbs.gob.pe/app/pp/SISTIP_PORTAL/Paginas/Publicacion/TipoCambioContable.aspx

Image Added


5.

  • There you you'll find the information ready for the upload:

Image Removed

**The upload is done the same way as the other currency the only difference is where you extract the information.

3.2.

2. I upload the exchange rate

WP1:

- Daily

Run the transaction transaction ZRATEMOD   (WP1 system WP1) in order to upload to SAP the Exchange Rate. 

In the transaction insert , enter the following information: 

  • "Valid from" – Enter the date that should be insert the of the previous day exchange rate;
  • "From Currency" – the currency, for the Chile companies must be updated in 5 currencies:
    • USD
    • EUR
    • CLP
    • MXN
  • "Exch. Rate type" – the type of the rate to be modified;
  • "Exchange Rate" – the exchange rate retrieving of Banco de Chile ;

Image Removed

  • The rate is update for the following currencies: USD, EUR, CLP, MXN (LPED), and EUR, USD (LPES).
  • "Exchange rate type" – The type of rate to be modified: LPED and LPES. 


Image Added

Press enter;

The system will inform the actual rate. 
After that is necessary just to press Image Modified and Image Modified . The new rate will be assumed by the system:

Do the same process for USD, EUR, CLP, MXN (LPED), and EUR, USD (LPES).


5.3. I check the exchange rate - Daily

Access the transaction: 

Image Removed

At the end, the fees that must be updated are:

Repeat this process for EUR, CLP, MXN.

ZRATE

In the transaction, insert the following information:

  • "DATE" – Enter the previous day's exchange rate.

  • "From Currency" – The rate is updated for the following currencies: USD, EUR, CLP, MXN (LPED), and EUR, USD (LPES).
  • "To Currency" – The currency for Peru is PEN

  • "Exch. Rate type" – The type of rate to be modified: LPED and LPES.

And check that the rates are updated correctly.

Image Added

Do the same for: USD, EUR, CLP, MXN (LPED), and EUR, USD (LPES).


After verifying that the exchange rates are correct, access transaction OB08, save the report image and paste it into the TAXAS DIARIAS worksheet.


Run the transaction OB08 (system WP1) 

Image Added


SELECTION, BY CONTENTS;

Image Added


Select VALID FROM;

Image Added


Insert the previous day's:

Image Added



When the report appears, check if the rates are correct based on the print of the rates extracted from the link mentioned above. If everything is ok, give a PRINT.


Image Added


Click on ExRt column and click on filter:

Image Added


Save the report image and paste it into the TAXAS DIARIAS worksheet.

Image Added




Info

Exchange rate data for PE (Peru) is fed daily into the spreadsheet: TAXAS DIARIAS. Below is a link to access a conference if necessary:

https://docs.google.com/spreadsheets/d/1u5lr_oJBYo_uaAwSQl-2nqS2dwV3pjrQ/edit#gid=1210826692

Warning
titleImportant

The method to upload Peru taxes is different due to the effects of local FOREX revaluation in the period x the exchange of the last day of the year it would generate a divergence between the type of the 30/12 of SUNAT and of the Superintendence. 

To consult a comparison please see the attachment below:

View file
nameComparación del método de carga de tipo cambio PE x MX.xlsx
height250

End of document.

Viewtracker
hidetrue