How to Track Vendor Document Expiration Dates

To track document expiration dates for vendors, record each document’s expiration date the day it arrives (for insurance, each policy’s date, not the certificate’s issue date) in one place someone actually watches. Send reminders at 90, 60, 30, and 7 days before expiry, and give one person ownership of the follow-up. A calendar or spreadsheet works for a few vendors; past about twenty, dedicated software usually saves time.

Insurance certificates, licenses, and certifications all expire eventually. Without deliberate tracking, you find out about a lapse when it’s too late, usually from a claim, an audit, or a client asking for proof. This guide also covers what to do when a vendor ignores every reminder you send.

It’s part of a bigger process. If you’re still deciding what to collect from vendors in the first place, start with the vendor compliance management guide and the vendor compliance checklist.

Which vendor documents expire?

Insurance certificates, licenses, certifications with a printed expiry, and fixed-term contracts are the vendor documents that expire. Before you choose a tracking method, know what you’re tracking. The documents with hard expiration dates are the ones that cause trouble:

• Certificates of insurance. Each policy on a certificate has its own expiration date. A single ACORD 25 might list general liability, auto, umbrella, and workers compensation, and they don’t always renew on the same day.
• Business, contractor, and professional licenses. Renewal cycles depend on the state, city, and type of license.
• Industry certifications, such as ISO certificates or trade certifications, when they carry a printed expiry date.
• Contracts with a fixed term, such as a master services agreement or a business associate agreement.

Some documents, like a W-9, have no expiry date. They still need a recheck when details change, but they don’t belong in your expiration tracking.

One detail people miss: for insurance, track each policy’s expiration date, not the date the certificate was issued. The issue date at the top of the certificate tells you nothing about when coverage ends.

How to track document expiration dates: four methods compared

There are four common approaches. Each works at some size. The question is where yours is today.

Method	Cost	Sends reminders?	Works for	Breaks when
Calendar reminders	Free	Yes, to you	A handful of vendors, one person	You have many documents, or the owner leaves
Spreadsheet	Free	No, someone has to check it	10 to 30 vendors with one careful owner	Several people edit it, or nobody opens it for a month
Shared drive folders	Free or included	No	Storing files	You need to know what’s expiring without opening each file
Compliance tracking software	Monthly fee	Yes, to you and the vendor	Any size, especially 20 or more vendors	You never set it up or keep vendor emails current

Calendar reminders

Put each expiration date in your work calendar with a reminder a few weeks ahead.

Good: free, you already use it, it does notify you. Weak: each document is a separate event you create by hand. You can’t see all vendors at once, nothing reminds the vendor, and if you change jobs, the reminders leave with your account. It also doesn’t know when a renewal arrived, so you have to delete or move events yourself.

Spreadsheet

One row per document: vendor, document type, policy or license number, expiration date, status, and notes. Add conditional formatting so dates within 30 days turn yellow and past dates turn red.

Good: free, flexible, everyone can read it, easy to sort by date. Weak: a spreadsheet doesn’t send anything. Someone has to open it, sort it, and write the emails. When two people keep their own copies, you lose track of which is current. Dates get typed wrong. And the actual certificate lives somewhere else, so the spreadsheet can say “renewed” while nobody can find the file.

Shared drive folders

A folder per vendor, with files named like Ridgeline Electric - GL - exp 2027-03-15.pdf.

Good: the documents are in one place, and good file names make dates visible. Weak: it’s storage, not tracking. Nothing tells you what’s about to expire unless you go looking. Most teams pair it with a spreadsheet, which brings back the spreadsheet’s problems.

Compliance tracking software

A tool built for this keeps the documents and the dates together and sends reminders on a schedule.

Good: reminders go out without anyone remembering to send them, often directly to the vendor. You see everything expiring on one screen. Documents and dates stay connected. Weak: it costs money, someone has to set it up, and it only works if vendor contact emails are current. Dates read from a document still need a quick human check.

An honest rule of thumb: if you have fewer than ten vendors and one reliable person, a calendar or spreadsheet is fine. Once you’re past twenty, or more than one person touches vendor paperwork, the time spent chasing renewals by hand usually costs more than a tool.

A reminder schedule that works: 90, 60, 30, and 7 days

A common mistake is reminding too late. A reminder one week before a certificate expires gives the vendor almost no time to get a renewal certificate from their agent, especially if the renewal hasn’t been finalized.

A four-step schedule covers most situations:

Days before expiry	Purpose	Who it goes to
90	Early notice. Gives the vendor time to start their renewal and ask their agent for a new certificate when it’s ready.	Vendor
60	Follow-up for anyone who hasn’t sent the renewal. Most should be in progress by now.	Vendor
30	Firm reminder. Copy the person who manages the vendor relationship.	Vendor, plus internal owner
7	Final notice. State what happens if nothing arrives (work pauses, payment held).	Vendor, plus internal owner and accounts payable

