FREE TOOL
Supplier scorecard generator and template
A supplier scorecard rates each vendor on the same measures, usually on-time delivery, quantity accuracy, quality and price, and rolls them into one weighted score. Paste or upload your PO history and this tool builds the scorecard for every supplier, ranks them, and writes plain lines like “Slipped 3 of its last 5 POs” when a rule fires. Need a blank form instead? Download the template. Morsa builds the same scorecard from your POs, receipts and email threads and keeps it current, so nobody fills one in by hand.
Updated October 21, 2026
Vendor performance metrics that belong on a scorecard
| Measure | Formula | Default weight |
|---|---|---|
| On-time delivery | PO lines received by the promised date (plus grace days) / lines due | 50% |
| Fill rate (quantity accuracy) | Units received, up to the ordered quantity / units ordered | 15% |
| Quality | Units accepted / units received; each 1% rejected costs 10 points | 15% |
| Invoice accuracy | Invoice lines billed at the PO price / invoiced lines | 10% |
| Price stability | 100 minus 5 points per 1% price rise, first to last order, spend weighted | 10% |
Overall score = sum of weight x score / sum of weights. A 90+, B 80+, C 70+, D below 70. Change any weight in the tool.
Responsiveness (how fast a supplier confirms a PO or answers a question) is on the blank template as an optional line. It rarely lives in an ERP export, which is why most scorecards skip it.
Worked example: the sample PO history
The sample holds 25 PO lines from 5 suppliers, as of October 12, 2026, with a 2-day grace window. Ningbo ranks last at 77 (C): 3 of its 7 lines due arrived late, 13.3 days on average and 15 at worst. The tool writes: “Slipped 3 of its last 5 POs” and “Get a second quote on 41-2200 Check valve 1 in.” Westbrook Steel ranks first on delivery but still gets two flags: its coupling price rose 7.0%, and one invoice billed $13.50 against a $12.00 PO price on 300 units, $450 over.
How to create a supplier scorecard
Export PO lines for the last 6 to 12 months: supplier, PO number, part, promised date, received date, quantities and prices.
Agree the measures and weights with purchasing, quality and finance before you score anyone.
Score every supplier the same way, then sort. The ranking matters more than the exact number.
Send each key supplier its card with the two or three lines that need fixing and a date to review.
Repeat monthly for critical suppliers and quarterly for the rest.
Supplier scorecard template
Open the Blank template tab in the tool to download the scorecard as a CSV for Excel or Google Sheets, or print it. It has the five measures with how each is worked out, weights, targets (95% on time, 98% fill and invoice accuracy, under 0.5% rejected, price rise under 2% a year), space for results and scores, and the actions agreed with the next review date.
The modern way: a scorecard that keeps itself
A spreadsheet scorecard is out of date the week after someone builds it, and the late POs it shows were felt on the floor months earlier. Morsa builds each supplier’s scorecard from the POs, the receipts and the email threads, not from a survey, including how fast they reply. When a supplier keeps slipping, it says so and suggests a second quote on the part that matters, then chases the late lines from your buyer’s own mailbox.
Common scorecard mistakes
Measuring against the date you wanted, not the date they confirmed. Use the promised or confirmed date, or the supplier will dispute every late line.
No grace window. A day late on a truck is noise. Set the grace you would actually tolerate.
Ignoring open lines. A PO three weeks past due and still not received is the worst kind of late. Count it.
Averaging percentages across suppliers of very different size. Rank within a category, and look at spend next to score.
Scoring without telling the supplier. A scorecard only changes behaviour when the supplier sees it.
Frequently asked questions
What is a supplier scorecard?
A regular report that rates a supplier on agreed measures, usually delivery, quality, quantity accuracy and cost, and combines them into one score so suppliers can be compared and problems raised with facts.
What is a good on-time delivery rate for a supplier?
Many manufacturers target 95% or better on time against the confirmed date. Below 90% usually means you are carrying extra safety stock to cover for that supplier.
How do you calculate supplier on-time delivery?
Divide the PO lines received on or before the promised date (plus any grace days) by all lines that were due in the period. Open lines past their promised date count as late.
What is the difference between a vendor scorecard and a supplier evaluation form?
An evaluation form is usually filled in once, before you approve a new supplier. A scorecard tracks performance over time from real delivery, quality and invoice data.
What columns does my PO history need?
Supplier, promised date and received date (blank if still open). PO number, part, order date, quantities, PO and invoice prices and rejected quantity add the other measures.
Is my PO data uploaded?
No. The file is read in your browser and nothing leaves your device.
Related tools
WHERE MORSA FITS
Every supplier scored from their own POs, receipts and emails.
Morsa keeps a live scorecard for every supplier, flags the ones slipping, suggests second quotes, and chases late lines in email, Teams, WhatsApp or whatever your suppliers already use.
