What do all the columns in the Supplier Classification Tracker mean?
| Column |
Field |
Who enters it |
Key notes |
| B |
Supplier Name |
Site Lead |
Paste from export using Paste Special → Values Only. Column T flags duplicates automatically. |
| C |
Registration Number |
Site Lead |
Company registration number from procurement system. Use Paste Special → Values Only. |
| D |
Primary Contact Name |
Site Lead |
Must be a named individual — not a team or department (e.g. Sales, Finance, Procurement). |
| E |
Primary Contact Email |
Site Lead |
Named contact email only. Avoid generic addresses: info@, sales@, admin@. |
| F |
Category / Commodity |
Site Lead |
3–5 word description (e.g. 'Explosives & blasting', 'IT support services'). Consistent naming improves reporting. |
| G |
Country |
Site Lead |
Country of registration or primary operating location. Use full names consistently (e.g. 'South Africa' not 'SA'). |
| H |
Annual Spend (ZAR) |
Site Lead |
Total annual spend in ZAR. Remove currency symbols before pasting. Enter 0 if unknown and note in column V. |
| I |
Spend ≥ ZAR 500K |
Auto |
Locked. Calculated from column H. Spend ≥ ZAR 500,000 = Yes → triggers Comprehensive Assessment automatically. |
| J–K |
Commercial criteria |
Site Lead |
J: Sole-source or critical supplier. K: Contract term > 12 months. Use dropdowns — do not type free text. |
| L–S |
ESG risk criteria |
Site Lead |
L: Sanctions | M: Private security | N: Labour-intensive | O: Labour broker/subcontractor | P: Migrant/vulnerable workers | Q: Community/land interface | R: Hazardous materials | S: On-site/mine-adjacent. Dropdowns only. |
| T |
Data quality |
Auto |
Locked. Flags duplicates, missing names, non-numeric spend. Resolve all flags before returning the tracker. |
| U |
Assessment Tier |
Auto |
Locked. Calculated from Yes/No inputs. Blank if column B is empty. Shows 'Not assessed' until criteria are complete. |
| V |
Notes / Status |
Site Lead |
Free text context — e.g. 'Spend is FY2025 estimate', 'ISO 14001 certified'. |
No results found
