Spreadsheet · Excel + Google Sheets

Rental Property Tracker

Know what your rentals earn, who has paid, and what to hand your tax preparer.

$14.99

Works in Microsoft Excel and Google Sheets
10 tabs for up to 10 rentals or units
Blank tracker plus a filled example
7-page Getting Started guide (PDF)
Instant digital download

Get more and saveRental Property Planner BundleRental Property Planner + Rental Property Tracker. $24.99 instead of $29.98 separately.

The problem

Rent comes in, bills go out, and tax time sneaks up

When you have one or a few rentals, the money side often lives in a bank app, a shoebox of receipts, and your memory. It's hard to tell which unit is behind on rent or whether a rental actually made money this year. Then tax season comes and everything has to be sorted at once. This tracker keeps it all in one place, so the totals are ready when you need them.

Who it's for

Small and first-time landlords with 1 to 10 rentals or units
Owners renting out a mobile home, duplex, or the home they moved out of
Anyone who wants rent and receipts organized before tax time

What you'll be able to do

Know your numbers all year

See your year at a glanceThe dashboard shows income, cash out, net cash flow, rent collected, unpaid rent, and deposits held.
Know who has paidThe Rent Ledger shows rent due vs. paid for each unit, with rent still owed in red.
Never miss a lease dateLease status updates itself to Leased, Renew soon, or Vacant.
Log quicklyDropdowns for property, category, and payment method, plus a receipt saved check.
See what each rental earnsMonthly and property summaries, including shared costs.
Be ready for tax timeTotals by Schedule E category for each rental, plus mileage.

What's included

Everything in your download

Rental Property Tracker (.xlsx, blank) with 10 tabs: Start Here, Dashboard, Properties, Income, Expenses, Rent Ledger, Monthly Summary, Property Summary, Tax-Time Summary, and Mileage
Filled example with three sample rentals (a mobile home and a duplex) so you can see how it works
Getting Started guide (7-page PDF): how to open the file in Excel or Google Sheets and set it up step by step

How it works

Type in three places, the rest fills in

Add your propertiesList up to 10 rentals with rent, deposit, and lease dates.
Log income and expensesAdd each rent payment and each bill or receipt as it happens.
Check the dashboardSee cash flow, unpaid rent, and lease status at a glance.
Hand off the totalsAt tax time, share the Tax-Time Summary with your tax preparer.

Delivery

How you get it

This is a digital download. After checkout you get your download link right away and by email. Open the workbook in Excel, or upload it to Google Drive and open it with Google Sheets. Nothing ships.

For personal use. See the license and refund policy. This tracker is a record-keeping tool, not tax, legal, or accounting advice. Confirm how to report each item with a tax professional.

Questions

Frequently asked

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets (a free Google account works). It also works in Microsoft Excel. It has not been tested in Apple Numbers.

How many rentals can it track?

Up to 10 rentals or units.

Does it handle capital improvements and mortgage principal?

Yes. They are tracked separately from regular expenses.

I'm not a spreadsheet person. Is it hard?

You type in three places: Properties, Income, and Expenses. Everything else fills in, and the filled example and guide show you what goes where.

How do I get the files?

Right after checkout you get a download link on screen and by email.

Reviews

What customers say

No reviews yet. If you've used this tool, we'd love to hear how it went.

Write a review

Know what your rentals really earn

$14.99

Buy now · $14.99