A supplier that was reliable last year isn’t guaranteed to still be reliable today — tracking performance over time catches a decline before it becomes a real problem for your business. This is especially critical for small businesses operating on thin margins, where a single unreliable supplier can cascade into missed customer deadlines, emergency shipping costs, and damaged reputation.
Why Supplier Performance Tracking Matters
According to research from the Institute for Supply Management, 60% of supply chain disruptions stem from supplier performance issues that could have been identified earlier with proper monitoring. For small businesses without large procurement teams, this makes a simple tracking system not just useful—it’s essential.
Consider this realistic scenario: You work with a parts supplier that has been reliable for two years. You don’t formally track their metrics. In month 13, they start missing deadlines by 3–5 days. You don’t notice immediately because you’re busy. By month 15, they’re missing by two weeks. You’ve now had to pay rush fees twice, and one customer received their order late. A formal tracking system would have flagged the decline in month 14, giving you time to address it with the supplier or find an alternative.
What to Track Per Supplier
On-Time Delivery Rate
Track delivery against the quoted lead time, not just whether something eventually arrived. This is the critical distinction many small businesses miss.
- What to measure: Percentage of orders delivered by the promised date
- Target benchmark: 95%+ for critical suppliers; 90%+ is acceptable for non-critical items
- Example: Your supplier promises 10-day turnaround on custom components. Out of 20 orders placed over three months, 18 arrived within the promised window (90% on-time rate). The other two arrived on days 12 and 11—both late.
- How to track: Create a simple spreadsheet with columns: Order Date | Promised Delivery | Actual Delivery | On-Time (Yes/No). Calculate the percentage monthly.
Order Accuracy
This measures how often what arrived matched what was ordered—both in quantity and specification.
- What to measure: Percentage of orders with zero discrepancies on arrival
- Target benchmark: 98%+ for standard items; 95%+ for complex orders
- Example: You ordered 500 units of SKU-A (blue) but received 400 units of SKU-A and 100 units of SKU-B (red). That’s 1 out of 1 order with an accuracy issue = 0% accuracy that month. Over 10 orders, if 9 arrive exactly as specified and 1 has a minor quantity discrepancy, you’re at 90% accuracy.
- Why it matters: A supplier with 92% accuracy costs you in wasted inspection time, customer service issues, and potential rework. A supplier at 99% accuracy reduces your operational friction significantly.
- How to track: Add columns to your spreadsheet: Ordered Qty/SKU | Received Qty/SKU | Match (Yes/No). Flag any discrepancies, no matter how small.
Communication Responsiveness
When issues arise—and they always do—how quickly does your supplier acknowledge and address them?
- What to measure: Average time from when you raise an issue to when you receive a substantive response
- Target benchmark: Response within 24 business hours for urgent issues; 48 hours for routine concerns
- Example: You email a supplier on Tuesday morning about a damaged shipment. They respond Wednesday afternoon (25 hours). That’s responsive. If they don’t respond until Friday, that’s 60+ hours and a red flag.
- Why it matters: A supplier who communicates quickly allows you to solve problems before they impact your customer. A silent supplier creates stress and uncertainty.
- How to track: Create a separate log: Issue Date | Issue Description | Contact Method | Response Date | Resolution Time. Average the response times quarterly.
Implementing a Simple Tracking System
You don’t need enterprise software to do this effectively. A Google Sheet or Excel workbook works perfectly for most small businesses managing 5–20 regular suppliers.
Setup structure:
- Create one tab per supplier (or one master sheet with supplier names in a column)
- Track each order as a row with the metrics above
- At the end of each month, calculate: On-Time %, Accuracy %, and average response time
- Review quarterly and compare month-to-month trends
Red flags to watch:
- On-time delivery dropping below 90% (indicates a trend)
- Accuracy below 95% (increasing defects or confusion)
- Response times extending beyond 48 hours (communication breakdown)
- Any single metric declining for two consecutive months
Taking Action on Poor Trends
Finding a problem is only half the battle. When you spot a declining trend:
- Month 1 of decline: Document it and have a conversation with your supplier contact. Capacity issues or staffing changes on their end might be temporary.
- Month 2 of decline: If metrics haven’t improved, escalate the conversation or request a corrective action plan with specific milestones.
- Month 3 of decline: Begin qualifying backup suppliers. You may not switch immediately, but you’ll reduce your risk exposure.
Even a simple running log, reviewed quarterly, is usually enough to catch a supplier trending in the wrong direction before it disrupts your own delivery promises to customers.