Property management accounts receivable aging: ow to read it, what each bucket means, and what to do next

KEY TAKEAWAYS

• The accounts receivable aging report is a diagnostic tool, not a collections tool. It shows where balances are accumulating in the portfolio and what the trajectory of each delinquency looks like , information the PM company needs before deciding what to do, not after the situation has already escalated.

• The four columns track the age of each outstanding accounts receivable balance. Current (due but not yet past due), 30-day (one missed or partial payment cycle), 60-day (two cycles missed , formal intervention territory), 90-day and over (likely write-off or eviction decision). Most PM companies act on the 90-day column. The ones with the lowest write-off rates act on the 30-day column before balances migrate.

• The aging report and the trust account reconciliation must produce the same number for outstanding tenant balances. A tenant in the 60-day bucket has not paid rent for two months, which means the owner's trust account sub-ledger is lighter by that amount. If the aging report and the trust account do not agree, there is an unrecorded transaction or a timing error in the books.

• A clean aging report is a financial reporting document, not just an operational tool. Lenders reviewing an owner's refinancing package look at the aging report alongside the rent roll. A portfolio with no balances in the 60-day and 90-day columns signals operational strength. A portfolio with chronic balances in those columns signals a collections problem the lender will adjust for in their underwriting.

• Run the aging report on the same day every month, before disbursements are released. Disbursements made before the aging report is reviewed risk releasing funds based on stale data , specifically, funds that should be held pending the resolution of balances that have migrated into the 60-day or 90-day column since the prior review.

Think of the accounts receivable aging report as a blood panel for your portfolio. The current column is a resting heart rate , baseline healthy. The 30-day column is elevated cholesterol: worth monitoring, not yet a crisis. The 60-day column is borderline hypertension: a real condition that needs active management before it worsens. The 90-day-and-over column is acute: something must happen today, because every day of inaction makes the resolution more expensive and the outcome less certain.

Most PM companies run this report monthly and act on the 90-day column. The ones with the lowest delinquency rates, the cleanest trust accounts, and the most defensible owner statements act on the 30-day column before balances migrate. In our work reviewing aging reports across PM portfolios at Numetix, the single most predictive signal of a portfolio-wide delinquency problem is not the size of the 90-day column , it is the growth rate of the 30-day column month-over-month. By the time the 90-day column is large, the window for low-cost intervention has closed. Numetix takes an expert-led, AI-powered, and human-in-the-loop approach to this: the aging report is reviewed, tiered, and actioned before disbursements release each month, not after.

QUICK ANSWER: What is an accounts receivable aging report in property management?

• An accounts receivable aging report is a snapshot of all outstanding tenant balances organized by how long they have been unpaid. It groups balances into four buckets: current, 30-day past due, 60-day past due, and 90-day and over. Each bucket represents a different stage of delinquency and warrants a different response , from a routine reminder call at 30 days to an eviction initiation or write-off decision at 90 days.

• The report is a diagnostic before it is a collection tool. It tells the PM company where the delinquency is concentrated, which units or tenants are trending toward escalation, and whether the overall portfolio health is improving or deteriorating month-over-month. A rising 30-day column this month predicts a larger 60-day column next month unless intervention occurs.

• The aging report must reconcile to the trust account. Every balance in the aging report represents funds expected but not received, which means the owner's trust account sub-ledger is lighter by that amount. The trust account reconciliation cannot be considered complete until the outstanding AR balances in the aging report and the trust account sub-ledgers agree.

What the aging report columns actually mean

The four buckets in an accounts receivable aging report are not arbitrary divisions. Each one represents a meaningful difference in the relationship between the tenant and the payment obligation, and each one warrants a different PM company response.

Current. Rent is due but not yet past the grace period. Nothing to act on. Monitor to confirm payment clears within the grace period defined in the lease.

30-day. One payment cycle has passed without full payment. The tenant has missed or partially paid one month. At this stage, the most effective intervention is direct contact: a phone call, not a letter. Most 30-day balances in residential PM are addressable , financial hardship, banking error, communication gap. A brief personal call resolves a meaningful percentage before they migrate. The 30-day bucket is where the lowest-cost intervention is available. The rent collection and delinquency guide covers the full outreach workflow that converts 30-day delinquencies back to current.

60-day. Two payment cycles have passed without resolution. The tenant has either ignored the 30-day outreach or cannot pay. This is formal intervention territory: a written demand, a notice as required by state law, and a documented payment plan if one is offered. Extending informal arrangements past the 60-day threshold typically does not improve the outcome; it delays the formal process while the balance grows. Most PM companies should have an eviction initiation protocol that begins within days of a balance entering the 60-day column, not weeks.

90-day and over. The balance has been outstanding for three or more payment cycles. The remaining options are: payment in full, a negotiated settlement, a payment plan secured by written agreement, eviction filing, or write-off. At this stage, each additional day of inaction increases the ultimate loss to the owner. The decision must be made and documented: what is the action, who is responsible, and what is the timeline. The detailed collections framework for balances in this column is covered in the PM collections guide.

