1. Objective and Scope

The purpose of this document is to describe the BFC Admin activities concerning the PREV category in BFC. 

PREV phase is managed by the Corporate Controlling team and used by GBU controllers for Y+1 budget exercise.  

PREV it's a yearly phase with its own conso scope (PREV), currency conversion rates (PREV) and category scenario (PREV).

The content is restricted to P&L, WC, Fixed assets per business - multi periods category (5 quarters) - reporting per Business using fictive reporting companies (not legal ones).


2. Reporting Setup

2.1 Reporting setup - Reporting Organizer

The opening of PREV phase should occur in July.

To create a new Reporting ID for the period, select the one of the previous year in the field Select Reporting IDs.


Then in Reporting Organizer module Open it and Save As.





The General tab defines the general properties of the reporting ID.

Enter the following information:

  • Category - PREV
  • Data entry period - YYYY.12
  • Short & Long description - Budget - YYYY.12




The Definition tab indicates the reporting status. It can also be specified the associated category scenario and the start and end dates for the reporting.

Enter the following information:

  • Version of category scenario: PREV1609 
  • Start & End Date: Adjust start and end date.


The Package tab defines the data entry settings applicable to packages:

  • Windows and Internet folder: 00L-PREVEN
  • Set-of controls: PREV 
  • Control level to be reached: PREV
  • Blocking - Flag the option Blocking.


The Restrictions tab defines the data entry restrictions which are applied when the data is entered.

There are no restrictions to be set up.


The Operation tab defines the settings to publish the packages. 

In the Deadline it has to be informed the date that the packages will have to be published.


  • Deadline  31.12.YYYY+1.

Setting the deadline at the end of YYYY+1 will allow Corporate controlling team to publish or republish packages in the year of the budget. 




2.2 Reporting setup - RU Organizer and Package Manager

As general rule, BFC Admin can copy the list of packages completed in YYYY-1 + the 3 central adjustments ones (GEST-ADJ / AJUST-RH / AJUST-DISCOP). 

However, the list of packages to be created must always be confirmed by Corporate Controlling team (KUF Nicolas Bourgois).





3. PREV consolidation scope

3.1 Scope definition

PREV scope must be created in FCTop and piloted to FCProd.

Only required the list of companies for which PREV packages have been created.


  • Consolidation method - FC Full conso
  • Rate - 100%




3.2 Piloting to BFC_Production database

Task EXPL-GESTION has to be used to pilot PREV consolidation scope.







4. PREV exchange rates

PREV exchange rates are provided by Corporate Controlling team, in July, in an excel file.

BFC Admin team,

  • creates the 4 tables 03, 06, 09, 12 (YY+1) in July (YY)
  • updates 09 table in Oct.1st (TCN-1 & TMYN-1) 
  • updates the 4 tables in Jan.1st YY+1 (TCN-1 & TMYN-1 & TMN-1 & TO)

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





The file sent to BFC Admin must have a tab - BFC INPUT - with the Average (TMN) and Closing (TC) rates for the quarters of the next year.





4.1 PREV exchange rates - Initial update (July)

In FCTop, in the exchange rates module,

  • Open the YY PREV tables (03, 06, 09, 12)
  • Do a save as  of each table (YY+1)

In this example, to create 2023 tables we do a Save as from 2022 tables. 






There's an Excel workbook - BFC PREV ER update.xlsx  - that should be used to prepare the BFC tables update.

The file - BFC PREV ER update.xlsx - is saved in this folder on the remote desktop \\Acew1ptsefcp1\BFC-SHARE\ER\PREV


The file can also be found in the Gdrive







Open BFC Excel WIN Link Prod and then open the file. 







The file has several tabs: 

  • Copy BFC input 
  • PREV 03 , PREV 06 , PREV 09 , PREV 12 
  • PREV 09 update (Y) - to be used in Oct. to update Sept. rates
  • PREV 03 update(Y+1) , PREV 06 update(Y+1) , PREV 09 update(Y+1) , PREV 12 update(Y+1)-  to be used in Jan.YY+1 to update Dec. rates





Tab Copy BFC input - is the one to which we should copy/paste the values we receive in BFC input from the requestor.



Tabs PREV 03 , PREV 06 , PREV 09 , PREV 12 - will be automatically updated trough excel formulas and BFC excel retrieval formulas.


PREV 03 and PREV 06

TC & TMN (columns C & D) - values are retrieved trough formulas from tab Copy BFC input;

TMN-1 & TO (columns E & F) - values are retrieved from BFC (PREV / Dec. Y-1);

TCN-1 & TMYN-1 (columns G & H) - values are retrieved from BFC (REEL / N-1);






To update TMN-1 & TO (columns E & F) and  TCN-1 & TMYN-1 (columns G & H) we must connect to BFCTop






Once the data has been refreshed we should copy the tables into BFC:

    • Select C4:H44 range and copy / paste into BFC 




PREV 09 and PREV 12

TC & TMN (columns C & D) - values are retrieved trough formulas from tab Copy BFC input;


4.2 PREV exchange rates - Update with REEL rates (Oct.)


4.3 PREV exchange rates - Update with REEL rates (Jan.)


5. Consolidation definition

PREV consolidation is defined yearly and it's multi-period:

Data entry period 12.YY

Calculated periods 03.YY+1; 06.YY+1; 09.YY+1; 12.YY+1

In the tab General should contain the following information:

  • Category: PREV
  • Data entry period: YYYY.12
  • Scope: PREV
  • Variant: 2
  • Currency: EUR 
  • Long Description: Budget YYYY.12- YYYY+1


In the tab Properties should contain the following information:

  • Scope Period: YYYY.12 
  • Version: S-1
  • Set of rules: PREV12
  • Multiply thresholds by: 1
  • Conversion Rate Period: YYYY.06
  • Conversion Rate Version: REEL



In the tab Opening Balances no opening balance data 


In the tab Periods conversion rates need to be adjusted to the PREV rates.