United States › Compliance

Subcontractor COI & License Tracker

Available 18 January 2027

A spreadsheet that tracks every subcontractor's certificates of insurance and contractor licenses, flags what expires in the next 30 days, and checks each policy against the limits and endorsements you require. Excel and Google Sheets. One-time price, no subscription.

What it does

  • One row per policy, one row per license. Coverage, carrier, policy number, dates, limits, additional insured, waiver of subrogation, primary and non-contributory.
  • Status on every row: Valid, Expiring (within 30 days, or a warning period you choose), Expired, Missing.
  • Requirement check: set requirement profiles with your own minimum limits and endorsements. Each policy shows "Meets requirement" or exactly what falls short.
  • Missing coverage count: if a profile requires workers' compensation and there's no policy row for it, the subcontractor is flagged.
  • Overall status per subcontractor and a one-page dashboard.
  • W-9 on file column, so nothing gets paid before the paperwork is in.

What's included

Tab Purpose
Start here Four-step setup and what each status means
Dashboard Counts by status for subcontractors, policies and licenses
Subcontractors Up to 200 companies with contact details and requirement profile
Policies Up to 600 policies from certificates of insurance
Licenses Up to 400 contractor licenses with the date you verified them
Requirements Your own minimum limits and endorsements per profile
Lists Coverage types, profile names, warning period
Changelog Version history

Works with

Excel 2016 or later (Windows and Mac) and Microsoft 365. Google Sheets via a make-a-copy link. No macros, no add-ins, no account.

What it isn't

  • Not an ACORD form. It records the details from your certificates; it doesn't reproduce any certificate.
  • Not insurance advice. It ships with requirement limits blank: you enter what your contracts require.
  • Not software. No logins, no per-vendor fees, no reminders by email. You open the file and see the status.

Licenses

License Who Launch price
Single One person in one business $39
Team Up to 10 people in one company $97

Lifetime free updates. License terms · Refunds

FAQ

Does it work in Google Sheets? Yes. Your download includes a make-a-copy link that puts your own copy in your Google Drive.

Which version of Excel do I need? Excel 2016 or later on Windows or Mac, or Microsoft 365. It doesn't use any functions newer than Excel 2016.

Can I change the 30-day warning? Yes. Set any number of days from 1 to 365 on the Lists tab.

Does it tell me what insurance limits to require? No. Requirements come from your contracts and your insurance professional. You enter them once per profile.

Can I add my own coverage types? Yes. Add them on the Lists tab and they appear in the dropdowns.

What happens when you update it? You get an email, and the new version appears on your downloads page. Updates are free for life.

How was it made? Built and tested to our quality standard: every formula tested against sample data, print layout checked on US Letter, sources checked and dated.


Fernoth research, sources checked 21 Nov 2026. This tracker is a record-keeping aid. It does not guarantee that any insurance is adequate or that any license is valid for the work.