A real accounting spreadsheet built for landlords who want to run their properties like a business.
Track income, expenses, NOI, and cash flow across up to 3 rental properties — all in one fully linked Excel workbook. Enter your actuals each month and every number flows automatically through the entire file. No manual linking, no broken formulas.
What's included:
- Instructions tab — color-coded setup guide so you're running in minutes
- Assumptions tab — enter your rents, vacancy rate, and annual expenses once; everything else updates automatically
- 3 Property tabs (A, B, C) — log monthly actuals by unit, with budget vs. actual and variance for every line item
- Annual Summary tab — full-year budget vs. actual by property and combined portfolio, linked live from your monthly trackers
- Dashboard tab — KPI snapshot including NOI, cash-on-cash return, cap rate, and expense ratio by property
- Schedule E tab — year-end tax summary linked to your actuals, labeled by IRS line number, ready to hand to your CPA
Built for:
Independent landlords with 1–3 properties who want proper double-entry thinking — not just a rent roll. Written by a landlord with 20+ years in nonprofit and independent school finance.
Instant download. Editable Excel (.xlsx). Works in Google Sheets.