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 exchange rates) in the months for which there are no actual rates yet.
Every month, around D1/D2, 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, upon requests from Corporate Controlling.
Below are the 2 types of conversion rates updated in this monthly process:
- TC - Closing rate
- TMN - Average cumulative rate
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 upload files.
Access the Simul ER update.xlsm trough 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 the file we receive.
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 worksheet BFC format 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 Q1 anymore
As of July we don't update Q1&Q2 anymore
As of October we don't update Q1&Q2&Q3 anymore
3. BFC upload
The files MM.YYY.txt have the correct format ready to be uploaded in BFC.
3.1 Update SIMULATION tables in BFCTop
In this example, we'll update 06.2022.
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.
