Tracking two endorsements on a single document

Professionals often deal with documents that carry more than one endorsement, such as a driver’s license with both a passenger‑vehicle and a hazardous‑materials endorsement, or a safety certificate with basic and advanced modules. Distinguishing which endorsement expires when helps keep the record clear about what each document covers.

Structure the record to hold each endorsement separately

Instead of a single “expiry date” field, create two sub‑fields: Endorsement A Expiry and Endorsement B Expiry. If a document has only one endorsement, leave the second field blank or mark it as N/A. This avoids the “all‑or‑nothing” problem where a single expiry date masks the status of individual privileges.

How to flag expired vs. pending endorsements

Add a column Endorsement Status that can show values such as Active, Expiring Soon (within 30 days), or Expired. Conditional formatting or a simple formula can populate this column by comparing each expiry date to today’s date.

Worked example

Dwayne Porter holds a forklift evaluation document that lists two endorsements: - Endorsement 1 – Standard Operation expires 2025‑09‑10 - Endorsement 2 – Load‑Securement expires 2025‑10‑02 The tracker records both dates in separate columns. Today is 2025‑08‑31, so the record can show Endorsement 1 as Active and Endorsement 2 as Active, with Endorsement 1 noted as “Expiring in 72 days” and Endorsement 2 as “Expiring in 63 days.” If today were 2025‑09‑11, Endorsement 1 would be past its date while Endorsement 2 would still be current.

Reusable artifact

Sample row with two endorsements | Employee | Document | Endorsement A | Endorsement A Expiry | Endorsement B | Endorsement B Expiry | Status A | Status B | |----------|----------|---------------|----------------------|---------------|----------------------|----------|----------| | Dwayne Porter | Forklift eval | Standard Operation | 2025‑09‑10 | Load‑Securement | 2025‑10‑02 | Active | Active |

A spreadsheet can color‑code the Status columns (green = active, yellow = expiring soon, red = expired) for quick visual scanning, if that setup is available.

Exception

If the two endorsements share a common renewal cycle (e.g., both renew on the same anniversary), you may record a single Renewal Date and note in the Validity Basis field that both endorsements expire together. This reduces redundancy while still communicating that the privileges are linked.

Related: Cert Expiry Tracker features.