The practical answer
Every COI program starts as a spreadsheet, and for a handful of vendors it genuinely works. Here's the structure that works longest — and the failure modes that tell you it's time to stop.
The columns that matter
A workable tracking sheet has one row per vendor and these columns:
- Vendor name, contact email, and the PRODUCER (agent) email from the certificate — the agent re-issues renewals, so this column does the real work.
- Per coverage: expiration date and key limit (GL each-occurrence, auto CSL, umbrella, workers comp Y/N).
- Endorsements required vs. verified: additional insured (ongoing/completed ops), waiver of subrogation, P&NC — with a 'verified on endorsement page' checkbox, not a 'checkbox on the cert' checkbox.
- Certificate file link, date received, date verified, next chase date.
The process that keeps it alive
The sheet is the easy part. The program is: a weekly 30-minute review of upcoming expirations, chase emails at 30/14/7 days (to the agent, not just the vendor), verification of every new certificate against requirements within a day of arrival, and a rule that no vendor works with an expired row.
Where it breaks
Spreadsheet COI programs die the same four deaths:
- The verifier bottleneck: one person knows how to read endorsement pages; they go on vacation in renewal season.
- Silent staleness: coverage gets cancelled mid-term and the sheet still shows green until renewal.
- The endorsement gap: rows track dates fine, but nobody re-checks that the CG 20 37 was attached to the renewal policy.
- Volume: past ~30–40 vendors, chasing alone becomes a part-time job, and the audit trail (who was chased when) lives in a personal inbox.
When to graduate
If any of those four failures has already happened — or vendor count crossed 40 — purpose-built tracking pays for itself in chased renewals alone. CoverWarden automates the verification (endorsement pages included), the chasing (vendor + agent, 30/14/7), and the audit trail, from $79/mo.
Keep coverage decisions human and evidence explicit
CoverWarden records submitted evidence, requirements, findings, and authorized decisions. It does not issue coverage, guarantee claim outcomes, or replace your broker, attorney, or risk professional.
What teams usually ask
Is there a free COI tracking template?
The column structure above IS the template — recreate it in any spreadsheet. The hard part isn't the columns; it's the weekly verification and chasing discipline, which is exactly what software automates.