All articles · Vendor management
When one spreadsheet runs your vendor programme
By Celia SGAR · 4 min read
When one master spreadsheet, kept by one person, runs your vendor programme, your supplier history lives in their head and their file. When they leave, that history leaves with them. Your next review starts from whatever people remember, and the supplier walks in with better records than you.
What does it look like when a spreadsheet runs your vendors?
It starts with good intentions. My first vendor management role came with a folder of contracts and no handover (what that folder cost me). So I built a spreadsheet, with colour codes and a list of who to call when there was a problem. It worked, sort of, and I survived. Years later I named the four things that file could never give me: Strategy, Governance, Assessment and Relationship.
Most people I talk to are sitting where I sat. Someone updates a number and nobody owns it. I've seen brilliant teams lose hours chasing updates, merging files and debating performance scores that live in ten versions of Excel.
What happens when the person who keeps the file leaves?
A client came to me three weeks into a new role. Her predecessor had gone with no handover call, leaving an old QBR deck and a shared inbox. On her first call with the vendor, the account manager mentioned a roadmap review the team had discussed months earlier. She had never heard of it. She searched old threads for two days, never found it, and walked into the review guessing at commitments she had never made.
She had every file her predecessor left behind. The vendor had the memory of what was agreed.
You know you have this problem when
- •One person can answer questions about a supplier's performance, and everyone else asks them.
- •Before every review someone spends hours fixing links, checking versions and chasing updates.
- •IT, Procurement and Operations each bring a different number for the same supplier.
- •You know this quarter's score and can't say whether it is better or worse than last year's.
- •Service owners send back scores with no comments. I once opened a scorecard survey where three service owners had typed dots where the comments should be.
- •The supplier's account manager remembers your last agreement better than you do.
What does losing the history cost you?
Without history you can't see a trend, and without a trend every conversation about a supplier runs on opinion. A vendor manager I know heard a stakeholder say a supplier wasn't good. He asked when they had last met. Nobody had spoken to the supplier in over a year: no calls, no reviews, no conversations. The supplier took the blame anyway.
The file itself carries risk. One wrong cell can throw off a report that decisions worth millions rest on. Outdated data ends up in front of executives. And the same supplier gets three versions of the truth, one each from IT, Procurement and Operations.
Is Excel the problem?
For one or two suppliers, Excel does the job, and when my clients first put structure in place I tell them to start with spreadsheets and slides. I've also seen billion-dollar supplier portfolios run on spreadsheets. The trouble comes from the set-up around the file: many suppliers, one person who understands the logic, and no way to read a supplier's performance across quarters. You can move the same set-up into a tool and still have the problem.
What does good look like?
In a healthy programme your supplier history outlasts any one person. Whoever picks up a supplier can see how it scored last quarter and the year before, what it committed to and whether it delivered. IT, Procurement and Operations look at the same numbers, and decisions start from performance data, with opinions second. When a supplier asks for more money, or a stakeholder says a supplier isn't good, you can open the record and look.
When I work with my clients, I look for the places where the programme depends on one person's memory, and we put the method into the organisation so it survives the next resignation. That starts with deciding which suppliers deserve the effort, a scorecard everyone uses, and a named owner.
Does your vendor history live in one person's file?
This is the work I do with clients in the Vendor Management Reset: one day to segment your vendors, build a working scorecard and name an owner. Remote or on site, EUR 5,000.
See the Vendor Management Reset →Vendor Management Reset · Consulting · Book a 20-minute diagnostic call