Rental Property Tracker Spreadsheet
$24.99 USD · instant download
A live command center for DIY landlords: portfolio dashboard, rent roll with renewal alerts, expense log, and per-property P&L.
Buy Now — $24.99Secure checkout via Gumroad · buy once, use forever
Who it's for
DIY landlords with a handful of units live in spreadsheet chaos: rent tracked in one place, expenses in another, and tax season becomes a forensic investigation. This Rental Property Tracker gives you a live command center for 1–10 units — portfolio dashboard, rent roll, expense log, and per-property P&L in one file, all automatic.
It's for landlords who love the income but dread the admin: side-hustle landlords, accidental landlords, and small-portfolio investors who want professional-grade tracking without property management software fees.
What's inside
- Dashboard: total monthly rent, units, occupancy %, expenses, net cash flow, and annual ROI % — live, plus a per-property snapshot table that flags negative cash flow in red and vacancies in amber.
- Properties tab: address, units, purchase price, rent, mortgage, tax, insurance, HOA, and other expenses per property.
- Rent Roll: tenant, unit, lease dates, rent due day, and status (Occupied / Vacant / Notice Given), with an automatic days-until-lease-end countdown and RENEW SOON alerts inside 60 days.
- Expense Log + Per-Property P&L: categorized expenses with vendor tracking flow into an annual P&L per property — gross rent, vacancy loss, NOI, mortgage, cash flow, and ROI %.
How it works
- Download the .xlsx file instantly after checkout.
- Open in Excel or import into Google Sheets (File → Import → Upload).
- Replace the amber example rows with your properties and start logging — every formula updates instantly.
Frequently asked questions
How many properties does it handle?
It's designed for 1–10 units — the sweet spot for DIY landlords. The structure scales cleanly within that range.
Does it calculate ROI?
Yes: per-property and portfolio-level ROI, plus cash flow, NOI, vacancy loss, and occupancy — all formula-driven and tested.
What are the RENEW SOON alerts?
The rent roll counts down days until each lease ends and flags any lease expiring within 60 days, so renewals never sneak up on you.
Excel or Google Sheets?
Both. It's a standard .xlsx that imports cleanly into Sheets.
Get the Rental Property Tracker Spreadsheet
Instant download. Yours forever.
Buy Now — $24.99
