CertExpiryTracker

Separating training booked from training completed

A common source of stale expiry lists is confusing a scheduled class with a finished one. When training is booked, the system may show a future date, but until the employee signs the attendance sheet or the instructor submits the completion report, the old credential remains active. The fix is to treat every booking as provisional until a completion marker appears in the record.

Record the booking date and trainer details

When a new training slot is added, capture the scheduled date, trainer name, and location. Enter these details in the certification entry so that later you can tell whether the session happened or was cancelled.

Mark completion when the attendance sheet is signed

After the session, obtain a signed attendance sheet or an electronic completion receipt. Update the certification entry with the completion date and set the new expiry based on the course type. If the employee was absent, leave the old expiry unchanged and note the absence.

Compare the completion date to the booking date

If the completion date matches or follows the booked date, the training is verified. If the session was cancelled or rescheduled, adjust the booking record and re‑book if needed. This comparison prevents stale entries from staying on the list.

Worked example

Kevin Tran’s food handler card was booked for a class on 2024‑04‑10. The class occurred, but the attendance sheet was not signed until 2024‑04‑12. The record was updated with the completion date of 2024‑04‑12, and the new expiry of 2027‑04‑12 was set. Prior to the sign‑off, the system had shown the card as expired based on the old date, causing a false alert.

Verification checklist

  • [ ] Booking date, trainer, and location captured
  • [ ] Signed attendance sheet or electronic receipt obtained
  • [ ] Completion date entered in the certification record
  • [ ] New expiry calculated and saved
  • [ ] Old expiry removed or archived as appropriate

Exception

If the training provider does not issue a completion certificate within 30 days, flag the record for follow‑up. Do not assume completion based on the booking alone; wait for documented proof before updating the expiry.

Related: Cert Expiry Tracker features.