Vendor list with insurance tracking
A vendor list for property management tracks each vendor's trade and contact along with the papers you need before they work: a W-9, a current certificate of insurance (COI), additional insured status and any license. This free template has those columns, six sample vendors and a CSV download.
Sample as of November 17, 2026. Sort by COI expiration each month and ask for new certificates before the old ones lapse.
| Vendor | Trade | Contact | W-9 on file | COI expiration | Additional insured | Workers' comp | License | License expiration | Status | |
|---|---|---|---|---|---|---|---|---|---|---|
| RapidFlow Plumbing | Plumbing | Dana Ortiz | office@rapidflow.example | Yes | 2027-04-30 | Yes | Yes, expires 2027-04-30 | Master plumber PL-20418 | 2027-06-30 | Active |
| Summit Roofing | Roofing | Mark Feld | jobs@summitroofing.example | Yes | 2026-12-10 | Yes | Yes, expires 2026-12-10 | Contractor HIC-55102 | 2027-03-31 | COI expires in 23 days; new certificate requested |
| Brightline Electric | Electrical | Sara Nunez | dispatch@brightline.example | Yes | 2027-08-15 | Yes | Yes, expires 2027-08-15 | Electrical contractor EC-31877 | 2028-01-31 | Active |
| Northside HVAC | HVAC | Kevin Park | service@northsidehvac.example | Yes | 2027-05-31 | Yes | Yes, expires 2027-05-31 | HVAC contractor HV-44210 | 2027-09-30 | Active |
| Greenway Landscaping | Landscaping and snow | Tom Becker | tom@greenway.example | Yes | 2026-10-31 | No | Exemption on file | Not required for this trade where the properties are | N/A | On hold: COI expired, no new jobs |
| Clearview Cleaning | Turnover cleaning | Ana Lopez | ana@clearviewclean.example | No | 2027-02-28 | Yes | Yes, expires 2027-02-28 | Not required for this trade where the properties are | N/A | W-9 requested; hold payment until received |
How to use it
- Add one row for every vendor you pay, including small and one-time vendors.
- Get a W-9 before the first payment, so you have the legal name and taxpayer ID for year-end 1099s.
- Get a certificate of insurance before the first job. Check the coverage types, limits, dates and the additional insured wording against your requirements.
- Record license numbers and expiration dates for licensed trades, and check them with the licensing board where you can.
- Set the status: Active, On hold or Do not use. Put the reason in the status so the team knows why.
- Each month, sort by COI expiration and license expiration and request anything due in the next 30 days.
- Your contracts and your insurance advisor set the coverage requirements. Rules vary by state; this is not legal or tax advice.
What should a property management vendor list include?
Vendor name, trade, contact, W-9 status, certificate of insurance expiration, additional insured status, workers' compensation, license and license expiration, and a status.
Why track COI expiration dates?
Certificates expire when the policies do. A vendor whose insurance lapsed can leave the owner and the manager exposed if something goes wrong on a job.
What is additional insured status?
It means the vendor's policy also covers the named party, such as the owner or the management company, for claims arising from the vendor's work. Your contract sets whether you require it.
When should I collect a W-9 from a vendor?
Before you pay them for the first time. It gives you what you need to file 1099s at year-end; ask your tax advisor which vendors need one.
Does Zrico track vendor insurance?
Yes. Zrico vendor compliance tracks insurance and license papers, a workflow can remind vendors 30 days before they expire, and vendors can upload new papers in the vendor portal.
See Zrico run your portfolio.
Bring a property. We will show you, on your own data, what Zrico would have handled last month.