Supplier Risk RegisterSpend analysis: Pareto, tail spend and concentration
Drop in an export of invoices, purchase orders or payments. See which suppliers make up 80% of your spend, how many sit in the tail, how concentrated spend is and how much has no contract behind it.
Your file never leaves your browser. The page is blocked from making network requests.
Columns it looks for: supplier (or vendor, payee), amount (or spend, net amount, invoice amount), and optionally category and a contract or PO reference. One row per line is fine; lines for the same supplier are added up.
Or paste the lines
What the numbers mean
- Pareto (80/20): the smallest number of suppliers that together make up at least 80% of spend. In the sample, 5 of 18 suppliers.
- Tail spend: the suppliers outside that group. Many small suppliers mean more invoices, onboarding and risk checks per dollar spent.
- Concentration (HHI): the sum of each supplier's squared percentage share, from near 0 (spread across many) to 10,000 (one supplier). The effective number of suppliers is 10,000 ÷ HHI: spend in the sample behaves as if it were split evenly across 4.5 suppliers.
- Spend without a contract: lines whose contract or PO column is blank or says no.
Next: score the suppliers that matter in the risk register, or estimate a negotiation with the savings calculator.
A spreadsheet goes stale. Keep the register live.
In Qeluntra, risk is scored when a supplier arrives through source-to-pay and onboarding, so the register is a view over the live record rather than a document someone refreshes.
Keep this register live in Qeluntra, free Guide: register columns and scoring
Free plan: no card, no expiration, one company workspace.