Resources
COI Expiration Tracker (Word & Excel)
Keep every vendor’s certificate of insurance current with a free tracker you can download in Excel, Word or PDF. The Excel copy counts the days left on each policy and flags the ones that are expired or due within 30 days.
Printable template
A certificate is only as good as its dates
The certificate a vendor sent at signing describes its policies on the day it was issued. Policies renew, lapse or get cancelled after that, and nothing on the paper changes to tell you. The Texas Council Risk Management Fund puts it plainly: a certificate confers no coverage. If a policy ends mid-contract and a claim comes in, the gap is yours to discover.
That is why risk managers keep a running log instead of a folder of PDFs. One line per policy, sorted by expiration date, shows at a glance which vendor needs a renewal certificate this month. The tracker on this page is that log, ready to fill in.
What to record for each policy
Give each policy its own row, even when one certificate lists several. A vendor’s general liability and workers’ comp often renew on different dates, and each line on an ACORD 25 carries its own policy number and term.
- Vendor: the business name exactly as it appears in your contract.
- Coverage: general liability, auto, workers’ comp, umbrella, professional or cyber.
- Insurer: the company writing that line, from the insurer list on the certificate.
- Policy number: your reference when you request a renewal certificate.
- Expiration date: the date the tracker counts down to.
- Days left: calculated for you in Excel.
- Certificate on file: where the current copy is saved, or the date it arrived.
- Notes: endorsements still owed, a contract limit the vendor falls short of, or the renewal request date.
Not sure what your vendors should carry in the first place? The vendor insurance requirements builder lists typical coverages and clauses by vendor type.
How to use the Excel copy
Download the Excel file from the bar on this page and type or paste each expiration date into its row. The Days left column subtracts today’s date each time the file opens, so the count stays current without any updating. Rows turn amber when a policy is 30 days or less from expiring, and red once the date has passed.
Sort by Days left once a month and work from the top: email each amber vendor for its renewal certificate, and pause new work orders for any red row until a current one arrives. The Word and PDF copies hold the same columns for a team that prefers a printed binder.
Keep endorsements in the same routine
A renewal certificate is also the moment to confirm the wording you negotiated carried over: additional insured status, waiver of subrogation and primary and non-contributory language all live in endorsements, not on the certificate itself. Our certificate of insurance guide shows where each appears, and additional insured endorsements explained covers the forms by number.
Want advance warning of a cancellation, not just an expiration? A certificate gives you no notice right by itself, which is why public buyers such as LA County write 30 days’ notice into the contract, 10 for non-payment, and ask for an endorsement naming them. Pair that with this tracker and cancellations and renewals both reach you in time.
Are you the vendor, sending your own certificates to clients? Talk to Mithril1 about keeping your general liability certificates ready for each new contract.
A few useful answers
Common questions
How do I track certificate of insurance expiration dates?
Log each vendor policy on its own row with the vendor, coverage, insurer, policy number and expiration date, then sort by days left. The free Excel tracker on this page does the counting and color-codes rows that are due within 30 days or already expired.
How far ahead should I request a renewal certificate?
Thirty days out is a practical trigger, and it is the point where the tracker turns a row amber. That leaves time for the vendor’s agent to issue the new certificate and for you to check its limits and endorsements before the old policy ends.
Does an expired COI mean the vendor has no insurance?
Not necessarily. An expired certificate means you lack current evidence of coverage, and the policy itself has often renewed. Ask the vendor for a renewal certificate right away, and hold new work until it arrives.
Will I be told if a vendor’s policy is cancelled?
Only if the policy carries an endorsement that names you for notice. A certificate alone creates no right to notice, as New York’s Department of Financial Services has said. Ask for the endorsement in the contract and keep tracking expiration dates as a backstop.
Resources
