How to track visa and residency expiries without a spreadsheet

A missed visa renewal usually starts the same way: the date was in a spreadsheet, and nobody opened it that week.

If you look after people in the Gulf, you already know how much depends on those dates. A renewal that starts late can hold up a payroll run, a business trip or a new contract, and it lands on HR at the worst possible moment. This guide sets out a simple method for tracking expiries properly: what to record, when to send reminders, who owns each renewal, and how to close the loop when it’s done. It works for a small team as well as a company with several hundred people.

One note before we begin. The rules on renewals, grace periods and fees differ by country and change over time, so this guide doesn’t cover them. Always check the current requirements with the relevant official authority or your PRO before you act on a specific case.

Why the spreadsheet stops working

A spreadsheet is the natural place to start, and for a while it’s fine. One row per employee, a column for the visa expiry, a column for the residency expiry, maybe some colour for anything coming up soon.

The problems show up slowly:

• Nobody is told. A spreadsheet doesn’t send reminders. Someone has to remember to open it, sort it and read it, every week, without fail.
• Copies multiply. One version on the shared drive, one attached to an email, one on someone’s laptop. The date that matters is in the copy you didn’t open.
• Dates and documents drift apart. The expiry date gets updated, but the new document is saved somewhere else, or not at all.
• Ownership is vague. “HR tracks it” usually means everyone assumes someone else is looking.
• It breaks when people leave. When the person who kept the sheet moves on, the habit often goes with them.

The people keeping the sheet are usually doing their best. A list of dates just can’t tell anyone anything. Tracking means the right person hears about a date in time, and there’s a record of what happened next.

What to track for every employee

Before you choose a tool, agree on what you’re tracking. For each employee, record:

1. Every document with an expiry. Visa, residency, passport, and any work permit or professional licence their role depends on. Don’t track the visa alone; renewals often depend on other documents being valid, the passport especially.
2. The expiry date of each one. Taken from the document itself, not from memory or an old email.
3. A copy of the current document. Stored with the record, so anyone who needs it can see exactly what the date is based on.
4. The status. Keep it simple: valid, renewal in progress, renewed, or cancelled.
5. The owner. The one person responsible for making sure this renewal happens. More on this below.
6. The company entity. If you run more than one company or branch, note which one the employee’s paperwork belongs to.
7. Notes. Anything unusual: a pending transfer, a role change, an employee on long leave.

Keep access tight. These are personal documents, so only the people who need them should be able to see them.

When to remind: a simple schedule

The aim is to give everyone enough time to act without creating noise that people learn to ignore. We don’t give fixed day counts here, because the allowed and required windows differ by country and document and they change. Check the official authority first, then set your reminders in three stages:

• First reminder: plan. The owner confirms the employee is staying, checks which documents the renewal will need, and tells the employee and their manager that it’s coming.
• Second reminder: act. Documents should be gathered and the renewal started, or at least booked. If anything is missing, this is when you find out with time to fix it.
• Final reminder: escalate. If the renewal isn’t done or clearly on track, it goes to the HR lead or the business owner, not just the owner.

To time them, start from your own history: look at the longest a renewal has taken in your company, and make sure the first reminder comes comfortably before that. Adjust to your situation, but keep the three stages: plan, act, escalate.

Two habits make the schedule work. First, reminders should go to a named person, not a shared inbox. Second, every reminder should lead to an action: a status change, a note, or a new document. If reminders are arriving and nothing changes, the system isn’t working yet.

Who owns each expiry

Every expiry needs one owner. Not a team, not “HR”, one person.

In a small company, that might be the HR officer for everyone. In a larger one, you might split ownership by entity, by department or by location, and work with a PRO for the government side. Whatever you choose, write it down and make sure each record shows it.

Then add a backup. Owners go on leave, change roles or leave the company. A backup who knows they’re the backup means nothing falls through when that happens.

Three other people should always be in the loop:

• The employee, who usually has to provide documents, photos or signatures, and who has the most at stake.
• Their manager, who needs to plan around any appointments or travel restrictions during a renewal.
• Whoever runs payroll, because a lapsed document can affect how that person’s salary is handled that month.

How to handle a renewal, step by step

When a reminder comes in, work through the same steps every time:

1. Confirm the employee is staying. If they’re leaving, the next step may be a cancellation, not a renewal. Agree on which before spending time or money.
2. Check the requirements. Look up the current process with the official authority or your PRO. Requirements change, so don’t rely on how it worked last time.
3. Gather the documents. Ask the employee early for anything you need from them, and check the passport is valid for long enough.
4. Get internal approval. If the renewal involves costs or a change in the employee’s role or terms, get sign-off before you submit.
5. Submit and record it. Set the status to “renewal in progress” and note the date and reference.
6. Update the record. When the new document arrives, save a copy, enter the new expiry date and set the status to “renewed”.
7. Close the loop. Tell the employee, their manager and payroll that it’s done.

The last two steps are the easiest to skip. Skip them and next year’s reminder will be wrong.

A monthly routine that keeps you ahead

Reminders catch individual dates. A monthly review catches everything else. Once a month, ideally a few days before you lock payroll, spend a short session on the list:

• Everything inside its first-reminder window: is each one planned or in progress?
• Everything in progress: has it moved since last month?
• New joiners: are all their documents and dates recorded?
• Leavers: are their records closed or cancelled as they should be?

Doing this just before payroll means any visa or residency issue is already known when you review salaries, not discovered afterwards.

Common mistakes to avoid

• Tracking the visa but not the passport. A passport close to expiry can hold up a renewal.
• Updating the date but not the document. The record should always show the document the date came from.
• Sending reminders to a shared inbox. Everyone sees it; no one acts on it.
• Forgetting leavers. An employee who has left can still have open paperwork that needs closing.
• Relying on one person’s memory. If the process lives in someone’s head, it leaves with them.

How Ahlan Hamad does it

You can do everything above by hand. We built Ahlan Hamad so you don’t have to.

Each employee’s records, contracts and documents live in one place, so the expiry date and the document it came from sit together. Visas and residencies are tracked, with alerts before expiry, so the right people hear about a date before it becomes a problem.

Getting started doesn’t mean retyping your old sheet. You can add staff one by one, from a spreadsheet, or from your old system. If you’d rather not do it yourself, send us your staff sheet and we set it up for you.

Your staff also get the employee app for payslips, leave and attendance. And when you want to change something, you can ask Hamad, our assistant. Nothing changes until you confirm.

Because records sit alongside payroll, you can check visa and residency status during the same review where you look over salaries, before you lock payroll and download the WPS salary file for your bank.

Ahlan Hamad works in Kuwait, Saudi Arabia, the UAE, Qatar, Bahrain and Oman, in Arabic and English.

Start your 30-day free trial — no credit card: ahlanhamad.com