1. Objective and Scope

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

PREV phase is operated by the Corporate Controlling team (not GAR) and used by GBU controllers to report and consolidate Dec. Y and quarterly Y+1 Budget / Forecasts:

  • Budgeting process conducted at detailed level in Controlling tools, BFC being the final step to aggregate GBU's forecasts and to provide Consolidated Forecasts at Group level
  • 5 periods : Dec. Y  / Quarterly 03 06 09 12 Y+1
  • Reporting to BFC not handled by legal company but at the GBU level using fictive reporting companies (1 package per GBU in K. Euros + 3 dedicated central packages for Corp Controlling)
  • Note that single consolidation method "IG / fully conso" for each fictive package. Non Conso companies being excluded, Equity Methods and IP methods being directly integrated in GBU package, not relying on consolidation rules
  • Reporting content made of P&L (Sales to Net result), Balance Sheet (Working Capital, Fixed Assets), CAPEX, SCF (Simplified Cash Flow / GBU) and FCF (Free Cash Flow / Group)
    • using some aggregated headings (compared to detailed chart of headings used in ACTUAL's category)
    • using limited flows : Closing balance F99 F99EX F99 AJ for P&L (to manage both IFRS and Underlying sets of Financial statements), closing balance F99 for BS and some variations flows for CAPEX and SCF
  • Purpose of PREV Exchange Rates : not used for the consolidation of Budget data (as packages are reported directly in K. Euros) but used in RSB (Restated Y-1) consolidations (variant 2) for future months (when ACTUAL rates are yet available)

From a customizing point of view, this category has its own:

  • Scope (PREV code)
  • Exchange rates (PREV version)
  • Category scenario (PREV code)
  • Package schedules / folders and Controls


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 will define the associated category scenario and the start and end dates for the reporting.

Enter the following information:

  • Version of category scenario: PREVxxxx (latest version to be selected) 
  • 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.
  • Opening balance data : not applicable: Budget is focused on future, not needing any link with the past ACTUAL's or PREV's


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

  • There are no restrictions to be set up. Compared to ACTUAL's categories, PREV category does not require any link or reference to the past (no need for F00 "opening balance")


The Operation tab defines the settings associated with packages publication. 

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 update packages all during the Budget year




2.2 Reporting setup - RU Organizer and Package Manager

As general rule, BFC Admin should copy the list of packages completed in the previous PREV exercise:

  • GBU packages using fictive GBU companies
  • 3 central packages (GEST-ADJ / AJUST-RH / AJUST-DISCOP) directly completed by Controlling Corporate

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

  • in case of new GBU created since the previous PREV exercise, most probably that a GBU fictive company will have to be created, integrated in PREV scope and its PREV package created as well
  • in case of GBU divested or merged since the previous PREV exercise, most probably that its package will not be required anymore and that its fictive company will be excluded from the PREV scope



Folder adaptation for central packages dedicated to Adjustments  AJUST-DISCOP and AJUST-RH:

  • Folder dedicated to GBU "00L-PREVEN" selected in the General Reporting Organizer has to be removed for those 2 companies and replaced by the folder "00L-PREVRH"
  • Difference between both : 00L-PREVRH folder will allow Corporate Controlling to report Financial Statements sections not handled by GBU
    • P&L : headings to bridge from post EBIT to Net Result
    • Headings to bridge from SCF (Simplified Cash flow / GBU) to FCF (Free Cash Flow / Group)







Final step in package manager, launching the generation of packages.




3. PREV consolidation scope

3.1 Scope definition

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

It has to include the list of companies for which PREV packages have been created.


  • Consolidation method - FC Full conso : as explained above, special consolidation methods (Equity methods, IP, Non Conso) are directly integrated in packages, not relying on consolidation treatments
  • Rate - 100%




3.2 Piloting to BFC_Production database

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








3.3 Internal Control 

It is part of the internal controls to archive the evidences of the objects created in the BFC_Top and transferred to BFC_Prod, as well as the approval initially obtained from the Corporate Controlling (e-mails).








The e-mail should be save in PDF format and archived in the following Google Drive folder of BFC Admin team Internal Control folder for pilotings

Select the sub folder related to the current year => EXPL-GESTION sub folder => relevant quarter

The file Name should be coded this way: Code of the Reception task in BFC_Prod DD.MM.YYYY- E-mail Subject





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  to 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 and refresh the file










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;


As in July we don't have yet the REEL rates for Sept. and Dec., we will update only TC & TMN (columns C & D).


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







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

Once 09 YY REEL rates become available,

In BFC PREV ER update.xlsx, there's a tab PREV 09 update (Y) created to retrieve 09 YY REEL rates and to update TCN-1 & TMYN-1 columns in 09 YY+1 PREV rates table.


Once the data has been refreshed we should copy the 2 columns into BFC.



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

Once 12 YY REEL rates become available, YY+1 PREV rates tables can be updated.

In BFC PREV ER update.xlsx, there are 4 tabs PREV 03 update(Y+1), PREV 06 update(Y+1), PREV 09 update(Y+1) and PREV 12 update(Y+1)  created to retrieve 12 YY REEL rates and update Dec. YY-1 in PREV rates.


03, 06 and 09 PREV tables

In these tables we need to update TCN-1 & TMYN-1 columns.


12 PREV table

In these table we need to update TMN-1, TO,  TCN-1 & TMYN-1 columns.



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.