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 |
|---|---|---|---|---|---|---|
| 3309 | Rachel Jones t0004702 | $2,920.00 | $5,508.50 | $0.00 | $5,508.50 | 31–60 days |
| 3415 | Lisa Anderson t0004740 | $2,365.00 | $4,087.34 | $0.00 | $4,087.34 | 31–60 days |
| 2307 | Diego Evans t0004578 | $2,895.00 | $2,890.71 | $0.00 | $2,890.71 | 0–30 days |
| 1105 | Ana Roberts t0004399 | $2,285.00 | $2,063.08 | $0.00 | $2,063.08 | 0–30 days |
| 3411 | Emily Taylor t0004734 | $2,890.00 | $1,774.20 | $0.00 | $1,774.20 | 0–30 days |
| 1313 | Karen Evans t0004478 | $1,815.00 | $1,294.54 | $0.00 | $1,294.54 | 0–30 days |
| 2211 | Ingrid Brown t0004558 | $2,260.00 | $1,248.02 | $0.00 | $1,248.02 | 0–30 days |
| 2204 | Patricia Brooks t0004546 | $1,920.00 | $964.99 | $0.00 | $964.99 | 0–30 days |
8 positive-balance accounts · $19,831.38. 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 |
|---|---|---|---|---|---|
| 2410 | Daniel Medina | $0.00 | -$861.61 | -$861.61 | Credit balance — confirm refund or hold for next charge |
| 1308 | Nancy Chavez | $0.00 | -$1,813.52 | -$1,813.52 | 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.