Delinquency & Collections
Balances to review
positive net balances by resident account · top tenPositive values from the aging's Balance column, after each account's prepays. Colour follows the oldest bucket with a charge in it.
Unpaid charges by age
gross positive charges · before prepaysAging of positive unpaid charges before prepays. 0–30 days is the charge-age bucket; it does not by itself establish that a payment is late.
Collections review list
08/31/2026 aging · sorted by net balance| Unit | Resident account | Monthly rent | Unpaid charges | Prepays | Net balance | Charge age |
|---|---|---|---|---|---|---|
| 9203 | Mark Nelson t0006104 | $1,565.00 | $4,605.26 | $0.00 | $4,605.26 | 61–90 days |
| 2104 | Deborah Williams t0005332 | $1,820.00 | $3,348.23 | $0.00 | $3,348.23 | 31–60 days |
| 1106 | Diego Sanchez t0005235 | $1,805.00 | $3,171.07 | $0.00 | $3,171.07 | 31–60 days |
| 7208 | Daniel Howard t0005918 | $1,700.00 | $2,981.04 | $0.00 | $2,981.04 | 31–60 days |
| 10107 | Rafael Garcia t0006183 | $1,830.00 | $1,936.98 | $0.00 | $1,936.98 | 0–30 days |
| 9107 | Miguel Bailey t0006070 | $1,620.00 | $1,588.95 | $0.00 | $1,588.95 | 0–30 days |
| 5204 | Nadia Collins t0005700 | $1,900.00 | $1,213.09 | $0.00 | $1,213.09 | 0–30 days |
| 5201 | Ashley Gutierrez t0005685 | $1,545.00 | $1,135.92 | $0.00 | $1,135.92 | 0–30 days |
| 10103 | Carlos Alvarez t0006163 | $1,795.00 | $1,098.04 | $0.00 | $1,098.04 | 0–30 days |
| 1209 | Ingrid Nelson t0005296 | $1,820.00 | $522.27 | $0.00 | $522.27 | 0–30 days |
10 positive-balance accounts · $21,600.85. Confirm the current resident ledger before outreach; the aging is the 08/31/2026 snapshot and ties to Accounts Receivable on that month's balance sheet.
Payment-allocation review
accounts with prepays or offsetting charges| Unit | Resident account | Unpaid charges | Prepays | Net balance | Suggested review |
|---|---|---|---|---|---|
| 8209 | Pamela Young | $0.00 | -$1,073.88 | -$1,073.88 | Credit balance — confirm refund or hold for next charge |
| 10209 | Omar Rogers | $0.00 | -$1,090.72 | -$1,090.72 | Credit balance — confirm refund or hold for next charge |
| 6102 | Kevin Edwards | $0.00 | -$1,470.63 | -$1,470.63 | Credit balance — confirm refund or hold for next charge |
Receivables trend
12 months · Accounts Receivable, accrual balance sheetThe August point equals the sum of unpaid charges on this aging; earlier months are the ledger balance.
Definitions & report reconciliation
Unpaid charges are the gross positive buckets (0–30, 31–60, 61–90, over 90). Prepays are credits on the account. Net balance = unpaid − prepays, and only positive net balances count as delinquency on the portfolio page and in the threshold chips. The dashboard therefore filters to positive open AR, as the spec asks, while the review list keeps the credits visible so nobody chases a resident who has already paid ahead.
The verify script asserts that the buckets sum to unpaid total, that net = unpaid − prepays, that the balance-sheet A/R and prepaid-rent lines equal these totals, and that exactly one balance in the portfolio is over 90 days.