Rental Property Tracker Spreadsheet, Landlord Income & Expense + Rent Log (Excel & Google Sheets)

A simple landlord spreadsheet for up to 5 rental properties: log rent and expenses, and see each property's cash flow.

What it does:

Rent log with tenant, amount due and paid. Short payments turn red.

Expense log with 13 categories that roughly follow common Schedule E lines (rename them as you like).

Summary by property (rent, expenses, net cash flow, year-to-date cash-on-cash return) and by month, with a chart.

Spending by category for the year, handy at tax time.

Tenants & leases tab: leases ending within 60 days turn orange.

What you get: one .xlsx file (Excel 2016+/Microsoft 365/Excel for the web, imports into Google Sheets) and a short how-to. Instant digital download.

Honest notes:

Cash flow here = rent collected minus expenses you log. It doesn't calculate depreciation or split mortgage principal from interest.

It's a spreadsheet, not an app. No bank syncing. Comes with example rows; delete them before you start.

A tracking tool, not financial, tax or legal advice.

Instant digital download. Nothing physical ships. More free guides: https://cedarandledger.vercel.app/guides/

Running a business or side hustle? All 9 tools are in the Self-Employed Bundle for $29 ($80 separately): https://payhip.com/b/NQ2yK