Why a name and a date are not enough

Most expiry tracking starts as a spreadsheet with two columns: the document and the date it expires. That tells you what will lapse. It does not tell you who has to act, how early they have to start, or where the proof of the last renewal is. When the date comes close, someone still has to work all of that out — usually under time pressure.

A register earns its keep when every row answers three questions without asking anyone: what is this, who renews it, and when must they start?

The minimum fields

These fields work for licenses, permits, insurance policies, inspections, certifications and personal qualifications alike.

  1. Document type. A fixed list — for example insurance policy, operating permit, inspection certificate, software license, personal qualification. Free text makes filtering and reminder schedules unreliable.
  2. What it covers. The site, asset, client, vehicle or person the document applies to. Two identical certificates for two locations are two rows.
  3. Issuer. The authority, insurer, inspection body or supplier that issues the renewal, with a contact route.
  4. Reference number. Policy number, permit number or certificate ID, so the renewal request is unambiguous.
  5. Expiry date, confirmed. Taken from the document itself, not from memory or an email, and marked as checked by a person.
  6. Named owner and backup. A person, not a team alias. The backup takes over during leave or when the owner moves on.
  7. Renewal lead time. How long the renewal really takes end to end. This sets when the first reminder goes out.
  8. Current file. A link to the valid document. Auditors and clients ask for the evidence, not the date.
  9. Status. Valid, renewal in progress, expired, or no longer needed — so a lapsed row cannot hide among valid ones.

Useful extra fields

  • Renewal cost and budget owner, when a purchase order or approval is part of the process.
  • Legal or contractual basis — the regulation, client contract or tender requirement that makes the document mandatory.
  • Risk if it lapses — for example “site must stop work” or “contract breach”. This helps decide who gets the escalation.
  • Last renewal date and duration, so lead times can be calibrated on real history.
  • Notes on exceptions, such as a slower authority in one country or a client that needs advance copies.

Common mistakes

  • One row for many things. A single “insurance” row for all policies hides the one that expires first.
  • Owner by department. “Operations” cannot receive a reminder; a person can.
  • Dates typed by hand without a check. A swapped day and month is enough to miss a renewal.
  • Old documents overwritten. Keep the previous version: it shows continuity of cover during audits.
  • No status after expiry. If a row simply turns red and stays there, nobody knows whether it was renewed, replaced or dropped.

Managed service providers: one register model, many clients

For a managed service provider (MSP) that tracks documents for several clients, the fields should be the same for every client, with the client as an extra dimension. That makes it possible to see across the whole portfolio what expires in the next 90 days, which rows have no owner, and which clients carry the most risk — without opening a separate spreadsheet per client.

Practical checklist

  1. Fix the list of document types before you import anything.
  2. Split combined rows so each row covers one document for one site, asset, client or person.
  3. Confirm every expiry date against the document itself.
  4. Assign a named owner and a backup to every row; leave none empty.
  5. Set a renewal lead time per document type and let reminders follow from it.
  6. Link the current file and keep the previous version.
  7. Review rows without an owner or with an expired status every month.

How ExpiryKit helps

ExpiryKit is built around these fields: upload a license, permit, policy or certificate, AI extracts the expiry date for you to confirm, and each document gets a type, a named owner and a reminder schedule — for a single business or for multi-tenant MSP portfolios.

Want to move from a spreadsheet to a register that triggers action? Start a free trial or contact us — we will help you map your current list onto these fields.