I need a single, well-structured Excel workbook to manage my annual rental property portfolio I am looking for an Excel expert to build a professional workbook that will allow me to manage my mixed-use rental portfolio for an entire year without switching between multiple files. The model should remain in native Excel—no complex macros are strictly required, as long as the core tasks run smoothly. What the file must include: Contracts & Tenants Management Record tenant details, lease dates, rental amounts (annual and monthly), renewal dates, and security deposits. Quick filters to see who is due to renew or who has arrears at a glance. Rent & Payment Tracking Record monthly rent, other income, and utility bills (electricity/water). Automated tracking of due and overdue payments with reminders. Roll up data into quarterly and annual summaries automatically. Expenses & Maintenance Log operating expenses and maintenance requests. Assign a status, note completion dates, and record costs. Outstanding items should display clearly on a dashboard. Reports & Dashboards Monthly and annual revenue vs. expenses reports. Performance dashboard comparing best- and worst-performing properties. Clear alerts for expiring contracts, unpaid rent, and pending maintenance. Design Requirements: Clean interface with separate but linked sheets or a dashboard page. Built-in data validation, drop-downs for common categories, and simple conditional formatting. Transparent calculations so I can adjust or expand formulas later if needed. Deliverables: A ready-to-use .xlsx file where I can plug in my existing data. Brief user notes inside the workbook itself (no separate documentation required). landlordstudio.com