





Rental Property Tracker Spreadsheet
Rental Property Tracker Spreadsheet for landlords – keep rent, expenses, loans and repairs for up to 10 properties or units in one tidy file. Log a payment and…
- Instant download after checkout
- Secure checkout on Etsy
- Print at home or use digitally
Rental Property Tracker Spreadsheet for landlords – keep rent, expenses, loans and repairs for up to 10 properties or units in one tidy file. Log a payment and the rent roll marks it Paid, Paid late or Partial by itself; log a bill and your cash flow, occupancy and annual summary update. Light and dark versions included.
✦ WHAT'S INCLUDED – SPREADSHEET (12 tabs, light + dark version)
• Start Here – how to use it + your rentals at a glance
• Settings – tracking year, grace period for late rent, lease alert days, your own expense categories, payment methods and property types
• Properties – up to 10 properties or units: address, type, tenant and contact, lease start and end, monthly rent, rent due day, security deposit, purchase details; lease status (Active, Ending soon, Month-to-month, Vacant) and days left fill in by themselves
• Rent Roll – every unit and month: rent received, status (Paid, Paid late, Partial, Late, Due, Upcoming), rent due from the lease, collection % and late-month count; adjust any month for a vacancy or tenant change
• Income – rent, late fees, parking, laundry and other income (600 rows)
• Expenses – by property and category, or General for shared costs; flags missing receipts (700 rows)
• Loans + Loan Payments – type principal, interest and escrow from your statements (nothing is estimated); balances and yearly totals fill in by themselves
• Maintenance – repair requests with priority, status, vendor, cost and days open
• Annual Summary – income, expenses by category, interest, escrow, net income, principal and cash flow per property, plus rent collected and occupancy – handy for your tax preparer
• Dashboard – occupancy, rent collected, late rent, net income, cash flow, loan balances, leases ending soon, a property table, month-by-month table and 4 charts
• Example – sample entries for every tab
✦ WHAT'S INCLUDED – QUICK-START GUIDE (PDF, 7 pages)
• Opening the file in Google Sheets or Excel, step by step
• Your first 10 minutes
• A tour of every tab
• Tips & answers + a 15-minute monthly landlord check-in
✦ GREAT FOR
• Small landlords with 1 to 10 doors
• Duplex, condo, single-family and room rentals
• Real estate investors who want clean records at tax time
• Anyone moving their rent records off paper
✦ FORMAT
• 2 XLSX spreadsheets (light and dark version) for Microsoft Excel and Google Sheets (free)
• Quick-start guide PDF (US Letter)
• Digital download – no physical item will be shipped
✦ HOW TO USE
1. Complete checkout
2. Go to You > Purchases and reviews on Etsy (or the link in your email)
3. Click Download Files. Upload the spreadsheet to Google Drive and open it with Google Sheets, or open it in Excel
✦ GOOD TO KNOW
• Works in Excel (desktop, web and mobile) and Google Sheets – no macros, no add-ins
• Money cells use $ – switch to your own currency in a click (Format > Number). A record-keeping tool – not tax, legal or financial advice
• Personal use only; please do not share or resell the files
• Because this is a digital item, returns are not accepted – but if anything is wrong with your file, message us and we will fix it quickly
✦ ABOUT THIS DESIGN
Original design by Pagevine Studio, created with digital design tools (including AI assistance) and checked page by page before listing.
✦ MORE FROM PAGEVINE STUDIO
See more spreadsheets, planners and templates in our shop: https://www.etsy.com/shop/PagevineStudio
How your download works
Check out on Etsy, then open You › Purchases and reviews to download right away (Etsy also emails you a link). Unzip if needed, then print, import to GoodNotes, or open in the app named in the listing. Full guide.
License & use
For personal use unless the listing says commercial use. Please don't share or resell the files. Colors can vary a little between screens and printers.
Need help?
If anything is wrong with a file, message us with your Etsy order number and we'll fix it quickly.