Property Management Spreadsheet, Landlord Rent Tracker, Tenant Lease Log, Maintenance, Rental Property Manager, Excel Google Sheets

Property Management Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Run the day-to-day of your rentals in one file: tenants and leases, rent collection with late fees, repairs, expenses, lease alerts and an owner dashboard. Perfect for landlords with 1 to 100 units. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info). ★ WHAT'S INCLUDED ★ • Clickable Start Here cover page with quick-start steps (10 tabs in total) • Owner Dashboard: occupancy, rent due and collected this month, outstanding rent, late fees, NOI, cap rate, cash flow, open repairs, leases ending soon, a by-property table and 2 charts • Properties: up to 15 buildings with value, cash invested and mortgage. Units, occupancy, rent collected, operating costs, NOI, cap rate, cash flow and cash-on-cash fill in automatically • Units & Tenants: 100 units with tenant, phone, email, lease start and end, rent, deposit, due day, status and lease alerts • Rent Payments: 1,500-row log. Due date, days late and late fees (flat $ or % of rent, after your grace period) are worked out • Rent Tracker: every unit and every month shown as Paid, Paid late, Partial, Unpaid or Due, plus scheduled vs collected rent and collection rate • Maintenance: 300 requests with category, priority, vendor, status, dates, cost, who paid and days open, with flags for urgent and overdue repairs • Expenses: 500 rows of operating costs by property and category • Lease Alerts: leases ending in the next 60 days (you choose the window) and leases past their end date, soonest first • Setup: grace period, late fee rule, vendors and drop-down lists • Sample data for 4 properties and 13 units ★ PERFECT FOR ★ ✓ Landlords with 1 to 100 units ✓ Small property managers ✓ Investors who self-manage their rentals ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 2 files included: an Excel version + a Google Sheets edition • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Set your late fee rule, vendors and lists on Setup. 2. Add your properties, then each unit and tenant with lease dates and rent. 3. Log rent payments, repairs and expenses as they happen. 4. Check Rent Tracker, Lease Alerts and the Owner Dashboard each week. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NOTE ★ • This is a digital download. Nothing will be shipped. • Late fee rules depend on your lease and local law. This is a record-keeping tool, not legal or financial advice. • Looking for tax categories and Schedule E totals instead? See the Rental Property Tracker in my shop. • Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.