Why cheque and PDC tracking breaks down beyond a few hundred units
Post-dated cheques work on paper until volume rises. Why spreadsheet tracking fails around a few hundred units, and what a controlled cheque register needs.

A property management MD can run the week from five numbers: cash collected against due, arrears over 30 days, cheques due and returned, jobs past target, and renewals with no action. Together they show money, risk and service. If those five take more than a few minutes to find, the operation is not connected.
Ask a managing director how the business is doing, and you usually get a confident answer. Ask for the arrears figure as of this morning, and the room changes.
Someone will find out. It might take until Wednesday. By then, the number will have moved.
You cannot manage a portfolio from a monthly pack that arrives three weeks late. You also cannot read fifty KPIs. A short, honest weekly list works better.
Here are five numbers. Each one answers a question an owner, auditor or bank could reasonably ask.
The Monday five
Not revenue. Cash. How much was due this month, and how much has arrived so far?
This is your first signal. A fall here usually shows up before any other problem does. Look at the percentage, and compare it with the same point last month.
Total arrears can mislead, since new debts appear and clear all the time. The over-30 figure shows what is getting stuck.
Watch the movement, not just the level. If this number rises for three weeks, collections has a problem, even if the total looks stable.
How many cheques should be banked this week? How many came back last week?
In the UAE, this is a leading indicator. A returned cheque is tomorrow’s arrears. It only works if returns are recorded the same day, as explained in why PDC tracking breaks down.
This is the service number. It counts maintenance jobs open longer than your agreed target.
Complaints come later. Owners and tenants feel slow service long before they say so. A variant is also worth adding: jobs completed but not invoiced, the leak described in following one request from WhatsApp to invoice.
How many leases expire in the next 60 days with no recorded conversation?
Firms lose revenue quietly here. Renewals drift, tenancy registrations lapse, and a good tenant leaves because nobody called. This number turns a calendar problem into a weekly action.
| Number | The question it answers | Warning sign | Who owns it |
|---|---|---|---|
| Cash collected | Is money arriving as expected? | Below last month’s pace | Finance lead |
| Arrears over 30 days | Is debt getting stuck? | Rising three weeks running | Collections |
| Cheques due and returned | What is about to go wrong? | More returns than usual | Finance lead |
| Jobs past target | Is service slipping? | One building dominates | FM or operations |
| Renewals with no action | Is income quietly leaving? | Any lease under 30 days | Leasing |
Each number needs one named owner. If a number belongs to everybody, nobody will explain it on Monday.
The real value appears when the numbers move together. Each combination suggests a different question.
Reading the numbers as a set
The numbers are only useful if someone acts on them. Keep the routine short.
Monday, 15 minutes
There is a useful test hidden in this routine. How long does it take to produce the five numbers?
If they appear in minutes, your operation is connected. Perhaps someone spends Monday morning building them from four files instead. Then you have learned something more important than the numbers themselves.
That is the control principle in practice. If you cannot see it in one place, you cannot control it.
Start with what you can get, even if one number is rough at first. An imperfect figure reviewed weekly improves quickly, because someone now cares about it.
Every dashboard grows. Someone asks for one more metric, then another. Resist it.
Five numbers that are reviewed every week beat thirty that nobody opens. Change one only when it stops prompting action.
Ask your team for these five numbers by 10:00. Do not warn them first.
Note how long each one takes, who produces it, and whether two people give different answers.
Which of the five could you not get at all, and what does that tell you?
A month is long enough for a small problem to grow. A weekly view shows direction early, while there is still time to act before month end.
A dashboard helps if it draws from live records. If someone rebuilds it by hand, it becomes another report that is out of date by Tuesday.
They suit most property management firms. Community managers may swap in service charge collection, and FM firms may focus on jobs and unbilled work.
A 20-question self-assessment is in preparation. Leave your email on the newsletter form to hear when it opens.
Post-dated cheques work on paper until volume rises. Why spreadsheet tracking fails around a few hundred units, and what a controlled cheque register needs.

Follow one maintenance request through a UAE property firm. Each handover from WhatsApp to invoice is a chance to lose time, evidence and money.