Finance / Controlling data

Objective
This report is a fixed costs report on Travel & Expenses set up by Solvay reporting platform and is the reference for P&L calculation.

Target Users

ExCom
Leadership team
Financial Directors
Purchasing Function
Controllers

Authorization & Rights

All the accesses must be validated by:

Excellence Center / Purchasing

Click here for the Access form to get access to the T&E Dashboard.

Current authorizations are available on this file.

Currency - RSB - FX effect

In order to neutralize the FX effect, spend is always extracted in local currency and calculated in EUR using the following methodology :

Current Year (M-1)+ Y-1 RSB : Data are extracted in EUR each month
- - Exchange rate : CAR 3 (Monthly Average End of M-1)

All spend of current year is adjusted from local currency to EUR using the exchange rate (average value) of M.

Y-1 Historical : Data are extracted once a year (in January)

All spend of previous year is fixed and adjusted using average value of December of this same year.

Source & Scope
BW sources : GBUs : Functions : Solvay group Exception BAAN & PE1 spend cannot be extracted from BW. In the meantime of Composites Materials integration on WP1, data are extracted from Cognos (owner: James Blandford) and are RSB with the same methodology as spend extracted from BW.

Additional Information

It has been agreed that controlling data are the reference to measure the spend evolution and will only be adjusted with FX effect and not on scope.

Also note that there is an average of about 35 days lagging effect between a booking and its impact in BW, with the assumption that travelers are expensing at least once a month (policy recommendation).

Page tree

Excellence Center Demand Management & Purchasing

Claire Boursier

Marie-Line Ardito

Finance / Controlling data

This report is a fixed costs report on Travel & Expenses set up by Solvay reporting platform and is the reference for P&L calculation.

ExCom

Leadership team

Financial Directors

Purchasing Function

Controllers

All the accesses must be validated by:

Excellence Center / Purchasing

Click here for the Access form to get access to the T&E Dashboard.

Current authorizations are available on this file.

In order to neutralize the FX effect, spend is always extracted in local currency and calculated in EUR using the following methodology :

Current Year (M-1)+ Y-1 RSB : Data are extracted in EUR each month

Exchange rate : CAR 3 (Monthly Average End of M-1)

All spend of current year is adjusted from local currency to EUR using the exchange rate (average value) of M.

Y-1 Historical : Data are extracted once a year (in January)

Exchange rate : CAR 3 (Monthly Average December Y-1)

All spend of previous year is fixed and adjusted using average value of December of this same year.

BW sources :

GBUs :

Functions :

Solvay group

Exception

BAAN & PE1 spend cannot be extracted from BW.

In the meantime of Composites Materials integration on WP1, data are extracted from Cognos (owner: James Blandford) and are RSB with the same methodology as spend extracted from BW.

It has been agreed that controlling data are the reference to measure the spend evolution and will only be adjusted with FX effect and not on scope.

Also note that there is an average of about 35 days lagging effect between a booking and its impact in BW, with the assumption that travelers are expensing at least once a month (policy recommendation).

Page tree

Copy of Financial Overview

Excellence Center Demand Management & Purchasing

Claire Boursier

Marie-Line Ardito

Finance / Controlling data

This report is a fixed costs report on Travel & Expenses set up by Solvay reporting platform and is the reference for P&L calculation.

ExCom

Leadership team

Financial Directors

Purchasing Function

Controllers

All the accesses must be validated by:

Excellence Center / Purchasing

Click here for the Access form to get access to the T&E Dashboard.

Current authorizations are available on this file.

In order to neutralize the FX effect, spend is always extracted in local currency and calculated in EUR using the following methodology :

Current Year (M-1)+ Y-1 RSB : Data are extracted in EUR each month

Exchange rate : CAR 3 (Monthly Average End of M-1)

All spend of current year is adjusted from local currency to EUR using the exchange rate (average value) of M.

Y-1 Historical : Data are extracted once a year (in January)

Exchange rate : CAR 3 (Monthly Average December Y-1)

All spend of previous year is fixed and adjusted using average value of December of this same year.

BW sources :

GBUs :

Functions :

Solvay group

Exception

BAAN & PE1 spend cannot be extracted from BW.

In the meantime of Composites Materials integration on WP1, data are extracted from Cognos (owner: James Blandford) and are RSB with the same methodology as spend extracted from BW.

It has been agreed that controlling data are the reference to measure the spend evolution and will only be adjusted with FX effect and not on scope.

Also note that there is an average of about 35 days lagging effect between a booking and its impact in BW, with the assumption that travelers are expensing at least once a month (policy recommendation).