COI Tracking for Small Property Managers

A practical afternoon setup for COI tracking at a small property management company: one person, about 40 vendors, and when to move off a spreadsheet.

A small property management company can set up COI tracking in an afternoon: list every vendor, write one requirements sheet, collect current certificates, record each policy's expiration date, and schedule renewal reminders. A spreadsheet works at first. Move to software when renewals start slipping or the vendor list passes what one person can review.

This guide is written for the manager who is the property manager, the bookkeeper and the compliance department at once, with roughly 40 vendors across a few hundred units. Large-company advice assumes a team and a budget you do not have. For the broader overview see COI tracking for property managers and the property manager hub. This article focuses on the setup itself.

Can You Really Set This Up in One Afternoon?

Yes, for about 40 vendors, if you separate the work you control from the work that depends on vendors. A realistic plan for about four hours:

Hour Task Output
1Build the vendor list from accounts payable, work orders and your inboxOne list with trade, properties served, and contact
2Write a one-page requirements sheet with two tiersStandard and high-risk limits
3Pull the certificates you already have and record each policyDates and limits per coverage line
4Send requests to every vendor with a missing or expired certificateA deadline and a response list

You will not finish with a clean list that afternoon, because vendors answer slowly. You will finish with a complete picture of who is covered, who is expired and who you have never checked. That alone is worth the four hours.

Step 1: How Do You Build the Vendor List?

Start with the people you have paid in the last 12 months, since those are the ones who were on your properties. Pull the list from your accounting system, then add anyone who appears in work orders but is paid by owners directly. Remove duplicates and one-off off-site suppliers. Tag each vendor with the properties they serve, because the same plumber on three buildings is one vendor with one certificate.

Step 2: What Goes on the Requirements Sheet?

Keep it to one page. List the two tiers, the endorsements you require (additional insured, waiver of subrogation), your exact entity names for the certificate holder box, and the email address where certificates should be sent. Use our COI requirements checklist as a starting point and read what to require by vendor type for common limits. Have your insurance agent or attorney look over the limits once.

Step 3: What Do You Record From Each Certificate?

  • Insured name and whether it matches the vendor you pay
  • Each coverage line: carrier, policy number, limits, expiration date
  • Additional insured and waiver of subrogation: yes or no
  • Certificate holder name
  • Date you reviewed it and who reviewed it

The date that matters most is the earliest expiration among a vendor's policies, because that is when their compliance quietly changes. General liability and workers' comp often renew on different dates, so track them separately. If you need help reading the form, see how to read an ACORD 25.

Step 4: How Do You Handle Renewals Without Chasing People?

Set a reminder rhythm and stick to it. A common pattern is a request 30 days before expiration, a nudge at 14 and a final warning at 7, with a rule about what happens if the date passes. That pattern is described in more detail in our expiration tracking system setup guide, and for the front end of the process see the vendor onboarding workflow. If a vendor goes silent, use the approach in what to do when a vendor won't send a certificate.

When Should You Switch From a Spreadsheet to Software?

A spreadsheet is a good first system. Our free tracking spreadsheet template is a fine place to begin. The signals that it is time to move:

  • You have found an expired vendor after the fact more than once.
  • Renewal reminders live in your head or in calendar entries you ignore.
  • You are re-keying data from PDFs for more than a handful of vendors.
  • Someone else, such as an owner or a second manager, needs to see compliance status.
  • You spend more time chasing certificates than reviewing them.

For many one-person teams, the tipping point lands somewhere between 20 and 40 vendors, but your own experience is the better guide. See spreadsheet vs software and the true cost of spreadsheet COI tracking for a fuller comparison.

What Does the Software Version of This Look Like?

In COI File the same afternoon looks like this: import your vendor list by CSV, configure your requirement rules, and send vendors a magic-link upload request. Vendors upload their certificate without creating an account. AI extracts the ACORD 25 fields, and each certificate is checked against your rules. Renewal emails go to vendors at 30, 14 and 7 days, and you can have the vendor's broker copied and escalate when a date passes. Vendors and projects can be tagged by property, and Pro adds PDF compliance audit logs if an owner or lender asks for proof. Extracted data is there for your review, so you stay the decision-maker. You can test it on your own list with the 7-day free trial. See pricing for plans.

Frequently Asked Questions

Yes, if the process is simple and the follow-up is automated or scheduled. With about 40 vendors, most of the work is a one-time setup: a vendor list, a standard requirements sheet, and expiration tracking. After that the recurring effort is chasing renewals and reviewing new certificates, which is manageable with a good routine.
There is no fixed number. Many one-person teams are comfortable with a spreadsheet at 15 to 25 vendors, and start to feel the strain somewhere past that, especially when renewal dates multiply across several coverage lines. The tipping point is less about the count and more about whether renewals are slipping.
Vendor name, trade, properties served, contact and agent details, each policy type with its carrier, limits and expiration date, additional insured and waiver of subrogation status, and the date you last verified the certificate. Our free template includes these columns.
For about 40 vendors, a focused afternoon is realistic if you already have most certificates in your email. The slower part is the vendors who respond late, so set a deadline and follow up rather than waiting on them before you call the setup done.
Most managers apply the requirement to anyone who sends people onto the property, including one-time jobs, and set a lighter process for non-hazardous vendors such as an off-site printer. Write the rule down and confirm it with your attorney.
You avoid the worst gap, which is working with a lapsed vendor, but you miss wrong limits, missing endorsements, and the wrong named insured. Tracking dates is the minimum. Reviewing each certificate against your requirements is what makes the record useful in a claim.
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 Base Trial →