Skip to content
D-LIT Logo

Dashboards & Reporting

Dashboards for vendor performance, procurement efficiency, and cost tracking.

By D-LIT Team

Procurement dashboards fail for one of two reasons: they show too much data without a clear decision framework, or they show high-level metrics that executives ignore because they cannot be actioned without drilling deeper. Both problems are design failures, not data failures.

Effective procurement dashboards are built around decisions, not metrics. Before designing any procurement dashboard, the first question is: what decision does this audience need to make, and what data do they need to make it confidently? The answer determines the KPIs displayed, the level of aggregation, the update frequency, and the alert thresholds. Tools like Plotono support this decision-first approach by allowing teams to build role-specific dashboard views that pull from shared data pipelines, so each audience gets exactly the data they need without duplicating the underlying integration work.

This article describes six procurement dashboard archetypes, each designed for a specific audience and decision context. Each includes the key metrics, layout principles, data requirements, and recommended update cadence. For the KPI definitions underlying each dashboard, see Procurement KPIs. For the data sources that feed these dashboards, see Procurement Data Sources.


Dashboard 1: Procurement Executive Overview

Primary audience: CPO, CFO, CEO Decision context: Strategic procurement performance: are we delivering on savings commitments, managing spend responsibly, and protecting supply chain? Update cadence: Monthly with real-time headline metrics

Purpose

The executive overview is not a management tool; it is a strategic summary. It answers three questions: Are we on track against the savings plan? Is spend under control? Are there supply chain risks that require executive attention? Everything else belongs in a more operational dashboard.

Executives who look at procurement dashboards are scanning for anomalies and confirmation that the function is performing. They do not want to investigate data; they want to be flagged when something requires their involvement. Design for exception reporting, not comprehensive reporting.

Core Metrics Section

Savings performance panel (top left, largest real estate):

  • Savings Delivered YTD vs. Target (large number with RAG status and trend arrow)
  • Savings Realisation Rate: YTD Delivered / YTD Committed (%)
  • Savings Pipeline: Projected full-year savings based on initiatives in progress
  • Prior year comparison: YTD savings vs. same period prior year

Spend control panel (top right):

  • Spend Under Management (%): current vs. prior year with trend sparkline
  • Maverick Spend (%): current vs. target with RAG indicator
  • Top 5 spend categories by volume (horizontal bar chart, current month)

Supply chain health panel (centre):

  • Supplier Risk Alerts: count of suppliers in Red tier with change from last month
  • Critical Supplier OTD (%): weighted average across Tier 1 suppliers
  • Active supply disruptions: count, with link to detailed dashboard

Procurement ROI (bottom):

  • Procurement ROI: £/$ savings per £/$ cost of procurement function
  • Cost Per PO: current vs. target and prior year
  • PO Cycle Time: average days, current vs. target

Layout Principles

Use a four-quadrant layout with headline KPIs as large numbers in each quadrant, supported by sparklines showing 12-month trend. RAG (Red/Amber/Green) indicators should use consistent threshold definitions agreed with the CPO and CFO. Avoid letting each dashboard designer set their own thresholds.

Limit the dashboard to a single screen without scrolling. If it does not fit on one screen, it contains too many metrics for an executive view. Every metric on this dashboard must map to a decision or escalation. If a metric cannot be actioned by an executive, it belongs on an operational dashboard.

Alert layer: The executive overview should surface a small number of exception alerts prominently (three to five items that require attention), generated by rule-based thresholds (supplier risk score moved to Red, savings realisation fell below 80%, maverick spend exceeded 12%). These should appear at the top of the dashboard and link to the relevant detailed view.


Dashboard 2: Spend Analytics Dashboard

Primary audience: CPO, Category Directors, Finance Business Partners Decision context: Where is spend going, and where are the largest opportunities for savings, consolidation, or category management intervention? Update cadence: Weekly refresh; real-time for tactical monitoring

Purpose

The spend analytics dashboard is the central tool for understanding the procurement landscape. It presents spend across the full category-supplier-department-geography matrix and enables rapid identification of anomalies, opportunities, and concentration risks. This is the most analytical of the six dashboards and requires the most from the underlying data (categorised, normalised, multi-entity consolidated spend data).

Core Sections

Spend by Category (primary view):

  • Treemap or sunburst chart showing spend volume by category hierarchy (Category Group → Category → Subcategory). Size represents spend volume; colour represents YoY change (warm for increase, cool for decrease).
  • Filter controls: time period, business unit, geography
  • Click-through from any category segment to category detail view

Spend by Supplier:

  • Top 20 suppliers by spend volume, with percentage of total spend and YoY variance
  • Supplier concentration metric: percentage of total spend with top 10 suppliers
  • New suppliers added in period (indicates new spend entering without contracted agreements)

Spend Trend:

  • Monthly spend volume over 24 months, stacked by category group
  • Overlay: contracted spend vs. spot spend vs. off-contract spend
  • Inflation-adjusted trend line (for direct materials categories): actual spend vs. what spend would have been at prior-year prices

