1. Objective and Scope

The purpose of this document is to describe the monthly process to update SIMULATION exchange rates in BFC.

SIMULATION exchange rates are used in RSB reporting category (restatement of Y-1 with Y scope and Y exchange rates) in the months for which there are no ACTUAL rates yet.

Every month, around WD1/WD2 (WD = working day), after ACTUAL rates have been published, the Corporate Controlling team reviews the projection of exchange rates for the next quarter months until the end of the year.

BFC Admin team creates the 4 tables 03.YYYY, 06.YYYY, 09.YYYY, 12.YYYY at the beginning of each year and updates the tables every month.

Both, creation and update, ONLY upon requests from Corporate Controlling team. 

Below are the 2 types of conversion rates updated in this monthly process:

  • TC - Closing rate 
  • TMN - Average cumulative  rate
  • the other Exc. rates types (TO, TMNY-1...) updated in ACTUAL (REEL) Exc. Rates tables are excluded there


2. Upload files preparation  

The Corporate Controlling team sends an email to the BFC Admin with an Excel file attached with the quarter rates to be updated. 






The information BFC Admin needs is in BFC format tab.




There's an Excel macro workbook - BFC Simul ER update.xlsm - that should be used in order to generate the BFC import files.

Access the Simul ER update.xlsm through the link below and download it to your PC 





The Simul ER update.xlsm file has 4 tabs: 

  • data input - to which we will copy the data from BFC format tab of Corp Controlling's file. 
  • 03.2022 / 06.2022 / 09.2022 / 12.2022 - these tabs will be automatically updated from data input tab  (VLOOKUP formulas).

Important note: If there's any change in data input tab (e.g. new currency added), the other tabs must be adjusted manually (new currency lines must be inserted and formulas copied).


Every year we need to rename these tabs: 03.YYYY / 06.YYYY / 09.YYYY / 12.YYYY 








In the file received from Corporate Controlling select the entire "BFC format" tab and press Copy 



In Simul ER update.xlsm file , in data input tab , select Paste → Values 


The other tabs will be automatically updated.






Click on  to generate the import files.



BFC import files (one for each quarter) will be saved in the same directory where the Simul ER update.xlsm is saved.

Notes:

  • As of April we don't update 03.YYYY anymore
  • As of July we don't update 03.YYYY & 06.YYYY anymore
  • As of October we don't update  03.YYYY & 06.YYYY & 09.YYYY anymore




3. BFC upload

The files  MM.YYYY.txt have the correct format ready to be uploaded in BFC.


3.1 Update SIMULATION tables in BFC_Top

In this example, we'll update 06.2022.

In the Exchange rates module,

  • Open the corresponding SIMULATION 2022.06 table
  • Select File → Import






  • Processing existing data → Replace








Click on Import


Confirm there are no errors.


Click on Finish and Save before exiting the table.


3.4 Piloting to BFC_Production database

 Task EXPL-ADMIN has to be used to pilot SIMULATION Exchange Rates tables.















END OF THE PROCEDURE