Manage your rentals like a pro with this Rental Property Income & Expense Tracker for Excel and Google Sheets. Track multiple properties, tenants, rent and expenses in one place, and let the dashboard reveal your real cash flow.

What’s inside

A six-sheet workbook built for landlords and property investors.

Dashboard — portfolio totals and performance that update automatically
Properties — log each property with address, units, purchase price, monthly rent and status
Income — record rent and other income by property and tenant
Expenses — categorise repairs, mortgage, tax, insurance and more
Annual Summary — month-by-month totals across the whole year
Instructions — get set up in minutes

Who it’s for

Landlords with one property or a growing portfolio
Real estate investors tracking cash flow and returns
Anyone renting out a room, unit or holiday let
Property managers who need a simple, shareable record

How to use it

Download and open in Excel, or import into Google Sheets.
Add each property on the Properties sheet.
Log income and expenses as they happen.
Review the Dashboard and Annual Summary for a clear picture of performance.

Formats & delivery

Instant digital download. A ready-to-use .xlsx file compatible with Microsoft Excel and Google Sheets. No physical item is shipped.

Frequently asked questions

How many properties can I track?
Multiple — the Properties, Income and Expenses sheets are built to handle a whole portfolio.

Will it work in Google Sheets?
Yes, import the .xlsx and the formulas and dashboard carry over.

Is this tax advice?
No — it’s an organising tool to keep clean records. Always consult a qualified accountant for tax.

Can I customise categories?
Yes, all categories and labels are editable.

License

excel rental template

Rental Property Income & Expense Tracker | Excel & Google Sheets | Multi-Property Dashboard, Annual Summary | Landlord Spreadsheet