Savings Waterfall:

  • Waterfall chart showing YTD spend variance decomposed into: Volume change, Price change (PPV), Structural change (mix shift), New categories/suppliers
  • This decomposition answers “why did spend change?” rather than just showing that it did

Maverick Spend Breakdown:

  • Maverick spend by department: which business units are buying off-contract most
  • Maverick spend by category: which categories have highest off-contract rates
  • Top 20 unapproved suppliers by maverick spend volume

Data Requirements

Categorised spend data (UNSPSC or custom taxonomy, minimum 3 levels), normalised supplier names with parent-child consolidation, department/cost centre dimension, prior year baseline for YoY comparison, contracted spend flag (PO references a contract vs. not). Without spend classification, this dashboard cannot be built beyond the supplier level.


Dashboard 3: Supplier Performance Dashboard

Primary audience: Category Managers, Supplier Relationship Managers, Operations Decision context: Which suppliers are meeting performance commitments, which are deteriorating, and which require intervention? Update cadence: Weekly; real-time for critical supplier alerts

Purpose

The supplier performance dashboard is the primary tool for supplier relationship management. It tracks delivery performance, quality, and responsiveness across the managed supplier base, and flags emerging trends before they become operational problems.

This dashboard is most valuable when it covers the full managed supplier base (not just Tier 1 strategic suppliers) and when performance data is sourced directly from system records rather than self-reported by suppliers. Self-reported supplier performance data is always optimistic.

Core Sections

Supplier Scorecard Summary:

  • Table of all managed suppliers with composite performance score
  • Columns: Supplier Name, Category, Annual Spend, OTD (%), Quality Rating, Lead Time (days), Risk Score, Overall Score, Score Trend
  • Sortable and filterable by category, score range, spend tier
  • RAG status per supplier and per metric, with threshold lines configurable by category manager

On-Time Delivery Analysis:

  • OTD trend chart: rolling 13-week OTD by supplier (line chart, multiple series for top 10 suppliers by spend)
  • OTD distribution: histogram of OTD rates across all suppliers, showing whether performance is broadly distributed or whether a small number of suppliers are dragging down the average
  • Late delivery root cause categories: if root cause data is captured, a breakdown by cause (supplier production delay, logistics, inaccurate date commitment, etc.)

Quality Performance:

  • Defect rate (PPM) by supplier, trended over 12 months
  • Inspection rejection rate by supplier and category
  • Warranty claims or service failures linked to supplier

Lead Time Performance:

  • Average lead time vs. committed lead time by supplier
  • Lead time variability (standard deviation): suppliers with high variability require more safety stock and deserve attention even if average lead time is acceptable
  • Lead time trend: are suppliers getting faster or slower over time?

Supplier Risk Heatmap:

  • 2x2 matrix: spend concentration (x-axis) vs. composite risk score (y-axis)
  • Each bubble is a supplier; bubble size represents spend volume
  • Suppliers in the top-right quadrant (high spend concentration, high risk) are the priority for risk mitigation

Design Note

Supplier performance dashboards need to be personalised by audience. A category manager for logistics should see their logistics suppliers; an automotive category manager should see their direct materials suppliers. Row-level security or dynamic filtering by category/portfolio is essential for this dashboard to be used by a broad category management team rather than just a central analytics team.


Dashboard 4: Contract Management Dashboard

Primary audience: Category Managers, Legal, Procurement Operations Decision context: Which contracts are at risk of expiring, which have compliance issues, and what is the contracted value at stake? Update cadence: Weekly; daily alerts for expiry thresholds

Purpose

The contract management dashboard prevents two common and expensive failures: contracts expiring without renewal (which strips procurement of pricing protection and compliance requirements), and contracted terms being ignored by buyers or suppliers (which undermines the value of the sourcing effort that created the contract in the first place).

Core Sections

Contract Expiry Pipeline:

  • Timeline view: contracts expiring in the next 30/60/90/180 days, with contracted annual value
  • Colour-coded urgency: Red (30 days), Amber (31-90 days), Green (91-180 days)
  • Renewal status column: Not started / In progress / Approved / Signed
  • Estimated value at risk if contract expires without renewal: contracted spend that would revert to spot purchasing

Contract Coverage Analysis:

  • Spend with active contracts vs. spend with expired or no contracts, by category
  • Contract coverage rate by category: percentage of category spend under active contract
  • Categories below target coverage rate highlighted with spend-at-risk calculation

Contract Compliance:

  • Compliance rate by category: percentage of purchases made under contracted terms
  • Top non-compliant categories and departments
  • Off-contract spend volume by supplier (where a contract exists but is not being used)

Contract Value Summary:

  • Total contracted spend under management
  • Average contract duration by category
  • Contract renewal success rate: percentage of expiring contracts successfully renewed vs. lapsed

Data Requirements

Active contract register with structured fields for: supplier, category, effective date, expiry date, annual contract value, renewal type (manual vs. auto-renew), and contract owner. Contract data must be linked to spend transaction data via supplier and category keys to calculate compliance rates. Without a CLM system, this data is typically in spreadsheets, which significantly reduces dashboard reliability.


Dashboard 5: Purchase Order Operations Dashboard

