Zum Inhalt springen
Search the hub

← All suppliers

Finance

SAP Concur

Expense: reports/entries, travel — Concur API load, PII and spend measures.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

Expense spend

What is expense spend in the period?

SUM(TransactionAmount) FROM expense_entry WHERE Report.SubmitDate IN period AND IsPersonal = false
Grain
Expense entry
Fields
ExpenseEntry.TransactionAmount, ExpenseEntry.ExpenseTypeName, ExpenseReport.SubmitDate
Dimensions
expense_type, cost_center, employee, country, payment_status

Concur v3/v4 Expense APIs — TransactionAmount + CurrencyCode; allocation for cost center.

Adapt: Lock submit vs payment date and company vs personal share.

Example

Reports submitted

How many expense reports were submitted in the period?

COUNT(*) FROM expense_report WHERE SubmitDate IN period
Grain
Expense report
Fields
ExpenseReport.SubmitDate, ExpenseReport.OwnerLoginID, ExpenseReport.ID
Dimensions
employee, country, payment_status

SubmitDate from report header; ApprovalStatusName separate from PaymentStatus.

Adapt: Clarify counting recalls and resubmits once vs multiple times.

Reports approved

How many reports were approved in the period?

COUNT(*) FROM expense_report WHERE ApprovalStatusName = 'Approved' AND ApprovalDate IN period
Grain
Expense report
Fields
ExpenseReport.ApprovalStatusName, ExpenseReport.ID, ExpenseReport.Total
Dimensions
employee, cost_center, country

Map ApprovalStatusName locally (Approved / Approved & Closed).

Adapt: Lock first-approval vs final-approval and workflow stages.

Avg report amount

What is the average report amount?

AVG(Total) FROM expense_report WHERE SubmitDate IN period
Grain
Expense report
Fields
ExpenseReport.Total, ExpenseReport.CurrencyCode, ExpenseReport.SubmitDate
Dimensions
expense_type, country, employee

Total in report currency; FX to group currency before AVG if multi-currency.

Adapt: Lock median vs average and outlier caps (executive travel).

Mileage amount

What is mileage reimbursement amount in the period?

SUM(TransactionAmount) FROM expense_entry WHERE ExpenseTypeName IN ('Mileage','Personal Car Mileage') AND SubmitDate IN period
Grain
Mileage entry
Fields
ExpenseEntry.ExpenseTypeName, ExpenseEntry.TransactionAmount, ExpenseReport.SubmitDate
Dimensions
employee, cost_center, country

Map expense type codes/names per tenant; optionally add distance fields.

Adapt: Clarify company car vs personal vehicle and country rate (km vs mile).

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
Expense spend SUM(TransactionAmount) FROM expense_entry WHERE Report.SubmitDate IN period AND IsPersonal = false Expense entry ExpenseEntry.TransactionAmount, ExpenseEntry.ExpenseTypeName, ExpenseReport.SubmitDate
Reports submitted COUNT(*) FROM expense_report WHERE SubmitDate IN period Expense report ExpenseReport.SubmitDate, ExpenseReport.OwnerLoginID, ExpenseReport.ID
Reports approved COUNT(*) FROM expense_report WHERE ApprovalStatusName = 'Approved' AND ApprovalDate IN period Expense report ExpenseReport.ApprovalStatusName, ExpenseReport.ID, ExpenseReport.Total
Avg report amount AVG(Total) FROM expense_report WHERE SubmitDate IN period Expense report ExpenseReport.Total, ExpenseReport.CurrencyCode, ExpenseReport.SubmitDate
Mileage amount SUM(TransactionAmount) FROM expense_entry WHERE ExpenseTypeName IN ('Mileage','Personal Car Mileage') AND SubmitDate IN period Mileage entry ExpenseEntry.ExpenseTypeName, ExpenseEntry.TransactionAmount, ExpenseReport.SubmitDate

Tour