Vendor Rating and Supplier Evaluation: A Simple Method
6 min read
By
TranZact Solutions Team
· Published


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.
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
Pull PO, GRN and QC records
Calculate the five KPIs
Apply weights, total out of 100
Place each supplier in a band
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.




