IMScollect
Template · ISO 9001, ISO 14001 and ISO 27001

Supplier evaluation with weighted criteria

Which suppliers deliver reliably, and who needs a condition? The template evaluates against criteria you weight yourself and calculates the score and class.

Download the Excel templateExcel file · as of 13 November 2026 · no email address
supplier-evaluation.xlsx

Examples

Five completed evaluations for orientation, invented values

4 sheets17 columns60 rows prepared
Examples: extract from the template with example rows
SupplierService or product groupQuality (1-5)
Weber Precision Housings LtdMilled aluminium housings4
Northern Circuit Boards plcControl boards3
Cloud storage providerStorage for design data5
Hansen HaulageOutbound delivery4
Spotless Cleaning & Co.Building cleaning2
+ 11

more columns in the file: Criticality · Evaluated on · Ontime delivery (1-5) · Responsiveness and communication (1-5) · Price and value (1-5) · Environment (1-5) · Information security (1-5) · Decision · Action, condition · Next evaluation · Evaluated by

InstructionsCriteriaEvaluationExamples

Extract from the Excel file with example rows · the workbook has 4 sheets, highlighted columns are calculated by the template. The example values are invented.

What the template is for

ISO 9001 clause 8.4 asks you to determine and apply criteria for the evaluation, selection, monitoring of performance and re-evaluation of external providers and to retain the results. The question is whether a provider can meet your requirements.

ISO 14001 looks at outsourced processes and environmental requirements for suppliers, ISO 27001 at information security in supplier relationships (Annex A, controls 5.19 to 5.22). The template has its own criteria for both, which you can switch off by setting their weight to zero.

What is in the file

  • An “Instructions” sheet with steps and the rating scale from 1 to 5.
  • A “Criteria” sheet with six criteria and their weight in per cent: quality, on-time delivery, responsiveness and communication, price and value, environment, information security. Names and weights can be changed.
  • An “Evaluation” sheet with 60 rows: supplier, service, criticality, rating per criterion; the template calculates the weighted overall score and the class (A from 4.0, B from 3.0, otherwise C).
  • Columns for decision (approved, with conditions, blocked), action, next evaluation and evaluator; an “Examples” sheet with five suppliers.
Step by step

How to fill it in

  1. 1

    On the “Criteria” sheet, set the weights so they fit your business; together they must add up to 100 per cent, and the template shows the total.

  2. 2

    Enter all external providers whose performance affects your product, your environmental performance or your information security. Service providers such as cloud providers, calibration services or carriers are included.

  3. 3

    Set the criticality; evaluate critical providers more often and more closely.

  4. 4

    Give a rating for each criterion, based on data where possible: complaints, delivery reliability, response times, evidence such as certificates.

  5. 5

    Derive a decision from the class. For B and C, set an action, such as a supplier meeting, an audit or a second source.

  6. 6

    Enter the date of the next evaluation, annually for critical providers.

The same steps are in the file on the “Instructions” sheet, together with the rating scales and the completed examples.

Common mistakes when filling it in

What most often goes wrong when filling in this file, and how to avoid it.

Preset weights taken over unchecked
The weights on the “Criteria” sheet are a suggestion. If you do not run ISO 27001, set information security to 0; together the weights must add up to 100, and if the total is off, the cell turns red.
A rating invented instead of left blank
If a criterion does not fit a provider, leave the cell blank: criteria without a rating do not count. A 3 “to be on the safe side” shifts the overall score and with it the class.
Ratings from memory
If you rate without figures, you get a class nobody can justify. Before the evaluation, gather the complaints, delivery reliability and response times for the period and derive the ratings from them.
Class B or C without a decision
The “Decision” column stays empty or says “Approved” despite class C. Classes B and C need a decision and, next to it, an action, such as a supplier meeting or a condition with a deadline.
Criticality and next date missing
Without criticality, you cannot decide how often to evaluate, and without “Next evaluation” the re-evaluation is forgotten. Plan providers marked “High” at least once a year.

What an auditor checks for this clause and which nonconformities they often find is explained on the clause page: ISO 9001, clause 8.4: Suppliers and external providers.

ISO 9001 with IMScollect

In IMScollect you evaluate suppliers in the system, with score, approval and date of the next evaluation, and you handle complaints and supplier audits in the same system.

Find out more

See it working in one system

In a free demo we show you how these lists work together in IMScollect, with your standards and your questions.

Start 14-day free trial

Try it yourself, no call needed.Prefer a walkthrough? Book a guided demo →