You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 85 Next »











Process Owner

Excellence Center Demand Management & Purchasing


T&E Expert

Claire Boursier - Philippe Vanash


D&PS Expert

Marie-Line Ardito

 

General Description

The objective is to allow GBU and Functions monitoring their spend evolution, as well as their travelers behaviors over time. The T&E Dashboard, is a result of a Demand Management initiative and therefore has been built to increase transparency on T&E Spend, Expenses reports and travelers behaviors.
It has been built using 3 different data sources :


 *check details in "Information on data sources" Concur
**check details in "Information on data sources" Amex GBT

Those sources are coming from different tools, using different scope and reference dates. 


It is recommended to use Expenses and Booking information as additional information to Finance- Controlling data from BW, but not to try to match figures of the 3 sources.

This dashboard is providing different angles of analysis :
    1. Executive summary & group benchmark
    2. Financial overview - spend evolution (controlling data)
    3. Expenses overview (Concur data)
    4. Bookings behaviors (AmexGBT/travel agency data )
    5. Bookings overview (AmexGBT/travel agency data )  
    6. My reports

ADD LINK TO DETAILS FOR EACH SECTION

There are some accesses restrictions to employee level information in accordance to GDPR regulations.
You will find N-1 data, as well as current year YTD M-1 data, all figures are in EUR.
Data of M-1 are available on the 15th day of M. (also display info in dashboard)
By default, data selection is always YTD of current year.
What is online & offline, ATP or O&D? Click here to see the glossary and fully understand the acronyms of T&E.

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.


Data Sources

3 different data sources, those sources are coming from different tools, using different scope and reference dates. 
It is recommended to use Expenses and Booking information as additional information to Finance- Controlling data from BW, but not to try to match figures of the 3 sources.


Period of Analysis

  • Current Year
  • Y-1
  • By Month, By Quarter


Dimensions

Dimension Description
Finance -Controlling (BW)
Expenses
(Concur)
Booking
(AmexGBT)
Comments
GBU / Function
X
X
X

Sub GBU/Function
X
X


Company (name - code)
X
X


Region
X
X
X
Origin region of expense
Country
(country of employee)
X
(Company Country)
X
(Country of Employee)
X
(Country Point of Sale)

Hotel/Car rental Country


X

Hotel/Car rental City


X

Cost Center
X
X

No cost center for Cytec Concur
Year
X
X
X

Quarter
X
X
X

Month
X
X
X

Reference date
Posting Date
Send for Payment date
Booking date

Vendor Name
X (question)

X
Airline or Railway company
Expense Type (Cluster)

X


Trip Purpose


X

Trip Duration


X

Employee Name

X
X (Traveler Name)

Booking Channel (Online/Offline)


X
Online or Offline
Compliance on advance purchase (Yes/No)


X

Lowest Logical Fare Adoption (Yes/No)


X

Primary Product Code


X
Air- Rail - Car - Hotel
Domestic or Regional/International


X

Class of Service


X
Booking class (Explain FIRST vs FIRST US & others) for Air/Rail
Car type for Rental
Frequent traveler


X
travelers with an average of more than 2 bookings per month (air and/or rail)
VIP


X
travelers accessing AMEX VIP service
SLT

X
X
travelers part of Solvay Leadership Team (to Do)
O&D Net Amount


X
allow to filter above certain ticket amount


A conserver???

QlikviewComments

GBU / Function

 
Company 
RegionAPAC, EMEA, LAM, NAM
CountryCompany country
YearY-1, Y
Quarter
Month

Cost Center


Fixed Cost Group 2
VendorName, Number


 

 

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels