Rental Property Tracker Spreadsheet | Landlord Income & Expense, Rent Log for Excel & Google Sheets
A simple landlord spreadsheet for up to 5 rental properties: log rent and expenses, and see each property's cash flow.
$12 on its own, or get it with 8 more business tools in the Self-Employed & Small Business Bundle for $29.
Works in Google Sheets and Excel · Instant download · Nothing shipped
What you get
Real screenshots of the actual tabs, taken from the same .xlsx file you download. All numbers are example data.
Who this is for
- You're a landlord with 1 to 5 rental properties.
- You want to log rent and expenses and see cash flow for each property.
- You want a heads-up when a lease is ending in the next 60 days.
Who it's not for
- Not for you if you have more than 5 properties in one file.
- Not for you if you need depreciation or a mortgage principal/interest split.
- Not for you if you want online rent collection, tenant screening or tax advice.
Need more than one?
This sheet is one of the 9 in the Self-Employed & Small Business Bundle. Get all 9 business tools for $29 (about $80 if bought one by one).
Get the bundle on Payhip – $29 See what's in the bundle
Need the home and the business sets? The Everything Bundle (what's inside) has all 22 (21 spreadsheets + the website template) for $39, about $149 if bought one by one.
Instant download. Works in Google Sheets and Excel (the website template is plain HTML/CSS).
Instant digital download, sold through Gumroad. Good for: rental property,landlord tracker,rent tracker,rental income,property expenses,real estate,landlord spreadsheet,excel template,google sheets,cash flow tracker.
2 separate spreadsheets (.xlsx files) in one zip: Rental Property Tracker v2, Rental Property Tracker. Each works in Excel and Google Sheets (import the .xlsx) and opens on a Start Here tab with a short how-to.
How it works
- Download the zip after checkout and unzip it.
- Open each .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
- Delete the example rows and type in your own numbers.
Previews and the files use example data only.
What's inside
- Rent log with tenant, amount due and paid. Short payments turn red.
- Expense log with 13 categories that roughly follow common Schedule E lines (rename them as you like).
- Summary by property (rent, expenses, net cash flow, year-to-date cash-on-cash return) and by month, with a chart.
- Spending by category for the year, handy at tax time.
- Tenants & leases tab: leases ending within 60 days turn orange.
Good to know
- Cash flow here = rent collected minus expenses you log. It doesn't calculate depreciation or split mortgage principal from interest.
- It's a spreadsheet, not an app. No bank syncing. Comes with example rows; delete them before you start.
- A tracking tool, not financial, tax or legal advice.
Previews
Works in Google Sheets and Excel · Instant download · Nothing shipped
Try the free rental cash flow calculator →
Frequently asked questions
Which apps does it open in?
Excel 2016 or newer (including Microsoft 365 and Excel for the web) and Google Sheets: upload the .xlsx to Google Drive, then open it with Google Sheets. You get one .xlsx file (Excel 2016+/Microsoft 365/Excel for the web, imports into Google Sheets) and a short how-to. Instant digital download.
What happens after checkout?
Gumroad emails you a receipt right after checkout; click View content in it to open your download page. You download a .zip with the .xlsx file(s) and a short how-to. It's an instant digital download; nothing physical ships.
Can I edit it?
Yes. Nothing is locked: rename categories, add rows, change colors and type over the example data.
Does it connect to my bank or send reminders?
No. It's a spreadsheet, not an app: you type in your own numbers and nothing is synced or sent.
Are the numbers in the previews real?
No. Previews and the file use example data only. Delete the example rows and add your own.
Can I get a refund?
It's a digital download, so if something doesn't open or work, reply to your Gumroad receipt and I'll help fix it. Refund requests are handled under Gumroad's refund policy. If you bought it on Payhip, message the shop there.
Is this financial advice?
No. It's an organizing and planning tool with example numbers, not financial, tax, legal or medical advice.
Works in Google Sheets and Excel · Instant download · Nothing shipped
Free guides that use this sheet
Pairs well with
Small Business Bookkeeping Tracker ($12)
For any other business income you run.
Not ready to buy? Start with the free Starter Budget Sheet.