Lease Expiration Tracker.

Build a lease expiration tracker for Bluebonnet Property Management in San Antonio, which manages 82 occupied units across three properties and wants to smooth out turnover instead of getting buried in summer move-outs. Layout. The top row pairs three stat cards (Expiring in Next 90 Days 19, Not Contacted Inside Notice Window 6, Average Proposed Increase 4.3%) with a stacked bar chart of expirations per month across the next 12 months, months on the x axis, lease count on the y axis, stacks colored by renewal status. The main region is a month-by-month grid: twelve month sections rendered as cards in a responsive grid, each headed by the month name and its lease count, listing that month's leases as compact rows with unit, tenant, current rent, proposed renewal rent, increase percent, notice deadline, and a status badge. Statuses and colors: Not Contacted gray, Offer Sent blue, Renewed green, Month-to-Month amber, Vacating red. Any lease inside its 60-day notice window that is still Not Contacted shows its deadline in red. A filter bar above the grid holds a status dropdown, a property dropdown, and quick chips for Inside 60 Days and Inside 90 Days that collapse the grid to matching leases only. Clicking a lease opens an edit dialog to update status, proposed rent, and notes; an Add Lease button opens the same dialog blank. Seed 82 leases with end dates staggered across the next 12 months so the grid is full on first load. Properties: Mission Flats (38 units, rents $950 to $1,350), Alamo Heights Cottages (26 units, $1,250 to $1,700), and Terrell Hills Homes (18 units, $1,500 to $2,100). Proposed renewal rents run 3 to 6 percent above current. Notice deadlines fall 60 days before each lease end. Status mix: 34 Not Contacted, 18 Offer Sent, 16 Renewed, 8 Month-to-Month, 6 Vacating, with sensible pairing so leases expiring soonest are mostly resolved. Plant the story: a clear summer spike, with 13 expirations in the month ten months out and 11 in the month eleven months out against a typical month of 5 to 7, the first three months totaling exactly 19, plus exactly 6 leases inside their 60-day window still Not Contacted so the stat card and the red deadlines agree. Compute increase percent, days to expiration, notice-window membership, and monthly counts; rents, dates, and statuses are entered. Use a muted crimson accent for primary actions, chart emphasis, and active filters, on a clean light neutral base, and let the status colors carry the grid.