Spreadsheet or system for supplier documents?
When a spreadsheet is enough to track supplier certificates and insurance, where it stops being enough, and what a dedicated system adds and costs.
In short
A well-kept spreadsheet can be enough for a small number of suppliers, a few documents each and one careful owner. It gets harder to keep reliable when several people request documents, when you must show who checked what, when renewals pile up, or when an auditor asks what you knew on a past date. A dedicated system adds tracked requests, follow-ups, recorded review and history, at a cost in money, set-up time and change for your suppliers.
For a small, stable supplier base, a spreadsheet can be a reasonable way to track supplier documents. It gets harder to keep reliable when the work is shared, when there are more dates than people watching them, or when you need to show what happened. Here is how to tell which side of that line you are on.
When is a spreadsheet enough?
- You have a small number of suppliers, each providing a few documents.
- One person owns the list and has time to keep it current.
- Documents rarely change, and renewals are spread through the year.
- Nobody outside the team needs to rely on the record, such as an auditor or a customer.
If all four are true, a spreadsheet with one row per document, the expiry date in an unambiguous format and a link to the stored file may serve you well. Use the version history your spreadsheet tool offers. In Microsoft 365, for example, version history works for files stored in OneDrive or SharePoint.
Spreadsheet tools can also be automated. A SharePoint list with a date column can run a reminder flow, for example. The comparison below is with a spreadsheet nobody has automated.
Where do spreadsheets break down?
- The requests happen elsewhere. Requests and replies live in individual inboxes, so the sheet shows what should exist, not what has been asked for or received.
- Dates are typed by hand. A date entered as 03/04/2027 can be read as different days, and a typo can silently push a renewal a year out. ISO 8601 dates help, but only if everyone uses them.
- The review is invisible. A row says “ISO 9001 – OK”, but not who checked the scope, the site or the issuer, or when.
- History is hard to reconstruct. Version history shows what a cell said; it does not easily tell you which certificate was valid, and known to you, on a given past date.
- Renewals depend on someone looking. A certificate can be suspended or withdrawn before its printed expiry date, as IAF CertSearch statuses show. In Connecticut, the insurance regulator says a certificate holder is owed no duty to be notified of cancellation. A date nobody looks at does not protect you.
- Access needs care. Check how access to the sheet and its linked files is granted. Sharing a whole folder with suppliers or colleagues can expose more than each person needs to see.
What does a dedicated system add?
| Job | Spreadsheet | Dedicated system (Vendarity) |
|---|---|---|
| Request a document | Email from someone’s inbox | A request tracked to the requirement, with a private upload route for the supplier |
| Follow up | Calendar reminders, if someone sets them | Scheduled reminders for each item still outstanding, once automatic reminders are on |
| Check the details | Free-text notes | Review of each detail recorded with the reviewer and time |
| Renewals | Filter by date, manually | Planned from the accepted expiry and review dates |
| History | Cell-level version history | Recorded versions and decisions kept for the retention period, viewable as known on a past date |
| Supplier access | Shared folders | Access you can remove; later download requests are checked against current access |
What does a dedicated system cost you?
Money, first: Vendarity is free for up to 25 active suppliers, and its Core plan, for example, is US$129 a month, excluding tax, for up to 100 active suppliers (see pricing). Set-up time, second: someone has to define requirements and import suppliers. Third, change for your suppliers, who must learn a new way to send documents. Be wary of any system that cannot export your data in full; the record should outlive the tool.
How do you decide?
- Count the documents that expire in the next 12 months. If nobody can name them all from memory, you need more than memory.
- Ask who would answer an auditor’s question about a past date, and how long it would take.
- Count how many people request, check or rely on the documents.
- Price the cost of one lapsed certificate or uninsured contractor against the cost of a system.
How do you move from a spreadsheet without losing history?
Keep the spreadsheet as an archive and import suppliers into the new system from a CSV export. For each document, either upload the copy you already hold for review or request a fresh one, starting with anything due in the next few months. Each new record then starts with a reviewed document.
Before committing, Vendarity’s free renewal preview reads your spreadsheet, as an Excel workbook or a CSV file, in your browser and shows the renewals coming up, without uploading the file.
Sources
- View previous versions of Office files · Microsoft Support
- Set a reminder flow · Microsoft Support
- ISO 8601: date and time format · ISO
- Bulletin S-14: use of certificates of insurance (9 November 2010) · Connecticut Insurance Department
- Manual search by certificate number (certificate statuses) · IAF CertSearch support
- Vendarity pricing · Vendarity