Daily roll-up of operating · reserves · investments per association. Pulled at 6 AM ET from each bank's API + AppFolio. Delta vs yesterday + vs prior month-end. Alerts on unusual moves.
| Association | Operating | Reserves | Investments (CD) | Total | Δ vs yesterday | Δ vs Mar 31 |
|---|---|---|---|---|---|---|
| Plaza Tower COA | $184,200 | $284,400 | $120,000 | $588,600 | +$1,840 | +$18,420 |
| Plaza Tower Master | $48,200 | $96,200 | $0 | $144,400 | +$420 | +$3,120 |
| Tallahassee Center COA | $92,400 | $210,800 | $60,000 | $363,200 | $0 | +$8,200 |
| Centerville HOA | $38,400 | $78,400 | $0 | $116,800 | +$960 | +$4,000 |
| Camellia Oaks COA | $24,200 | $42,100 | $0 | $66,300 | −$8,400 | −$12,200 |
| The Lakes (LUHOA) | $56,800 | $112,600 | $25,000 | $194,400 | +$2,200 | +$5,400 |
| The Timbers HOA | $32,200 | $88,200 | $0 | $120,400 | +$840 | +$3,840 |
| Other 11 associations · combined | $364,000 | $129,300 | $0 | $493,300 | +$3,200 | +$12,400 |
| Total · 18 associations | $840,400 | $1,042,000 | $205,000 | $2,087,400 | +$1,060 | −$12,420 |
Bars represent total cash · all 18. Last 2 weeks trending down (gold) — Camellia Oaks reserve drawdown for Q1 audit fees + 2 NOLA-stage write-offs portfolio-wide. Within expected range.
Single transfer to Drive Account confirmed by treasurer. 2024 audit fee payout to CRI ($8,200) + bank fees ($200). Expected · noted in audit-prep workspace. No action needed.
2 owner ACH payments + 1 estoppel payment. Routine collection day.
$60,000 CD at Capital City Bank matures May 12. Manager + treasurer notified. Renewal at current 4.6% APY rate confirmed in audit prep workspace.
Until this tool, each treasurer got a weekly email with last-week's bank balances. Stale, manually compiled, easy to miss anomalies.
API connections to First Federal + Capital City Bank fetch overnight. Reconciled against AppFolio. Cash position dashboarded by 6:30 AM ET.
Any same-day balance change > 5% triggers a manager alert. Normalizes across audit fees, NOLA recoveries, special assessments. Camellia Oaks audit fee was expected; not flagged.
Each treasurer sees only their association's data. Tizi sees the rollup. Drives BOD financial Q&A faster — answers like "what's our cash position right now" go from 24h to instant.
Investment CDs across 4 associations on a maturity calendar. Auto-reminds 30/14/0 days before. Treasurer reviews + decides renew vs reallocate.
Daily reconciliation between bank and AppFolio. Discrepancies > $50 fire to Kyle (accountant) for review. Most resolve within 24h (timing).
