How to track agent CE and license renewals in a small brokerage

An agent walks into the office on a Tuesday and mentions, in passing, that they got an email from the state about their licence. It is due in eleven days. They have none of their continuing education hours done, the mandatory legal courses are the ones that fill up first, and they have three contracts under deadline.

Nobody did anything wrong, exactly. The renewal notice went to a personal email address the agent checks on weekends. The hours were "on the list." And the brokerage had no way of knowing, because nothing in the office was watching.

This is the most avoidable emergency in a small brokerage, and it is worth understanding why it keeps happening to offices that are otherwise well run.

The real problem is that the deadline belongs to the agent and the consequence belongs to the brokerage

A licence is personal. The state issues it to the agent, emails the agent, and holds the agent responsible. So every incentive points at the agent to manage it, and most agents do — right up until a busy quarter.

But the consequence is not personal. An agent whose licence lapses cannot work. Their listings need covering, their pending contracts need a licensed person attached, and the broker is the one who has to solve that on a day's notice. In a ten-agent office, one lapse is a real operational event.

So you end up with a responsibility that sits with one person and a risk that sits with another. That gap is the thing a tracking system has to close. Not by taking the responsibility away from the agent — you can't, and you shouldn't want to — but by making sure the office sees the same clock the agent sees.

What actually has to be tracked

Most brokerages think of this as one number: hours completed. It is four things, and conflating them is the first place the system breaks.

The expiration date. The single most important field, and the one most often stored only in someone's memory. It is a per-agent date, it does not move, and everything else counts backwards from it.

The renewal cycle. Hours count within a cycle, not forever. An agent who took a course three cycles ago has a certificate that proves nothing about this renewal. This is where hand-kept spreadsheets go wrong most reliably: they accumulate hours and never reset.

The mandatory courses, separately from the total. In Texas, the state requires a set number of hours per cycle, and a portion of those must be specific legal update courses — and brokers carry an additional requirement that sales agents do not. An agent can be at the full hour count and still be short, because the hours they have are the wrong hours. A tracker that only totals hours will happily show a green number over a renewal that is going to be rejected. Check the current requirement on TREC's own site; it is the only authority that matters, and it changes.

The certificate itself. Not just the fact of the course, but the document. When there is a question, the question is always "can you produce it," and the answer is usually "it's in an email from eighteen months ago."

The three places tracking breaks

It is stored where only one person can see it

The office manager knows. The office manager is on holiday. This is not a hypothetical failure mode; it is the normal one. A tracking system that lives in one person's spreadsheet, inbox or head is not a system, it is a dependency.

The fix is unglamorous: the data has to be somewhere the broker, the office manager and the agent can all open, and it has to be the same copy. Two copies means two answers, and the one you check will be the stale one.

It is checked on the wrong cadence

Offices check this annually, or when something reminds them. Both are too late. The mandatory courses are the ones with the least availability — they fill, and the online sessions have their own schedules — so an agent who discovers a shortfall three weeks out has a genuinely hard problem, and an agent who discovers it four months out has an afternoon of admin.

A useful cadence is monthly, and the question is not "who is expiring soon." It is "who is more than halfway through their cycle with less than half their hours." That question catches the problem while it is still cheap.

It tracks completion but not the gap

"Twelve hours done" is not actionable. "Six hours short, including one mandatory legal course, with four months left" is. The difference is whether the system knows the requirement, not just the progress.

This is the one part worth building properly, because it is the part that converts a tracking system into something the office actually uses. A list of numbers gets ignored. A list of named gaps gets worked.

A system that works for a ten-agent office

You do not need software to do this well. You need these things to be true:

1. Every agent's expiration date and cycle start are recorded in one shared place on the day they join, not later. Onboarding is the only moment you have someone's full attention for paperwork.
2. The requirement is written down beside the progress, so the gap is visible without anyone doing arithmetic.
3. Someone owns the monthly check — by name, on a recurring task, with a defined action. Usually the office manager. The check takes fifteen minutes.
4. Certificates land in one folder, named consistently, as they are earned. Not collected at renewal.
5. The agent gets told what they are short, specifically, with enough runway to fix it without drama.

That is the whole system. A spreadsheet with five columns does it. The reason offices still get caught is not that this is hard — it is that nobody is assigned to it, so it is done by whoever happens to think of it, which is nobody in a busy month.

Where software helps, and where it does not

Software helps with exactly two things here: keeping one copy of the data that three people can see, and doing the gap arithmetic so the monthly check is a glance instead of a project. That is genuinely useful, and it is most of the value.

Software does not help with the part that actually fails. If nobody in the office owns the monthly look, a tool will produce an accurate report that nobody opens, and the agent will still walk in on a Tuesday with eleven days left. Pick the cadence and the owner first. Then pick where the data lives.

The office that never has this emergency is not the one with the best tracker. It is the one where somebody looks, every month, and says something out loud four months early.