Construction

Construction COI Tracker Template

Track certificate expiration dates and coverage for every active subcontractor

By Chandler Supple5 min read

An expired Certificate of Insurance is one of the most frustrating reasons to have a construction draw rejected, because it is entirely preventable. The insurance did not expire mid-draw. The subcontractor probably just did not send you the renewal. Your tracker failed to catch the upcoming expiration before submission day. This post gives you a COI tracker template with the exact columns you need and a monitoring process that catches expirations 30 days before they become a problem.

Why COI Tracking Matters for Construction Draws#

Most construction lenders require that every subcontractor performing work have valid certificates of insurance on file before draw funds are released. A COI documents the subcontractor's current coverage — general liability, workers compensation, automobile, and umbrella — and confirms that the owner and lender are listed as additional insureds.

The problem is that COIs expire on policy renewal dates that have nothing to do with your project schedule. A subcontractor who started work in August with a December policy expiration will have an expired COI by February. If nobody is tracking that, February's draw gets rejected.

COI Tracker Template: Column Structure#

One row per subcontractor (not per policy). Add additional coverage-type columns as needed for your project's specific requirements.

  1. Subcontractor name — Full legal entity name
  2. Trade / scope — Brief description (e.g. Electrical, Concrete, HVAC)
  3. Status on project — Active, Complete, Inactive
  4. COI on file — Yes / No / Requested
  5. COI date received — When you received the current COI
  6. Policy effective date — Start of current policy period
  7. Policy expiration date — End of current policy period (this is the date to monitor)
  8. General liability limits — Per occurrence and aggregate
  9. Workers compensation — Confirmed in place (Y/N) with employer's liability limits
  10. Automobile liability — Limits confirmed (Y/N)
  11. Umbrella / excess — Limits if required by contract
  12. Owner listed as additional insured — Yes / No / Check needed
  13. Lender listed as additional insured — Yes / No / Not required
  14. Project listed by address — Yes / No (blanket additional insured vs. project-specific)
  15. Days until expiration — Calculated from today to expiration date
  16. Renewal requested — Date you sent renewal request
  17. Renewal received — Date updated COI received
  18. Notes — Coverage gaps, non-standard endorsements, issues with additional insured language

The 30-Day Expiration Monitoring Process#

Your tracker should flag any active subcontractor whose policy expires within 30 days. That gives you time to send a renewal request, receive the updated COI, and confirm it before the draw package goes out.

Set up a filtered view or conditional formatting that highlights any row where:

  • Status is Active and expiration date is within 30 days
  • Status is Active and COI on file is No or Requested
  • Additional insured confirmation is missing for an active sub

Review this filtered view every Monday. If you see flagged rows, send renewal requests immediately rather than waiting for draw prep week.

What to Check When You Receive a COI#

Do not file a COI without reviewing it first. A COI that looks complete can still fail the lender's review if any of the following are wrong:

  • Limits below contract minimums: Your subcontract specifies minimum insurance limits. The most common issue is an umbrella/excess policy that does not bring total coverage up to the required threshold.
  • Additional insured language too narrow: The COI says the owner is an additional insured but the policy endorsement limits coverage to completed operations only, or requires a written agreement to trigger additional insured status.
  • Wrong entity name: The additional insured is listed under a slightly different name than the owner entity. This matters more than you might think — lenders are specific about entity names.
  • Blanket vs. project-specific additional insured: A blanket additional insured endorsement covers all parties meeting the policy's definition. A project-specific additional insured endorsement lists your project by address. Some lenders require project-specific. Check your loan agreement.
  • Workers compensation exclusion: If the subcontractor's policy excludes a class of workers (e.g. owners or partners), those individuals are not covered. This is a gap that can matter if one of them is injured on site.
  • ACORD 25 vs. ACORD 28: ACORD 25 is the standard liability COI. ACORD 28 is for property coverage. Some lenders require specific ACORD form numbers. Know what your lender accepts.

COI Tracking for Large Projects with Many Subs#

On a project with 30 to 50 active subcontractors, tracking COIs manually is a full-time job. Policies expire on different dates throughout the year. New subs come on as the project progresses. A tracker that was accurate in October may have 5 expired policies by February.

The River construction draw workflow tracks COI expiration dates automatically and flags any active subcontractor with an expired or missing certificate before draw prep begins — so your team is chasing renewals 3 weeks before the draw instead of discovering expirations on submission day.

Written by

Chandler Supple

Co-Founder & CTO, River

Chandler spent years building machine learning systems before realizing the tools he wanted as a writer didn't exist. He founded River to close that gap. In his free time, Chandler loves to read American literature, including Steinbeck and Faulkner.

Ready to write better, faster?

Try River's AI-powered document editor for free.

Get Started Free →