How to track certification expiry dates (free tracker)

Every small employer ends up with the same problem. Cards and licenses come in at different times, last two, three or five years, and nobody remembers them until an inspector, an insurer or a customer asks. Here is a routine that works whether you use a spreadsheet or a tracker.

Download the free certification expiry tracker (CSV)

It opens in Excel, Google Sheets or Numbers. One row per certificate, with these columns:

Column	What to put in it
Name	The person, vendor, vehicle or your company
Kind	employee, vendor, equipment or business
Email	Theirs, if you want them to get reminders too
Role and Location	Helps when you sort by site or job
Manager email	The person who should chase the renewal
Certification	For example CPR / AED, Forklift evaluation, General liability insurance
Expires	The date printed on the card, like 2027-03-01
Notes	Provider, card number, anything else

1. Collect every expiry date once

Walk through each person and each vendor and write down every card or certificate with an expiration date. Copy the date from the card itself rather than working it out from the class date. Some cards expire at the end of the month and some on the exact day.

Do not forget the things that are not people: your business license, contractor licenses, vehicle registrations, equipment inspections, and the insurance certificates your subcontractors owe you.

2. Keep the proof next to the date

The sheet is an index. When an inspector asks, you need the card. Save a photo or PDF for each row and keep it where you can find it from the row, such as a shared folder named after the person.

3. Add a days left column

In the column after Expires, add =H2-TODAY() and fill it down. Sort by it. Anything under 60 needs a class or a phone call booked now. In Google Sheets, Format, Conditional formatting, "Less than" 0 in red and "Less than" 60 in yellow makes the urgent rows stand out.

4. Decide who gets told, and when

A sheet only helps when someone opens it. Put a monthly reminder on one person's calendar to sort it and send out the list. For most cards, 60 days is enough time to book a class, 30 days is the second nudge, and 7 days is the last chance. Insurance certificates and licenses that take paperwork often need 90 days.

5. Keep the old record when something renews

When a new card comes in, do not just overwrite the date. Move the old row to a second tab called History. If something goes wrong, you can show what was on file at the time.

When to move off the spreadsheet

A spreadsheet is fine for a handful of people. It starts to slip when nobody opens it, when each location keeps its own copy, or when the cards live in someone's inbox instead of next to the dates. CertExpiryTracker imports this same file, emails reminders on the schedule you pick, lets staff and vendors send in renewed cards through a private link, keeps the renewal history, and prints a monthly expiry report.

Comparing tools? See how we stack up as an Expiration Reminder alternative.