Expenses Overview

add screenshot of the dashboard with Numbers of final version in Qlik

Restricted on Scope

Scope of Concur is not finalized yet (see planning of deployment for Concur) - therefore it is not always relevant to compare N vs N-1.

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.

Nb	Name	Source	Calculation	Comments
1	Total expenses	Concur - Expenses	∑Approved Amount without reclaimable tax (EUR)	Total is excluding Pcard
2	Number of active spenders		Count number of Employee over period (no duplicates)	Any employee that enter an expense in Concur over the analysis period
3	Expenses per region/Country (%)		∑Approved Amount without reclaimable tax (EUR) in % of each Region or country	This metric has 2 dimensions: Region or country Region/country is origin region/country from the traveler, not the location of the expense
4	Expenses by Cluster		∑Approved Amount without reclaimable tax (EUR) in % of each expense cluster	This metric has 2 dimensions: % or EUR A cluster is a grouping of similar expense types in Concur
5	Spend evolution		∑Approved Amount without reclaimable tax (EUR) per month/quarter	This metric has 2 dimensions: Month / Quarter
6	Spend per Employee		∑Approved Amount without reclaimable tax (EUR) per month per employee
7	Spend per Cost Center (name + code)		∑Approved Amount without reclaimable tax (EUR) per month per cost center	Not available in Concur Cytec

Page tree

Expenses Overview

Excellence Center Demand Management & Purchasing

Claire Boursier

Marie-Line Ardito

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.

1

Total expenses

Concur - Expenses

∑Approved Amount without reclaimable tax (EUR)

Total is excluding Pcard

2

Number of active spenders

Count number of Employee over period (no duplicates)

Any employee that enter an expense in Concur over the analysis period

3

Expenses per region/Country (%)

∑Approved Amount without reclaimable tax (EUR) in % of each Region or country

This metric has 2 dimensions: Region or country

Region/country is origin region/country from the traveler, not the location of the expense

4

Expenses by Cluster

∑Approved Amount without reclaimable tax (EUR) in % of each expense cluster

This metric has 2 dimensions: % or EUR

A cluster is a grouping of similar expense types in Concur

5

Spend evolution

∑Approved Amount without reclaimable tax (EUR) per month/quarter

This metric has 2 dimensions: Month / Quarter

6

Spend per Employee

∑Approved Amount without reclaimable tax (EUR) per month per employee

7

Spend per Cost Center (name + code)

∑Approved Amount without reclaimable tax (EUR) per month per cost center

Not available in Concur Cytec