📅 Published: June 10, 2026
COI tracking becomes stressful when certificates live only in email threads. A vendor can be approved one month and expired the next, and nobody notices until an urgent job is already scheduled.
Quick answer
Use a spreadsheet with vendor name, service type, COI expiration date, coverage notes, additional insured status, last request date, next follow-up date, and approval status.
Use a spreadsheet with vendor name, service type, COI expiration date, coverage notes, additional insured status, last request date, next follow-up date, and approval status.
Spreadsheet columns
| Column | Purpose |
|---|---|
| Vendor name | Who the certificate belongs to |
| Service type | Plumbing, HVAC, roofing, electrical, cleaning, etc. |
| COI expiration date | Main renewal trigger |
| Coverage notes | General liability, auto, workers comp if applicable |
| Additional insured status | Needed, received, missing, not applicable |
| Last request date | When you asked for updates |
| Next follow-up date | When to ask again |
| Approval status | Approved, pending, expired, do not use |
| File link | Where the current certificate is saved |
Reminder timing
- 30 days before expiration: friendly renewal request
- 15 days before expiration: second request
- 7 days before expiration: internal flag
- expiration day: mark expired until updated COI is received
Vendor follow-up email
Template
Hi [Vendor Name], our records show your COI expires on [date]. Please send an updated certificate when available. If the certificate needs specific holder or additional insured wording, please let us know who on your team should receive those details. Thank you.
Hi [Vendor Name], our records show your COI expires on [date]. Please send an updated certificate when available. If the certificate needs specific holder or additional insured wording, please let us know who on your team should receive those details. Thank you.
Common mistakes
- tracking the COI but not saving the file
- saving the file but not tracking the expiration date
- not checking the vendor name
- not archiving old certificates
- letting urgent vendors expire without notice
Weekly habit
Every Monday, filter the tracker for COIs expiring in the next 30 days. That one habit can prevent many last-minute chases.
Final thought
COI tracking is not complicated. It just needs a clear owner, visible dates, and consistent follow-up.
Need vendor paperwork cleaned up?
If COIs, W-9s, expiration dates, licenses, and vendor folders are scattered everywhere, DamnJobs can help organize the mess.