Guide
How to Track COI Expirations
By Keelstar Team · Updated June 1, 2026
The short answer
For every vendor, record each policy's expiration date and required limits from the ACORD certificate, then set reminders well before expiration — not on the expiration date. Spreadsheets work for a few vendors; ongoing monitoring needs automated warnings and a historical record of what was on file when.
Why COI expiration tracking matters
A certificate of insurance is a snapshot, not a policy. Coverage can cancel or lapse after the certificate is issued. If a vendor is uninsured when work happens or a claim arises, your organization may absorb liability that insurance was meant to cover — especially in construction, facilities, and healthcare vendor relationships.
What to capture for each certificate
Track enough to answer: is this vendor covered right now, to the limits we require?
- Expiration date for each policy line on the ACORD 25
- Coverage types: general liability, auto, workers comp, umbrella
- Per-occurrence and aggregate limits vs your requirements
- Additional insured status where required
- Certificate holder name and address
- Producer contact for renewal requests
Set reminders before, not after
A reminder on the expiration date is too late — the policy may already be expired. Most teams warn 30–60 days ahead and again at 14 days. Optionally notify the vendor automatically with a renewal request link.
Subcontractors and downstream vendors
In construction and property management, COI tracking often extends to subcontractors you do not pay directly but who work on your premises. Require certificates that meet your contract's additional insured and waiver requirements, and track them the same way as primary vendors.
Keep the history
Claims and audits ask whether a vendor was insured on a specific date — not whether they are insured today. Store superseded certificates with received dates so you can reconstruct coverage at any point in time.
When spreadsheets stop working
Spreadsheets do not send reminders, do not flag limit shortfalls, and do not preserve who changed a date. Once you exceed roughly a dozen active vendors or face audit scrutiny, move COI monitoring into a workflow with validation on intake and alerts before lapses.
Related guides
Put this into a monitored workflow
COI Tracker handles this continuously — with reminders and an audit trail.