How are you tracking vendor insurance (COI) expirations?

How are you tracking vendor insurance (COI) expirations?

Investor · Member since 2026 · 11 posts · 0 votes

Question for anyone managing more than a handful of doors. How do you keep track of when your vendors' certificates of insurance expire?

I talk to a lot of property managers about their paperwork, and this one comes up more than I expected. The COI comes in as an email attachment when you first onboard the vendor, gets saved somewhere, and nobody looks at it again. Then there's a claim and you find out the plumber's coverage lapsed two months ago.

What I've seen people do:

1. A spreadsheet with vendor, policy and expiry date. Works great for about a month, then nobody updates it.

2. Calendar reminders set when the COI arrives. Better, but it depends on one person remembering to set them, and it breaks when that person leaves.

3. Making it the vendor's problem. No current COI on file, no work order and no payment. The firms that do this seem to have the fewest gaps, because the vendor chases it instead of you.

4. Automating it. Have the COIs filed and the expiry dates pulled out of the PDFs so you can just ask which ones expire in the next 60 days. Full disclosure, this is what I work on, so I'm biased. But even with a tool, #3 is still the policy that does the heavy lifting.

Curious what's actually working for people here. Does your PM software handle this well, or is it still a spreadsheet? And do you hold payments when a COI lapses?

0Reply
815 views

11 Replies

Jump to latestLatest
  • Chris SeveneyBusiness Member
    Moderator
    Investor · VA · Member since 2015 · 21k+ posts · 19k+ votes
    1w

    Pm software we use handles it and for construction arm software also handles it:

    For smaller people put it on a spreadsheet and have Claude create a script for your spreadsheet to send you an email or them an email 30 days before it expires

    7e investments53 Reviews
  • Investor · Member since 2026 · 11 posts · 0 votes
    1w

    @Chris Seveney the 30-day email is a smart touch, especially sending it to the vendor too. That puts the chasing on them instead of you.

    Which PM software are you using that handles it? I hear a lot of people say theirs technically has a COI field but nobody fills it in, so curious which ones actually make it stick.

  • Member since 2023 · 188 posts · 73 votes
    1w

    We keep it simple, and the rule does the work: no current COI on file, no work order and no payment. We collect the COI when a vendor is onboarded, before their first small paid job — a faucet swap or a lock change — and we log the expiry date in one vendor sheet with the trade, the areas they cover, and their rate. The sheet gets a 30-day and a 14-day reminder, and when it lapses the vendor chases the renewal, not us, because they cannot get the next job without it. At 236 doors that is the only version that holds up; a spreadsheet nobody updates is the same as no system. The policy matters more than the tool. Do you hold payment when a COI lapses, or just stop sending work?

    • Member since 2026 · 2 posts · 1 vote
      1w

      Rosina, I'd do both, but only if it's written down before the job starts. Put it in the vendor agreement or the work order that payment goes out once a current COI is on file. Then holding a check isn't a fight, it's just the rule they already signed.

      At my day job at a car dealership I chase bankers for their renewed licenses, and it works the same way. When the paperwork is tied to getting paid, it shows up fast. When it's just a reminder, it sits.

    • Investor · Member since 2026 · 11 posts · 0 votes
      6d

      236 doors and it holds up, that's the real proof. Collecting the COI before the first small job is a great detail, way easier than chasing it after a big one. Most people I talk to stop sending work rather than hold payment, but putting it in writing upfront like Jeanette said seems to make holding payment a non-issue.

    • Investor · Member since 2026 · 11 posts · 0 votes
      6d

      Tying it to getting paid is the whole trick. Funny that it works the same way for banker licenses.

  • Technology · Vancouver, BC · Member since 2026 · 274 posts · 75 votes
    6d

    Hi @Bigyan Karki,

    I'd put #3 and #4 together. Policy without a system breaks the moment someone gets busy, and a system without policy only tells you about the gap after the fact.

    The version I like best: the COI request goes out as part of vendor onboarding, the expiry date gets pulled from the PDF into one shared list, and the vendor gets an automatic note 30 days before it lapses. No current COI, no new work order.

    That way the only human step is approving the vendor in the first place, and nobody on the team has to remember a date.

    Cheers,
    Lee

  • Monroe, Orange County · Member since 2026 · 20 posts · 5 votes
    5d

    A simple sheet works fine for this: vendor, policy type, carrier, expiration date, and whether you're listed as additional insured. Sort by expiration and set a reminder 30 days out.

    The part that actually protects you is checking at payment time, not just at hiring. Before paying any invoice, look at that vendor's row. If the COI is expired, payment waits until a current one comes in. Put that in your vendor agreement so nobody's surprised.

    Two things people miss: being named as additional insured (not just certificate holder), and workers' comp proof, or a signed exemption from sole proprietors.

  • Investor · Member since 2026 · 11 posts · 0 votes
    3d

    @Lee Futcher agreed, it's the combination that works. Policy alone breaks when people get busy. Pulling the expiry date from the PDF into one shared list is exactly the piece I'm working on, so good to hear that's where you'd put it.

    @Ezra Bennett checking at payment time is a great addition, and additional insured vs. certificate holder is a detail nobody else in this thread mentioned. Same for workers' comp proof from sole proprietors. Thanks both.

  • Technology · Vancouver, BC · Member since 2026 · 274 posts · 75 votes
    3d

    Hey @Bigyan Karki,

    Thank you for coming back to tie the thread together. I think you and Ezra landed on the most useful version of this. Checking the certificate when an invoice gets paid, and not only when the vendor is first hired, means someone actually looks at it every month instead of it sitting in a folder.

    It also makes the piece you're working on more valuable, because that payment check is only as good as the details behind it. Being able to see the expiry date, the additional insured status and the workers' comp proof for every vendor in one place is what lets someone on the team pay an invoice with confidence.

    Appreciate you pulling the best ideas together,
    Lee

Join the conversationCreate a free account to reply, vote on answers and follow this thread.