Guides

How to track certificates of insurance

Keep one list with a row per vendor and per policy, record each policy's expiration date from the certificate, ask for the renewal about 30 days before it expires, and check the list on a fixed day every week. The expiration date and the follow-up are what matter most; storing the PDF is the easy part.

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:

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.

FAQ

How often should I check certificates of insurance?

Weekly is a practical rhythm for a small vendor list: sort by expiration date and follow up on anything inside 30 days. Automated reminders remove the need to remember the weekly check.

Do I need software to track COIs?

No. A spreadsheet works if someone reviews it on a schedule. Software helps when the review keeps getting skipped, or when you want reminder emails sent for you.

What should I do when a certificate expires?

Ask the vendor or their agent for the renewed certificate right away, and follow your own contract terms about whether the vendor can keep working until it arrives.

Does tracking a certificate prove the vendor is insured?

No. A certificate is a summary issued at a point in time. Tracking its date helps you ask for renewals; it does not confirm coverage, limits or endorsements.

Get an email before a certificate lapses

COI Nudge tracks each expiry date and reminds you 30, 14 and 7 days before, on the day, and after. $9/month, reminders included.

Try 3 vendors free