Reading Your Delinquency Before It Reads You: The Aging Report and the Collection Period

The annual percentage is the least informative number you have

A single delinquency rate compresses everything that matters into one figure and discards all of it. It cannot tell you whether the balance is old or new, whether it is held by many owners or a few, whether it is getting better or worse, or whether the owners behind it are three weeks distracted or three years insolvent. Those are four different problems with four different responses, and the percentage is identical in every case.

Two instruments recover what the percentage throws away. Neither requires new data, new software, or a consultant. Both can be produced from the association's existing general ledger by the manager, and one of them is almost certainly already in the packet, unread.

The aging report, and why shape beats total

An accounts receivable aging report sorts the balance in GL 10400 by how long each amount has been outstanding: current, 31 to 60 days, 61 to 90, 91 to 120, and 120 or more. The total at the bottom is the least useful line on the page. The distribution above it is the diagnosis.

Magnolia Recreational HOA is a composite illustration built for the FOAM series. The community, its vendors, and its financial institutions are fictional; the structures and the arithmetic are real.

Consider two 1,200-lot associations. Both bill $1,224,000 a year. Both carry exactly $73,440 in assessments receivable at year end, which is 6.0% of billings. On the annual report they are indistinguishable.

Association A's balance is young. Most of it sits in current and 31 to 60, spread across roughly 130 owners at an average balance of $565, which is a little over two quarters. That profile is produced by invoicing friction, address errors, autopay lapses, and ordinary human distraction. It resolves. The right intervention is a better reminder cycle, and the cash is coming.

Association B's balance is old and concentrated. $47,900 of $73,440 is more than 120 days out, held by eleven owners averaging $4,355 each — roughly two years of unpaid assessments plus the late charges, interest, and collection costs that accumulated on top. No reminder cycle recovers that. It is a matter for the association's counsel under whatever process the declaration and the statute provide, it will take time, and it may end at a sale.

Same percentage. Same total. One association has a process problem and the other has a legal proceeding. The board that reads only the total cannot tell which one it is sitting in.

The average collection period, and why it is cleaner here than anywhere

The second instrument measures speed rather than size. Ratio analysis calls it receivable turnover, and its more legible form is the average collection period, or days sales outstanding (Garrison, ch. 15). For an association the formula is:

Average assessments receivable is the average of the GL 10400 balance across the year, not the year-end figure. Twelve month-end balances divided by twelve is fine and is what most accounting systems will hand you.

The ratio deserves more confidence in an association than in almost any company the textbooks describe, and it is worth being explicit about why. Days-sales-outstanding is a noisy measure in a firm because some sales are cash and some are on credit, the credit mix moves, and seasonality distorts the denominator. None of that applies here. Assessment billing is 100% on credit, it is perfectly predictable, it is set a year in advance by the board's own vote, and it has no seasonality whatsoever. The denominator is a number the association chose. That makes any movement in the ratio a signal about collection behavior and nothing else.

One honest caveat about the level. Because a quarterly-billed association carries the whole current quarter's invoice in receivables for a few weeks after each billing, the average balance includes a substantial block of money that is not late at all. Magnolia's 51 days is not 51 days of delinquency. This is why the level of the ratio is not the interesting part, and why comparing your number to another association's is close to meaningless unless you bill on the same cycle. The trend is the interesting part, and the trend is comparable to nothing but itself.

A delinquency rate is a photograph. The collection period is a movie.

Here is what the two instruments do to the same five years of Magnolia's history.

Magnolia's annual delinquency rate is close to flat, averaging 5.3% and ending FY2025 at 6.0%. Its collection period rose from 34 days to 51 days, an increase of 50%, in a straight line, across five consecutive fiscal years. Every one of those years closed with an unremarkable financial statement and a treasurer's report that said collections were in line with prior years. They were. That was the problem. The stock of unpaid money was stable while the speed of payment collapsed, and speed is what the operating account actually runs on.

Lateness is a symptom, and it predicts the next thing

The reason to care about the 61-day bucket specifically is not that it is annoying. It is that lateness is diagnostic.

Credit management is direct about this: the longer a balance has been outstanding, the higher the probability it is never collected — and the reason is usually not defiance. A payer who is late is, more often than not, short of cash. (Quiry et al., ch. 48 — idea level.) The 60-day delinquent owner is not being stubborn or making a point about the landscaping. In the large majority of cases he is in trouble, and the balance is going to get worse rather than better without contact.

That finding changes both the urgency and the tone of the response. The urgency rises, because an account moving through the buckets is not drifting, it is deteriorating, and every bucket it crosses lowers the probability of recovery. The tone should soften, because the person on the other end of the notice is not an adversary and treating them as one makes the account harder to resolve, not easier. A disputing owner pays nothing at all, and a single contested charge can freeze an entire balance while it is argued about.

The honest limit: this is liquidity, not solvency

In many communities a delinquent assessment is secured against the property in some form — whether it is, and what that security actually reaches, depends on the declaration and on state law, and is a question for the association's counsel. Where such security exists, it is a real difference from an ordinary commercial receivable, and any article that skips past it is overstating the danger. The balance is often not permanently lost; it may be recovered later, in whole or in part, when the property changes hands.

So an association's delinquency is rarely a bad debt in the sense a business would mean it. It is an illiquid asset. The distinction matters because it tells you what kind of problem you actually have, and therefore which instrument to reach for. A solvency problem means the money is gone. A liquidity problem means the money exists but is not available when the bills arrive.

That is not reassuring, and it should not be read as reassuring. Liquidity problems are what kill organizations in the meantime. ClearWave Pool Service does not accept a lien as payment. Caliber Community Insurance Group does not accept a lien as payment. The premium is due in March whether the eleven owners in the 120-plus bucket pay or not, and the fact that the association may eventually be made whole, possibly years from now, possibly on a resale, does nothing at all for March. Whatever security the association holds protects its balance sheet. It does not protect the operating account, and the operating account is what the community runs on.

The buckets and the question each one asks

What to do with this

1. Put the aging report in the monthly packet, by bucket, with an owner count in each bucket. Not the total. The distribution, and how many owners are in each band. The owner count is what tells you whether you have Association A or Association B.
2. Compute the average collection period once a year and chart it. One division, five years of history, one line. Ask the manager to add it to the year-end financial summary permanently, so the next board inherits the series rather than starting over.
3. Track the 61-to-90 bucket as your leading indicator. It is the bucket that predicts next year's 120-plus bucket. When it grows for two consecutive quarters, something has changed in the community and it has not shown up in the delinquency rate yet.
4. Ask what share of the 120-plus balance is assessments and what share is accumulated charges. A balance that is mostly charges behaves differently from one that is mostly assessments, and it is worth knowing which you have before deciding anything.
5. Separate the liquidity question from the recovery question in every collections discussion. "Will we get this money back?" and "Do we have the cash to pay the insurance premium in March?" are different questions. Boards routinely answer the first and act as though they have answered the second.
6. Get controls right before you get remedies right. Consistent billing, timely reminders, documented contact, escalation on fixed dates. Enforcement machinery layered on top of a sloppy billing process produces disputes rather than payments, and a disputed account pays nothing while it is disputed.