COI tracking spreadsheet template (and why it breaks)
A COI tracking spreadsheet needs one row per subcontractor and columns for carrier, policy number, coverage types, limits, additional insured and waiver status, effective and expiration dates, and overall status. It works at first—but has no expiration alerts and cannot read certificates, so it breaks down as your list grows.
What columns does a COI tracking spreadsheet need?
A useful spreadsheet captures every field you would otherwise have to re-read off the certificate of insurance. Use one row per subcontractor (or one row per policy if you want to track each line separately) and these columns:
| Column | What it records |
|---|---|
| Subcontractor name | The legal/business name of the insured sub. |
| Insurance carrier | The company issuing each policy (e.g., from the ACORD 25). |
| Policy number | A separate number for each policy line you track. |
| Coverage types | General liability, auto liability, workers’ comp, umbrella/excess. |
| Coverage limits | Per-occurrence and aggregate limits for each line. |
| Additional insured (Y/N) | Whether your company is named as additional insured. |
| Waiver of subrogation (Y/N) | Whether the policy includes a waiver in your favor. |
| Effective date | When each policy period begins. |
| Expiration date | When each policy lapses—the column you must watch. |
| Status | Compliant, expiring soon, expired, or missing documents. |
Add optional columns as needed—project name, certificate holder, primary and non-contributory (Y/N), the date you last requested an update, and a link to the stored PDF. Conditional formatting on the expiration and status columns (red for expired, amber for expiring soon) is the single most useful enhancement.
A starter column layout
In practice, the left-to-right order that reads best is: Sub name → Carrier → Policy # → Coverage type → Limits → Additional insured → Waiver → Effective date → Expiration date → Status. Group the four coverage lines (general liability, auto, workers’ compensation, umbrella) so each sub’s policies sit together, and keep the Status column far right where it is easy to scan. Before you build it, confirm what each sub actually needs to carry using our subcontractor insurance requirements checklist.
Why a COI tracking spreadsheet breaks down
A spreadsheet is a fine place to start, but it is a static list— it does nothing on its own. Three limits show up fast as your subcontractor count grows:
- No expiration alerts.The spreadsheet will not warn you when a policy lapses. Someone has to remember to check the dates—and the cost of forgetting is uncovered work.
- No ACORD reading. A person still has to open each ACORD 25, interpret it, and type the limits and endorsements in by hand—where typos and misreads creep in.
- Manual chasing. Collecting renewals, following up on missing certificates, and confirming additional insured and waiver status is all on you, every cycle.
None of these are spreadsheet bugs—they are simply jobs a spreadsheet cannot do. The risk is quiet: a single expired policy or mistyped limit can leave you exposed without any visible warning.
When to upgrade from a spreadsheet
If you are tracking more than a handful of subs—or if a lapse would put real liability on you—it is worth moving to software that does the work the spreadsheet cannot. Wardlyis free COI tracking built for general contractors: subs upload a certificate from a link with no account, Wardly reads each ACORD 25 and auto-grades it A–F against your requirements, and it monitors every expiration date so renewals never slip. There is no per-vendor fee and no downloadable template to maintain—the tracking is the product. See how it compares on our comparison hub, learn the full tracking workflow, or start from the Wardly homepage.
General information, not legal or insurance advice.
Frequently asked questions
What columns should a COI tracking spreadsheet have?
At minimum: subcontractor name, insurance carrier, policy number, coverage types, coverage limits, additional insured (Y/N), waiver of subrogation (Y/N), effective date, expiration date, and a status column. Each captures one piece of data you would otherwise have to re-read from the certificate.
Is a spreadsheet good enough for tracking COIs?
It works for a handful of subcontractors, but a spreadsheet has no expiration alerts, cannot read an ACORD 25 for you, and requires manual chasing of renewals. As your subcontractor list grows, those gaps turn into coverage that lapses without anyone noticing.
Why does a COI spreadsheet break down at scale?
Because every step stays manual: someone has to read each certificate, type the data correctly, remember every expiration date, and chase renewals. One missed date or typo can leave you exposed, and the workload grows with every subcontractor you add.
Keep reading
More COI tracking guides for general contractors.
What is COI tracking?
A plain-English definition of certificate-of-insurance tracking: what it is, why it matters, and how it protects contractors from uninsured risk.
Read the guideHow COI tracking works
The end-to-end workflow of COI tracking—from collecting certificates to grading, verifying endorsements, and monitoring expirations.
Read the guideCOI tracking checklist
A practical, printable checklist for collecting, verifying, and renewing every subcontractor and vendor certificate of insurance.
Read the guideConstruction COI requirements by state
How certificate-of-insurance and coverage requirements vary by state for construction—workers’ comp rules, limits, and what to standardize.
Read the guideSkip the spreadsheet. Track COIs for free.
Wardly reads each certificate, grades it A–F against your requirements, and watches every expiration date—free forever, no per-vendor fees.
Get started free