Primary audience: Procurement Operations, Shared Services, Finance Decision context: Are transactional procurement processes performing efficiently, and where are bottlenecks? Update cadence: Daily; real-time for SLA breach alerts

Purpose

The PO operations dashboard is the efficiency view of procurement. It tracks the velocity and quality of the procure-to-pay process from requisition to payment, and identifies where bottlenecks, errors, and delays are occurring. This is primarily used by procurement operations teams, not category managers or executives.

Core Sections

PO Cycle Time:

  • Average PO cycle time by category and business unit (days from requisition to PO)
  • Cycle time distribution: histogram showing whether delays are widespread or concentrated in specific request types
  • SLA compliance rate: percentage of POs issued within target cycle time
  • Bottleneck analysis: where in the process are delays occurring? (Requisition approval, sourcing, PO creation, supplier acknowledgement)

Invoice Match Rate:

  • Two-way match (PO vs. invoice) and three-way match (PO vs. receipt vs. invoice) rates
  • Invoice exceptions: count and value of invoices with price, quantity, or receipt discrepancies
  • Exception age: how long are invoice exceptions outstanding?
  • Exception by category: which categories have highest invoice exception rates

Purchase Order Quality:

  • PO amendment rate: percentage of POs that are modified after issuance (high amendment rates indicate poor requisition quality or scope creep)
  • Blanket PO utilisation: percentage of releases against open blanket POs vs. new POs (high blanket PO utilisation is efficient)
  • Emergency purchase rate: percentage of spend processed as emergency purchase orders, with cost premium estimate

Supplier Acknowledgement:

  • PO acknowledgement rate: percentage of POs acknowledged by supplier within SLA
  • Unacknowledged POs by supplier and age

Data Requirements

P2P platform timestamp data (requisition submitted, approved, PO created, supplier acknowledged, goods received, invoice received, invoice matched, payment processed). High-quality cycle time analysis requires accurate system timestamps for each process step. Organisations without a P2P platform and relying on ERP alone frequently have gaps in this data.


Dashboard 6: Category Spend Dashboard

Primary audience: Individual Category Managers Decision context: How is my category performing against savings targets, supplier commitments, and spend budget? Update cadence: Weekly

Purpose

The category spend dashboard is the most operational of the six archetypes. It is designed for daily use by individual category managers to monitor their category portfolio and identify action triggers. It should be personalised to the category manager’s portfolio.

Core Sections

Category Savings Performance:

  • Savings delivered YTD vs. target, by initiative
  • Savings pipeline: active initiatives in sourcing, with projected savings and confidence level
  • Savings at risk: initiatives where execution is behind schedule or target savings are being revised

Category Spend Trend:

  • Monthly spend in category over 24 months
  • Spend by sub-category
  • Spend by supplier: are any suppliers growing share unexpectedly?
  • Price trend: average unit price trend over time, compared to relevant market index

Supplier Performance Summary:

  • OTD, quality, and lead time for all active suppliers in the category
  • Suppliers with OTD below threshold highlighted
  • Upcoming contract renewals in category

Demand Outlook:

  • Projected category spend for next 3 months based on demand signals
  • Open purchase orders value (committed spend)
  • Category budget remaining

Personalisation

The category dashboard must be personalised. A single generic category dashboard shown to all category managers creates a bad user experience and low adoption. Implement row-level security or dynamic filtering so each category manager automatically sees only their assigned categories, suppliers, and initiatives. This is a data access architecture decision that must be made before the dashboard is built.


Cross-Dashboard Design Principles

Consistent Metric Definitions

The same KPI must have the same definition across all six dashboards. Savings Realised means the same thing on the executive overview as it does on the category spend dashboard. This seems obvious but is frequently violated in practice when dashboards are built by different teams at different times. Establish a procurement metrics glossary before building dashboards, and enforce it through a semantic layer in your BI platform.

Drill-Through Navigation

Executive dashboard metrics should drill through to operational dashboards. A CPO who sees a red maverick spend indicator on the executive overview should be able to click through to the spend analytics dashboard filtered to off-contract spend, then drill into the category detail, then see the specific suppliers and departments responsible. This navigation chain makes dashboards a decision tool rather than a reporting artefact.

Alert Thresholds and Notifications

Passive dashboards that require users to log in to check for problems are less effective than proactive alerts. Configure threshold-based alerts for the metrics most likely to require rapid response: supplier OTD drops below threshold, contract within 30 days of expiry with no renewal action, maverick spend spike in a specific department. These alerts should be delivered to the relevant user via email or Slack rather than requiring login.

Update Frequency and Data Freshness

Show data freshness timestamps on every dashboard. Users who do not trust data freshness will not trust the dashboard. Automate ETL processes so dashboards are updated without manual intervention. For operational dashboards (PO operations, supplier performance), daily refresh is minimum. For executive and spend dashboards, weekly refresh with real-time headline metrics is appropriate.

For the KPIs underlying these dashboard designs, see Procurement KPIs. For the analytical models that generate insights for category managers, see Procurement Techniques.

Get More from D-LIT

Ready to transform your analytics capabilities? Talk to our team about how D-LIT can help your organisation make better, data-driven decisions.

Get in Touch