Almost nobody wakes up to a collections crisis. What actually happens is that a number sits at 2.1% for four months, then 2.3%, then 2.2%, and everyone reads the flat line as stability. Meanwhile the composition underneath it has changed completely, and by the time it shows up as bad debt the money has been gone for a quarter.
A single delinquency percentage tells you almost nothing, because two properties with identical rates can be in completely different health. Take a 200-unit property at $1,400 average rent, billing about $280,000 a month. Property A is at 2.5%, roughly $7,000 outstanding, and nearly all of it is in the 0-30 bucket: this month's late payers, most of whom will pay. Property B is also at 2.5%, the same $7,000, but $4,500 of it has aged past sixty days. Property A has a timing pattern. Property B has already lost most of that money and has not written it off yet.
The report shows the same number for both.
Collection probability falls off a cliff as a balance gets older, and the reason is behavioral rather than financial. A resident who is thirty days late is usually late. A resident who is ninety days late has generally made a decision, or their circumstances have changed in a way that a payment plan will not fix. Once a balance crosses that line you are no longer collecting rent, you are managing an exit and hoping to recover a fraction.
Which means the useful question is never "what is our delinquency?" It is "how much money moved from the 31-60 bucket into 61-90 this week, and is that number growing?" That is the leading indicator. The headline rate is the lagging one, and bad debt is the obituary.
Here is what deterioration looks like on a real report when nobody is reading aging. Month one: $7,000 total, $6,000 of it current-ish, $1,000 aged. Month two: $7,200 total, $5,400 current-ish, $1,800 aged. Month three: $7,100 total, $4,600 current-ish, $2,500 aged. The headline moved from 2.5% to 2.57% to 2.54%, which any reasonable person reads as flat. The aged share went from 14% to 25% to 35%, which is a property quietly converting collectible money into write-offs at roughly $750 a month.
Annualized, that is close to $9,000 walking out the door on a single 200-unit property, invisible in the number everyone was actually looking at.
You do not need new software. Every property management system already produces an aging report; it just usually arrives buried in a monthly packet where nobody derives the ratio. Pull the four buckets weekly, compute the aged share, and put it on one line of a one-page report. When it rises two weeks running, ask the property manager what changed. That single question, asked in week two instead of month three, is most of the value.
The reason this is rarely done is not ignorance. It is that computing it every week is tedious, and tedious work is the first thing to slip in a busy month. That is precisely the sort of thing worth handing to a machine: an AI system pulls the exports, derives the aging movement and flags the direction, and a human decides what the flag means and what to say to the property manager about it.
If you want to run it yourself, the free weekly flash template computes the aged share for you. Enter the four buckets and it does the arithmetic. That is genuinely the whole trick.
The weekly flash report puts aging movement next to occupancy, exposure and variance flags, in front of you before your PM call. It is published in full before any conversation.
Download the sample reportCalculate your reporting gap · Free Excel template · What it costs