Free COI Tracking Spreadsheet Template (+ When You'll Outgrow It)

Here's a free COI tracking spreadsheet template — built for property managers and contractors who need to track certificates of insurance across vendors and tenants without buying software on day one.

Download the template (.xlsx) →

It's deliberately more opinionated than the usual "name, policy number, expiration date" tracker, because expiration dates are the least important thing a COI tracker watches. What actually causes claims to land on the wrong policy is missing endorsements and inadequate limits — so this template tracks those.

What's in it

COI Tracker tab. One row per vendor or tenant. You fill in the yellow cells — carrier, limits, expiration, and three Yes/No endorsement columns (additional insured attached, primary & noncontributory, waiver of subrogation). Two columns calculate themselves:

• Days until expiration — counts down automatically.
• Status — the useful one. It doesn't just say "expired/current." It returns Missing COI, EXPIRED, GAP – Endorsements (an endorsement column says No), GAP – Limits (GL below your required amount), Expiring ≤30 days, or Compliant — color-coded, so the portfolio's real state is visible at a glance.

Note what that status logic implies: a certificate can be current and still show as a gap. That's the point. A tracker that only watches dates marks wrong-but-active coverage as fine, and wrong-but-active is the most common failure on real certificates.

Requirements Schedule tab. A three-tier vendor requirements baseline (low risk / standard trades / high hazard) plus typical tenant requirements, so the "Required GL" column has something defensible behind it. Adjust to your portfolio — and to your actual leases and contracts, which always win.

How to Use tab. Two minutes of setup instructions, including the one rule that makes the endorsement columns meaningful: only enter "Yes" if the endorsement form is actually attached to the certificate. A mention in the ACORD description box amends nothing.

How to use it well

Enter every active vendor and tenant, set each row's required GL from the lease or contract (not from memory), and update the endorsement columns from what's physically attached to each certificate. Then work the color: red rows get chased this week, amber rows are renewals to request now, and "Last Verified" gets a new date every time you re-check a cert — at intake and at every renewal, because renewal is where compliant certificates quietly go bad.

For the full process this template supports, see the complete guide to COI tracking for property managers — or the subcontractor insurance requirements guide if you're on the construction side.

When you'll outgrow it — honestly

A spreadsheet holds up to roughly 50–75 active certificates. Past that, three things break, in order:

1. The chase outgrows the sheet. Every red row means multiple rounds of email with someone's insurance agent. The spreadsheet can tell you a correction is needed; it can't send round three of the follow-up, and round three is where compliance actually happens.
2. The verification thins out. The endorsement columns are only as true as the last human who read the attachments. Under time pressure, "Yes" starts meaning "probably."
3. Renewals cluster. January and July renewal waves hit, twenty certificates arrive in a week, and the sheet stops reflecting reality precisely when the risk is highest.

None of that is a knock on spreadsheets — it's just what happens when a verification job is tracked by a tool that can't do the verifying. When you hit that point: Tightrope's agent Travis reads each certificate and its endorsements against your actual lease or contract requirements, flags the gaps, and runs the follow-up itself — email, phone, and text — until the corrected certificate is on file. The free plan means the upgrade path costs the same as this template.

FAQ

What should a COI tracking spreadsheet include? Beyond names and expiration dates: required vs. actual limits, and whether the additional insured, primary & noncontributory, and waiver of subrogation endorsements are attached. If it only tracks dates, it's tracking the wrong risk.

How do I track COI expiration dates in Excel? This template does it with =ExpirationDate−TODAY() and a status formula with conditional formatting. The countdown is the easy part — build the tracker around endorsements and limits, and the dates come along for free.

Is there a free alternative to COI tracking software? This template, up to about 50–75 certificates. Past that, the follow-up workload — not the tracking — is what forces the upgrade.

---

Download the template above, and when the red rows start piling up: run one through Travis on Tightrope's free plan and see what the chase feels like when you're not the one doing it.