General Description |
|---|
The T&E Dashboard has the objective to :
The dashboard is providing different angles of analysis :
There are some accesses restrictions to employee level information in accordance to GDPR regulations. Sources: This dashboard has been build using 3 different data sources:
* list to attached **clarify amount between Spend report & O&D report Dashboard is providing N-1 data, as well as current year YTD M-1 data. Data of M-1 are available on the 15th day of M. Dashboard is only available in EUR. |
Dimensions Overview:
| Qlikview | Comments |
|---|---|
GBU / Function | |
| Company | |
| Region | APAC, EMEA, LAM, NAM |
| Country | Company country |
| Year | Y-1, Y |
| Quarter | |
| Month | |
Cost Center | |
| Fixed Cost Group 2 | |
| Vendor | Name, Number |
Details on sources:
Expenses :Concur Data
There are two different Concur systems; one from Solvay and the other from Cytec legacy (expected to run until 2020). Concur is a tool were employees are claiming T&E for reimbursement. This tool is still under implementation and therefore not covering 100% of the scope.
INCLUDE LINK TO CONCUR SCOPE AND DEPLOYMENT PLAN
Finance/Controlling data: P&L
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 scope.
Also note that there is an average of 35 days lagging effect between a booking and its impact in BW, with the assumption that travellers are expensing at least once a month (policy recommendation).
FX effect methodology
TO DO
Booking information: Travel Agency data AmexGBT Insight
Detail files with different spend references
Not able to find the solution? Contact SBS Support.