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 |
|---|---|---|
| 1 | Build the vendor list from accounts payable, work orders and your inbox | One list with trade, properties served, and contact |
| 2 | Write a one-page requirements sheet with two tiers | Standard and high-risk limits |
| 3 | Pull the certificates you already have and record each policy | Dates and limits per coverage line |
| 4 | Send requests to every vendor with a missing or expired certificate | A 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
Related Resources
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.