The columns
| Column | What goes in it |
|---|---|
name | Vendor or subcontractor name |
email | Who sends the certificate (the vendor or their agent) |
policy type | General liability, auto, workers' comp, umbrella |
expiry | Expiration date of that line, as YYYY-MM-DD |
note | Job, required limits, missing endorsement |
Dates as YYYY-MM-DD sort correctly in every spreadsheet app and import cleanly into other tools.
Useful formulas
In Excel or Google Sheets, with the expiry in column D, add a "days left" column:
=D2-TODAY()
And a status column:
=IF(D2<TODAY(),"EXPIRED",IF(D2-TODAY()<=30,"EXPIRING","OK"))
Conditional formatting on the status column (red for EXPIRED, amber for EXPIRING) makes the weekly check quick.
Where spreadsheets fall short
A spreadsheet only helps when someone opens it. It will not email you or the vendor. If the weekly check keeps slipping, see COI Nudge vs a spreadsheet for an honest comparison.
Import this template into COI Nudge
The template's headers are the ones the COI Nudge importer reads. Open the vendor list, choose the CSV, and the free try keeps the first 3 vendors on your device. The paid plan holds up to 100 vendors and sends the reminder emails.