United States › Guides

How to track subcontractor certificates of insurance

Fernoth research. Sources checked 21 Nov 2026.

To track certificates of insurance (COIs), record each policy from every subcontractor's certificate in one list: coverage type, carrier, policy number, effective and expiration dates, limits and endorsements. Then review expirations every week, request renewals 30 days ahead, and check each policy against the requirements in your subcontract.

What to record from each COI

Field Where it is on a typical certificate Why you need it
Insured Insured box Must match the company you contracted
Coverage type Each row of the coverages section General liability, auto, workers' compensation, umbrella
Carrier Insurers listed by letter To verify the policy
Policy number Next to each coverage To verify and reference
Effective and expiration dates Next to each policy The certificate only speaks for these dates
Limits Right-hand column per coverage Compare with your contract minimums
Additional insured, waiver of subrogation Marked per policy (often "ADDL INSD" and "SUBR WVD" columns) Many contracts require these; ask for the endorsement itself
Certificate holder Bottom left Should be your company

A certificate is issued for information. It doesn't change the policy, so when your contract requires additional insured status, ask for the endorsement too.

A simple weekly routine

  1. Add every new certificate the day it arrives.
  2. Filter for anything expiring in the next 30 days and request renewals.
  3. Flag anything expired or missing before the sub's next day on site.
  4. Re-check limits and endorsements whenever a contract changes.

Spreadsheet or software?

Spreadsheet COI software
Cost One-time Typically per vendor per month or quote-based (for example, one vendor lists about $0.95 per vendor per month)
Setup Minutes Onboarding, integrations
Reminders You check a status column Automatic emails
Best for Small and mid-size GCs, remodelers Large GCs with hundreds of vendors

Our COI & License Tracker is a spreadsheet built for this: statuses, a 30-day warning, requirement checks per subcontractor and a license tab.

FAQ

Can I copy an ACORD form into my spreadsheet? Record the details, not the form. ACORD forms are copyrighted.

What if the sub has no license on file? Track licenses alongside insurance and check them with the state or local licensing authority.


Sources: bcs pricing (checked 21 Nov 2026); Billy on COI tracking. General information, not insurance or legal advice.