Landlord Rental Manager | Google Sheets Rent Tracker with Late-Rent Reminders

Know who's paid, who's late, and what goes on your Schedule E, without doing the math.

A Google Sheet for landlords with 1–25 units. You type in your units and the payments you receive. The rent roll, late fees, dashboard and year-end tax summary fill in on their own.

What it does

• Rent Roll: every unit, every month, marked Paid, Partial, Due, Late, Upcoming or Vacant.
• Automatic late fees: flat or percent, applied after your grace period.
• Rowhouse menu (Google Sheets): record a payment in a simple form, email yourself who's late or due soon, optionally send tenants reminders in your own wording, and turn on daily reminders.
• Expenses sorted into IRS Schedule E categories.
• Schedule E Summary: tax-year totals per property for you and your tax preparer.
• Dashboard: this month's rent due, collected, still owed, occupancy, and a month-by-month chart.
• Maintenance log that posts finished repairs to Expenses in one click.

What you get

• A step-by-step setup guide (PDF) with the link to make your own Google Sheets copy (the automation is included)
• An Excel version with all the formulas (Excel doesn't run the Rowhouse menu)

Good to know

• You need a free Google account and a computer for the Google Sheets version. Custom menus don't appear in the Sheets phone app.
• The first time you use the Rowhouse menu, Google shows a "this app isn't verified" screen, because the script lives in your own copy of the sheet. The setup guide walks you through it. The script only works inside your spreadsheet and sends email from your own Google account.
• Supports up to 25 units and 5 properties. Rent due days 1–28.
• This is a record-keeping tool, not tax or legal advice. Depreciation isn't calculated.

Instant digital download. No physical item will ship. Made by Rowhouse Supply Co. with help from AI tools; every formula and script was tested before release.