Everything for a structured quarterly business review with a key supplier: agenda with timings, KPI scorecard with RAG status, actions from the last review, and decisions.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 4 | KPI | Target | This quarter | Trend | RAG |
| 5 | On-time in-full delivery | 95% | 96% | Improving | Green |
| 6 | Defect rate (ppm) | 150 | 180 | Improving | Red |
| 7 | Stakeholder satisfaction | 4.0 | 3.9 | Improving | Amber |
| 8 | Invoice accuracy | 98% | 99% | Improving | Green |
What is inside
Yellow cells are yours to fill in. Grey cells calculate. Every sheet has a worked example so you can see the expected format.
Purpose, steps, colour legend and assumptions.
Meeting details and eight agenda items with lead, minutes and calculated start times.
KPI target, previous and current values, change, trend and RAG status, with an Amber tolerance you set.
Action log with owner, side, due date, status and days late.
Decisions and joint initiatives with expected benefit, owner and date.
How to use it
No macros, no add-ins. It works in Excel, Google Sheets and LibreOffice.
01
Fill in the meeting details and agenda. Start times follow from the minutes per item.
02
Enter target, previous and current values. Trend and RAG are calculated.
03
Review last quarter’s actions first, then agree new actions and decisions.
04
Send the pack to the supplier at least three working days before the meeting.
Spreadsheet or platform
The template and the platform use the same structure, so nothing you set up here is wasted.
Questions
The scorecard and its trend, open actions from the last review, upcoming demand and changes on both sides, improvement or innovation topics, and decisions with an owner and a date. Supplier QBR software →
Yes. The file downloads directly, with no form and no email address.
When several people rate the same suppliers, when suppliers need to see their results, or when actions get lost between file versions. That is usually the point where a shared platform pays back. Signs you have outgrown the spreadsheet →
Related templates
Templates that pick up where this one ends.
Six dimensions, weights by segment, tiers and next actions.
View template →
Likelihood and impact before and after mitigation, review dates and a heat map.
View template →
8D cases with targets by severity, containment check and supplier summary.
View template →
Run it live
Start a free sandbox and set it up yourself: send requests and surveys to real suppliers, collect answers and see scores in one place.