What is in the template
This supplier scorecard records, for each supplier and period, how many orders were placed, how many arrived on time and in full, the share of items rejected on quality, the average lead time and the price variance against the agreed price.
Use it in a regular review, such as monthly or quarterly. The aim is not to punish suppliers but to spot trends early, back conversations with evidence and decide where to consolidate or dual-source.
The sample rows are fictional and can be deleted. The file is plain comma-separated text, so it opens in Excel, Google Sheets and Numbers; add formulas for any calculated columns after you import it.
Columns explained
| Supplier | Supplier name. |
| Period | Review period, for example 2026-Q3. |
| Orders_Placed | Number of orders placed in the period. |
| Orders_On_Time | Orders delivered by the promised date. |
| On_Time_Rate | On time divided by placed, as a percentage. |
| Orders_In_Full | Orders delivered complete. |
| In_Full_Rate | In full divided by placed, as a percentage. |
| Quality_Rejection_Rate | Share of received items rejected, as a percentage. |
| Avg_Lead_Time_Days | Average days from order to receipt. |
| Price_Variance | Invoiced price against agreed price, as a percentage. |
| Overall_Score | Your weighted score, out of 100. |
| Notes | Free text for context. |
Where a spreadsheet template breaks down
The rates and the overall score are typed values in the CSV. Turn them into formulas in a spreadsheet, and decide your weighting up front (for example on time 30, in full 30, quality 30, price 10), or scores cannot be compared between reviews.
The template holds figures but not the evidence behind them: purchase orders, receipts and rejection records still live elsewhere, and counting them by hand each period is slow and easy to get wrong.
Related resources
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”