Why this spacing works:

• 90 days is early enough that nobody can claim surprise. Commercial insurance renewals often get underway well before the expiration date, so the vendor may already be talking to their agent.
• 60 and 30 days catch the vendors who meant to handle it and forgot.
• 7 days is a last call, and the point where your own team needs to plan for a lapse.

What each of those reminders should say is covered in insurance renewal reminders. CertiTrack follows exactly this schedule: at 90, 60, 30, and 7 days before each document expires, it emails the vendor a secure link to upload the renewal and sends your team a copy. If you’re tracking by hand, you can copy the same schedule into calendar events or a spreadsheet column.

When the renewal arrives

The job isn’t done when a new document shows up. Check it the same way you checked the first one:

• Are the new effective and expiration dates correct?
• Did the coverage or limits change at renewal?
• Is the insured name still the business you contract with?
• If you require endorsements (additional insured, waiver of subrogation), is a current endorsement attached? This needs a person to read it; a checkbox on the certificate isn’t proof.

Then update your records and keep the old version. If a claim comes up later, you’ll need to show what was in force on that date. For certificate-specific review steps, the certificate of insurance tracking guide goes deeper.

Who should own the follow-up?

One person should own expiration follow-up, usually an operations or office manager, with a named backup for when they’re out. Reminders don’t help if nobody acts when they’re ignored.

The owner is responsible for:

• Making sure every new document gets its expiration date recorded the day it arrives.
• Watching the list of what’s expiring in the next 30 days.
• Personally following up when automated or scheduled reminders don’t get a response.
• Telling project leads and accounts payable when a vendor has lapsed.

For larger teams, split it: the owner handles the tracking, and whoever manages each vendor relationship handles the phone calls. But one person still owns the list.

What should you do when vendors ignore reminders?

Escalate step by step, from a phone call to holding payment where your contract allows it. Some vendors will ignore every email. Usually they’re not hiding anything; insurance paperwork is just at the bottom of their list. Here’s an escalation path that works:

1. Call instead of email. A two-minute phone call gets more done than a third email.
2. Contact their insurance agent directly. For certificates, the agent’s name and contact details are in the producer section of the ACORD 25. Agents issue certificates all the time and are often faster than the vendor. You can ask for the renewed certificate yourself.
3. Make it easy. If the vendor has to dig through email to find where to send the file, it’ll wait. A direct upload link they can use from their phone removes that excuse. CertiTrack sends vendors a secure link where they can upload from any device without creating an account.
4. Pause new work. Don’t schedule new jobs until current documents are on file.
5. Hold payment, if your contract allows it. (See the pre-payment compliance check.) Nothing moves paperwork faster than an invoice on hold. Make sure the person who pays invoices knows which vendors are out of compliance.
6. Escalate internally. If the vendor still doesn’t respond, the decision about whether they keep working should be made by someone with authority, on purpose, and written down.

The best way to avoid all this is to set expectations at the start. Put renewal requirements in the contract: documents must stay current for the length of the relationship, and renewals are due before the old ones expire.

Keeping the system honest

Whatever method you use, a few habits keep it accurate:

• Record dates the day documents arrive. A backlog of unprocessed certificates is how lapses slip through.
• Track each document separately. One vendor might have five documents with five different expiration dates.
• Review the 30-day list every week. It takes five minutes and catches most problems.
• Clean up vendors you no longer use. Archive them so their expirations don’t clutter the list, but keep their records.
• Spot-check against the document. Whether a person typed the date or software read it, compare it to the file once.

If you’d rather not build this by hand, CertiTrack’s Free plan covers up to 5 vendors, enough to try it on your highest-risk ones; see pricing for larger plans.

Frequently asked questions

How far in advance should I remind vendors about expiring documents?

Start about 90 days out. That gives the vendor time to work with their agent or licensing board, and leaves room for follow-ups at 60, 30, and 7 days before expiry.

Should reminders go to the vendor or to my team?

Both. Early reminders go to the vendor, since they’re the one who has to act. Later reminders should also reach the person who manages the vendor, so a lapse doesn’t come as a surprise.

What date should I track on a certificate of insurance?

The expiration date of each policy listed in the coverage section, not the certificate’s issue date. Different policies on one certificate can expire on different days.

Is a calendar good enough to track vendor expirations?

For a few vendors and one person, yes. It gets hard to manage once you have dozens of documents, need to share the view with others, or want reminders to reach the vendor directly.

CertiTrack keeps every vendor’s insurance, licenses, and renewal reminders in one place. Start free.