How to Track Certificate Expiry Dates (Free Method) [2026]

If your team holds certifications, somebody has to know when each one expires. Miss a renewal and the consequences are real: a failed audit, a paused contract, a worker who can't legally do the job until they re-certify. This guide shows a free way to track certificate expiry dates, the mistakes that trip people up, and when it's worth moving to a tool that does the watching for you.

This works for any kind of certificate: ISO 9001 and ISO 27001, professional qualifications, trade and safety certs, first-aid and CPR, food-hygiene, electrical and gas inspections, LOLER, and more.

The free method (start here)

You don't need software to begin. A simple, disciplined system beats an expensive one you don't maintain.

1. List every certificate. One row each: certificate name, who holds it, the issuing body, the issue date, and the expiry date.
2. Add a "renew by" date. This is the date you need to start the renewal, not the expiry. If a cert takes four weeks to renew, your renew-by date is at least 30 days before expiry.
3. Set two calendar reminders per cert. One at the renew-by date, one a week before expiry as a backstop. Put them on a shared calendar, not a personal one.
4. Store the PDF with the record. Keep the actual certificate somewhere everyone can find it, named clearly with the holder and expiry.
5. Review weekly. Five minutes scanning what's due in the next 30, 60, and 90 days.

That's genuinely enough for a handful of certificates held by a few people. Here's a starter layout for your sheet.

Common mistakes that cause a lapse

Most lapsed certificates aren't a tracking failure. They're one of these:

• Tracking the expiry date, not the renew-by date. By the time the expiry reminder fires, you may be out of time to renew. Always work backwards from how long renewal takes.
• Reminders on a personal calendar. When that person is on leave, the reminder fires into an empty room. Use a shared calendar or a tool the whole team sees.
• No backstop. A single reminder gets dismissed and forgotten. Two reminders, at different times, catch the misses.
• The document lives in someone's inbox. When an auditor asks for proof, you don't want a frantic search. Keep the PDF with the record.
• One person owns it all. If the entire certificate list is in one head or one private file, you have a single point of failure.

When to switch to a real tracker

Move from spreadsheet to a dedicated tool when:

• You track more than ten certificates, or they belong to several people.
• You need to prove compliance in an audit and want the documents and history in order.
• Renewals currently depend on one person remembering.
• You also track other things that expire - contracts, licenses, insurance - and want them in one view.

How a dedicated tracker handles it

A purpose-built tool like Lapsewise removes the manual parts:

• Add the cert and its expiry once. It calculates the runway and shows you what's due this week, month, and quarter.
• Automatic email reminders at 8am in each person's own timezone, with the lead time you set, so the holder and the manager both get warned in good time.
• The certificate PDF stored on the record, so audit proof is one click away.
• A status view that flags each cert as active, expiring soon, or action needed, with a health ring for your whole certificate stack.
• AI parsing (optional): drop the certificate PDF and it reads the dates and details for you to confirm, so data entry isn't a chore.

If you also manage agreements and funding, see how to set up contract renewal reminders and track grant deadlines. For the bigger picture, start with what renewal management is.

Frequently asked questions

How far ahead should a certificate reminder fire? Work backwards from how long renewal takes. If re-certification takes a month, set the reminder at least 30 days before expiry, plus a backstop closer to the date.

How do I track certificates for a whole team? Use a shared system, not individual calendars. Each certificate should record the holder so you can see, at a glance, who needs to renew what and when.

What if a certificate has no fixed expiry? Track a review date instead. Even open-ended certifications usually need periodic checks or re-validation, so set a recurring review.

Is a spreadsheet enough? For a few certs held by a few people, yes, if you're disciplined about reminders and backups. Past a dozen, or with audit stakes, a tool that reminds you automatically pays for itself the first time it catches a lapse.

The takeaway

Tracking certificate expiry comes down to three habits: record the renew-by date (not just the expiry), set reminders the whole team can see, and keep the document attached. Start free with a spreadsheet and calendar. When the list outgrows it, let a tracker do the watching so a lapse never catches you by surprise.