Spreadsheet template
COI Tracking Spreadsheet Template for Contractors
If your office tracks subcontractor certificates in Excel or Google Sheets, start with the fields that actually make the workflow safer: expiration dates, review status, file location, reminder ownership, and what still needs follow-up.
Start with the spreadsheet if that is what the office uses
The spreadsheet is not the enemy. A clear spreadsheet is often the fastest way to turn a messy COI file into a working system. The problem starts when the spreadsheet looks organized but nobody trusts the status column.
A row can say “current” while the PDF has not been reviewed since the last policy renewal. Or the file link can point to an old certificate. Or the expiration date can be right but the follow-up owner is blank. That is how a tidy spreadsheet becomes fake confidence.
Use this template structure as the baseline. You can copy the fields into Excel, Google Sheets, Airtable, or any lightweight tracker.
Recommended COI tracking columns
| Column | Example value | Why it belongs in the tracker |
|---|---|---|
| Subcontractor | North Ridge Electrical | The company you hired. Match this against the insured name on the certificate. |
| Trade / scope | Electrical | Helps project teams and office staff prioritize active work. |
| Contact email | [email protected] | The person who should receive certificate requests and renewal reminders. |
| Certificate file location | Drive link or folder path | Prevents the “I know we have it somewhere” problem. |
| General liability expiration | 2026-09-01 | One of the core dates most GC offices need visible. |
| Workers comp expiration | 2026-08-15 | Often expires on a different date than GL; track it separately. |
| Auto / umbrella expiration | 2026-10-01 | Use only for coverage lines your contracts require. |
| Earliest expiration | 2026-08-15 | Use the earliest required date to drive status and reminders. |
| Certificate holder confirmed | Yes / No / N/A | Flags whether the certificate was reviewed against your requirements. |
| Additional insured required / received | Required — received | Useful when contract requirements include additional insured endorsements. |
| Coverage limits reviewed | Yes / Needs review | Keeps “PDF received” separate from “certificate reviewed.” |
| Status | Current / Expiring soon / Expired / Missing / Needs review | The field everyone should be able to understand at a glance. |
| Last requested | 2026-06-01 | Shows whether someone already followed up. |
| Next reminder date | 2026-07-15 | Turns renewal tracking into a routine instead of a memory test. |
| Owner | Admin / PM / accounting | Names who is responsible for the next action. |
| Notes | Waiting on corrected holder name | Captures the messy edge cases without hiding them in email. |
Status labels to use
Keep the status labels boring. Boring is good here.
- Current — certificate reviewed and no required coverage expires inside your reminder window.
- Expiring soon — earliest required coverage expires in the next 60 or 90 days.
- Expired — at least one required coverage line is past its expiration date.
- Missing — no usable certificate is on file.
- Needs review — PDF received but not yet checked, or the certificate has a mismatch.
Do not let “received” become a status. It is a step, not an answer.
Reminder dates that make the spreadsheet useful
The easiest reminder system is a separate column for “next reminder date.” Calculate it from the earliest required expiration date. A simple routine:
- 90 days out: first renewal request for active or frequently used subcontractors.
- 60 days out: follow-up request and internal owner assignment.
- 30 days out: escalation if the sub has not responded or sent an incomplete certificate.
- Expired: mark the row red and decide whether the sub can continue work under your company’s process.
For email copy, use the COI renewal reminder templates.
Simple conditional formatting
If you are using Excel or Google Sheets, color should reflect action, not decoration:
- Green: current and reviewed.
- Yellow: expiring soon or waiting on review.
- Red: expired or missing.
- Gray: inactive subcontractor or no current job exposure.
The rule of thumb: if a project manager looks at the sheet for 30 seconds, they should know what is safe, what is pending, and what needs help.
When the spreadsheet stops being enough
A spreadsheet is usually enough when one person owns the process and the active sub list is small. It starts to break when the same few issues repeat:
- reminders go out late because nobody checked the dates;
- the office cannot find the reviewed PDF quickly;
- multiple people edit rows without the same status rules;
- new certificates arrive in email but do not get reviewed;
- owners or project teams ask for proof faster than the spreadsheet can answer.
That is the moment to move from “spreadsheet as memory” to “tracker as workflow.” CertKeeper is being built around that handoff: email-based intake, reviewed status, stored certificates, and renewal reminders without asking every subcontractor to log into another portal.
Want the spreadsheet to stop doing reminder duty?
CertKeeper helps GC offices track subcontractor COIs, certificate status, file locations, and renewal reminders in one place. Request early access if your spreadsheet is starting to leak.
Request early access