Rental Property Tracker for Landlords (Excel + Google Sheets)

DIGITAL SPREADSHEET: nothing is shipped.

A simple, organized record for small landlords with up to 10 rentals or units. Log rent as it comes in and expenses as you pay them, and see at a glance who has paid, what is owed, net cash flow per property, and which leases end soon.

AI disclosure: this item was created with the use of AI. LB3 Trackers designed it with AI assistance; AI tools helped write the formulas, layouts and instructions.

What's inside (10 tabs):

- Instructions

- Properties: address, monthly rent, due day, tenants, contact, lease start and end, deposit held

- Rent Ledger: 600 rows of date, property, the month the rent is for, amount and method; partial payments welcome

- Rent Status: a 12-month Paid / Partial / Unpaid grid for every unit, color coded

- Expenses: 800 rows of date, property, category, vendor, amount and where the receipt is saved; rename the 14 categories

- Maintenance: repair requests with vendor, status (Open, Scheduled, Done), date fixed and cost

- Summary: rent collected, expenses, net cash flow, rent due to date and balance owed per property, open repairs, lease-end alerts (within 60 days, adjustable), and a monthly rent vs expenses chart

- Settings and Lists

You get a SAMPLE file (two made-up rentals) and a BLANK file. Works in Excel, Google Sheets, LibreOffice and Numbers. No macros.

Please note: this is an organizational record-keeping tool. It does not calculate taxes or depreciation and is not tax, legal or accounting advice. Ask a qualified professional how to report rental income and expenses.

Instant download: after payment you get a download link right away.

Questions or a problem with the file? Message us through the store contact page. If the file doesn't work for you, we'll fix it or refund you.

License: personal / own-business use. Please don't resell or share the file.