Guide
How small general contractors track subcontractor COIs
A practical playbook for GCs running 5 to 50 subs on how to collect, store, and renew Certificates of Insurance without enterprise software or a dedicated compliance hire.
No credit card required · Cancel anytime
Most guides about COI tracking are written for 500-sub enterprise GCs with a dedicated risk department. This one isn\u2019t. If you\u2019re a small or mid-size general contractor juggling 5 to 50 active subcontractors, the game is different: you don\u2019t have budget for myCOI\u2019s 200-vendor minimum, you don\u2019t want to sit through a TrustLayer sales call, and a spreadsheet breaks the moment your admin goes on vacation. This guide walks through the three options small GCs actually use — spreadsheet, shared email folder, and purpose-built software — and when each one makes sense.
The spreadsheet approach (works up to ~5 subs)
Create a simple Google Sheet with columns for Sub name, COI expiration, GL limits, WC policy number, and file link. Email subs asking for their COI; drop the PDF in Google Drive; link it in the sheet. Free and flexible — but it breaks at ~5 subs because you’re manually tracking expiration dates and chasing renewals with no reminders.
The shared inbox approach (works up to ~10 subs)
Route all COIs to a dedicated address like compliance@yourgc.com. Use email rules to auto-label by sub name. Slightly better than a spreadsheet because you have a paper trail, but you still have zero expiration tracking and no way to enforce the "no COI, no work" rule systematically.
Purpose-built software (the break-even is ~10 subs)
A tool like PaperBoss takes over the parts a spreadsheet and inbox can’t handle: automated upload links, expiration reminders at 90/60/30 days, structured field storage (GL limits, additional insured, waiver of subrogation), and built-in W-9 and WC exemption tracking in the same workflow. The break-even is around 10 subs — below that, a spreadsheet is fine; above that, the admin hours alone pay for the software.
What small GCs get wrong most often
Three recurring mistakes: (1) asking for the COI after the sub is already scheduled, so you either proceed uncovered or push the schedule; (2) not specifying Additional Insured and Waiver of Subrogation up front, so ~80% of incoming COIs need revisions; (3) never tracking expirations, so mid-project policy lapses go undetected until a claim surfaces.
PaperBoss vs Spreadsheet
Side-by-side on what a spreadsheet workflow can and can’t do for a small GC compared to a purpose-built tool.
Frequently asked questions
How many subs do I need before I outgrow a spreadsheet?
Most small GCs find the spreadsheet breaks around 5 active subs. Past that, tracking expiration dates manually becomes a part-time job. By 10 subs, you’re almost certainly losing money to missed renewals and admin time. Software pays for itself at 10-15 subs.
What COI fields should I track for each sub?
At minimum: sub name, COI expiration date, General Liability limits and carrier, Workers’ Comp policy number and expiration, Auto Liability if they drive to sites, whether the GC is named as Additional Insured, and whether Waiver of Subrogation is endorsed. For construction, also track the project name listed on the certificate.
Is there free software for small GCs to track COIs?
Thimble offers a free Certificate Manager, and many GCs use Google Drive + a spreadsheet at zero cost. Both work up to ~10 subs. Purpose-built paid tools like PaperBoss start at $29/mo and add automated reminders, structured fields, and expiration tracking that free tools can’t match.
How do I handle WC exemptions for small subs?
In states like Florida and Texas, owner-operators can file for a Workers’ Comp exemption. Track the exemption certificate the same way you track a COI: store the PDF, log the expiration date, and set a reminder before it lapses. PaperBoss handles WC exemptions in the same workflow as COIs.
What’s the single biggest change I can make to improve COI tracking?
Block project scheduling until the COI is in the system. No paperwork, no pour day. Small GCs who enforce this rule collect 90%+ of COIs before work starts instead of chasing them after. Everything else is a tooling upgrade on top of that one process change.
Built for small GCs, priced like it.
Start at $29/mo. No vendor minimum, no sales call, no implementation. Track your first sub today.
14 days free · No credit card