Skip to content

Guide

How to track vendor certificate of insurance expiration dates

Record the expiration date of each required policy on the certificate, not the date printed at the top. Track the earliest one per vendor, and start asking for a renewal certificate about 60 days before it, with follow-ups at 30, 14 and 7 days.

Updated October 10, 2026 · By the ClearedPro team

The date at the top is not the expiration date

On an ACORD 25 certificate, the DATE box in the top right is the day the certificate was issued. It says nothing about when coverage ends. Each policy row in the coverages section has its own POLICY EFF and POLICY EXP dates, and those are the dates to track.

A vendor's general liability, auto, umbrella and workers' compensation policies often renew on different dates. If your contract requires all four, the vendor stops meeting your requirements on the earliest of those expiration dates, not the latest.

A common miss: the umbrella policy expires a month before the general liability policy, and nobody notices because only one date was copied into the spreadsheet.

What to record for every vendor

Whether you use a spreadsheet or software, capture the same facts from each certificate:

FieldWhere it is on an ACORD 25Why it matters
Vendor (named insured)INSURED boxMust match the company you contract with
Each policy's expirationPOLICY EXP column, one per rowThe earliest required one is your real deadline
Limits per policyLIMITS columnCompare to your minimums when the renewal arrives
Insurance agent contactPRODUCER box and CONTACT fieldsThe agent issues the renewal certificate, often faster than the vendor
Additional insured / waiver flagsADDL INSD and SUBR WVD columnsRenewals sometimes drop endorsements
Certificate issue dateDATE box, top rightShows how current the document is

A reminder schedule that works

Renewal certificates take time: the vendor has to ask their agent, and the agent has to issue a new one naming you as certificate holder. A schedule that starts early avoids the last-minute scramble:

  1. 60 days before the earliest required expiration: ask the vendor and their agent for the renewal certificate. The free COI request letter generator writes the request for you.
  2. 30 days before: second request, copying the agent named in the PRODUCER box.
  3. 14 and 7 days before: final reminders, with a note about what happens if coverage lapses under your contract.
  4. The day after it lapses: the vendor no longer meets your requirements per the certificate on file. Follow your contract and see what to do when a vendor's COI expires.

ClearedPro's paid plans send these reminders automatically, to the vendor and the agent, at 60, 30, 14 and 7 days and after a lapse.

When a renewal certificate arrives

Do not just update the date. Check the whole certificate again, because a renewal can change carriers, lower a limit, or drop an endorsement:

  • New POLICY EXP dates on every required line.
  • Limits still at or above your minimums.
  • ADDL INSD and SUBR WVD still marked where your contract requires them, with endorsement pages if you require those.
  • Certificate holder is still your exact legal name and address.

The full walkthrough is in how to check an ACORD 25 against your requirements.

Spreadsheet or software?

A spreadsheet with conditional formatting works for a handful of vendors. It starts to fail when one person owns it, policies expire on different dates, and reminders depend on someone opening the file. Software adds three things a spreadsheet cannot: it reads the dates off the certificate for you, it sends the reminders on its own, and it keeps a timestamped record of what was on file on any given day.

ClearedPro's Free plan covers up to 3 vendors at $0 with no card. Paid plans add automatic reminders and more vendors; every price is on the pricing page.

Questions

Which date on a COI is the expiration date?
Each policy row has its own POLICY EXP date. The DATE box at the top of an ACORD 25 is only the date the certificate was issued.
How far ahead should I request a renewal certificate?
About 60 days before the earliest required policy expires gives the vendor and their agent time to issue a new certificate, with follow-ups at 30, 14 and 7 days.
Should I contact the vendor or their insurance agent?
Both. The agent listed in the PRODUCER box issues certificates, so copying them usually gets the renewal faster.

Related

ClearedPro is not an insurance agency and does not provide insurance or legal advice. A certificate of insurance is evidence of coverage as of its issue date; the policy and its endorsements control. Ask your insurance professional or attorney about your specific requirements.