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.

[Rachid Abadli]

@Samuel Ralston — solid template. Spreadsheets are genuinely the right answer for anyone with 1–3 units who's disciplined about updating them.

@John Underwood — your setup managing 35 properties across multiple LLCs with SDIRA and Solo 401(k) tracking in Excel is impressive. The fact that your CPA is happy tells me it's working. But I'd bet you're spending 3–5 hours a month maintaining it, and you've got institutional knowledge in your head that isn't in the spreadsheet. What happens if you're out for a month?

Here's the ceiling I hit with spreadsheets at 4 units: they track what happened, but they don't prevent what shouldn't happen. A spreadsheet won't flag a partial payment before you accidentally accept it. It won't auto-calculate a California late fee on day 2. It won't tell you that a tenant's lease expires in 45 days and you need to send a renewal notice.

The tracker-to-system jump is less about scale and more about risk. At 1–2 units in a landlord-friendly state, a spreadsheet is fine. In California, where accepting partial rent at the wrong time can blow up an eviction, I needed something that caught mistakes before they became legal problems.

@Kelly Hester — for expense tracking, the key thing most templates miss is categorizing by Schedule E line item from the start. Saves a ton of time at tax filing.