Blog · Procurement and supply chain · Procurement
A sourcing dashboard brings purchasing spend, supplier concentration and contract coverage into one review. Work through a reconciled purchasing example and see which sourcing decisions the measures support.
A sourcing dashboard compares purchasing spend, supplier concentration and contract coverage so buyers can choose where to investigate next. Start with reconciled invoices and match each purchase to the contract that applied when it occurred. The useful result is a short sourcing agenda with evidence behind each item.
The dashboard should let the procurement lead ask three connected questions: where is spending concentrated, how dependent are we on particular suppliers, and which purchases have contract support? A spend total without those distinctions tells the team how busy purchasing was, but gives little direction about the next negotiation.
The GSA's category management overview describes using purchasing data to manage suppliers, demand and total ownership cost across an enterprise. That federal example supports organizing spend around business decisions. A private company should define categories and coverage rules around its own purchasing arrangements.
Keep the review focused on sourcing choices. Daily purchase-order approvals, invoice processing queues and detailed supplier delivery measures can sit elsewhere. For the definitions behind a wider procurement scorecard, use the existing procurement KPI guide.
Bring the invoice-line export for one closed period, a supplier register and the dated contract register. Each invoice line needs a stable identifier, posting date, supplier identifier, category, net spend and currency. Contract matching also needs the buying entity, covered product or service and effective dates when those determine eligibility.
Use net invoiced spend for this example: purchases after credits, excluding recoverable tax, all in USD. Do not add purchase orders or payments to the same total. They describe different stages of the purchase. The purchase-order, invoice and paid-spend comparison explains that distinction.
Normalize suppliers before calculating concentration. Two spelling variants of one supplier should not look like alternative sources. Keep the original names alongside the normalized identifier so a buyer can inspect the mapping.
Consider a US components distributor reviewing September 2026. The following table summarizes its reconciled invoice lines by category, supplier and coverage status. A covered purchase has a valid, applicable contract on the purchase date. Unknown means the supplied records do not establish that status.
| Category | Supplier | Net spend (USD) | Coverage status |
|---|---|---|---|
| Packaging | Apex Packaging | 120,000 | Covered |
| Packaging | Beacon Cartons | 60,000 | Off-contract |
| Maintenance supplies | Forge Industrial | 80,000 | Covered |
| Maintenance supplies | Toolway Supply | 40,000 | Unknown |
| Freight | RouteCo | 70,000 | Covered |
| Freight | ExpressCo | 30,000 | Off-contract |
| Total | 400,000 |
The first panel groups those same rows by category. It keeps the numerator and denominator next to each coverage percentage. Percentages here and below are rounded to one decimal place; calculations use unrounded amounts.
| Category | Spend (USD) | Covered (USD) | Off-contract (USD) | Unknown (USD) | Coverage |
|---|---|---|---|---|---|
| Packaging | 180,000 | 120,000 | 60,000 | 0 | 66.7% |
| Maintenance supplies | 120,000 | 80,000 | 0 | 40,000 | 66.7% |
| Freight | 100,000 | 70,000 | 30,000 | 0 | 70.0% |
| Total | 400,000 | 270,000 | 90,000 | 40,000 | 67.5% |
Contract coverage = Covered net spend / All in-scope net spend
Supplier share = Supplier net spend / Net spend in the stated scope
Company coverage is 270,000 / 400,000 = 67.5%. Known off-contract spend is 90,000 / 400,000 = 22.5%, and unknown spend is 40,000 / 400,000 = 10.0%. These three shares account for the whole purchasing population.
Apex receives 120,000 / 180,000 = 66.7% of packaging spend, while its share of company spend is 120,000 / 400,000 = 30.0%. Both are correct. The category share describes dependence within packaging; the company share describes the supplier's overall financial importance. Label the scope so the reader cannot confuse them.
The contracted share roll-up covers detailed contract matching and category aggregation. Here, the matched amounts are inputs to the sourcing review rather than a replacement for that method.
The spend check is 180,000 + 120,000 + 100,000 = $400,000, matching the invoice export's control total. The coverage check is 270,000 + 90,000 + 40,000 = $400,000. Supplier totals must independently reconcile to that same amount.
Unknown status must stay in the denominator. If the buyer drops Toolway's unresolved $40,000, reported coverage becomes 270,000 / 360,000 = 75.0%. No additional purchase gained a contract; only the population changed. Show unknowns as an investigation queue and update the result when evidence arrives.
Retain the source invoice identifiers behind each summary. A reviewer should be able to move from a category total to the purchases behind it and then to the applicable contract evidence. If one invoice matches overlapping contracts, resolve that ambiguity before it becomes covered spend.
Packaging has $60,000 of known off-contract spend. Its category owner should check whether those purchases were approved exceptions, an unmet specification or an opportunity for a competitive event. The dashboard identifies the question; it does not establish that switching suppliers will save money.
Maintenance supplies has a different issue: $40,000 needs a contract-status decision. The buyer should resolve the evidence before treating it as avoidable off-contract purchasing. Freight has $30,000 of known off-contract spend, which needs its own explanation even though its coverage percentage is higher than packaging's.
Concentration should prompt a capability review, not an automatic supplier reduction. Federal market-research procedures explicitly consider suppliers' distribution and support capabilities, including alternative arrangements. For this private-company example, use the same practical question: can an alternative meet the required specification, capacity, service and terms?
The category manager owns the proposed action. Procurement operations owns supplier and contract matching, and finance confirms the purchasing basis and reconciliation. Record an owner, evidence needed and next review date for each action so the next meeting checks progress against the same scope.
Upload your purchasing export and relevant supplier and contract files to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the sourcing results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for procurement teams for the purchasing context.
Include net purchasing spend by category and supplier, the largest supplier's share, covered spend, known off-contract spend and unresolved contract status. Add the period, exclusions and responsible buyer so the review can produce a specific follow-up rather than another summary.
No. Coverage asks whether an applicable contract exists for a purchase. Compliance can also test whether the buyer used the correct supplier, item, price or terms. A covered invoice can still contain a pricing exception that needs a separate check.
Match the cadence to purchasing decisions and the availability of complete records. A monthly review can use closed invoice exports, while a renewal discussion may need the latest contract register. State the cutoff whenever the files have different refresh dates.