How to Track Subcontractor Certificates of Insurance (Without a Spreadsheet)

To track subcontractor certificates of insurance, collect a compliant COI before each sub mobilizes, verify the coverage types, limits and endorsements against the subcontract, store the PDF with the sub's record, and set renewal alerts 30 days before expiry.

If you run subs, you already know the drill. Before a crew sets foot on site, someone needs to chase down a certificate of insurance, confirm the coverage is real, file it somewhere, and remember to ask for a new one before it expires. Multiply that across a dozen active jobs and fifty subcontractors, and you have a full-time job hiding inside your project management.

Most general contractors start tracking COIs in a spreadsheet. It works — right up until it doesn't. This is a practical playbook for tracking subcontractor certificates of insurance in a way that actually holds up when a claim, an audit, or an owner's request lands on your desk.

What a Certificate of Insurance Actually Tells You

A COI (usually an ACORD 25 form) is a snapshot summary of a subcontractor's insurance at the moment it was issued. It is not the policy itself, and it does not, on its own, guarantee coverage. It tells you the insurer, the policy numbers, the coverage types, the limits, and the effective and expiration dates.

For a GC, the point of collecting one is straightforward: if a sub causes damage or injury on your project, you want their insurance to respond first, not yours. That only works if the coverage is in force, meets your contract requirements, and is structured to actually protect you. A certificate that expired last month protects no one.

What to Collect From Every Subcontractor

Don't just collect "a COI" and move on. Collect the right pieces, and read them. At minimum, for each active sub you want:

1. General liability coverage with limits that meet your subcontract and the project owner's requirements.
2. Workers' compensation coverage, which is required in most states for subs with employees.
3. Auto liability, especially for subs hauling material or equipment.
4. Umbrella/excess coverage if your contract requires higher limits than the primary policy provides.
5. Additional insured status naming your company, typically for both ongoing and completed operations.
6. Waiver of subrogation and primary and non-contributory language where your contract calls for it.
7. The endorsement forms that back up the additional insured and other special status — the certificate references them, but the endorsement is the proof.

The last two points are where spreadsheet tracking quietly falls apart. A certificate can list "additional insured" in a checkbox while the underlying endorsement says something narrower. If you're only logging expiration dates in a grid, you never catch the gap. For a fuller breakdown of what belongs in your contract in the first place, see our guide to subcontractor insurance requirements.

This is general information, not legal or insurance advice.

Why Spreadsheets Fail at This

Spreadsheets are great at math and terrible at deadlines. Here's where they break down for COI tracking:

• They don't remind anyone. A cell that reads "Expires 3/14" will not email you on March 1. You have to remember to look — and everyone forgets during a busy build.
• They rot silently. One person renames a tab, another sorts the sheet and breaks the formulas, a third keeps their own copy. Within a season you have three versions and no source of truth.
• They store dates, not documents. The actual PDF lives in email, or a shared drive, or someone's downloads folder. When you need to prove coverage, you're hunting.
• They don't verify anything. A spreadsheet happily accepts a limit that's too low or an expired date typed in wrong. It can't tell you the coverage doesn't meet the contract.
• They don't scale. Twenty subs is tedious. Two hundred across multiple jobsites is genuinely risky, because the gaps you can't see are the ones that hurt you.

The core problem: a spreadsheet is a record of what you typed, not a system that watches your risk for you.

A Simple System That Works

You don't need enterprise software to do this well. You need a repeatable process. Here's a workflow you can run whether you're doing it manually or with a tool:

1. Standardize your requirements. Write your insurance requirements into every subcontract — coverage types, minimum limits, additional insured and endorsement language. Every sub gets the same baseline, so there's nothing to negotiate at the last minute.
2. Collect before mobilization. No valid, compliant COI on file means no work on site. Make it a hard gate, not a follow-up item.
3. Verify on receipt. Check the coverage types, limits, dates, and that your company is named correctly. Confirm the endorsements match what the certificate claims.
4. Store the document, not just the data. Keep the actual PDF attached to the sub's record, tied to the project it covers.
5. Set renewal reminders before expiration. Trigger a reminder 30 days out so there's time to chase a renewal without a coverage gap.
6. Track status at a glance. You should be able to answer "which subs are non-compliant right now?" in seconds, not by scrolling a sheet.
7. Keep an audit trail. When an owner, insurer, or auditor asks, you want a clean history of what was collected and when.

Run that loop consistently and most COI headaches disappear. The subs learn your standard, the documents stay current, and you stop discovering lapses after the fact.

The Quick Compliance Checklist

Use this every time a new certificate comes in:

• Coverage types match the subcontract
• Limits meet or exceed your minimums
• Policy is currently in force (check effective and expiration dates)
• Your company is named as additional insured, spelled correctly
• Endorsement forms are attached and match the certificate
• Waiver of subrogation and primary/non-contributory included if required
• Workers' comp present for subs with employees
• Document saved to the correct project and sub record
• Renewal reminder set for 30 days before expiration

When to Move Off the Spreadsheet

There's no shame in starting with a spreadsheet. The signal to graduate is usually one of these: you've missed a renewal and didn't notice until a sub was already working uninsured, you can't quickly tell who's out of compliance, or you're spending real hours each week on manual chasing and filing.

At that point, purpose-built COI tracking software pays for itself by doing the parts spreadsheets can't — automatic expiration reminders, document storage tied to each sub and project, and a live compliance view. It turns tracking from something you have to remember into something that happens on its own.

The goal isn't more paperwork. It's making sure that when something goes wrong on a jobsite, the right insurance responds — and you can prove it in minutes.

Frequently Asked Questions

What is a certificate of insurance?

A certificate of insurance, usually an ACORD 25 form, is a snapshot summary of a subcontractor's insurance at the moment it was issued. It shows the insurer, policy numbers, coverage types, limits, and effective and expiration dates. It is not the policy itself and does not on its own guarantee coverage.

Can you track subcontractor COIs in a spreadsheet?

Yes, up to a point. A spreadsheet records expiration dates but it does not remind anyone, store the actual documents, or check that coverage meets the subcontract. Most general contractors outgrow it once a missed renewal or the weekly hours of manual chasing start to cost real money.

When should you collect a COI from a subcontractor?

Before mobilization, as a hard gate rather than a follow-up item. A valid, compliant certificate belongs on file before any crew sets foot on site, and the renewal should be requested roughly 30 days before the current policy expires.

Why isn't the "additional insured" box on the certificate enough?

Because the certificate only references the endorsement, and the endorsement is the proof. A COI can show additional insured status while the underlying endorsement grants something narrower, so the endorsement forms need to be collected and read alongside the certificate.

How far in advance should you request a COI renewal?

At least 30 days before the expiration date. That leaves time to chase the subcontractor and their broker without a coverage gap opening up while the sub is still working on site.

If you're ready to retire the spreadsheet, you can try TradeGuard free for 14 days at trade-guard.pro/signup and see how your COI tracking looks when it runs itself.