Rental Property Income & Expense Tracker Spreadsheet
Every rental property you own, in one file: rent and every other payment that comes in, every expense that goes out by property and category, and the tracker works out your operating expenses, net operating income, mortgage payments, improvements, and cash flow for every month, every quarter, and every property, plus how much of the rent you expected has actually come in.
- Rent and every other payment in, every expense out, by property and by category
- Operating expenses, NOI, mortgage payments, improvements, and cash flow for every month, quarter, and property
- Rent collected against the rent you expected, and rent that is due but not in yet, at a glance
Instant download after checkout. Sales tax, where it applies, is added at checkout.
- Files
- Blank .xlsx + filled-in example .xlsx
- Made for
- Microsoft Excel and Google Sheets
- Inside
- A Properties tab for up to 8 properties with each one's income, operating expenses, NOI, debt service, capital, cash flow, and rent collected against expected, an income log, an expense log where every category counts as operating, debt service, or capital, a cash-flow-by-month grid per property, and a dashboard with tiles, month by month, by quarter, by property, every category, and three charts
Use this file for your own household or business. Do not resell, share, or redistribute the file or any part of it. Designed by Tally & Page with AI-assisted tools.
Features
What it does for you
- Up to 8 properties: income, operating expenses, NOI, debt service, capital, cash flow, rent collected vs expected, and NOI yield on the price for each
- Cash flow by month and property: a 12-month grid with a column per property and one for all of them
- Income log with 300 rows: property, tenant or unit, category, amount, payment method, received Yes/No; month and quarter worked out
- Expense log with 400 rows: property (or blank for all), paid to, category, amount, payment method, receipt Yes/No; what the category counts as worked out
- Every expense category counts as Operating, Debt service, or Capital on Setup, so NOI and cash flow come out right
- Month by month and by quarter: income, operating, NOI, debt service, capital, cash flow, and each month against your goal
- Dashboard tiles: rental income, operating expenses, NOI, cash flow, this month, rent collected vs expected, year to date vs goal, rent not yet received
- Every expense category with what it counts as, entries, amount, and share; three charts; a filled-in example plus a blank file
How it works
From checkout to your first entry
-
Buy and download
Your files are ready right after checkout. Nothing ships, and there is nothing to install.
-
Open the file
Open the blank copy in Microsoft Excel or upload it to Google Sheets. There are no macros, add-ins, or passwords.
-
Start with the example
Each spreadsheet comes twice: filled in with sample numbers, and blank. Read the example to see how the parts connect, then type your own numbers into the yellow cells of the blank copy.
More templates
More from Tally & Page
Questions
Before you buy
Is anything shipped to me?
No. Every template is a digital download. Right after checkout you land on your download page; bookmark it to download again later.
Can I use it for my business?
Yes, for your own household or business. Please don't resell, share, or redistribute the files or any part of them.
What if a file doesn't work?
Contact us from your order receipt within 10 days of purchase and describe what you see. We'll send a fixed file, or a refund if we can't make it work as described.
What do I need to use it?
Microsoft Excel and Google Sheets
Is it made with AI?
We design with AI-assisted tools. Before a file is listed, every spreadsheet is recalculated and checked for formula errors, and every link in a planner or guide is tested.
Is this financial, tax, or legal advice?
No. The templates help you organize your own numbers and work. For decisions about taxes, debt, or investments, talk with a qualified professional.





