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 |
|---|---|---|---|---|---|---|
| 4107 | Carlos Aguilar t0000778 | $1,840.00 | $1,974.29 | $0.00 | $1,974.29 | 0–30 days |
| 3204 | Kevin Lee t0000557 | $1,780.00 | $1,656.65 | $0.00 | $1,656.65 | 0–30 days |
| 1201 | Hiro Clark t0000044 | $1,665.00 | $1,413.37 | $0.00 | $1,413.37 | 0–30 days |
| 4202 | Olivia Green t0000810 | $2,240.00 | $909.11 | $0.00 | $909.11 | 0–30 days |
| 1509 | Juan Richardson t0000238 | $2,330.00 | $788.39 | $0.00 | $788.39 | 0–30 days |
| 2303 | Sharon Guzman t0000362 | $2,350.00 | $613.14 | $0.00 | $613.14 | 0–30 days |
6 positive-balance accounts · $7,354.95. 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 |
|---|---|---|---|---|---|
| 3309 | Elizabeth Clark | $0.00 | -$1,320.96 | -$1,320.96 | Credit balance — confirm refund or hold for next charge |
| 1401 | David Romero | $0.00 | -$1,392.20 | -$1,392.20 | Credit balance — confirm refund or hold for next charge |
| 3202 | Debra Ramos | $0.00 | -$1,561.67 | -$1,561.67 | 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.