Free template · American wording

Certificate of insurance tracking spreadsheet

An Excel spreadsheet for the certificates of insurance (COIs) your vendors and subcontractors send you: the coverage, the insurer, the limit and the expiration date of each policy. Free to download, with no email address asked.

Excel workbook (.xlsx). Free to download, with no sign-up or email address.

What’s in the register

One row per policy. The example rows in the file are fictional.
ColumnWhat it holds
nameThe vendor’s legal name, as on its W-9
countryUS or CA
categoryContractors, Facilities, Services or Equipment
siteThe location or project the work is for
contact_nameWho sends you the COI: the vendor or its agent
emailTheir email address
phoneTheir phone, as +1 and the number
documentGeneral liability, auto, workers’ compensation, umbrella…
insurerThe insurer named on the COI
policy_numberThe policy number
each_occurrenceThe each-occurrence (or per-accident) limit
expiry_dateThe 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.