How to read the aging report as a portfolio health signal

Any single month's aging report shows where balances are. The month-over-month comparison of aging reports shows where they are going. These three metrics tell the story:

30-day column total, month-over-month. If this number is growing, balances are entering delinquency faster than they are being resolved. This is the early warning signal. A rising 30-day total in July predicts a larger 60-day total in August unless intervention accelerates.

Migration rate. What percentage of balances that were in the 30-day column last month are now in the 60-day column? A migration rate above 50% means outreach is not working. Either the outreach is not happening, it is not reaching the right people, or the tenants are unable to pay regardless of outreach. Each of these has a different response.

Write-off rate. How much is written off per month as a percentage of gross rent billed? A write-off rate consistently above 1% of gross potential rent suggests a screening problem (accepting tenants who cannot sustain the rent level), a collections problem (not pursuing balances aggressively enough), or a property problem (a building where tenant financial instability is concentrated).

How the aging report connects to the trust account reconciliation

The aging report and the trust account must agree on the outstanding receivable balance. Every tenant balance in the aging report represents rent that was expected but not received. The corresponding trust account sub-ledger for that owner shows a balance that is lower by that amount. If the aging report shows $4,200 in outstanding receivables across three tenants and the trust account sub-ledger for those owners shows $4,200 less than a fully-paying month, the books are consistent. If they differ, there is an unrecorded transaction, a coding error, or a timing mismatch that must be resolved before disbursements release.

This is why the aging report review must precede the trust account reconciliation in the monthly close sequence. Reviewing the aging report first identifies every outstanding balance. The trust account reconciliation then confirms that those balances are reflected correctly in the sub-ledger structure. The three-way reconciliation guide covers how outstanding tenant balances integrate into the full reconciliation structure.

What lenders see when they review the aging report

A lender reviewing an owner's refinancing package looks at the aging report as a signal of operational quality. A portfolio where all balances are current or in the 30-day column demonstrates that the PM company is collecting efficiently and that the tenant base is financially stable. A portfolio with chronic 60-day and 90-day balances suggests a PM company that is not pursuing collections aggressively, or a tenant base that cannot sustain the current rent level, or both. Either finding affects the lender's comfort with the income projections in the refinancing underwriting.

The most important number in the aging report for lender review is the percentage of gross potential rent that sits in the 60-day and 90-day columns. Below 2% is a healthy portfolio. Above 5% raises questions the PM company will need to answer in writing. The monthly financial statements guide covers how to package the aging report alongside the rent roll and income statement in the owner reporting package that supports a refinancing.

Frequently asked questions

How often should property managers run the accounts receivable aging report?

Monthly at minimum, as part of the month-end close sequence, before disbursements are released. PM companies managing larger portfolios or portfolios with higher delinquency rates benefit from a weekly aging review , not a full reconciliation, but a quick check on which balances moved between buckets in the past seven days. The timing matters: running the aging report after disbursements have been released means releasing funds before knowing whether the outstanding balance picture has changed since the prior month. The standard practice is aging report review, then trust account reconciliation, then disbursement release , in that sequence every month.

At what point is a tenant balance written off as uncollectable?

There is no universal rule, and the timing should be documented on a case-by-case basis rather than applied mechanically to any specific bucket. In practice, most PM companies write off balances when two conditions are both met: a legal judgment has been entered (or the eviction process is complete and no judgment was pursued), and a skip trace or collection attempt has confirmed that garnishable income or assets are not available. Writing off before these conditions are met understates the owner's potential recovery. Writing off too long after these conditions are met leaves a phantom asset in the books and overstates the owner's expected income. The documentation supporting the write-off decision should include the date, the basis (judgment date plus collection attempt), and the amount.

How does a high AR aging balance affect the owner's monthly disbursement?

Directly and proportionately. A tenant in the 60-day column has not paid for two months, which means the owner has collected two months less than the rent roll would suggest. The disbursement is calculated on what was actually received, not what was billed. For an owner with a 10-unit property where one unit has a $2,900 outstanding balance, the disbursement is $2,900 lower than a fully-paying period, and the owner statement should show this as a specific line: "Unit 7B outstanding balance: $2,900 , two months unpaid, formal notice issued." Presenting it this way prevents the owner from interpreting the disbursement reduction as an unexplained accounting discrepancy and initiates an informed conversation about the status of the collection effort.

For property management firms that need the aging report reviewed before every disbursement cycle, each bucket actioned systematically, and outstanding balances reconciled to the trust account before month-end close, our accounting services run the aging review as a standard step in the monthly close sequence, expert-led, AI-powered, and human-in-the-loop.

See the complete guide to property management accounting for the framework connecting the aging report to trust accounting, disbursements, and owner financial reporting.