← All resources

Supplier and Vendor Database (Excel)

A ready-to-use Excel database for businesses and procurement teams to manage their suppliers in one place. Supplier Register: contact and registration details, category, approval status, and expiry dates for key documents (tax clearance, licence, insurance, certifications). Compliance is flagged automatically as Compliant, Expiring soon or Expired. Orders & Contracts: records each order and its value, and shows whether delivery was on time, late or is overdue. Performance Evaluations: scores each supplier on weighted criteria and gives a rating from Excellent to Poor. Dashboard: total spend by category, the top 10 suppliers by spend, document expiry alerts, the on-time delivery rate and performance ratings. How to use: Setup: enter your organisation name and currency. Edit the supplier categories and the performance weights (they must add up to 100%). Supplier Register: add each supplier with a unique ID (for example SUP-011), contact details, approval status and document expiry dates. Orders & Contracts: log each purchase order or contract, and enter the delivery date when the goods or services arrive. Evaluations: score suppliers from 1 to 5 after each contract or periodic review. Dashboard: check it regularly and follow up on expired documents, overdue deliveries and suppliers rated Poor. Before use: delete the example rows but keep the grey formula columns. Don’t store bank account numbers in the file.