CertRevisit

Guide

A COI tracking spreadsheet template, and where it stops working

Free to download, no email required. Below it: the columns most templates leave out, and the three failures a spreadsheet cannot fix.

If you manage property, you collect certificates of insurance from every contractor who sets foot on it — and then you have to remember when each one expires. Most people start with a spreadsheet, and for a dozen vendors a spreadsheet is the right answer.

Download the template (CSV) — opens in Excel, Numbers or Google Sheets.

The columns that matter

Most templates track the vendor, the carrier and an expiry date, and stop there. These are the ones that save you an argument later:

  • Additional insured — yes or no. This is the field agents get wrong most often, far more than the limits. If you require it and the certificate does not show it, the certificate does not do what you asked.
  • Certificate holder, spelled exactly. A certificate naming the wrong entity is a certificate for somebody else.
  • Each occurrence and aggregate, separately. A single “limit” column hides the difference, and the aggregate is what runs out halfway through a bad year.
  • Date received, not just the expiry. It tells you whether a vendor is slow every year or had one bad month.
  • Waiver of subrogation, if your contracts require it.

Where a spreadsheet lets you down

Nobody reads it on the right day. A spreadsheet is a record, not a reminder. The expiry date sits there being correct while the policy lapses, and you find out when a claim arrives or an owner asks.

Chasing is manual, and it is the actual work. Collecting a certificate takes one email. Collecting it from the vendor who ignores two emails takes five, and that is where the hours go.

Typing the figures invites mistakes. Reading an ACORD 25 and copying four limits into cells, forty times a year, produces errors — and the errors look exactly like correct entries.

What to do about it without buying anything

Three habits make the spreadsheet survive longer: decide your minimum coverage once and write it into the vendor agreement, so you are not negotiating per vendor. Diary the expiry the day the certificate arrives, not later. And ask for the certificate thirty days before the lapse, not on the day — agents need a week, and a vendor who waits until the last day leaves you uncovered in the meantime.

Or let it run itself

CertRevisit collects certificates from your vendors, reads the dates and limits, and chases the renewals before anything expires. Free for 14 days, no card.

Start free trial

Last updated 13 October 2026. CertRevisit is record keeping — it is not insurance, legal or professional advice.