Free Google Sheets rent payment tracker template for landlords

[Samuel Ralston]

I've spent the last several months deep in the landlord/self managing world researching how small portfolio owners track their rentals. Talked to a ton of people managing 5-20 units on Google Sheets.

One thing that kept coming up: everyone's spreadsheet layout is slightly different, and most of them have gaps that cause problems down the road. Missing columns, no summary formulas, no way to scan who's paid at a glance.

So I put together a rent payment tracker template based on what the best setups I've seen have in common:

- Columns for unit, tenant, amount, due date, and payment status

- Color coded status so you can scan who's paid, unpaid, overdue, or partial at a glance

- Summary formulas at the bottom for total collected vs outstanding, paid count, overdue count

- Works in Google Sheets and Excel, no macros or anything weird

I also made templates for maintenance tracking, lease renewals, and expense tracking.

All free, no signup. Happy to share the download link if anyone wants them.

Also happy to hear feedback on what columns or features you'd want that I might be missing.