Select contacts, then email or schedule a meeting. Edit the directory in Smartsheet.
Loading contacts…
Name
Title
Email
Phone
No contacts found in the Key Contacts sheet. Add rows there and refresh.
About this page
Building details
Static reference info about Vallone. Edit in code if any of these change.
Asset management calendar
Pulled live from Smartsheet (ID 3656008613187460). Overdue and due-within-14-day items are highlighted red; 15–30 days shows amber.
Key contacts
Pulled live from the Key Contacts sheet in Smartsheet (ID 7821428152815492). Add/remove rows there; changes appear on next page load.
Email selected
Opens Gmail compose in a new tab with the selected addresses pre-populated. Requires Google account.
Schedule meeting
Opens a new Google Calendar event page with attendees pre-filled. Requires Google account.
Pre-meeting briefing ·
Health check
Worth discussing this month
Snapshot
Suggested agenda
Copy into your meeting doc as a starting point. Non-dashboard topics (capital construction, holdovers, management issues) go in the Other section.
Overview
Net Operating Income
—
Income
Total Rental Income vs GPR
Total rental income
Gross potential rent
Total rental income is line 4699-9999. GPR is line 4320-0000 — face rent before concessions and subsidy offsets.
Expenses
Total Operating Expenses
—
By category — click a category to see its subcategory detail
⚠
Category
This Month
Monthly Budget
YTD Actual
Annual Budget
Variance
% of OpEx
Glossary
Physical occupancy
Occupied units / 99 × 100%.
Collections rate
Current payments received / current charges billed × 100% (Analysis of Charges — Property Total).
Gross potential rent (GPR)
Line 4320-0000 Residential Rent — face rent charged to occupied units before Section 8 offsets and concessions.
Concessions
Line 4390-0200 — rent discounts and preferential rent below face.
Total rental income
Line 4699-9999 Total Residential Rent Income.
Total miscellaneous income
Line 5790-9999 — non-rent income: laundry, keys, fees, insurance settlements.
Total income
Line 5999-9999 — full P&L income line.
NOI
Line 7999-9999 — total income − operating expenses. Can be distorted by journal reclassifications.
Net income
Line 8999-9999 — bottom line after all expenses including non-operating.
Cash flow
Net income after debt service.
Monthly budget
The 2026 annual budget for that category divided by 12. Not the budget figure printed on the monthly report.
Annual budget
The full-year 2026 budget for that category.
Overview
Cumulative NOI · T-12 · YTD
—
Income · In Depth
YTD Cumulative Income · T-12
—
Income · monthly
Expenses · In Depth
By category — click a category to see monthly detail
Category
Projected
Actual
Variance
Variance %
Annual Budget
Remaining
Expense category trends · monthly
Operating account balance · monthly
Operating account (monthly reports)
History
Total Income
Total OpEx
Budget
Glossary
Annual GPR
The year's projected rental income, from the 2026 annual budget (line 4389-9999 TOTAL GROSS POTENTIAL RENT = $1,964,016).
Monthly collections table
Per month: payments charged, payments received, collection rate (received/charged), and the flat budgeted GPR reference ($163,668 = annual GPR / 12).
Income · Projected
Budgeted Total Rental Income per month (line 4699-9999), from the 2026 annual budget. Spreads evenly across the 12 months at $155,485/month.
Income · Actual
Actual Total Residential Rent Income (line 4699-9999) from the monthly report. Compared apples-to-apples with the budget's rental income line.
Income · Variance
Actual − Projected. Positive (green) means over budget in income terms (good). Negative (red) means under budget.
Expenses · Projected
Sum of all 8 expense categories' PTD Budget figures (from the Budget Comparison report) for that month.
Expenses · Actual
TOTAL OPERATING EXPENSES line (7995-9999) for that month. Can be distorted by journal reclassifications — see the ⚠ flag on the Monthly Expenses tab when this happens.
Expenses · Variance
Projected − Actual. Positive (green) means under budget (good). Negative (red) means over budget.
Category breakdown
Click any month row to see Projected vs Actual for each of the 8 expense categories (Payroll, Insurance, Taxes, Administrative, Professional Fees, Repairs & Maintenance, Utilities, Other Operating).
CapEx
Capital Expenditures line (8320-0000) from the Non-Operating Expenses section of the Cash Flow Statement. Not included in Total OpEx or NOI.
Year-over-year totals based on uploaded reports. Years with partial data are noted.
Auto-updated each upload for leases within 150 days of expiration (including expired). Edit Renewal Status and Notes in Smartsheet.
Unit
Tenant
Lease end
Days left
Bucket
Status
Notes
Reserve balances
Operating Account (1110-0000), Operating Reserve (1189-0040), and Replacement Reserve (1189-0050) pull from the Bank Reconciliation each upload. Lender-Controlled and Owner-Controlled Replacement Reserve values marked with * are placeholders until their account designations are confirmed.
Reserve breakdown
Account
Purpose
Balance
Target
% of target
Reserve health notes
Industry benchmarks (placeholder targets)
Operating Reserve: 3–6 months of operating expenses. At ~$100k/month, that's $300k–$600k for Vallone.
Replacement Reserve: HUD guidance for senior housing is typically $300–$500 per unit per year. For 99 units accumulated over time, healthy balance is usually $300k+.
Tenant Security Deposits: Held in trust — not a true operating reserve but must always be fully backed by cash.
Once HSC confirms account designations, targets can be set explicitly per your ownership agreement.
Upload monthly report
Upload a PDF or Excel report — data is extracted automatically. Excel is faster and more accurate when available.
Drop PDF or Excel here — or click to browse
Monthly report (.pdf / .xlsx) · 12-month T-12 (.xlsx) · or a rent roll (.xlsx)
What gets extracted
Gross potential rent
Collection rate %
NOI & net income
Physical & economic occupancy
All expense categories
Aged receivables (0–90+ days)
Operating account balance
Top debtors list
Settings
API configuration
Your Anthropic API key and Smartsheet token are stored securely as environment variables on Cloudflare — they never touch the browser. To update them, go to your Cloudflare Pages project → Settings → Environment variables.
Data source
Choose which set of numbers the dashboard displays. Monthly Reports are the property manager's monthly statements (cash basis). The Corrected T-12 is the owner-provided trailing-12-month statement (accrual basis) — upload one on the Upload page to enable it.
Monthly Reports · cash basis · defaultEvery figure comes from the monthly PM statements, exactly as uploaded.
Corrected T-12 · accrual basisIncome, expenses, NOI, and CapEx come from the T-12 where available. Occupancy, collection rate, reserves, and aged receivables always fall back to the monthly reports — the T-12 doesn't carry them.
Accrual vs. cash: the T-12 is accrual-basis and the monthly reports are cash-basis, so the same month can legitimately differ between the two — a difference is not necessarily an error. One-time items (e.g. the insurance settlement, boiler CapEx) may also be booked differently. The T-12 view is best for a corrected annual picture; the monthly view reflects what actually hit the books each month.
Change password
Password is stored in this browser. Each team member will need to set it on their own device.
