How to Track Employee Certifications Across a Team [2026]

If your business depends on people holding current certifications, a folder of PDFs and a manager's memory isn't a tracking system. It might work for three employees and a handful of dates. It gets risky when people change roles, certificates arrive from different providers, or several renewals fall in the same month.

This guide is for operations managers, HR teams, compliance leads, facilities managers, and small-business owners who need a practical way to track employee certifications across a team. You'll see a free spreadsheet and calendar method first, then the point at which a dedicated tracker earns its place.

The goal is simple: know who is certified, what they can do, when the evidence expires, and who acts next.

1. Define what counts as a certification

Start by agreeing on the records you actually need to track. “Training” is too broad to be useful on its own. A record should represent a qualification, card, certificate, licence, or recurring safety requirement that has an owner and a date.

Typical examples include:

• Forklift or powered industrial truck operator training
• First-aid, CPR, or workplace safety certificates
• Food-safety certificates
• Construction or trade qualifications
• Equipment-specific authorisations
• Professional licences and continuing-education requirements
• Internal qualifications that must be refreshed after a role or equipment change

Write down the scope before importing. Otherwise, the tracker becomes a mixture of certificates, informal training notes, and documents that don't need renewal.

A useful distinction is certificate expiry versus training review. A qualification may require periodic evaluation even without a clear expiry field.

For example, OSHA says powered industrial truck operator performance must be evaluated after initial training, after refresher training, and at least once every three years. The employer's certification record must include the operator's name, training date, evaluation date, and the identity of the trainer or evaluator. See OSHA's OSHA powered industrial truck standard for the requirements. The exact rule for your industry and location may differ, so verify it with the relevant authority or adviser.

2. Create one row per person and certification

Don't create one row per employee with a long list of certificates in a single cell. Create one row per certification held by one person.

That structure lets you filter for every first-aid certificate expiring in the next 60 days, or every forklift evaluation due this quarter. It also gives each record its own document, owner, status, and reminder dates.

Use these spreadsheet columns:

| Column | What to enter | | --- | --- | | Employee | Full name and, if useful, employee ID | | Team or location | Department, site, or cost centre | | Certification | Clear name of the certificate or qualification | | Provider | Issuing body, training provider, or assessor | | Certificate number | The identifier printed on the document | | Issue date | When the current certificate or qualification started | | Expiry or review date | The date action is required | | Start-renewal date | When preparation should begin | | Status | Current, expiring soon, expired, or pending evidence | | Record owner | The person responsible for the next action | | Document link | A stable link to the PDF or scanned record | | Notes | Restrictions, site scope, equipment type, or follow-up |

The record owner is important. The employee may be the person who attends the course, but a manager, HR coordinator, or compliance lead may be responsible for booking it and checking the evidence.

3. Capture the dates from the source document

Open each certificate and record dates from the document itself. Don't copy a date from an old spreadsheet unless you can verify it.

Look for:

• Issue, expiry, renewal, or reassessment dates
• Certificate number
• Scope, class, equipment type, or location
• Any condition that changes the next action

If the certificate has no expiry date, don't guess. Record the document's issue or completion date, add a note about the governing rule, and confirm the review interval with the issuer, regulator, or internal policy owner.

This is also where you should check whether the record is personal or role-based. A person might hold a qualification, but the qualification may only be valid for a specific machine, site, jurisdiction, or type of work.

4. Work backwards from the action date

The expiry date is often not the date you need to start. Decide how much lead time each certification needs, then calculate a start-renewal date.

For a simple certificate, 30 days may be enough. For a course that requires booking, an assessment, manager approval, or a replacement card, 60 or 90 days may be safer. If the person is hard to replace or the certificate is required for a customer contract, use more runway.

A basic spreadsheet formula is:

=ExpiryDate - LeadTimeDays

You can add a second date for the final check. For example:

• 90 days before: owner confirms the course, assessment, or application route
• 60 days before: booking or renewal request is complete
• 30 days before: employee attends, submits evidence, or completes the assessment
• 7 days before: manager checks the new document and updates the record
• Expiry date: only a final boundary, not the first reminder

