Rent Roll Spreadsheet, Tenant Rent Ledger and Late Payment Tracker, Landlord Excel Template, Up to 20 Units
One row per unit with tenant, rent due, lease dates and monthly paid amounts. Shows the balance owed, late flags and the collection rate per month.
Works in Excel and Google Sheets. No macros, no external links. Yellow cells are inputs, blue cells are formulas. Tabs: Start Here, Units, Payments, Collections Summary.
If the file does not work as described and we cannot fix it within 3 days, we refund the order.