Expiry tracker for a Dubai brokerage: agent cards, trade licence, permits, visas and Emirates IDs

Why expiries slip in a brokerage with 30 agents

Each agent has several dates: a broker card, a visa, an Emirates ID, sometimes a professional exam result. The company has its own: the trade licence, the insurance, tenancy contracts for the office. Every ad has a permit, including property videos that must carry the permit and QR fields. Multiply that by 30 people and a few dozen live ads, and no one can hold it in their head. A date slips when it lives in the agent's own phone, the manager assumes the agent has it, and the agent assumes the company does. For what else breaks as a firm grows, see scaling a Dubai brokerage from 5 to 30 agents.

The cost of a miss is lost days. An agent with a lapsed card cannot work as a registered broker, and an ad without a valid permit should not be live. I will not put a number on that, because I could not find an official figure I trust. The point of the tracker is that you never learn the number.

What to track: people, company and permits

Group	Examples	Whose problem it is
Agent	Broker card, annual test result, Emirates ID, visa	The agent does the renewal, the brokerage checks it
Company	Trade licence, insurance, office tenancy (Ejari, the registered tenancy contract), company permits	The owner or office manager
Advertising	Trakheesi permit per listing	The listing agent, with an admin check
Compliance	Compliance officer registration on goAML (the Financial Intelligence Unit's reporting system), training dates, screening list reviews	The compliance officer

One dependency matters: DLD's pages tie a broker card to the company's trade licence, so a licence slip can affect every agent. That is why the company dates sit at the top of the sheet.

The tracker columns that matter (template)

Column	What it holds
Person or entity	Name and agent ID
Document	Broker card, visa, Emirates ID, trade licence, permit
Reference number	Card number, permit number
Issue date	From the document
Expiry date	The date shown on the document itself
Days left	Formula: expiry date minus today
Owner	Who must act
Manager	Who is told if the owner does not act
Status	Valid, due, in progress, lapsed
Proof	Link to the scan of the renewed document

A note on card validity: sources conflict on whether a broker card runs for a year or follows the trade licence. Track the date printed on the e-card, whatever the rule is.

The reminder ladder and who gets each reminder

This is my design, not a legal requirement.

• 60 days: a note to the agent and the admin: this is coming up, check any prerequisite (for the card, the annual test).
• 30 days: a reminder to the agent, copying the manager. Status should be "in progress".
• 14 days: the manager is told directly if status is not yet "in progress". The agent is told that the card must be done this week.
• 7 days: the owner or compliance officer sees the list of anything still open.
• Expiry day: the item turns red, and the rule in the next section applies.

What the official DLD renewal actually involves

From DLD's page for requesting renewal of a real estate activity practice card (the broker card), checked 2 November 2026:

• The renewal is done online through Trakheesi or the Dubai REST app (DLD's platform for brokers).
• The fee is AED 500 plus an AED 10 knowledge fee and an AED 10 innovation fee, so AED 520 in total.
• The service time shown is five minutes.
• The applicant must have passed the annual test, and all sales personnel must be registered with cards issued.
• The page says approval is automatic once you submit online, but you still have to log in and pay the fees yourself, so it is not an automatic renewal.

What I could not confirm, so I leave out: a renewal window (some sources say 30 days before expiry, but the official page states none, so use 30 days only as a sensible internal target), a late-renewal rule or fine, and any reminder sent by the authorities. If a card lapses, ask DLD what applies to you. Do not take late-fee numbers from setup-company blogs.

Owner view and agent view

An agent sees a renewal as a five-minute task they will do eventually. An owner sees it as a risk across the whole team, because one lapsed licence or a pile of cards expiring in the same month can stop work for several people at once. Design the tracker for both: the agent gets a short, specific nudge with the date, and the owner gets one page showing everything open, sorted by days left. Stagger renewals where you can, so you are never handling ten at once, and record the new expiry date the same day a renewal is done, from the renewed document and not from memory.

Worked example: a 30-agent brokerage's monthly expiry view

These are made-up figures. On the first working day of the month, the admin opens the saved view "expiring in 60 days" and finds 7 items: 3 agent cards, 2 visas, 1 Emirates ID and 1 permit-bearing listing campaign. The sheet shows two cards at 28 days (status "in progress", fine) and one at 21 days with status "due" (an escalation to the manager). The trade licence is at 190 days, so it shows green but is pinned at the top of the sheet. By the 14-day check the third card is "in progress". The visa at 19 days has no owner assigned, which is the real finding, so the admin assigns one. Result: seven items, one gap, caught in a ten-minute review.

Moving from a sheet to an automated tracker

Start with a sheet. It works up to the point where people stop updating it. The step up is a small app or CRM view where each person's dates are entered once and reminders are sent without anyone remembering to send them. The tracker should then: email the agent and manager on the ladder, show the list to the owner, and keep the proof scan beside each date. See brokerage management software for where this sits in a wider system and what internal tools are for the custom route.

How software and AI help with expiry tracking, and where a person must decide

Concrete tasks:

• Reading the date. AI can read a scanned card, visa or Emirates ID and fill in name, number and expiry, for a person to confirm. See AI document processing.
• Reminders by email or WhatsApp. Automatic messages along the ladder. For WhatsApp, business messages sent outside a customer service window must use pre-approved templates, see the WhatsApp Business API explained. Messages to your own staff are internal, so email is often enough.
• Escalation. If status has not changed by the 14-day mark, the system alerts the manager automatically.
• Stop-work rules. A lapsed card flags the agent's new listings and permit requests for hold until renewal is logged. This is an internal control, not a legal claim. Decide it with your lawyer.
• Dashboards. A single "expiring in 60 days" view for the owner, and counts by group.

What stays human: doing the renewal, confirming the new date from the official record, and deciding what happens to an agent's work if a card lapses. I build trackers like this for brokerages when a sheet is no longer enough, but start with the sheet.

Try it yourself with Claude (an AI assistant). Paste a made-up table of ten agents with card expiry dates and ask: "Add a days-left column using today's date of [date], list everyone under 60 days, and draft a 30-day reminder message for each in a friendly, short tone." Use invented names and dates, then run the same logic on your own sheet.

Common mistakes

• Relying on an agent to remember, or on a reminder from the authorities that you cannot confirm exists.
• Tracking the card but not the licence it depends on.
• Entering a date from memory instead of from the document.
• No owner on a visa or permit line.
• Letting the sheet go stale: no one is responsible for the monthly review.
• Reminders that go only to the agent, so no one else finds out.

How I'd approach this

Build the sheet this week. Enter every date from the actual documents, assign an owner to each row and put a monthly 60-day review in the admin's calendar. Run it for two months. If the review is reliably done and nothing slipped, you may not need anything more. If it slips, that is the moment to automate, not before. Confirm renewal rules and any consequences of a lapse with DLD.