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
- Add every new certificate the day it arrives.
- Filter for anything expiring in the next 30 days and request renewals.
- Flag anything expired or missing before the sub's next day on site.
- 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.