How to Track Subcontractor COIs (Free Spreadsheet Template + Why It Breaks)

If you run a small general contracting business, you already know the drill: before a sub sets foot on your job site, you need a current certificate of insurance (COI) on file. If their coverage lapses mid-project and something goes wrong, the claim — and often the cost — can land on you. And at your workers' comp premium audit, missing COIs can mean you get charged premium for your subs' payroll (we cover that in detail in our premium audit checklist).

The good news: you do not need software to start tracking COIs. A well-built spreadsheet works fine at a small scale, and this guide gives you one for free. The honest part: spreadsheets break down in predictable ways as you grow, and we'll tell you exactly when that happens so you can see it coming.

What you actually need to track for each sub

A COI (usually an ACORD 25 form) summarizes a sub's insurance policies. For tracking purposes, you care about a handful of fields:

• General liability expiration date. The single most important date. When it passes, the sub may be working uninsured.
• Workers' comp expiration date. Critical for your own premium audit — auditors ask for proof of every sub's coverage.
• Auto liability expiration if the sub drives to your sites (most do).
• Additional insured status. Whether your company is named as an additional insured on the sub's general liability policy. Many GC contracts and many GCs' own insurers require this.
• Waiver of subrogation. Whether the sub's insurer has waived its right to come after you to recover claim payments. Also commonly required by contract.
• Coverage limits. Your contracts probably require minimums (commonly $1M per occurrence / $2M aggregate for general liability, but check your own contracts and ask your agent).

One important caveat: a COI is an informational snapshot, not proof that coverage exists today or that endorsements are in force. The certificate itself says so. If additional insured status matters to you — and it should — the real evidence is the endorsement page from the policy, not the checkbox on the certificate. Our field-by-field ACORD 25 guide explains this in depth.

The free COI tracking spreadsheet template

Copy the table below into Excel or Google Sheets. One row per subcontractor. It covers the fields above plus W-9 status, since you will want that for 1099 season anyway (see our W-9 collection guide).

Three setup tips that make the spreadsheet actually work:

1. Add conditional formatting on the date columns. In Google Sheets: Format → Conditional formatting → "Date is before" → "exact date" → =TODAY()+60 for yellow, =TODAY() for red. Now expiring rows light up without you doing math.
2. Keep the actual PDFs in one place. A single cloud folder with one subfolder per sub. The "COI File Location" column exists because six months from now you will not remember which email thread the PDF lives in.
3. Put a recurring 30-minute review on your calendar. The spreadsheet only tells you what is expired if someone opens it. Monthly is the minimum; twice a month is better during busy season.

When a spreadsheet is genuinely enough

Honesty time: if you work with a handful of subs — say five or fewer — and they are the same subs year after year, a spreadsheet plus a calendar reminder is a perfectly reasonable system. The renewal dates cluster, you know everyone personally, and a phone call gets you a new certificate in a day. Do not buy software you do not need. There are even free software tiers for small vendor counts, which we cover in our COI software pricing guide.

Where the spreadsheet breaks (and it always breaks the same way)

Somewhere between roughly 10 and 20 active subs, the same failure pattern shows up in almost every GC office we have talked to:

• The chase consumes hours. Every expiration means emailing the sub, waiting, emailing again, sometimes calling their insurance agent directly. Multiply by 15 subs with staggered renewal dates and someone is spending several hours a month just chasing paper.
• Data entry stops happening. A new COI arrives while you are on a job site. It sits in your inbox. The spreadsheet still shows the old date — or worse, shows "OK" for a sub whose renewal actually lapsed and whose new certificate never came.
• The spreadsheet lies by omission. A spreadsheet shows what someone typed, not what is true. If nobody read the new certificate closely, the "Additional Insured: Yes" cell may be copied forward from last year even though this year's policy dropped the endorsement.
• It depends on one person. When the office manager who owns the spreadsheet goes on vacation or leaves, the system stops. Nobody else knows the formatting rules, the folder structure, or which subs are behind.
• Audit season becomes a scramble. When your workers' comp auditor asks for certificates covering your entire policy period, you need historical COIs — not just current ones. Most spreadsheets only track the latest certificate, so you end up digging through a year of email.

None of these are character flaws. They are structural problems: a spreadsheet is a passive record, and COI tracking is an active chore. The work is in the chasing, the reading, and the reminding — and a spreadsheet does none of that.

What to look for if you outgrow the spreadsheet

When the spreadsheet starts costing you real hours, look for a system that does the active work: sends your subs a link to upload documents (without making them create accounts they will never use), reads the expiration dates off the certificate for you, and emails both you and the sub before coverage lapses — at 60, 30, 15, and 7 days out, not the morning after. Pricing across the market varies enormously, from free tiers to five-figure annual contracts; our 2026 pricing guide breaks down what each vendor charges and who each one actually fits.

Whatever you choose — spreadsheet or software — the goal is the same: no sub on your site without current coverage on file, and no surprises at audit time.