A delinquency report is a property management document that lists every tenant carrying an unpaid balance, organized by how many days each amount is past due. It shows tenant name, unit, charges owed, and aging buckets such as 30, 60, and 90 days. The delinquency report is the operator's primary tool for tracking uncollected rent and prioritizing collections.
What Is in a Delinquency Report?
A delinquency report is built from three elements: the tenant and unit identity, the outstanding charge, and the aging bucket that shows how overdue each balance is. Per Rent Manager and rental accounting guidance, standard reports include tenant name, unit, invoice and due dates, amount due, and prior-period balances carried forward, grouped into 30, 60, and 90-plus day columns.
Column | Contents |
Tenant and unit | Who owes and which space |
Charge type | Base rent, CAM, late fees, other reimbursements |
Current | Billed this period, not yet past due |
1 to 30 days | Recently overdue, first follow-up |
31 to 60 days | Escalation, formal notice |
61 to 90 plus days | Legal review, potential eviction or write-off |
One rule governs a useful delinquency report: it must age balances, not just total them. A single "past due" figure hides whether a tenant is a week late or a quarter behind, and those two situations call for different actions.
Why the Delinquency Report Matters
The delinquency report matters because rent that is billed is not rent that is collected, and the gap between the two is where cash flow quietly erodes. Per FRED, the delinquency rate on commercial real estate loans held by all commercial banks rose from 0.95 percent in Q3 2023 to 1.05 percent in Q3 2024, a signal that tenant stress feeds directly into owner distress.
The report converts scattered late payments into a ranked action list. Accounts more than 30 days past due warrant formal notice, and balances beyond 60 days with no payment plan warrant escalation. Catching a slipping tenant at 30 days rather than 90 is the difference between a payment plan and a write-off.
It also feeds valuation. Economic occupancy, the share of potential rent actually collected, cannot be computed without knowing what went uncollected. A property at 95 percent physical occupancy but carrying heavy delinquency is worth less than its rent roll implies, and only the delinquency report exposes that gap.
Example
A small retail center runs its monthly delinquency report using representative figures. Five tenants carry balances, aged into buckets. The report ranks them by severity so the manager works the oldest, largest exposures first.
Tenant | Unit | Current | 31 to 60 | 61 to 90 plus | Total owed |
Cafe A | 101 | $2,000 | $0 | $0 | $2,000 |
Salon B | 102 | $0 | $3,200 | $0 | $3,200 |
Retailer C | 103 | $0 | $0 | $9,500 | $9,500 |
Office D | 104 | $1,500 | $1,500 | $0 | $3,000 |
Gym E | 105 | $0 | $0 | $4,800 | $4,800 |
Total | $3,500 | $4,700 | $14,300 | $22,500 |
Total delinquency is $3,500 plus $4,700 plus $14,300, or $22,500. The report tells the manager where to focus: $14,300 sits in the 61-plus bucket across Retailer C and Gym E, so those two accounts, not the $2,000 recently late cafe, drive the collections and legal effort this month.
Variations and Edge Cases
Delinquency reports differ by what they age and how they treat disputed or partial balances. Some report only base rent, others include CAM reconciliations and late fees, and treatment of prepayments and credits varies by system.
Variant | What it shows |
Rent-only delinquency | Base rent past due, excludes reimbursements |
Full-charge delinquency | Rent, CAM, late fees, and all billable charges |
Delinquency with notes | Adds status, payment plans, and legal actions |
Portfolio delinquency | Rolls up multiple properties into one view |
Net of prepayments | Offsets credits and deposits against balances owed |
The recurring error is reading a delinquency total without its aging. A property may show the same $22,500 owed in two months, but if the balance shifted from the 30-day bucket into the 90-day bucket, collectability fell sharply even though the total held flat.
Delinquency Report vs Accounts Receivable Aging
A delinquency report is often confused with an accounts receivable aging report, and they overlap heavily. An accounts receivable aging report lists all outstanding receivables by age, including current balances not yet due. A delinquency report focuses specifically on balances that are past due, the subset that requires collection action.
The difference is scope. An aging report answers "what is owed to us and how old is it," including this month's fresh invoices. A delinquency report answers "who is late and how late," filtering to overdue balances so the manager can act. In many systems the delinquency report is the past-due slice of the aging report.
Frequently Asked Questions
What is a delinquency report in property management?A delinquency report lists every tenant with a past-due balance, organized by how many days overdue each amount is. It shows tenant, unit, charges owed, and aging buckets so a manager can prioritize collections on the oldest and largest balances first.
How are delinquencies aged?Delinquencies are grouped into buckets by days past due, commonly current, 1 to 30, 31 to 60, and 61 to 90-plus days. Accounts more than 30 days past due are typically flagged for formal notice, and balances beyond 60 days are escalated.
Is a delinquency report the same as an aging report?No. An accounts receivable aging report lists all outstanding balances including current ones not yet due, while a delinquency report focuses on past-due balances that require collection. The delinquency report is effectively the overdue subset of the aging report.
Related Terms
Rent Roll
Accounts Receivable Aging
Economic Occupancy
Operating Budget
Net Operating Income