How to Build a Compliance Certification Tracker [2026]

If you manage safety certificates, professional licenses, training records or business accreditations, the difficult part isn't storing the PDF. It's knowing what needs attention next, who owns it and how much time the renewal actually requires.

This guide is for operations managers, compliance leads and small business owners who need a reliable certification expiry tracker. A useful system records the right date, assigns an owner, starts work early enough and keeps replacement evidence with the record. You can build it in a spreadsheet, then move to a dedicated certificate management system when the list grows.

1. List every certification and compliance record

Start with an inventory, not a reminder tool. Search shared drives, email attachments, HR folders, supplier portals and paper binders. Include records that don't look like certificates at first glance:

• ISO, safety and quality certifications
• First aid, forklift, food hygiene and other staff training certificates
• Professional or trade licenses
• Insurance certificates and other proof-of-cover documents
• Fire, electrical, equipment and inspection certificates
• Permits, accreditations and customer-required compliance documents

For each item, record the holder or covered entity. That might be a person, location, vehicle, piece of equipment or the business itself. A forklift operator certificate belongs to an employee, while a fire inspection certificate may belong to a site.

If a document has no clear owner, assign the person responsible for renewal.

2. Capture the dates that actually matter

The expiry date is only one date. A good tracker should capture at least:

1. Issued or completed date - when the qualification or certificate began.
2. Expiry or renewal date - the date the current evidence stops being valid.
3. Renewal start date - when the process should begin.
4. Last reviewed date - when somebody confirmed the record is still correct.
5. Next evidence date - when the replacement certificate or approval must be uploaded.

Use the issuing body's wording where possible. “Valid until,” “renew by,” “review due,” “evaluation date” and “next inspection” are not always interchangeable.

For example, OSHA's 29 CFR 1910.178 requires a powered industrial truck operator evaluation at least every three years, with earlier refresher training when an incident, unsafe operation, poor evaluation or workplace change indicates it is needed. The three-year date is not the only trigger. See the OSHA standard.

3. Add a lead time that matches the renewal work

A reminder on the expiry date is not a renewal process. Choose the lead time based on what must happen before the date:

• 14 to 30 days: simple online renewal with no supporting evidence
• 60 to 90 days: training, assessment, inspection or manager approval
• 90 to 180 days: external audit, site visit, several employees or a scarce assessor
• Longer: accreditations, permits, insurance changes or renewals that require budgeting

If the expiry date is in F2 and your lead time in days is in G2, use:

=F2-G2

For a simple status column, use:

=IF(F2<TODAY(),"Expired",IF(F2<=TODAY()+30,"Action needed",IF(F2<=TODAY()+90,"Expiring soon","Current")))

Choose the window based on your process. Thirty days may be fine for an online renewal, but not for a course, exam and supervisor sign-off.

4. Build the free spreadsheet tracker

For a small list, create one row per certificate or certification. Use these columns:

| Field | What to enter | |---|---| | Record name | Plain-English name, such as Forklift operator certificate | | Holder | Person, site, vehicle or business entity | | Type | Training, license, ISO, inspection or other category | | Issuing body | The organization that issued or verifies it | | Certificate number | Reference or credential ID | | Issued date | Date issued or completed | | Expiry date | The exact date shown on the source document | | Renewal start | Your calculated action date | | Owner | Person responsible for renewal | | Status | Current, expiring soon, action needed or expired | | Evidence link | Shared-drive or document-management link | | Last checked | Date someone verified the row | | Notes | Renewal route, fee, training or special condition |

Add conditional formatting to the status column. Use one color for current records, amber for the next 90 days and red for overdue records. Filter the sheet by owner each week and review all red and amber rows.

Then create calendar events for the renewal start date, not just the expiry date. Put the certificate name, holder, owner and document link in the event notes. For records with a long process, add a second event at the expected booking or application deadline.

This free method works well when one person manages a handful of records in a stable shared folder.

5. Add a weekly review and a handover rule

A tracker is only as reliable as its review habit. Set a 15-minute weekly check:

1. Filter for records due within 90 days.
2. Confirm each owner still works on the task.
3. Check whether the renewal has started.
4. Update the status and next action.
5. Add the new evidence as soon as renewal is complete.
6. Move the next expiry date forward only after confirming the replacement document.

Add a handover rule for holidays, sickness and staff departures. Every record should have a primary owner and a backup. A shared spreadsheet with one accountable owner is safer than a large sheet that everybody assumes somebody else is watching.

See how to track employee certifications across a team for the owner problem.

6. Store evidence beside the expiry record

Don't make the person renewing a certificate search for the old one. Link or attach the source document to the row, and keep the certificate number, issuing body and holder visible.

When renewal is complete, retain the old document if required, mark it superseded and note what changed. That history helps when someone asks whether the certificate is current and how you know.

Common compliance certification tracking mistakes

Tracking expiry but not renew-by dates

Some records require action well before the printed expiry. A renewal application, inspection booking or training course may have its own deadline. Track both dates when they differ.

Sending one reminder too late

A reminder 14 days before expiry gives no room for failed assessments, unavailable trainers, missing documents or manager approval. Start with the real process lead time and work backwards.

Making one person the system

If the spreadsheet sits in one person's inbox or the owner is never reviewed, staff turnover can create a silent gap. Use a shared location, a backup owner and a weekly review.

Treating every certificate as a simple annual event

Some records renew on a fixed cycle. Others need event-based action. OSHA's forklift rule is a useful example: the three-year evaluation date matters, but certain incidents or changes can require earlier refresher training.

Updating the date before the evidence arrives

Don't mark a certificate renewed because someone says the course is booked. Update the new expiry date after the issuing body or approved trainer has provided evidence.

When Lapsewise fits better than a spreadsheet

A spreadsheet is fine for a small, stable list. Lapsewise helps when you have multiple owners, repeated reminders or audit-sensitive documents.

In Lapsewise's Certifications module, you can keep the certificate details, holder, issuing organization, reference number, key dates and document together. The Runway view shows what is due next, while reminders are sent before the date in each user's own timezone. Pro users can also use SMS reminders and AI document parsing, where a PDF is read for likely dates and details before you confirm them.

It isn't legal advice and it doesn't decide whether your certificate meets a regulator's requirements. You still need to confirm the correct renewal rules with the issuing body. Lapsewise handles the operational problem: making the dates, owners and evidence easier to see before something lapses.

FAQ

What is the best way to track certification expiry dates?

For a few records, use a shared spreadsheet with expiry date, renewal start date, owner, status and evidence link. For a team or a larger register, use a tracker that sends reminders and keeps documents with each record.

How far in advance should certification reminders be sent?

Start with the work required. Use 30 days for a simple online renewal, 60 to 90 days for training or inspection, and longer for audits, external appointments or multi-person renewals.

Should I track training completion and certificate expiry separately?

Yes. Completion proves the activity happened. The certificate expiry or evaluation date tells you when action is needed next. They may be the same date, but they represent different facts.

Can I use Google Calendar instead of a certification tracker?

Calendar reminders can work for a very small list. They become harder to audit when you need owners, documents, statuses, replacement history and multiple reminder windows. See calendar reminders versus an expiry tracker for the trade-off.

What should happen when a certificate has already expired?

Mark it expired, notify the responsible manager, confirm whether the activity can continue, and contact the issuing body about the next step. Don't assume a grace period exists.

Sources

• OSHA 29 CFR 1910.178, including powered industrial truck evaluation and refresher-training requirements.