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

Description

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

1. Download and open in Excel, or import into Google Sheets.
2. Add each property on the Properties sheet.
3. Log income and expenses as they happen.
4. 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.

You may also like

Small Business Bookkeeping & Tax Spreadsheet Business Financial Dashboard & Profit-Loss Tracker

License

For personal use. Use and edit the spreadsheet for your own property records. Please do not resell or redistribute the file. © Pixquo.