Free COI Tracking Spreadsheet Template for Small Property Managers

---

title: "Free COI Tracking Spreadsheet Template for Small Property Managers" description: "A free spreadsheet template for tracking vendor certificates of insurance, plus the fields, formulas, and workflow every small property manager needs." date: "2026-04-18" author: "COI Tracker Team" tags:

• "certificate of insurance"
• "COI tracking"
• "vendor insurance tracking"
• "property manager"

---

If you manage a small portfolio of properties, the odds are good that your vendor certificate of insurance tracking lives in a spreadsheet somewhere on your computer. Maybe it is a tab in your master vendor list. Maybe it is a file your predecessor left behind. Maybe it is the back of an envelope, and you are hoping no one asks.

You are not doing it wrong. For a handful of vendors and a handful of properties, a spreadsheet is the right tool. What trips people up is not the spreadsheet — it is the fact that most of the templates floating around online were built for a different problem. They treat a certificate of insurance like a contact record, when it really behaves more like an expiration date wrapped in legal exposure.

This guide walks through what a COI tracking spreadsheet actually needs, gives you a free template you can copy, and is honest about the point where spreadsheets stop being the answer.

Why expired COIs are expensive

Before we get into fields and formulas, it is worth being blunt about what you are protecting against. A vendor certificate of insurance is not paperwork for the sake of paperwork. It is the evidence that, if your plumber floods a unit or your landscaper injures a resident, their insurer — not yours — pays for it.

When a COI lapses and you do not catch it, three things can happen, in rough order of how quickly they hurt:

First, a claim lands on your policy instead of theirs. Your general liability premium goes up at renewal, and your broker starts asking questions you do not want to answer.

Second, you fail an audit. Lenders, owners, and insurance carriers increasingly run spot audits on vendor compliance. Expired COIs are the single easiest finding for an auditor to write up, because the dates are right there on the certificate.

Third — and this is the one that eats your Tuesday — you have to stop work, call the vendor, wait for their broker to re-issue the certificate, and re-onboard a vendor who was already approved last quarter. Multiply that by turnover at the vendor's end and you can easily lose a day a month to re-approvals that should never have been necessary.

A good COI tracking workflow is not about being a stickler. It is about not letting a $0 oversight turn into a five-figure problem.

What a good COI tracking spreadsheet needs

Most templates you will find online track the vendor. What you actually need to track is the certificate. One vendor can have three active certificates (general liability, workers' comp, auto) with three different expiry dates and three different insurers. If your sheet has one row per vendor, you are already in trouble.

Here are the fields that belong on every COI tracking spreadsheet, in the order they should appear:

• Vendor name — the legal name on the certificate, not the DBA you use in conversation. These often differ.
• Insurer — the carrier issuing the policy (e.g., Travelers, The Hartford). Useful for spotting carriers you have had bad luck with.
• Policy number — exactly as it appears on the certificate. This is the reference your own broker will ask for first.
• Coverage type — General Liability, Workers' Compensation, Auto, Umbrella, Professional Liability. One row per coverage type, not one row per vendor.
• Coverage limits — per-occurrence and aggregate, split into separate columns. "$1M/$2M" in a single cell is unsortable.
• Effective date — when the policy began.
• Expiry date — when it ends. This is the column you will stare at the most.
• Insured party / additional insured — whether your entity is named as an additional insured, and under what wording. A certificate naming the wrong entity is functionally worthless.
• Waiver of subrogation — yes/no. If it is not waived, the vendor's insurer can turn around and sue you after paying a claim.
• Contact email — the vendor's COI person, not the sales rep. Usually their office manager or their broker.
• Last verified date — the date you actually looked at the certificate, not the date the vendor told you it was fine.
• Document link — where the PDF lives. A link to your shared drive is fine. A filename that only exists on your laptop is not.
• Status — a short, automatic label: Current, Expiring Soon (within 30 days), Expired, Missing.

The template, visually

Here is what the spreadsheet looks like with one vendor populated. The real template has header formatting, a status formula, and conditional coloring for the expiry column; those do not render in a blog post, but the structure is identical.

Three rows, one vendor, three very different stories. That is the shape vendor insurance tracking needs to support.

Grab the template

Download the free COI tracking spreadsheet template (.xlsx)

Opens in Excel or Numbers. To use it in Google Sheets, go to File → Import → Upload and pick the downloaded file. It includes all fourteen fields above, a Status column driven by a TODAY() formula, and conditional formatting that turns rows amber 30 days before expiry and red on the day they lapse.

A few ground rules if you want the sheet to keep working six months from now:

One certificate per row. If a vendor carries three coverages, that is three rows. Sorting by expiry date is the single most useful thing you will do with this file, and it only works if each expiry lives on its own row.

Keep the PDF links alive. Use a shared drive, not your desktop. The single most common failure mode is a working spreadsheet that points to PDFs no one can open.

Update the last verified column when you actually look at the certificate, not when you email the vendor. "I asked them" is not verification.

When spreadsheets stop working

A spreadsheet is a great tool for certificate of insurance tracking right up until it isn't. Here is where the wheels tend to come off, in the order most property managers hit them:

Around ten to fifteen active vendors. This is where the weekly glance at the sheet stops being enough. You start missing the 30-day warning because you forgot to open the file that week. At this point you need reminders, not just a status column.

When more than one person edits the sheet. The moment a second admin starts updating rows, you will get a race condition — two people editing the same cell, one person's change quietly overwriting another's, nobody sure which version is current. Google Sheets mitigates this but does not solve it. You still cannot tell who last touched a given row without digging through version history.

The first time you are audited. Auditors ask for two things: proof of the current certificate, and proof that you noticed when the previous one expired. A spreadsheet can answer the first question. It cannot answer the second, because it does not keep history. As soon as you overwrite a row with new policy information, the audit trail is gone.

When an admin leaves. Every property manager has inherited a spreadsheet and discovered that half the vendors listed no longer exist, the formulas were hand-typed into cells instead of a column, and the "status" column was last updated nine months ago. If your vendor insurance tracking is one person's tribal knowledge, it will not survive their resignation.

If you are hitting any two of these, the spreadsheet has already cost you more time than the tool that replaces it would.

When you outgrow the sheet

This is the part where we have to mention what we do, so we will keep it short.

COI Tracker is built for the exact moment the spreadsheet stops scaling. It watches expiry dates, emails vendors before a certificate lapses, keeps a dated history of every certificate on file, and produces a one-click audit report when a lender asks. The free tier covers up to 5 vendors, which is enough to try it against a portion of your portfolio without moving everything at once.

If you are under ten vendors, stay on the spreadsheet. It genuinely is the right tool. If you are past that, or if you have been burned by an expired COI in the last twelve months, copy the template, use it for a month, and then come back.

Either way — start with the template. A structured spreadsheet beats an unstructured one every day of the week, and an unstructured one beats nothing by a mile.