How to track certificates of insurance

The three ways COIs get tracked

• The inbox. Certificates arrive by email and live where they landed. It costs nothing and fails the moment someone asks which subs are covered today.
• The spreadsheet. One row per subcontractor, columns for carrier, limits, expiry. Better, and it stays useful right up to the point where the roster, the projects, and the requirement list all grow at once.
• A purpose-built tracker. Requirements, uploads, review decisions, expiry dates, and reminders in one place, with the subcontractor uploading their own documents.

Where the spreadsheet quietly fails

A spreadsheet records what you typed into it. It doesn't record whether the file behind the row matches the contract, or whether that file is still current.

The failure modes are consistent: expiry dates are copied once and never re-checked, so the sheet reads 'covered' long after a policy lapsed; a new certificate replaces an old one and nobody knows which version the row refers to; the limits column says $1M but not whether that's per occurrence or aggregate; and there is no record of who chased whom, so the same phone call gets made twice by two people.

The deeper problem is that a spreadsheet is a private artefact. Your project manager, the superintendent, and the owner's risk manager each need a different view of the same roster, and the only way to give it to them is to send a screenshot of a tab.

A six-step process that survives contact with a real job

1. 1Write the requirements once. Decide what each trade must carry — limits, endorsements, additional insured, waiver of subrogation, licence — and turn it into a checklist you can reuse. One version per trade beats one version per project manager.
2. 2Send the checklist with a deadline. Ask for the documents before mobilization, with a clear date, and give the sub or their agent one place to upload them. No account to create, no portal password to forget.
3. 3Review against the checklist, not against a feeling. Limits, additional insured, expiry, description of operations. Approve or send back with the specific reason — 'additional insured endorsement missing for the owner' beats 'COI not accepted'.
4. 4Record the decision. The file should show who approved it, when, and against which version of the requirements. When an owner asks, you want an answer, not an reconstruction.
5. 5Track the expiry date of every approved document — and the endorsement, not just the certificate.
6. 6Chase automatically, and escalate. A reminder to the sub and their agent 30 days out, a second 7 days out, and an internal flag when a document is past due so somebody can hold mobilization or a pay application.

What to automate and what to keep human

Automate everything mechanical: sending the request, following up, flagging expiries, and telling you which subs on a live project are not currently compliant. Those tasks are unambiguous and they are the ones people forget under deadline pressure.

Keep the judgement calls human: whether a particular umbrella policy satisfies a contract requirement, whether a description of operations is broad enough, whether to hold a pay application over a lapsed certificate. Automation earns its place by removing the busywork around those decisions, not by making them.

A good rule of thumb: if a task could be described to a new assistant in one sentence, automate it. If it needs context about the relationship, keep it on your desk.

What 'good' looks like on a live project

• One screen shows every subcontractor on the job and their status — approved, awaiting documents, expiring soon, lapsed.
• Each requirement has a date attached, so you can see the next 30 days of expiries before they arrive.
• The subcontractor's insurance agent can upload without an account, so certificates don't pass through your inbox at all.
• A corrected certificate replaces the old one and the audit trail shows what changed.
• You can answer an owner's question about coverage in a couple of minutes instead of a morning.

Frequently asked questions

Keep reading

• TrackingCOI tracking software compared: DocumentLane, Billy, Jones, TrustLayer and myCOICompare DocumentLane with Billy, Jones, TrustLayer, myCOI and SmartCompliance by intake, insurance review and construction workflow — including where DocumentLane still needs a manual check.
• TrackingCOI renewals: how to stop chasing expired certificatesPolicies renew every year, but certificates don't update themselves. Why renewals slip, who to ask, and a routine that catches lapses before they become exposure.
• TrackingCOI expiration reminders that actually workWhy subcontractor insurance lapses slip past general contractors, a reminder cadence that gives agents time to respond, and what to do when a certificate expires mid-project.