Vendor Rating and Supplier Evaluation: A Simple Method

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

Supplier evaluation is the check you do before you add a new supplier: capacity, quality systems, finances and references. Vendor rating is the ongoing score you give suppliers you already buy from. It uses your own purchase orders and goods receipts: on-time delivery, quality (accepted vs rejected quantity), price and responsiveness. Score 4 to 6 criteria, always include quality and delivery, and review key suppliers every quarter.

Supplier evaluation vs vendor rating: what's the difference?

Evaluation happens once, before the first purchase order. It asks: can this supplier make what we need, at our quality, on time?

Rating happens every quarter for suppliers already on your list. It asks: did they deliver what they promised? A supplier can pass evaluation and still score badly once real orders start.

How to evaluate a new supplier before the first PO

To evaluate and select a supplier, check six things. Go in this order, so weak suppliers drop out before you spend time on a visit.

  • Capacity: monthly output, machines and shifts. Can they take your volume plus a rush order?

  • Quality systems: certifications such as ISO 9001, inward and final inspection, test reports.

  • Finances: GST registration, years in business and recent financial statements.

  • References: two or three current customers, ideally in your industry.

  • Sample or trial order: a small paid lot, inspected like any regular delivery.

  • Site visit: for critical parts, see the shop floor, the stores and how rejections are handled.

Approve the supplier only after the trial lot passes. From then on, vendor rating takes over.

The 5 KPIs to rate existing vendors

A KPI in vendor management is a number you track to judge a supplier. These five KPIs cover what matters to a manufacturer.

KPI

Formula

What it shows

On-time delivery %

Deliveries received by promised date ÷ total deliveries × 100

Whether you can plan production around them

Quality acceptance %

Accepted quantity ÷ received quantity × 100

How much material passes inward QC

Fill rate %

Quantity received ÷ quantity ordered × 100

Full quantities or short lots

Price vs agreed %

(Invoice price − PO price) ÷ PO price × 100

Whether the price holds after the PO

Responsiveness %

Queries closed within agreed time ÷ total queries × 100

How fast they reply and fix problems

Where each number comes from

The PO gives the promised date, ordered quantity and agreed price. The goods received note (GRN) gives the received date and quantity.

Inward QC records give the rejected quantity. The supplier's invoice gives the billed price. Responsiveness comes from your query log, even if that is a WhatsApp group.

Excel vs factory software for vendor rating

Excel works for a handful of vendors. One row per supplier, the five KPIs and a weighted total is enough.

It breaks when the data sits in different places. POs are in one file, GRNs in a register, rejections on paper and invoices in Tally. Someone copies it all every quarter, and the sheet falls behind.

Where your vendor rating numbers come from


Separate Excel sheet

PO, GRN and QC in one system

Promised dates and prices

Copied from PO files

Already on the PO

Received quantity

Typed from GRN register

Already on the GRN

Rejected quantity

Collected from QC papers

Recorded in inward QC

Quarterly update

Rebuilt by hand

From records you already keep

Where TranZact fits for a manufacturer

TranZact is manufacturing AI software used by 10,000+ manufacturers. Its purchase flow runs MRP report → indent → RFQ → PO → GRN → payment, with vendor coordination.

Your POs, GRNs and raw-material QC records sit in one system. So the numbers a vendor rating needs come from records you already keep, not a separate spreadsheet.

TranZact's AI matches supplier invoices to the POs they belong to, the same check your price KPI needs. A photo of a paper entry becomes a system entry, with no typing.

Quality control for raw material and finished goods is in the Dominate plan (see pricing). Accounting stays in Tally through a one-way sync, with no double entry. See how the full system connects sales, purchase, inventory and production.

One limit to know: you still choose the criteria, weights and bands. TranZact keeps the source records clean. Live in 2–3 weeks.

Book a demo →

Three ways to score vendors

  • Categorical: the team marks each supplier good, fair or poor on each criterion. Quick to start, but it rests on opinion.

  • Weighted point: each KPI gets a weight, and scores add up to 100. The most used method, because it runs on your own data.

  • Cost-ratio: quality, delivery and service problems become extra cost as a % of purchase value. Most accurate, but hard without clean cost data.

For most small and mid-size factories, the weighted point method is the right place to start.

Worked example: rating 3 steel suppliers for an engineering-goods factory

This is one quarter for a factory buying steel bars from three suppliers. All numbers are illustrative. Weights: Quality 40, Delivery 30, Price 20, Service 10.

Each KPI % is multiplied by its weight. Price score is agreed price ÷ invoiced price, capped at 100%. Service is a 1–5 score from the purchase team, scaled to 10.

Supplier

This quarter

Points (Q + D + P + S)

Score /100

Supplier A

98% accepted, 90% on time, agreed price, service 4/5

39 + 27 + 20 + 8

94

Supplier B

85% accepted, 60% on time, agreed price, service 3/5

34 + 18 + 20 + 6

78

Supplier C

70% accepted, 30% on time, billed 5% above agreed, service 1/5

28 + 9 + 19 + 2

58

Supplier C may have quoted the lowest price. Late, rejected and over-billed lots wipe out that saving, and the score shows it.

Vendor rating in five steps
  1. Pull PO, GRN and QC records

  2. Calculate the five KPIs

  3. Apply weights, total out of 100

  4. Place each supplier in a band

  5. Review with the vendor each quarter

What to do with the score

A score only helps if it changes who gets the next order. Use simple bands:

  • 80 and above: approved. First in line for the next RFQ and PO.

  • 60–79: watch. Still gets orders, with one or two agreed fixes.

  • Below 60: find a second source. Start evaluating a replacement and shift volume as it qualifies.

In the example, Supplier A gets the next steel PO. B goes on watch. You start looking for a second source to cover C.

To assess vendor performance well, share the score. Show each key supplier their numbers in a short meeting and agree on fixes.

How often to review vendor ratings

Review key suppliers every quarter: critical raw material or a large share of spend. Review the rest every six months.

Some vendors deliver only once or twice a quarter, so one bad lot crushes their score. Combine two or three quarters, or mark them "not enough data".

Rate suppliers on records you already keep, and give the next PO to the vendor who earned it. Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders