Track Visa, Emirates ID and Labour Card Expiry in Excel
A hundred workers hold five or six hundred documents, and each one expires on its own day. Here is a free tracker, the formula behind it, and a timetable for renewing in time.
- Every worker holds several documents that expire. The main ones are the passport, residence visa, Emirates ID, labour card and health insurance.
- One late renewal can mean daily fines, a worker who may not enter the site, or a worker who may not legally work.
- The free Excel tracker below shows the days left for each document and colours what is urgent.
- A tracker only helps if someone opens it. Decide who looks at it, and on which day of the week.
Why one expired paper is expensive
A manpower supply company sells one thing: a worker who is allowed to be on the customer's site tomorrow morning. An expired document breaks that in ways that cost far more than the renewal fee.
- The customer's gate turns the worker away, and you bill no hours for him.
- Fines start to count by the day.
- A worker with no valid work permit may not legally work at all, and the company that employs him carries the consequences.
- The renewal itself takes days: a medical test, typing, approvals. It cannot be done on the morning the gate says no.
Nobody forgets a renewal on purpose. It is forgotten because the date sat in a folder, or in the head of the one person who was on leave that week.
The documents to track
| Document | How long it usually runs | Worth knowing |
|---|---|---|
| Passport | Set by the worker's own country | The worker renews it through his embassy, which can take weeks. Offices usually want at least six months left before they renew a visa: confirm this with your PRO |
| Residence visa | 1, 2 or 3 years when sponsored by an employer | Renewal needs a medical fitness test and an Emirates ID application. Overstaying costs AED 50 a day. The portal says there is a grace period after expiry, and its length depends on the kind of resident: ask your PRO which applies |
| Emirates ID | Follows the visa | Late renewal is fined at AED 20 a day after 30 days, up to AED 1,000 |
| Labour card (work permit) | 2 years for the common kinds | Working without a valid permit is against the labour law |
| Health insurance | One or two years, depending on the scheme. Track the policy's own end date | The employer pays for it, and a residence permit is not issued or renewed without it |
| Unemployment insurance (ILOE) | By subscription | The worker subscribes himself, and he is the one fined if he does not. Many offices remind their workers anyway |
| Site passes and safety cards | Set by the customer or the site | Some sites need their own security pass or safety induction. Without it the worker does not pass the gate |
The fines in this table are the ones stated on the UAE Government's portal on the dates given under Sources. Check the current figure before you tell a worker what he owes.
"Labour card" and "work permit" mean the same paper in daily talk. Use whichever your office uses, but use one.
Download the tracker
Worker document expiry trackerExcel file. Free, no sign-up, nothing to install.
It has one row for each document, not one row for each worker. That is the detail that makes it work: you can sort the whole sheet by expiry date and see the next ten renewals of the company, whoever they belong to.
The Tracker tab is empty. The Example tab is filled in with made-up workers. Both count the days by themselves and colour each row.
The formulas behind it
If you would rather add this to a sheet you already have, these are the two formulas. The expiry date is in column F.
| Column | Formula | What it shows |
|---|---|---|
| Days left | =IF(F2="","",F2-TODAY()) |
The days until expiry. A negative number is the days since it ran out |
| Status | =IF(F2="","",IF(F2<TODAY(),"Expired",IF(F2-TODAY()<=30,"Renew now",IF(F2-TODAY()<=60,"Soon","Valid")))) |
One word to sort and filter by |
Format the Days left column as Number, or Excel may show it as a date. Then use Conditional Formatting on the Status column: red for Expired, orange for Renew now, yellow for Soon. Sort the sheet by expiry date, oldest first, and the work of the week is at the top.
Two warnings about dates in Excel. Type them the way your computer expects, and check one: a date that Excel stores as text will not count down. And agree on day-month-year in the office, because 03/04/2027 is the third of April to one person and the fourth of March to another.
A timetable for renewing in time
| Days before expiry | What to do |
|---|---|
| 90 | Passport: tell the worker, because his embassy sets the pace |
| 60 | Visa and labour card: collect the papers and book the medical test |
| 30 | Everything should be applied for. Tell the customer if a worker may miss days |
| 7 | Anything still open is now urgent. Decide who replaces the worker on site |
| 0 | A worker with an expired paper does not go to site |
These are working habits, not rules of law. Your PRO knows how long each step takes this year.
Where an Excel tracker stops helping
Excel keeps the dates. It does not tell anyone. The sheet has to be opened by someone who knows what to do with it, and it has to be filled in correctly, by hand, from six hundred scans.
Three signs that a company has outgrown the sheet:
- A renewal was missed although the date was in the tracker.
- Two people keep two versions of the file.
- Finding the scan of a passport takes longer than a phone call asking the worker to send it again.
Questions people ask
What is the fine for an expired Emirates ID?
The UAE Government's portal gives AED 20 for each day of delay after 30 days from the expiry date, up to a maximum of AED 1,000. Check the current figure with the Federal Authority for Identity, Citizenship, Customs and Port Security before you rely on it.
Is a labour card the same as a work permit?
In daily use, yes. The work permit is the ministry's permission for a worker to work for an establishment, and the labour card is the name most offices still use for it.
How early should a visa renewal start?
Start collecting papers about 60 days before the date, so that the medical test and the applications are done with weeks to spare. Your PRO will know how long each step takes at the moment.
Who pays for a worker's health insurance?
The employer. The ministry describes a basic health insurance scheme that the employer pays for, and a residence permit is not issued or renewed without it. The schemes differ between emirates, so check the rule for the emirate that issued the visa.
Can Excel send a reminder by email?
Not by itself. It shows colours when someone opens the file. To get a message without opening anything you need a calendar entry for each date, or software that sends the warning.
Sources
- The UAE Government portal, General provisions for the residence visa, updated 28 September 2026.
- The UAE Government portal, Emirates ID, updated 17 February 2026.
- The UAE Government portal, Work permits, updated 19 October 2026.
- Ministry of Human Resources and Emiratisation, The basic health insurance scheme.
- The UAE Government portal, Unemployment insurance scheme, updated 8 December 2025.
This guide explains the rules as we read them on 19 November 2026. Rules change, and your bank or exchange house may ask for more. It is not legal advice: for a decision that matters, check with the authority concerned, your PRO or your accountant.