What’s in the register
| Column | What it holds |
|---|---|
name | The vendor’s legal name, as on its W-9 |
country | US or CA |
category | Contractors, Facilities, Services or Equipment |
site | The location or project the work is for |
contact_name | Who sends you the COI: the vendor or its agent |
email | Their email address |
phone | Their phone, as +1 and the number |
document | General liability, auto, workers’ compensation, umbrella… |
insurer | The insurer named on the COI |
policy_number | The policy number |
each_occurrence | The each-occurrence (or per-accident) limit |
expiry_date | The policy expiration date |
A COI tracking spreadsheet lists every certificate of insurance your vendors have sent, one row per policy, with each policy’s expiration date. Sorted by that date, it shows which vendors are covered today and whose coverage lapses next.
What goes in each column?
Record the vendor’s legal name as it appears on the certificate, the type of coverage (general liability, commercial auto, workers’ compensation, umbrella), the insurer, the policy number, the each-occurrence or per-accident limit and the policy expiration date. One certificate often lists several policies with different expiration dates: give each policy its own row so the earliest date isn’t missed. The example rows show the format; replace them with your own vendors.
What should I check on a COI before I file it?
- The named insured matches the vendor you contracted with.
- Each coverage your contract requires is listed, at or above its minimum limit.
- The policy dates cover the dates of the work.
- Your company appears as your contract requires. A certificate “cannot be used to amend, expand or alter” the policy, as the Connecticut Insurance Department’s Bulletin S-14 puts it, so ask for the endorsement itself when your contract requires one, such as additional insured status.
How often should I review the spreadsheet?
Weekly is enough for most teams: filter for expiration dates in the next 30 days and email those vendors for renewals. When a renewed certificate arrives, replace the row’s dates and keep the old certificate on file in case you need to show what was in force on a past date.
Can I check this spreadsheet’s dates automatically?
Vendarity’s free expiry check reads this spreadsheet in your browser, with no upload or sign-up, and lists what has expired and what expires in the next 14, 30, 60 or 90 days. The vendor columns are named as Vendarity’s supplier import names them, so after you sign up you can keep the list and add your vendors without matching columns.
General information, not legal or insurance advice: your contracts and the law where the work is done decide which coverage you need.