Updated:
Multi Property Rent Tracker Spreadsheet
Example (made-up landlord, 4 properties, 8 units): the Portfolio sheet shows Cedar Court lost $4,343.11 after its mortgage from Jan 1 to Oct 31, while $2,195.00 of rent and late fees is still unpaid. Its Schedule E net is +$668.29, so an income-minus-expenses sheet would call it a winner.
Preview
What's inside
- Multi_Property_Rent_Tracker_2026_Example.xlsx
- Multi_Property_Rent_Tracker_2027_Blank.xlsx
Type each lease, payment and bill once. The workbook works out who is late, the late fee, who owes you now, the rent lost to empty units and each property's cash flow after the mortgage.
For landlords with 2 to 10 rentals: duplex to fourplex owners and self-managed homes and condos.
What you get:
- Multi_Property_Rent_Tracker_2026_Example.xlsx: a filled example (4 properties, 8 units, 10 tenancies)
- Multi_Property_Rent_Tracker_2027_Blank.xlsx: the same workbook, empty, set to 2027
Inside:
- Portfolio: collected, owed now, vacancy loss and cash flow per property, who owes you now, leases ending in 60 days, 4 data checks
- Rent Ledger: every tenant × 12 months, colored on time / after the grace days / still owing
- Property View: 12 months of one property on the Schedule E lines 5–19, with mortgage interest (line 12) split from principal
- Room for 10 properties, 60 units, 80 tenancies, 1,000 payments, 1,000 bills
Why it is different:
- Tested: an independent recount matches all 368 calculated values of the example, with zero formula errors.
- Late fees are calculated, not typed: grace days and fee per property, oldest rent paid first, move-ins prorated by the day.
- A plain .xlsx with no macros: it opens in Excel, not only in Google Sheets.
Format: US Letter landscape, $1,234.56, MM/DD/YYYY. Excel 2019+ / Microsoft 365, Google Sheets, LibreOffice.
How to use:
- Add properties, units and tenants.
- Type each payment and bill.
- Set the report date and read the Portfolio.
Record-keeping tool, not tax or legal advice. Depreciation (line 18) is not calculated.
- Fill-in guide in every file: a “Fill in with AI” chapter with ready-made sentences for an AI chat assistant, matched to the template’s fields
Need more than this one? ReadyStack Pass opens all 664 files and 553 full versions — $29/month or $199/year. See the Pass →
A template you fill in yourself — not legal or tax advice.