What a missed mandate expiry really costs, and how to build a tracking routine

A mandate, the agreement that gives your agency the right to market a property for a fixed period, is the most tangible asset an estate agency has. It protects the work you put in. Yet in most offices mandates sit in a folder or a shared drive, and when one expires nobody notices.

The moment it is noticed usually sounds like this: the owner calls and says the agency next door brought a better offer, and they have signed with them. The mandate has lapsed. The photos you took, the listing copy you wrote, the viewings you ran no longer give you any claim at all.

The real cost of a missed expiry

Knowing your commission rate is not enough to price a missed mandate. Line by line:

• Marketing spend. Portal fees, professional photography, video or drone footage if you used it, social ads. All spent on a property that is now gone.
• Agent time. Viewings, owner meetings, rounds of price negotiation. Hours spent on this property were not spent on another.
• Warm buyers. The buyer list you built for the property either evaporates or drifts to the neighbouring agency, who now say “we know that flat too”.
• The owner's trust. An agency that does not track its own expiry dates is, in the owner's eyes, an agency that does not follow through. The owner's next property goes elsewhere.

Add these up for your own office. The figure per mandate is usually larger than anyone guessed. We are not going to invent a number for you; take it from your own books.

Why expiry dates slip

Four recurring causes:

1. There is a document but no date. The mandate is signed, scanned and filed. The end date is never written into any calendar.
2. The date lives on the agent's phone. The agent made a note in a personal diary. If the agent is on leave, off sick or has left, the date leaves too.
3. The renewal conversation is left to the last day. Talking about renewal in the final week is hard; the owner is already in “you've had all this time and not sold” mode. Renewal should be raised weeks before expiry, as part of the sales process.
4. Nobody owns it. Mandates are “the office's job”, but the office is not a person. Without a named person and a dated reminder, it is nobody's job.

A one-page tracking routine

Mandate tracking does not need an elaborate system; it needs a disciplined routine. The one below can run on a spreadsheet. What matters is that it is complete and uninterrupted.

1. Four fields for every mandate

Property, owner, responsible agent, expiry date. If any is empty the record is incomplete. Alongside the date, record the type of mandate (sole agency or open) and whether there is an extension clause, and on what terms.

2. Staged reminders

One reminder is not enough; it arrives during a meeting and is forgotten. A cadence that works: 30 days before expiry, schedule the renewal conversation; 14 days before, meet the owner; 7 days before, record the outcome; 3 days and 1 day before, final check. Each stage should go to both the responsible agent and the branch manager. A reminder that goes only to the agent never arrived if the agent is away.

3. The renewal meeting agenda

The meeting at the 30-day mark should not be a “shall we extend?” question. The agenda is: what we did in this period (number of viewings, offers received, buyer feedback), what changed in the market, our recommendation on price, our plan for the next period. An agency that turns up with that agenda has earned the renewal. It also needs records to exist: an agency that did not log viewings and offers cannot tell the owner what it did.

4. Ten minutes a week

Every week on the same day the branch manager looks at the list of mandates expiring in the next 30 days and asks the responsible agent one question about each: where is the renewal conversation? It takes ten minutes and prevents most missed mandates.

Spreadsheet or software?

We said this routine can run on a spreadsheet, and it can. But a spreadsheet does not send reminders, does not reassign a record when the agent changes, and does not put the viewing history side by side for the owner conversation. Past three agents or a second branch, the spreadsheet falls behind.

If you use software, what you need is not a glossy “document management” feature. Look for: is the expiry date a required field; are reminders staged and do they reach the manager as well; is the mandate linked to the property record and to the owner's contact record; does a renewal create a new record that keeps the history.

Mandate tracking in PropOrdo

In PropOrdo each mandate lives in the Mandates screen as a record tied to a property and an owner, and the expiry date is required. As the date approaches, automatic reminders go to the responsible agent and the branch manager at 30, 14, 7, 3 and 1 days out. Upcoming expiries appear on the Today screen and in the branch report, and because the property's viewing and offer history is in the same file, preparing for the renewal meeting does not mean hunting for records. If you want to set this up with your own portfolio, the trial is free for 14 days.