How are you tracking vendor insurance (COI) expirations?

How are you tracking vendor insurance (COI) expirations?

Investor · Member since 2026 · 11 posts · 1 vote

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?

1Reply
1,004 views

Most Popular Reply

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 investments4.34 Reviews
See this reply in the discussion

13 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 investments4.34 Reviews
  • Investor · Member since 2026 · 11 posts · 1 vote
    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 · 200 posts · 87 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 · 1 vote
      1w

      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 · 1 vote
      1w

      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 · 296 posts · 80 votes
    1w

    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 · 25 posts · 7 votes
    1w

    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 · 1 vote
    6d

    @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 · 296 posts · 80 votes
    5d

    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

  • Investor · Member since 2026 · 92 posts · 19 votes
    18h

    Bigyan, one sheet does it for us: one row per vendor, trade, expiry, and whether we're listed as additional insured, with a 30-day and a 14-day nudge. The tool matters less than the rule behind it.

    Two things I'd add to what's here. First, check the COI before the work order goes out, not just before you pay. Holding payment after the work is already done uninsured is already too late. Second, check the name on the COI against the name on the invoice and the W-9. A vendor working under a different business name than the one on his policy is the gap that catches people.

    We do hold payment when a COI lapses, but only because it's in the vendor agreement up front, so it's the rule they signed, not a surprise.

  • Simon W.Business Member
    Real Estate Consultant · Lehigh Valley PA & New York City · Member since 2013 · 1k+ posts · 697 votes
    5h

    The piece I'd add is the bookkeeping side, because that's where the check can actually be enforced. Jeanette and Leef both got at tying payment to a current COI. In practice that means the invoice sits in accounts payable as an open bill until the certificate is current, and nobody cuts the check until it's cleared.

    Pair that with a W-9 on file before the first payment, and make sure the name on the COI, the invoice and the W-9 match the same legal entity. If a plumber is paid $2,400 across eight small jobs, you generally need his W-9 and a 1099 at year-end once he crosses the threshold, and chasing that in January is painful. I'd double check the current threshold with your CPA.

    It also helps to tag every vendor bill by property and vendor, so you can pull one vendor's whole year in a minute. If a claim happens, you can show what work they did and when, and whether they were covered then.

    Willsond's one-row-per-vendor sheet works well once the payment rule is behind it.

    Accounting Properties LLC
    View Page
    CFO LLC
    View Page
Join the conversationCreate a free account to reply, vote on answers and follow this thread.