Certificate of Insurance Tracking Log: Free Template for Vendors and Subcontractors
Quick Answer
A certificate of insurance tracking log records each vendor's or subcontractor's insurance certificate: the company, the types of coverage, policy numbers, insurers, limits, effective and expiration dates, whether your business is listed as required and when the certificate was received and reviewed. Collect a COI before work starts, check it against your requirements, set reminders before expiration, request updated certificates on renewal and pause work for vendors whose required coverage has lapsed. Ask your insurance agent what coverage to require.
A subcontractor's worker is injured on your job site, and you discover their workers' compensation policy expired two months ago. Or a cleaning company damages a client's property, and their liability coverage is lower than you thought. Tracking certificates of insurance is one of those boring tasks that matters a lot when something goes wrong.
This guide includes a free certificate of insurance (COI) tracking log and explains what to record, what to check on each certificate, how to stay ahead of expirations and how to collect COIs from vendors and subcontractors.
Note: This is general information, not insurance or legal advice. Ask your insurance agent which coverage types and limits to require, and have an attorney review your contracts.
What Is a Certificate of Insurance?
A certificate of insurance is a document, usually issued by the vendor's insurance agent, that summarizes their insurance coverage: the insurers, policy numbers, coverage types, limits and policy dates. It's a snapshot of coverage on the date issued. It doesn't change the policy itself, so it's important to confirm the details and keep certificates current.
Who Should You Collect COIs From?
| Vendor type | Why |
|---|---|
| Subcontractors | They work on your jobs and customers' property |
| Cleaning and janitorial companies | On site, often after hours |
| Landscapers and snow removal | Equipment and property risk |
| Electricians, plumbers and HVAC | Licensed trades with higher risk |
| Movers and delivery companies | Handling property |
| Event and catering vendors | On site at your events |
| Tenants (for property owners) | Lease requirements |
Vendors who never come on site, such as software or office supply companies, usually don't need a COI. Ask your agent where to draw the line.
Free Certificate of Insurance Tracking Log
| Vendor | Contact | Coverage type | Insurer | Policy # | Limits | Effective | Expires | Required wording met | Received | Reviewed by | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| General liability | ☐ | ☐ Active ☐ Expiring ☐ Expired | |||||||||
| Workers' comp | ☐ | ☐ Active ☐ Expiring ☐ Expired | |||||||||
| Commercial auto | ☐ | ☐ Active ☐ Expiring ☐ Expired | |||||||||
| Umbrella / excess | ☐ | ☐ Active ☐ Expiring ☐ Expired |
Use one row per policy, since each coverage type can have a different expiration date.
What to Check on Each Certificate
| Item | What to look for |
|---|---|
| Named insured | The vendor's legal business name matches your contract |
| Coverage types | All coverage you require is listed |
| Limits | Meet or exceed your requirements |
| Policy dates | Current, and covering the time the work will happen |
| Certificate holder | Your business name and address |
| Additional insured | Your business listed, if your contract requires it |
| Description of operations | Matches the work or job, if required |
| Producer (agent) contact | So you can verify coverage if needed |
If something doesn't match your requirements, ask the vendor to have their agent issue a corrected certificate before work starts.
Common Coverage Types
| Coverage | What it generally covers |
|---|---|
| General liability | Injuries to others and property damage caused by the vendor's work |
| Workers' compensation | Injuries to the vendor's own employees |
| Commercial auto | Vehicles used for the business |
| Umbrella or excess | Extra limits above other policies |
| Professional liability | Errors in professional services |
Your insurance agent can explain what each coverage means for your business and recommend required limits for each type of vendor.
Setting Your Insurance Requirements
- Talk to your insurance agent about risks for each vendor type.
- Set required coverage types and minimum limits.
- Decide whether you need to be named as additional insured.
- Put the requirements in your contracts and vendor setup forms.
- Share requirements with vendors before they bid.
| Vendor type | Coverage required | Minimum limits | Additional insured |
|---|---|---|---|
| Subcontractors | GL, WC, auto | [Per agent] | Yes |
| Cleaning vendors | GL, WC | [Per agent] | Yes |
| Delivery vendors | GL, auto | [Per agent] | [Per agent] |
Fill in limits based on your agent's advice and any requirements from your own customers or contracts.
Collecting COIs From Vendors
- Include insurance requirements in your new vendor setup form. See the vendor list template.
- Request a certificate from the vendor's insurance agent, with your business as certificate holder.
- Review it against your requirements.
- Record it in the tracking log.
- Approve the vendor to start work only after the COI is approved.
Sample request: "Before you start work, please have your insurance agent send a certificate of insurance to [email], listing [Business legal name and address] as certificate holder [and additional insured]. We require [coverage types and limits]. Thank you!"
Tracking Expirations
Most certificate problems come from expired coverage that nobody noticed. Stay ahead of renewals:
- Sort the log by expiration date.
- Set reminders 30 days before each expiration.
- Request updated certificates before the old ones expire.
- Mark vendors with expired coverage clearly.
- Review the log every week or month, depending on how many vendors you use.
Renewal reminder: "Hi [Name], our records show your [coverage] policy expires on [date]. Please have your agent send an updated certificate of insurance to [email] before then so we can keep scheduling work. Thanks!"
When Coverage Lapses
- Contact the vendor right away.
- Pause new work until an updated certificate is received, if your contract allows.
- Record the lapse and the date coverage was restored.
- Ask your insurance agent about any work done during the lapse.
- Review whether the vendor should stay on your approved list.
Missing or expired insurance is a common item on vendor scorecards. See what is a vendor scorecard.
Certificates for Your Own Business
Your customers may ask for your certificate of insurance too, especially commercial clients and general contractors. Keep a current copy of your own COI ready, know your agent's process for issuing certificates with additional insured wording and track your customers' requirements. Commercial clients often ask for it during setup, so add it to your client onboarding. See the client intake form.
COIs and Construction Projects
General contractors usually need current certificates from every subcontractor before they start work on a job. Add a COI check to your preconstruction steps, and confirm coverage again for long projects that cross policy renewal dates. See the construction project checklist.
Example: A General Contractor
A general contractor kept subcontractor certificates in an email folder and checked them only when a client asked. During an audit, his insurer found two subs with expired workers' comp coverage on past jobs. He started a COI tracking log sorted by expiration date, set 30-day reminders and made a current certificate a requirement before scheduling any sub. Expired certificates stopped slipping through, and audits became much simpler.
Common COI Tracking Mistakes
- Collecting a certificate once and never checking expiration.
- Not reviewing limits and coverage types.
- Name mismatches between the COI and the contract.
- Missing additional insured wording when the contract requires it.
- Letting work start before the COI is approved.
- Certificates scattered across inboxes.
COI Tracking Checklist
| Step | Done? |
|---|---|
| Set insurance requirements with your agent | |
| Add requirements to contracts and vendor setup | |
| Collect COIs before work starts | |
| Check names, coverage, limits and dates | |
| Record every policy in the log | |
| Set reminders 30 days before expiration | |
| Pause work when coverage lapses |
Sample Completed Log
| Vendor | Coverage | Expires | Status | Next step |
|---|---|---|---|---|
| ABC Electric | General liability | 03/15 | Active | Reminder set for 02/13 |
| ABC Electric | Workers' comp | 01/10 | Expiring | Renewal requested |
| Green Lawn Co. | General liability | 11/30 | Active | None |
| Green Lawn Co. | Commercial auto | 10/01 | Expired | Work paused; updated COI requested |
This sample uses made-up vendors. Notice that one vendor can be partly current and partly expired, which is why each policy gets its own row.
Spreadsheet Tips for COI Tracking
- Add a "days until expiration" column with a formula such as =Expires-TODAY().
- Use conditional formatting to turn rows yellow at 30 days and red when expired.
- Filter by vendor to see all policies for one company.
- Link to the PDF certificate in a shared folder.
- Keep a separate tab with your requirements by vendor type.
Storing Certificates
Save each certificate as a PDF in a folder named by vendor, with the expiration date in the file name, such as "ABC Electric GL exp 2027-03-15.pdf." Keep old certificates too; they show coverage was in place during past jobs, which can matter if a claim comes up later.
Who Owns COI Tracking?
Assign one person, such as an office manager, project coordinator or bookkeeper, to collect, review and track certificates. They should know your requirements, have authority to hold a vendor until the COI is approved and review the log on a set schedule. A single owner keeps certificates from falling through the cracks between project managers.
COI Review Checklist
| Check | OK |
|---|---|
| Vendor legal name matches contract | ☐ |
| All required coverage types listed | ☐ |
| Limits meet requirements | ☐ |
| Policies current for the work period | ☐ |
| Certificate holder is correct | ☐ |
| Additional insured wording, if required | ☐ |
| Agent contact information included | ☐ |
Questions to Ask Your Insurance Agent
- Which vendors should we require certificates from?
- What coverage types and limits should we require for each?
- Should we be listed as additional insured, and when?
- What should we do if a vendor's coverage lapses during a job?
- Do our own customers' contracts require anything from our subcontractors?
COIs and Vendor Payments
Some businesses won't release payment until a vendor's certificate is current. If you take this approach, put it in your vendor agreement, tell vendors in advance and apply it consistently. It's an effective way to make sure certificates get renewed on time.
Getting Started This Week
- List every vendor who works on site or on your jobs.
- Set requirements with your insurance agent.
- Request current certificates from each vendor.
- Build the tracking log and set expiration reminders.
- Make COI approval part of your vendor setup.
COI Requirements in Your Vendor Agreement
Put your insurance requirements in writing in every vendor or subcontractor agreement. Common provisions include:
- Required coverage types and minimum limits.
- Whether your business must be named as additional insured.
- That certificates must be provided before work starts.
- That the vendor must provide updated certificates on renewal.
- What happens if coverage lapses, such as pausing work or payment.
Have an attorney review the language, and ask your insurance agent to confirm the requirements fit your risks.
COIs for Recurring Vendors
Vendors you use every week, like cleaners, landscapers and maintenance companies, are easy to forget because they're always around. Their policies renew every year just like anyone else's. Put recurring vendors on the same expiration reminders, and check certificates at least once a year even if nothing seems to have changed.
When Your Customers Require COIs From Your Subs
Commercial clients and general contractors sometimes require that your subcontractors carry specific coverage or name them as additional insured too. Read those requirements in your customer contracts and pass them down to your subs in writing, so everyone on the job meets the same standard.
COI Tracking Quick Tips
- Collect before work starts.
- One row per policy.
- Remind 30 days before expiration.
- Check names, limits and wording.
- Pause work for lapses.
A Simple Habit That Protects Your Business
Tracking certificates takes a few minutes a week once the log is set up. Compared with the cost of an uninsured claim, it's one of the most valuable routines a small business can keep. Start with your highest-risk vendors and add the rest over time.
Common Questions About COIs
- Can a vendor send the certificate themselves? Many businesses prefer certificates sent directly from the vendor's insurance agent.
- Is a COI proof of coverage? It summarizes coverage on the date issued. If you have doubts, contact the agent listed on the certificate.
- Do sole proprietors need workers' comp? Rules vary by state; ask your agent how to handle vendors without employees.
- How long should I keep certificates? Ask your agent or attorney; many businesses keep them for several years after the work.
Tracking COIs Across Many Vendors
Once you have more than a handful of vendors, sort the log by expiration date and review it at the start of each month. Send renewal requests in one batch, and keep a short list of vendors who are currently on hold. A monthly routine is much easier than chasing certificates one at a time when a job is about to start.
Getting Your Team on Board
Project managers and office staff often schedule vendors directly. Make sure everyone who books vendors knows the rule: no current COI, no work. Give them access to the tracking log or a simple status list, so they can check before scheduling. When the rule is clear and easy to follow, certificates get collected without last-minute scrambles.
Annual COI Review
Once a year, review the whole log: remove vendors you no longer use, confirm requirements still fit your risks with your insurance agent, update contract language if needed and make sure every active vendor has a current certificate on file. A yearly cleanup keeps the log accurate and easy to use.
Start with your next new vendor: request a certificate before scheduling any work, review it against your checklist and add it to the log with a reminder.
Consistency is what makes it work.
A few minutes now can save you from a costly gap later.
Manage Vendors With Updoot
Updoot's purchasing keeps vendors and orders organized, and SOP management keeps your vendor setup and insurance requirements where your team can find them.