Every general contractor starts COI tracking in Excel. It works until it doesn't — usually the first time a sub's policy lapses mid-project, an owner requests a compliance audit, or you're managing three jobs with forty subs each.
Spreadsheets are not a compliance system. They are a temporary memory aid that becomes liability evidence when they fail.
What GCs try to track manually
- Sub name and trade
- COI PDF in a folder
- GL expiration date (sometimes)
- "Verified" checkbox
- Project assignment
What actually matters but rarely survives in Excel:
- Separate WC and auto expiration dates
- Endorsement confirmation (CG 20 10 / CG 20 37)
- Limits vs contract requirements
- Renewal history and lapse documentation
- W-9 name matching named insured
- Audit trail of who approved what and when
Failure modes we see repeatedly
1. Mid-project expiration
The sub was compliant at mobilization. Policy expired month five. Spreadsheet wasn't updated. Status still says verified.
2. Wrong limits approved
PM accepts COI with $500K GL because "we needed them on site Tuesday." Contract required $1M. Owner audit finds it at closeout.
3. AI assumed from COI text
Description box says additional insured. No endorsement on file. Claim denied.
4. Version chaos
COI_Plumbing_v3_final.pdf in email. Nobody knows which is current. Drive folder has duplicates from three projects.
5. No owner-ready export
Lender wants proof of continuous coverage for 18 trades. You spend a week reconstructing dates from email.
Time cost of manual tracking
Industry estimates for manual COI review range from 15–30 minutes per certificate when done carefully — reading limits, checking dates, confirming endorsements.
At 50 subs × 20 minutes = 16+ hours per project wave. Renewals double that annually.
Most teams cut corners under schedule pressure. That is when gaps appear.
What COI software should do for GCs
Not all "COI platforms" fit remodeling GCs. Enterprise vendor compliance tools target property managers and Fortune 500 construction — heavy onboarding, high price points.
Remodel and light commercial GCs need:
| Capability | Why it matters |
|---|---|
| Sub self-service upload | Stops email chasing |
| Requirement templates | Encode your subcontract standards |
| ACORD data extraction | Eliminates manual date entry |
| Expiration alerts | 30/14/7 day renewal workflow |
| Inline PDF review | Verify while reading the certificate |
| Project / sub dashboard | See who is blocked vs approved |
| Affordable per-sub pricing | Matches 15–50 sub program size |
CoiLoop positioning
CoiLoop is built for remodeling GCs collecting COIs and W-9s from subs:
- Magic links — subs upload without creating accounts
- Per-document checklist — COI, W-9, licenses as configured
- Inline review — PDF on left, requirements on right
- Expiration reminders — before policies lapse mid-job
- Published pricing — free tier for 20 subs; undercuts legacy COI tools
It is not a replacement for legal advice or carrier verification on every high-risk sub — but it replaces the spreadsheet that pretends you are compliant.
Migration path from spreadsheets
- Export active sub list with last known expiration dates
- Define default insurance requirements (limits + AI checklist)
- Send subs a portal link to upload current COIs
- Re-verify everything once in the new system (do not trust old "verified" flags)
- Turn on automated renewal reminders
- Retire the shared drive folder after one project cycle
Bottom line
Spreadsheets collect data. They do not enforce compliance. If your program cannot automatically surface expiring coverage and requirement gaps, you are self-insuring the administrative risk — and the claim risk when something slips through.
Start here: Subcontractor COI compliance checklist · Track expirations