COI tracking spreadsheet for general contractors
Track every sub's certificate of insurance in one place: limits, expiry dates with 30-day color alerts, endorsement flags, and who reviewed what. Free Excel download — no email address required, no account, nothing to sign up for.
What's inside
One row per subcontractor: the limits shown on their ACORD 25 (GL, auto, workers' comp, umbrella), the expiry date, additional-insured and waiver-of-subrogation flags, who on your team reviewed it and when, and W-9 status. Rows turn amber 30 days before a certificate's expiry date and red once it has passed.
Common starting values for twelve trades — the same table published at sublien.com/coi-requirements — so you can compare a certificate against something. Your company decides its own requirements.
Two minutes of instructions, three example rows to overwrite, and a plain statement of what a spreadsheet can and can't do about certificates.
What the spreadsheet can't do
A spreadsheet records what you type into it. It doesn't email your subs before a certificate's expiry date, read the ACORD 25 for you, compare limits against per-project rules, or keep an audit trail of who reviewed what. If one person on your team spends an afternoon a week on certificate emails, that's the part SubLien automates — COIs, W-9s and lien waivers on one record per sub, with the chasing done for you and your team recording the decisions. Prices are published: $199, $399 or $799 a month.