Landlord Rental Property Tracker Excel & Google Sheets Income Expense Log
Built for small landlords who manage a handful of properties or units, not a property management company. Track rent, expenses, repairs and tenant details for up to 6 properties in one spreadsheet — no more juggling notebooks, texts and separate files for each unit.
What's inside the workbook:- Properties & Units — every property or unit you rent out: address, current tenant, lease start and end dates, monthly rent and security deposit. Lease status (Active, Upcoming, Lease ended) updates on its own.- Income & Expenses — one 12-month block per property, pulled in by name automatically. Log rent collected, other income and 7 expense categories (mortgage interest, property tax, insurance, repairs, utilities, management/HOA and other); totals and net income are calculated for you.- Maintenance Log — date, description, cost and vendor for every repair and upkeep job, across all your properties.- Tenant Contacts — phone, email and emergency contact for every tenant, with room for roommates or additional leaseholders on the same unit.- Yearly Summary — per-property and whole-portfolio totals for rent, other income, expenses and net income, pulled in automatically.- Instructions tab built right into the workbook.
Included in this instant download:- LandlordRentalPropertyTracker.xlsx — the full editable workbook- LandlordRentalPropertyTracker.pdf — printable blank version of every tab
Works in Microsoft Excel, Google Sheets and LibreOffice Calc. Only the shaded input cells are meant for typing — everything else is protected so the formulas don't break by accident.
This workbook is a record-keeping and organization tool only — it is not tax or legal advice. Check which expenses are deductible for your situation with a qualified tax professional before filing. All names, addresses and amounts shown in the preview images are examples only.
Because this is a digital file, returns and exchanges are not accepted. If anything is wrong with your file, contact us through this store and we'll fix it quickly.
Made with the help of AI tools; all designs are original, not copied from another creator.