← All posts

Certificate tracking workflow

How to Track Certificates of Insurance: A Step-by-Step Guide for General Contractors

COIs spread across email, shared drives, and spreadsheet rows faster than most GC offices can keep up. Here is a practical cleanup workflow you can run in a few hours and actually maintain going forward.

The situation most GC offices are actually in

You have a folder somewhere — maybe a shared drive, maybe a cabinet, maybe both — full of PDF certificates. Some came in last week. Some came in two years ago and nobody has checked whether the coverage is still active. Your spreadsheet has rows that say "current" next to subs you haven't heard from since January.

Then an owner asks for proof of insurance on a sub before a Monday start. You look for the PDF. You find three versions in email. You're not sure which is the one you reviewed. That is the moment the system reveals itself.

Getting organized does not require new software right away. It requires one clean pass through what you have, a simple status system, and a process for what happens when a new certificate comes in.

Step 1: Build one list of active subcontractors

Start with whoever is on a current job or likely to be on a job in the next 60 days. Do not try to clean up every sub you have ever used — focus on active work first.

For each sub, you need: company name, primary contact name, contact email, trade or scope, and which jobs they're currently on or bidding. That is your working roster.

If you already have a spreadsheet, use it as a starting point. You may find rows that are outdated, duplicate, or missing key contact details. Fix those as you go.

Step 2: Find the most recent certificate for each active sub

Search email for the sub's company name plus "certificate" or "COI." Check your shared drive. Check wherever your admin saves PDFs. The goal is to surface the most recent certificate — not to organize every historical document you have.

For each one you find, note the expiration date for general liability and workers compensation at minimum. If the sub carries umbrella or auto coverage, note those too. Record the date you last reviewed it and where the file lives.

If you cannot find a certificate for an active sub, mark that as a gap and request one immediately. A sub working without a current certificate on file is an exposure, not just an admin problem.

Step 3: Assign a status to each sub

Keep this simple. Four statuses cover everything:

• Current — certificate is on file, reviewed, and not expiring in the next 60 days
• Expiring soon — less than 60 days until the earliest expiration date
• Expired — at least one coverage is past its expiration date
• Missing — no certificate on file or the one on file is too old to rely on

The status should be visible at a glance without opening the PDF. If someone has to do math from a date column to know whether a sub is compliant, the system will not hold up when it is busy.

Step 4: Check each certificate before you mark it current

Receiving a PDF is not the same as reviewing it. When you open an ACORD 25, confirm:

• The insured name matches the subcontractor you hired — not a parent company, not a DBA that no longer matches
• Your company is listed as the certificate holder or additional insured, if your contract requires it
• The coverage limits meet your contract minimums for GL, WC, and any other required line
• The expiration dates are what you expect — not a short-term binder or a policy renewed for only part of the year

If anything is off, mark it as "needs review" and send a correction request before marking the sub current. Common problems: wrong certificate holder name, limits below contract requirements, workers comp excluded, or a policy that expired and was renewed without sending the updated certificate.

Step 5: Set renewal reminders before you put the spreadsheet away

For every sub marked current, set a reminder at 60 days before their earliest expiration. That gives you time for a first request, a follow-up if they do not respond, and a correction if the renewed certificate comes back with problems.

If you are using a shared spreadsheet, a calendar event works. If reminders keep getting lost, that is the sign you need a more reliable process — but start with what you have today.

What to do this week

Pick the 20 subcontractors most active in your current work. Spend two to three hours finding their certificates, checking them against the list above, and recording status and expiration dates in one place. Send renewal requests for anything expiring in the next 90 days.

At the end of that session you will know two things: whether your compliance file is roughly in order, or whether the gaps are bigger than the spreadsheet made them look. Either result is useful.

If the gap is real — missing certificates, wrong insured names, expired policies you did not know about — fix those first before worrying about long-term systems. The most important certificate is the one that is missing right now.

A GC office that can answer "which subs are current, which are expiring, and where is the proof?" in under two minutes is ahead of most. That is the bar. Start there.

Keep reading

• Keeping up with COI tracking week to week
• COI renewal reminder email templates