· Updated May 26, 2026

COI Tracking: The Complete Guide for Property Managers & Contractors

Stop chasing expired certificates. Learn how to track, verify, and manage vendor insurance compliance - the simple way.

Managing certificates of insurance shouldn't take 10 hours a week. Yet for most property managers and contractors, that's exactly what happens - spreadsheets, email chains, and missed expirations that create real liability risk.

COI tracking is the process of collecting, verifying, monitoring, and renewing vendor certificates of insurance so you always know who's compliant and who's not. This guide covers everything you need to know about how COI tracking works, why it matters, and how to do it efficiently.

What is COI Tracking?

A certificate of insurance (COI) is a document that proves a vendor or subcontractor has active insurance coverage. It summarizes the policy types (general liability, workers' comp, auto, umbrella), coverage limits, effective dates, expiration dates, and additional insured endorsements.

COI tracking means keeping a record of every vendor's certificate of insurance and monitoring those certificates for:

  • Expiration dates - knowing when coverage is about to lapse
  • Coverage limits - verifying the vendor carries the required minimums
  • Additional insured status - confirming your organization is listed as additional insured
  • Policy types - ensuring the vendor carries the right types of insurance (GL, WC, auto, etc.)
  • Endorsements - checking for waivers of subrogation, primary/non-contributory clauses, and other requirements

Without a system, COI tracking means opening PDFs, reading ACORD 25 forms line by line, typing data into a spreadsheet, setting calendar reminders, and chasing vendors by email. It's tedious, error-prone, and easy to let things slip through the cracks.

Why COI Tracking Matters

The consequences of poor COI tracking are not theoretical. They're expensive:

  • Uncovered claims. If a vendor's insurance lapses and an incident occurs on your property, the property owner - and potentially you - are liable. Claims can range from thousands to hundreds of thousands of dollars.
  • Contract violations. Most property management agreements and construction contracts require proof of insurance. Failure to maintain compliant COIs can put you in breach of contract.
  • Insurance premium increases. Claims filed against your policy because a vendor was uninsured can drive up your own premiums.
  • Audit failures. Property owners, corporate offices, and regulators may require proof that all vendors are insured. Incomplete records lead to audit failures.
  • Time waste. The average property manager spends 8-10 hours per week on COI-related tasks: collecting, verifying, following up, and updating spreadsheets.

In my six years managing vendor compliance for commercial properties in Chicago, I tracked over 2,000 COIs across 150+ properties. Three vendors let their general liability lapse in the same month - and I didn't find out until an incident was already on my desk. One of those gaps cost the property $47,000 in uncovered damages. That's why I built COI File.

Who Needs COI Tracking?

Anyone who requires vendors or subcontractors to carry insurance needs a COI tracking system. The most common users:

Property Managers

Property managers are responsible for ensuring every vendor working on their properties - HVAC contractors, plumbers, electricians, landscapers, janitorial services - carries active insurance. With 20 to 200+ vendors across multiple properties, manual tracking is unsustainable.

Key challenges: tracking across multiple properties, differing requirements per property, quarterly audit requirements, and chasing vendors for updated certificates.

General Contractors

General contractors must verify that every subcontractor on a job site has compliant insurance before work begins. Projects can have 10-50+ subs, each with different coverage requirements.

Key challenges: per-project compliance tracking, trade-specific requirements, project owner reporting, and subs who let insurance lapse mid-project.

Facilities Managers

Facilities managers oversee vendor compliance across building portfolios - offices, retail centers, industrial parks, and mixed-use properties. The volume of vendors multiplied by the number of buildings creates a tracking nightmare without software.

Key challenges: portfolio-wide visibility, per-building vendor lists, quarterly compliance audits, and no centralized system.

Commercial Real Estate

CRE managers track both tenant and vendor COIs. Lease agreements mandate specific coverage limits and additional insured status, and tenant insurance lapses create liability gaps for property owners.

COI Tracking Methods

1. Spreadsheets (Excel, Google Sheets)

The most common starting point. You create a spreadsheet with columns for vendor name, policy types, coverage limits, effective dates, and expiration dates. You update it manually whenever a certificate comes in.

Problems with spreadsheets:

  • No automatic alerts - you manually check for upcoming expirations
  • Manual data entry - 15-30 minutes per certificate
  • Version control - shared spreadsheets get overwritten or duplicated
  • No compliance checking - you must manually verify coverage limits and additional insured status
  • Easy to miss things - one forgotten row update can mean an expired policy goes unnoticed

If you're currently tracking COIs in a spreadsheet, you're not alone - it's where most people start. But if you're managing more than 10 vendors, the spreadsheet approach will eventually fail you. Read our comparison of spreadsheets vs. COI tracking software - coming soon.

2. COI Tracking Software

Dedicated COI tracking software automates the entire process:

  • AI extraction: Upload any COI and the software reads coverage limits, dates, and additional insured status automatically - in under 30 seconds
  • Expiration alerts: Automatic email notifications at 30, 14, and 7 days before a certificate expires
  • Compliance dashboard: See which vendors are compliant (green), expiring soon (yellow), or expired (red)
  • Vendor portal: Vendors upload their own certificates, eliminating the need to chase them by email
  • Compliance reports: One-click reports for property owners, auditors, and project managers

The time savings are significant: what takes 15-30 minutes per COI manually takes under 2 minutes with software.

How to Choose COI Tracking Software

When evaluating COI tracking tools, look for these features:

  1. AI-powered extraction. You should be able to upload any COI format (PDF, image, ACORD 25) and have the system automatically extract the key data fields. Manual data entry defeats the purpose.
  2. Automatic expiration alerts. The whole point is not having to check dates manually. Make sure alerts go to both you and the vendor.
  3. Compliance dashboard. You need at-a-glance visibility into which vendors are compliant and which are not. Color-coded status (green/yellow/red) is ideal.
  4. Vendor upload portal. This lets vendors submit their own certificates, eliminating the email chase. Make sure it's easy for them to use.
  5. Transparent pricing. Beware of "contact us for pricing" - that usually means enterprise pricing starting at $500+/month. You should be able to see pricing and start without a sales call.
  6. Self-service signup. If you can't sign up and start tracking immediately, the product isn't built for small teams.
  7. CSV import/export. You should be able to bring your existing data in and get it back out.

COI Tracking Best Practices

  1. Set clear insurance requirements. Define the minimum coverage limits, additional insured requirements, and endorsements you need from each vendor type before you start tracking.
  2. Collect certificates before work begins. Never let a vendor start work without a compliant COI on file. This is your first line of defense.
  3. Set alerts at 30, 14, and 7 days. Give yourself enough lead time to request an updated certificate before the current one expires.
  4. Verify every certificate. Don't just file it - check the coverage limits, additional insured status, effective dates, and cancellation clause. Many certificates contain errors that would make them non-compliant.
  5. Require vendors to name you as additional insured. This is critical. If a vendor's policy doesn't list you as additional insured, you may not be covered under their policy.
  6. Track per-project and per-property. If you manage multiple properties or projects, organize your COIs accordingly. A vendor may be compliant on one project but not another.
  7. Archive expired certificates. Keep old certificates on file. You may need them for insurance claims or audits even after they expire.
  8. Use COI tracking software instead of spreadsheets. The moment you're managing more than 10 vendors, the manual approach takes more time than it saves.
app.coifile.com
COI File expiration alert email showing 3 certificates needing attention: one expired, one expiring in 9 days, one in 20 days, plus a push notification
Automatic email and push alerts at 30, 14, and 7 days before expiration - plus instant alerts for expired certificates.

Common COI Tracking Mistakes

  • Only checking at renewal time. Vendor insurance can lapse mid-term (cancellation, non-payment). Check compliance continuously, not just at annual renewal.
  • Not verifying additional insured status. A COI that doesn't list you as additional insured provides no protection under the vendor's policy.
  • Ignoring the cancellation clause. Most ACORD 25 forms state "should be canceled, a notice will be sent." Should is not will. Follow up proactively.
  • Accepting expired certificates. It happens more than you'd think. Always check effective and expiration dates before filing.
  • Not tracking by trade. Different trades have different insurance requirements. An electrician needs different limits than a landscaper. Use requirement templates.
  • Relying on vendors to notify you. Vendors rarely proactively send updated certificates. Set up alerts and follow up automatically.

How COI File Simplifies COI Tracking

COI File is built for property managers and contractors who are tired of spreadsheets. Here's how it works:

  1. Upload any certificate. Drag and drop a PDF, image, or ACORD 25 form. Our AI extracts the key data in under 30 seconds.
  2. See compliance at a glance. Your dashboard shows every vendor's status: green (compliant), yellow (expiring soon), red (expired or non-compliant).
  3. Get alerts before expiration. Automatic email alerts at 30, 14, and 7 days. Both you and your vendor get notified.
  4. Generate reports in one click. Compliance reports for property owners, auditors, and project managers - ready when you need them.

COI File is free for up to 5 vendors. No credit card required. Start free today.

Frequently Asked Questions

COI tracking is the process of collecting, verifying, and monitoring vendor certificates of insurance to ensure every vendor or subcontractor working on your property or project maintains active, compliant insurance coverage at all times.
COI tracking software lets you upload a certificate of insurance (usually an ACORD 25 form), automatically extracts key data like policy types, coverage limits, effective dates, and expiration dates using AI, then monitors those dates and sends alerts before coverage lapses.
Yes. COI File is free for up to 5 vendors with no time limit and no credit card required. Paid plans start at $29/month for growing teams.
A spreadsheet requires you to manually enter every certificate, check expiration dates by hand, and follow up with vendors via email. COI tracking software automates data extraction, sends expiration alerts, and shows compliance status at a glance - reducing the time per COI from 15-30 minutes to under 2 minutes.
Anyone who requires vendors or subcontractors to carry insurance: property managers, general contractors, facilities managers, commercial real estate managers, and anyone responsible for vendor compliance.
Without COI tracking, you may not find out until an incident occurs. With COI tracking software like COI File, you receive automatic email alerts at 30, 14, and 7 days before expiration so you can request an updated certificate before coverage lapses.

Sources & Further Reading

  • IRMI — Contractual Risk Transfer — Comprehensive resources on how certificates of insurance fit into contractual risk transfer strategy. irmi.com
  • ACORD Forms & Automation — The official source for ACORD 25 forms, XML standards, and insurance data automation. acord.org
  • NAIC Certificate of Insurance Model Act — Model legislation adopted by many states governing the use and regulation of certificates of insurance. content.naic.org
  • OSHA — Workplace Safety — Regulations that impact workers' compensation and liability insurance requirements for contractors and vendors. osha.gov
  • American Institute of Architects (AIA) — Contract documents that frequently reference COI requirements for construction and design professionals. aiacontracts.org
F

Firdaosh Bano

COI Compliance Specialist

Firdaosh Bano is a COI compliance specialist and the founder of COI File. She spent 6 years managing vendor compliance for commercial properties - tracking 2,000+ COIs across 150+ properties in spreadsheets before building the tool she wished she'd had. She writes about certificate of insurance compliance, vendor risk management, and making insurance tracking less painful for small teams.

Ready to simplify your COI tracking?

Join property managers and contractors who are ditching spreadsheets for good.

Start Free →