Supplier risk register template
A register lists each supplier with what could go wrong, how bad it would be, who owns it and what you're doing about it. Start from the blank template, or drop your existing supplier list into the tool and it builds the register for you.
Columns to fill in
| Column | What to put in it |
|---|---|
| Supplier | The supplier's name. The only column you must have. |
| Category | What you buy from them, in your own words (raw materials, logistics, IT services). |
| Country | Where the supply comes from. Used to see how much spend depends on one country. |
| Annual spend | What you spend with them in a year, in one currency. 1,250,000 and 1.250.000,50 both work. |
| Single source | Yes if there's no approved alternative supplier for what they provide, otherwise No. |
| Criticality | High, Medium or Low: how badly a failure would hurt your operations or customers. |
| Owner | The person accountable for managing this supplier's risk. |
| Treatment | What you're doing about it: accept, monitor, mitigate, find a second source or exit. |
| Review date | When the owner next checks it. Critical suppliers usually get the shortest cycle. |
The tool recognises common header names too (Vendor, Name, Sole source, Amount and others), and works with comma, semicolon or tab-separated files. Excel users: save as CSV first.
What the scored example shows
The example uses 12 made-up suppliers. The largest supplier holds 25.2% of spend, the top 5 hold 77.5%, and 3 are single-source. See how each score is worked out.
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.