How to Track Safety Certs and Inspections [2026]
Build a simple safety certificate and inspection tracker with a free spreadsheet method, reminder dates, ownership, and a clear upgrade path.
![How to Track Safety Certs and Inspections [2026]](https://pryurdtpjgpesqjqunbx.supabase.co/storage/v1/object/public/blog-images/how-to-track-safety-certs-inspections/header-1785310986612.png)
If your business relies on current safety certificates, equipment checks, or employee authorisations, the dangerous part isn't usually finding a document. It's knowing what is due next, who owns it, and whether the renewal process has actually started.
This guide is for operations managers, facilities teams, compliance leads, warehouse managers, and small-business owners who need one practical system for safety certificates and inspections. You can start with a spreadsheet and calendar for free.
A useful example comes from OSHA's powered industrial truck standard. An operator's performance must be evaluated at least once every three years, and the certification record must include the operator's name, training date, evaluation date, and the identity of the trainer or evaluator. That is more than an expiry date. It is a small record with evidence, ownership, and a next action. OSHA's standard is the source for those requirements.
1. List every safety-controlled activity
Start with the activity or obligation, not the file name. Create a list of everything that could become unsafe, non-compliant, or unavailable if a date slips.
Typical records include:
- Employee safety certificates and operator authorisations
- First-aid, CPR, fire warden, or food-safety training
- Forklift and other powered industrial truck evaluations
- Fire, lifting equipment, electrical, machinery, and calibration inspections
- Site-specific permits, competency cards, and contractor documents
Don't assume every document has the same kind of deadline. Some are certificates, some are recurring inspections, and some need a review after an incident or equipment change.
The date you need to track may therefore be an evaluation or review date, not just the date printed on a card.
2. Create one row per certificate or inspection
Avoid a single row called “Warehouse compliance” with ten documents hidden in a folder. Create one row per obligation. That gives every item its own owner, status, evidence, and next date.
A free spreadsheet can use these columns:
| Column | What to record | | --- | --- | | Item | “Forklift evaluation - Alex” or “Fire alarm inspection - Site A” | | Type | Certificate, training, inspection, examination, permit | | Holder or asset | Person, machine, vehicle, room, or site | | Issuing body or inspector | Who issued or completed it | | Reference number | Certificate, report, or asset reference | | Completed date | When the latest activity happened | | Expiry or due date | The date the current evidence ends or the next check is due | | Start-by date | When someone must begin arranging the next action | | Owner | The person accountable for progress | | Evidence link | Link to the PDF, image, or stored report | | Status | Current, due soon, overdue, or waiting for evidence | | Notes | Access needs, supplier lead time, conditions, or follow-up |
One row per item makes filtering possible. You can see every inspection due in the next 30 days, every certificate held by one employee, or every record without a document attached.
3. Track the action date, not only the expiry date
The expiry date tells you when current evidence stops being valid. It doesn't tell you when to book the inspection, arrange training, or chase a supplier.
Add a start-by date using this simple formula:
Start-by date = due or expiry date - expected lead time - safety buffer
Suppose a lifting-equipment examination is due on 30 September. The inspection company normally needs two weeks' notice, and your team wants one week of contingency. Your start-by date is 9 September. The buffer depends on the equipment and supplier.
For recurring inspections, record both the last completed date and the next due date. For employee certificates, record the holder and the evidence date. For equipment, record the asset identifier and location.
4. Add reminders at more than one distance
One reminder is easy to ignore. A short reminder chain gives the owner time to act and gives someone else a chance to notice if nothing is happening.
Start with:
- 90 days before: confirm the requirement, scope, and supplier or training provider
- 60 days before: book the inspection, course, or assessment
- 30 days before: confirm the appointment and gather the required documents
- 14 days before: check that the work is complete or the person is booked
- 7 days before: escalate anything still waiting
- On the due date: mark complete, attach evidence, or record the exception
These are operating suggestions, not universal legal deadlines. Your regulator, insurer, customer contract, or equipment manufacturer may require a different interval. If a provider has a long wait, start earlier.
For a small team, put the final due date in a shared calendar as a backstop. Use the spreadsheet as the register and calendar as the prompt. Include the item, owner, reference number, and link.
5. Assign an owner and a backup
Every row needs one accountable owner. “Operations” is not an owner. Neither is a shared inbox.
The owner starts the renewal, confirms the appointment, uploads the evidence, and marks the record complete. A backup should know where the register lives and how to take over if the owner is away or leaves.
This is especially important for safety records. A certificate may be held by an employee, but the business still needs someone to know that it exists, when it expires, and what happens if the holder is unavailable. Keep the holder and the accountable owner as separate fields where possible.
6. Review the register every week
Set a short weekly review. It doesn't need to become another meeting.
Use this order:
- Look at overdue items first.
- Look at everything due in the next 30 days.
- Check items with no owner.
- Check items with no evidence link.
- Check items marked complete but missing the new date.
- Move completed records out of the active view, but keep their history.
For multi-site businesses, filter by location. For training, filter by employee. For equipment, filter by asset. Use the certificate expiry tracking guide for the basic register design, then adapt the same fields to inspections and safety checks. Spreadsheet vs Renewal Tracker explains where the manual method starts to strain.
Track all your certifications and inspections in one place. Free to start, no card. Add the due date once and get reminded before it lapses.
Track safety dates freeCommon mistakes that cause safety dates to lapse
Treating the expiry date as the plan
If the first reminder arrives on the expiry date, the system has already failed. Add a start-by date and enough lead time for booking, evidence, and rework.
Giving one person the whole register
A single owner may be efficient until they take leave, change jobs, or simply miss one email. Use an accountable owner, a backup, and a shared location for the register and documents.
Using a generic interval for every item
Safety intervals vary by equipment, jurisdiction, manufacturer, insurer, and the event that triggered the check. Don't copy a six-month reminder to every row. Confirm the applicable requirement and document the source in the notes.
Forgetting changes and incidents
Some requirements become due after an accident, near miss, equipment change, or change in working conditions. Add a review trigger to the notes and train owners to update the record when one occurs.
Where Lapsewise fits
A spreadsheet and shared calendar can be perfectly reasonable for a small operation with a few dates and one owner. Lapsewise becomes useful when the register includes multiple people, sites, assets, or record types, and a missed date would create real operational or compliance risk.
In Lapsewise, you can keep certificates, inspections, licenses, insurance, contracts, and other expiry-driven records in one dashboard. Each record can have a holder or entity, key dates, documents, an owner, status, and reminders before the due date. The Runway view shows what is due soon, while the status board helps a team see what needs attention.
For a certificate-heavy workflow, certificate management software gives the module-specific overview. For recurring checks and examination dates, inspection management software is the closer fit.
Lapsewise isn't a substitute for your regulator, competent inspector, trainer, or safety adviser. It helps you remember the dates, keep the evidence together, and make ownership visible. You still need to confirm what the applicable requirement means for your business.
FAQ
Should safety inspections and employee certificates be in the same tracker?
They can be. Keep them as separate records with clear types, holders, assets, and owners. The shared tracker is useful because one team can see all upcoming dates without maintaining several disconnected calendars.
How far in advance should I start a safety certificate renewal?
Start with the provider's lead time, then add a buffer for unavailable trainers, failed inspections, corrective work, or missing documents. Many teams use 90, 60, 30, and 7-day reminders as a starting pattern, then adjust it by record type.
Is a spreadsheet enough for inspection tracking?
Often, yes, if you have a small number of records, one responsible owner, and a reliable review habit. A dedicated tracker earns its place when several people need access, documents are scattered, reminders are missed, or you need one view across certificates, inspections, licenses, and insurance.
What if the rule changes or an incident creates a new deadline?
Keep the original record, add the new review or action date, and note why it changed. Don't overwrite the old date without preserving the evidence and reason. That history makes future reviews much easier.
Track certificates, inspections, licenses, insurance, and other renewal dates in one place. Lapsewise warns you before a due date slips. Free to start, no card.
Related guides
Never let it lapse
Track every certificate, contract, grant, and license in one place. Lapsewise warns you before any renewal or expiry slips. Free to start, no card.