Every general contractor starts the same way: a spreadsheet with a column for the subcontractor's name, a column for the certificate expiration date, and good intentions about checking it every Monday. It works fine for the first ten subs. Then you're running fifteen jobs a year with sixty subcontractors rotating in and out, and the spreadsheet becomes a thing you update after a certificate has already lapsed, not before.

Why spreadsheets stop working

A spreadsheet isn't the problem by itself — a list of names and dates is a list of names and dates no matter what software holds it. The problem is that a spreadsheet doesn't do anything. It doesn't notice when a date is 30 days out. It doesn't email anyone. It doesn't know that an agent went quiet after the first request. Every one of those steps has to happen in someone's head, and someone's head is unreliable when they're also running four other things that day.

Three specific failure points show up over and over:

Nobody owns the follow-up

Checking the spreadsheet is usually one person's informal responsibility, on top of their actual job. When they're out, on a job site, or just busy during a heavy week, the check doesn't happen — and certificates don't lapse on a convenient schedule.

Chasing agents by email is a part-time job

Getting an updated certificate isn't a one-email problem. You email the agent, they don't respond for a week, you email again, maybe you call, maybe the sub has switched agents and the old contact bounces. Multiply that by every subcontractor renewing in a given month and "chasing COIs" quietly becomes several hours a week that never shows up on anyone's job description.

There's no record when someone asks

When your insurance carrier, a project owner, or your own risk manager asks "was this sub covered on this date," a spreadsheet with a few stale entries and a folder of unsorted PDF attachments isn't an answer you want to give out loud.

What a tracking system actually needs to do

The fix isn't a fancier spreadsheet — it's moving the two things a human keeps forgetting to do (watch the calendar, send the follow-up email) onto something that doesn't forget. A COI tracking system that actually holds up needs four things:

  • A single record per vendor — name, insurance agent contact, current certificate, and renewal date, in one place instead of split across a spreadsheet and an inbox.
  • Automatic renewal monitoring — something that watches the date so a person doesn't have to remember to check it.
  • Automatic follow-up with the agent — not you, sending the same "can you send an updated certificate" email for the fifth time. The agent, contacted directly, on a schedule that keeps going until they respond.
  • A status you can see at a glance — current, renewing soon, or lapsed — so answering "are we covered right now" doesn't require opening ten emails.

Enterprise COI platforms solve this, but they're built for a different problem

There are established platforms — myCOI, CertFocus, and similar tools — built for compliance teams managing hundreds or thousands of vendors across large organizations. They work, but they're priced for that scale: typically $11–$30 per vendor per year, often with a four- or five-figure annual minimum. If you're running sixty subcontractors, not six thousand, that pricing model doesn't fit — you end up paying for a compliance department's worth of software to solve a problem that's really just "email the agent and keep a status board."

That's the gap CertWatch fills. It's a flat monthly fee instead of a per-vendor charge — free for up to 5 tracked certificates, $29/mo for up to 25, $79/mo for up to 100, or $199/mo for unlimited — and it does exactly the four things above: one record per vendor, automatic renewal monitoring, automatic agent follow-up, and a status dashboard. You add a vendor's name, their agent's email, and the renewal date; CertWatch emails the agent as the date approaches and keeps following up if it passes without a response; you get notified the moment a current certificate lands. No account needed for the vendor or the agent — they just reply to an email with a one-click upload link.

Getting started without redoing everything at once

If you already have a spreadsheet, you don't need to throw it out and start from a blank list — bulk-import what you have, correct any stale dates as you go, and let the system take over the watching and the follow-up from there. The goal isn't a perfect record on day one. It's that from this point forward, nothing lapses because a person forgot to check a spreadsheet during a busy week.