Tracking COIs in a spreadsheet: a honest guide
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.
Frequently asked questions
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.
Upload a certificate and see the verdict in about a minute — 14-day free trial, no card, no demo call.