Zum Inhalt springen
Search the hub

← All suppliers

Finance

Coupa

Spend: PO, invoice, expense — Coupa API load, PII and maverick/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

PO spend

What is Coupa PO volume in the period?

SUM(total) FROM purchase_order WHERE created-at IN period
Grain
Purchase order
Fields
PurchaseOrder.total, PurchaseOrder.created-at, PurchaseOrder.supplier_id, PurchaseOrder.currency.code
Dimensions
supplier, commodity, chart_of_account, department, status

Coupa REST — purchase_orders.json; total + currency.code; hyphenated API fields.

Adapt: Clarify canceled/draft POs and change orders in the definition.

Example

Invoice spend

What is Coupa invoice spend in the period?

SUM(total-with-taxes) FROM invoice WHERE invoice-date IN period AND status NOT IN (voided, draft)
Grain
Invoice
Fields
Invoice.total-with-taxes, Invoice.invoice-date, Invoice.status, Invoice.supplier_id
Dimensions
supplier, commodity, chart_of_account, department, status

invoices.json — total-with-taxes; invoice-date vs created-at for period choice.

Adapt: Lock credit notes and tax-inclusive vs exclusive.

Expense spend

What is Coupa expense spend in the period?

SUM(total) FROM expense WHERE created-at IN period AND status = approved_for_payment
Grain
Expense
Fields
Expense.total, Expense.status, Expense.user_id, Expense.expense-category_id
Dimensions
commodity, department, chart_of_account, status

expense_reports / expense_lines — map status whitelist per tenant.

Adapt: Clarify submitted vs paid and personal vs corporate card.

Maverick spend rate

What share of spend runs outside policy/contracts?

SUM(spend WHERE maverick) / SUM(spend) — requires policy definition
Grain
Spend line (PO/Invoice/Expense)
Fields
PurchaseOrder.total, Invoice.total-with-taxes, Contract.id, PurchaseOrder.supplier_id
Dimensions
supplier, commodity, department, chart_of_account

Maverick requires a policy definition (no contract, off-catalog, non-PO) — fields are tenant-specific.

Adapt: Lock policy with procurement governance before reporting the rate.

Suppliers active

How many suppliers had spend activity in the period?

COUNT(DISTINCT supplier_id) FROM purchase_order OR invoice WHERE date IN period
Grain
Supplier with activity
Fields
PurchaseOrder.supplier_id, Invoice.supplier_id, PurchaseOrder.created-at
Dimensions
commodity, department, chart_of_account

Active via transactions — not only suppliers.status=active.

Adapt: Lock threshold (min spend) and one-time supplier rules.

Formula overview

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

Label Formula Grain Fields
PO spend SUM(total) FROM purchase_order WHERE created-at IN period Purchase order PurchaseOrder.total, PurchaseOrder.created-at, PurchaseOrder.supplier_id, PurchaseOrder.currency.code
Invoice spend SUM(total-with-taxes) FROM invoice WHERE invoice-date IN period AND status NOT IN (voided, draft) Invoice Invoice.total-with-taxes, Invoice.invoice-date, Invoice.status, Invoice.supplier_id
Expense spend SUM(total) FROM expense WHERE created-at IN period AND status = approved_for_payment Expense Expense.total, Expense.status, Expense.user_id, Expense.expense-category_id
Maverick spend rate SUM(spend WHERE maverick) / SUM(spend) — requires policy definition Spend line (PO/Invoice/Expense) PurchaseOrder.total, Invoice.total-with-taxes, Contract.id, PurchaseOrder.supplier_id
Suppliers active COUNT(DISTINCT supplier_id) FROM purchase_order OR invoice WHERE date IN period Supplier with activity PurchaseOrder.supplier_id, Invoice.supplier_id, PurchaseOrder.created-at

Tour