Rental property spreadsheet for landlords

Small landlords need to know three things: who has paid, what each property cost, and what each one really earns.

The Rental Property Tracker is built for up to 10 properties or units. Enter properties once, record rent as it comes in and log bills. It flags late rent, tracks balances owed and works out NOI, cash flow, cap rate, cash-on-cash return and occupancy for each property and the whole portfolio. There is a 12-month rent ledger for each unit and a portfolio dashboard that also lists leases ending soon.

Works in Excel and Google Sheets. It is a record-keeping tool, not tax or investment advice.

What you get

You get two files, a blank template and a filled-in example, plus a Start Here guide. Open them in Microsoft Excel, or upload them to Google Drive and open them with Google Sheets (free). You type in the input cells; the formulas, totals and charts update themselves.

Tips

• Record rent on the day it arrives.
• Split shared bills across units consistently.
• Check leases ending soon each month.