1. Make one list, not a folder of PDFs
A folder of certificates tells you what you have. It does not tell you what is about to lapse. Start a list with one row per vendor and per coverage line. The columns that earn their place:
- Vendor name and the email of the person who sends certificates (often their insurance agent).
- Policy type: general liability, auto, workers' compensation, umbrella. Each line on a certificate can have its own dates.
- Expiration date for that line, copied from the certificate.
- Notes: job, required limits, or "waiting on endorsement".
The free COI tracking spreadsheet template uses exactly these columns.
2. Read the dates per line
A single certificate often lists several policies with different expiration dates. Track the earliest one that matters to you, or add a row per line. See what to check on a COI.
3. Ask for renewals before they lapse
Renewed certificates usually take a few days to a few weeks to arrive, because the vendor's agent issues them. Asking 30 days ahead leaves time for a second nudge at 14 and 7 days. Ask once more on the day it expires, and again if it lapses.
4. Check the list on a fixed day
Pick a day, sort by expiration date, and email anyone inside 30 days. This is the step that slips when the office gets busy, which is why many teams automate the reminder.
5. Keep a person in the loop
A tracker records dates. It does not confirm coverage. Someone still has to open each certificate and compare it with your contract requirements.
Doing it with COI Nudge
COI Nudge is the reminder step on its own: add each vendor with an expiry date (or import a CSV), and it shows OK, expiring in N days, or EXPIRED. The paid plan ($9/month) emails you 30, 14 and 7 days before, on the day, and once after a lapse. You can also have it email the vendor directly. Try 3 vendors free, with no account.