Tracking document expiries without a spreadsheet.

Why expiries get missed

Almost every company starts with a spreadsheet: one row per employee, one column per document, an expiry date in each cell, maybe some conditional formatting that turns a cell red. It works for a while. Then it fails in predictable ways:

• Nobody opens it. A red cell only helps if someone looks at the sheet. Spreadsheets do not send reminders on their own.
• Dates are not updated after renewal. The document is renewed, the new copy is filed somewhere, and the sheet still shows the old date. Now the tracker is wrong in both directions.
• New document types are added inconsistently. One person adds a column for medical certificates, another writes them in a notes field.
• Ownership is unclear. Is it HR's job to chase the renewal, the manager's, or the employee's? When everyone assumes someone else is on it, no one is.
• Lead time is ignored. Some renewals take days, others take weeks and depend on another document being valid first. A reminder on the expiry date is too late.

What a reliable process looks like

Good expiry tracking is less about technology and more about four habits. Software just makes them stick.

1. One record per document, not per employee

Each document should be its own record: type, number, issue date, expiry date, a scanned copy, and the employee it belongs to. That way an employee can have any number of documents, and a renewal creates a new record with its own dates while the old one stays in the history.

2. A standard list of document types

Decide which document types your business tracks and use that list everywhere. For each type, set a reminder lead time that reflects how long renewal actually takes. A passport may need months; a parking permit may need days.

3. Reminders that go to a named person

A reminder should go to someone who can act, at the right time, and repeat until the record is updated. Useful patterns are a first notice well ahead of expiry, a second closer to the date, and an escalation to a manager if the document actually expires. Many teams also send a reminder to the employee directly, since they often hold the original documents.

4. Renewal closes the loop

The reminder should only stop when a new document with a later expiry date is recorded. "Marked as done" without new dates is how trackers drift from reality.

A weekly view that people actually read

Alongside individual reminders, a short weekly summary helps: documents expiring in the next 30, 60 and 90 days, grouped by department, plus anything already expired. Keep it to one screen. A long report gets ignored; a short list of names gets acted on.

Handling personal data properly

Identity documents are personal data, and in Bahrain the Personal Data Protection Law (Law No. 30 of 2018) applies to how you collect, store and use them. Practical steps:

• Store scans in a system with access control, not in a shared folder or a chat group.
• Limit who can view documents to the people who need them, typically HR and the employee concerned.
• Keep a record of who accessed or changed a document.
• Decide how long you keep copies after an employee leaves, and follow that rule.

Where a system helps

Everything above can be done with discipline and a calendar. Most businesses find it easier with a system that holds the documents, knows the expiry dates, and sends the reminders without anyone remembering to look. In RAL HR, expiry alerts are part of the core product alongside leave and attendance, because in our experience missed CPR, visa and permit renewals are one of the most common pain points for HR teams in Bahrain.

Whichever route you choose, start by listing every document type you need to track and who owns each renewal. That list alone will show you where the gaps are.

Questions about setting this up for your team? Get in touch.