Don't use one lead time for every certification. A first-aid refresher and a regulated professional licence may have very different booking and evidence requirements.

5. Add reminders that reach more than one person

A free setup can work well if you keep it disciplined:

1. Put the spreadsheet in a shared drive with edit history.
2. Create a shared calendar for renewal and review dates.
3. Add reminders at the start-renewal date, 30 days before, and 7 days before.
4. Invite the record owner and a backup owner.
5. Add the employee's manager when the certification affects staffing or site access.
6. Review the next 90 days once a week.

The calendar is useful for visibility, but it shouldn't be the only source of truth. Events are easy to dismiss or leave behind when someone changes role. The spreadsheet should hold the record, evidence link, status, and next action.

For a small team, this method is reasonable. The dates must be verified, reminders must start early enough, and a second person must be able to take over.

6. Run a weekly certification review

Set a recurring 15-minute review. Filter the tracker to show:

• Expired records
• Records due within 30 days
• Records due within 31-90 days
• Records with no document attached
• Records with no owner or backup owner
• People whose role or site changed recently

For each item, record one next action. “Needs attention” is not enough. “Book the evaluation by August 1” is an action.

After a renewal, update the document, issue date, expiry or review date, certificate number, and owner. Don't overwrite old evidence if you need an audit trail. Archive it or keep a versioned record according to your retention policy.

Common mistakes that make certification tracking fail

One person owns the whole system

If one HR coordinator or operations manager is the only person who knows where the tracker lives, the business has a continuity risk. Add a backup owner, shared access, and a short written review routine.

You track expiry but not renewal lead time

A reminder on the expiry date is not a renewal plan. The employee may need a course booking, manager approval, assessment, travel, or a replacement card first. Track the date action must begin.

You treat every certificate as a simple annual renewal

Some records use a fixed expiry date. Others require a reassessment, a refresher after an incident, or a check when the workplace or equipment changes. Confirm the rule for each certification type.

You keep the PDF somewhere else

A date without evidence creates another search task. Attach or link the source document, and record the certificate number and scope so someone else can verify it.

Reminders go to the wrong person

The employee, manager, record owner, and compliance reviewer may be different people. Make that distinction explicit. A reminder that reaches nobody with authority to act is just noise.

Where Lapsewise fits

A spreadsheet and shared calendar can be enough for a small, stable team. Lapsewise becomes useful when you have many employees, multiple sites, several certification types, or a real audit and staffing risk.

In Lapsewise's Certifications module, you can keep each certification as its own record, attach the document, assign the next action, and see what is due in the Runway view. Reminders are sent by email at 08:00 in each user's own timezone, and SMS is available on the Pro plan. CSV import is available on Starter and above, while Pro can parse dates and record details from a PDF for you to confirm.

It isn't a substitute for checking the rule that applies to your industry. It is a way to make sure the verified dates, evidence, and responsibilities don't disappear into a personal inbox. See the certificate management software page for the module overview, or start with how to track certificate expiry dates for the basic register design.

If your team tracks several kinds of renewal, the same approach can extend to contracts and grants. The plain-English guide to what renewal management means explains how one date system can cover those records without mixing up their rules.

FAQ

Should the employee or manager own a certification record?

The employee holds the qualification, but a named business owner should check evidence and start renewal. Add a backup owner for absences and staff changes.

How far in advance should we remind people?

Use the lead time needed for that specific certification. Thirty days may work for a simple refresher. Sixty or 90 days may be better when a course, assessment, approval, or replacement document is involved.

What if a certificate has no expiry date?

Don't invent one. Record the issue or completion date, note the applicable policy or rule, and confirm whether a periodic review, reassessment, or refresher is required.

Can a spreadsheet track employee certifications?

Yes. A shared spreadsheet plus calendar is a sensible free method for a small team. A dedicated tracker becomes more useful when you need reminders, documents, owners, audit history, multiple record types, or a reliable handover.

Is Lapsewise a compliance or legal adviser?

No. Lapsewise helps you track dates, documents, and reminders. You still need to confirm the requirements that apply to your industry, location, role, and certification provider.