A landlord spreadsheet for the whole portfolio — 14 connected worksheets that track properties, tenants, rent, expenses, tax and maintenance. Most landlord templates give you an income column; this one runs the rental business. 262 live formulas do the counting, you do the landlording.

WHAT'S INSIDE (14 worksheets):
- Dashboard — occupancy, rent due vs collected, arrears, expiring leases, YTD cash flow: all live - Start Here — tax year and entity details once, every sheet builds on them - Properties — addresses, purchase price vs current value — portfolio gain calculates itself - Units — one row per rentable unit: market rent, deposits held, occupancy status - Tenants — contacts, deposits, move-in / lease end dates, months left counting down - Lease Tracker — lease status flags calculate themselves: EXPIRED or Renew soon (90-day window) - Rent Roll — 12 months of rent due vs paid per unit — balances and Paid / Partial / Unpaid status live - Income Log — rent, late fees, parking, laundry — by-type summary calculates itself - Expense Log — every cost with Y/N tax-deductible tag — feeds P&L, budget and Tax Summary - Expense Budget — monthly limits per category, actual pulls from Expense Log (SUMIF) - Property P&L — income, expenses, NOI, debt service and cash flow per property (SUMIFS) - Tax Summary — deductible expense totals by category — ready for your accountant - Maintenance — requests with priority and days open; open / overdue counters are automatic - Mortgage — loan register; annual interest and annual debt service calculate themselves

Real working formulas (262), not decorative cells: occupancy rate, arrears totals, lease expiry flags, per-property NOI and cash flow, deductible tax totals. Dropdown validations everywhere — no typos in your data.

WHO IT'S FOR:
- Landlords with 1-20 units who manage them without property software - Real estate investors tracking portfolio value, NOI and cash flow - First-time landlords who want the books right from day one - Self-managing owners preparing clean records for an accountant

FORMAT & DELIVERY:
- Instant download: .xlsx file — works in Microsoft Excel 2016+ AND Google Sheets (File → Import). Sample rows included to show how each sheet works — delete them and make it yours - Set up in 3 steps: download → open in Excel or drag into Google Sheets → register your properties and units first — every other sheet fills from there - Personal use. Covered by a 30-day money-back guarantee — message me if anything doesn't work and I'll fix it or help you set it up. Organisation tool, not tax advice — check big decisions with your accountant.