Your spreadsheet works. You built it yourself, you know where everything is, and it has kept you compliant for years. But LOLER 1998 demands things a spreadsheet was never built to do: automated alerts, timestamped audit trails, complete Schedule 1 fields on every report. The gaps are not obvious until an HSE inspector is standing in front of you asking for a record you cannot find. Purpose-built LOLER inspection software closes those gaps before they become enforcement notices.
What the law requires from your records
LOLER 1998 Regulation 9 requires every thorough examination to be formally documented by a competent person. This is a legal duty. Not a recommendation.
The records must contain specific fields under Schedule 1 of LOLER 1998: a unique equipment identifier, the examination date, the result, any defects found, the deadline for repairs, and the date of the next examination. Miss any one field and you have an incomplete record. In an HSE audit, an incomplete record is treated the same as no record at all.
Records must be retained until the next examination report arrives, or for a minimum of two years for non-person-carrying equipment. Inspectors can ask for them at any time with no warning. Your system must produce a complete, accurate history on demand. Not tomorrow. Now.
Where your spreadsheet will eventually let you down
Excel was built for financial modelling. It was not built for regulated inspection records. The gaps that appear when you use it for LOLER compliance are predictable. Every inspection company using spreadsheets hits them eventually.
- No automatic renewal tracking. Dates live in cells. No cell sends an alert when an examination is due. Dates get missed. Equipment falls out of certification. A UK steel fabricator was fined GBP 13,333 for missing thorough examinations on just two cranes because the spreadsheet did not flag the lapsed dates.
- No immutable audit trail. Anyone with access to the file can edit or delete a cell. There is no log of who changed what, or when. From a compliance standpoint, a record that can be silently altered is not a reliable record.
- Not usable on site. Inspectors carry paper on site, write notes by hand, then return to the office to type everything up. Every record is created twice. That process introduces transcription errors at every step and consumes hours that add no inspection value.
- No version control. "Equipment_LOLER_v3_FINAL_revised_USE THIS ONE.xlsx" is a familiar filename in inspection companies. When multiple people save copies, nobody knows which version is authoritative. In an HSE audit, that uncertainty is a compliance gap.
- No secure client access. Emailing a spreadsheet to a client is neither controlled nor audited. They may forward it. You may send the wrong version. There is no trail of who accessed what, or when.
- Auto-formatting corrupts asset identifiers. Serial numbers such as "07-0399" can be silently reformatted by Excel on file reopen, converting text identifiers into dates or numbers. In a LOLER asset register, a corrupted identifier can make a piece of lifting equipment untraceable in your records.
The time your team wastes writing things down twice
Beyond the compliance risk, there is a direct financial cost buried in your team's working day. Most LOLER businesses have accepted it as normal overhead. It is not.
An inspector on a paper-based system spends between 45 and 60 minutes every day transcribing the notes they took on site. That is not inspection time. That is not client time. That is pure administrative overhead, duplicating work already done on a clipboard.
Scale that across a team of five inspectors and you have five hours of dead time every single working day. At a fully loaded cost of GBP 30 per hour, that is GBP 150 per day, GBP 3,000 per month, and GBP 36,000 per year, spent on a task that produces no customer value and no additional compliance value.
What happens when your records cannot stand up to scrutiny
HSE enforcement in construction and manufacturing has been consistently high. The HSE guidance on LOLER is clear about what inspectors look for: complete Schedule 1 reports for every asset, evidence that defects were categorised and followed up, no gaps in examination history, and records that are retrievable immediately.
A cell left blank, a sheet not updated after typing up, a file saved over: any of these creates a gap that an HSE inspector will note. The consequences are real: one UK company received an Improvement Notice after failing to produce complete examination records for a portfolio of overhead cranes. The problem was not missing inspections. The problem was missing records.
The distinction matters. You can have carried out every examination on time. If you cannot produce the Schedule 1 report immediately and in full, the examination is treated as unrecorded. That is a non-compliance finding, regardless of whether the physical inspection took place.
What purpose-built LOLER software gives you instead
A digital system built for LOLER work does not just replace your spreadsheet. It removes the problems your spreadsheet creates in the first place.
- Records created at point of inspection. Inspectors complete records on a mobile device while on site. There is no paper, no later typing, no double-handling. The record exists the moment the inspection is done.
- Automatic renewal alerts. The system tracks every examination date and alerts you, and optionally the client, before any asset falls due. Nothing slips.
- Immutable audit trail. Every change to every record is logged with a timestamp and user identity. Records cannot be silently altered. This is what an auditable compliance record looks like.
- Full inspection history per asset. Every item of lifting equipment has a complete, searchable examination history. Retrieved in seconds. No hunting through file versions or paper folders.
- Client portal. Clients access their own records securely and in real time, without you needing to email anything. No version confusion. Full traceability of who has viewed what.
- Works offline on site. Poor signal is not a problem. Records sync automatically when connectivity is restored. No data is lost.
The industry has already moved on from paper and spreadsheets
The Lifting Equipment Engineers Association (LEEA), the UK trade body for the lifting industry, has consistently promoted digital examination records as best practice. Tamper-evident records, automated scheduling, and immediate retrieval are the standard the industry is moving towards. If you are still on a shared spreadsheet, you are increasingly out of step with both enforcement expectations and client demands.
How to move across from Excel without losing your history
Moving from Excel to a purpose-built LOLER system is simpler than you might expect. These are the six steps that get you fully operational:
Every week on spreadsheets is another week of compliance exposure. Another week of wasted administration time. The transition takes a weekend. Your next Monday examinations can run on a system that actually works for LOLER.