The Rental Property Spreadsheet: What to Track, How to Set It Up, and When to Replace It
A rental property spreadsheet should track seven things per property at minimum: gross rent, vacancy loss, operating expenses, debt service, monthly cash flow, cash-on-cash return, and lease expiration date. Most investor spreadsheets fail because the rent and expense inputs go stale within months and nobody updates them, even when all the right columns are there.
If you own two or more rentals, you need a system, and a spreadsheet is a fine place to start. Below is the exact framework (what to track, how to lay it out, and a worked example with four properties), plus where spreadsheets hit their ceiling and what to do when they do.
What Your Rental Property Spreadsheet Needs to Track
Every property in your portfolio needs seven numbers, and if you skip any one of them, your spreadsheet will give you the wrong picture.
1. Gross Scheduled Rent
This is what the property should collect if every unit is occupied at current lease rates for 12 months. It's your top-line number, and everything else in the spreadsheet is calculated from it.
Where to get it: your lease agreement. Update it every time a lease renews or a new tenant signs.
2. Vacancy Loss
Budget 8% of gross rent, which accounts for roughly one turnover per year with 3-4 weeks of downtime plus make-ready costs. If you're using 5% or "zero because I've never had a vacancy," your cash flow projection is wrong. A single turnover typically costs 3-4 weeks of lost rent plus $500-1,500 in make-ready expenses.
How often it changes: annually, based on actual vacancy experience. Keep 8% as your baseline until you have 3+ years of history on a specific property.
3. Operating Expenses (Itemized)
Don't use a single lump number. Break it out into these lines:
- Property taxes: from your county assessor, not the listing. Verify annually; these can jump 10–20% after reassessment.
- Insurance: landlord dwelling policy, not homeowner's. A landlord policy typically runs 15–25% higher. Requote every 2 years.
- Property management: 10% of gross rent. Include this even if you self-manage, because your cash-on-cash return shouldn't depend on free labor. If you choose to self-manage, treat the savings as bonus return, not baseline.
- Maintenance reserve: 5% of gross rent. Covers routine repairs: faucets, locks, HVAC filters, garbage disposals, appliance fixes.
- CapEx reserve: 5% of gross rent. Covers major replacements such as the roof ($8,000-15,000), HVAC ($4,000-8,000), and water heater ($1,200-2,000), and you should track these in a dedicated rental property expenses spreadsheet. If you skip this line item, you'll wonder where $6,000 went in year three when the furnace dies.
For the formulas behind each line, see our rental property calculator walkthrough.
4. Debt Service
Your monthly principal and interest payment. If you have multiple loans on a property (first mortgage plus HELOC, for example), combine them. This number only changes at refinance.
5. Monthly Net Cash Flow
Cash Flow = (Gross Rent − Vacancy − Operating Expenses) ÷ 12 − Monthly Debt Service
This is what actually lands in your bank account, so it's the number to check first. A property can have strong NOI but negative cash flow if you're over-leveraged.
6. Cash-on-Cash Return
Cash-on-Cash = Annual Cash Flow ÷ Total Cash Invested × 100
Total cash invested = down payment + closing costs + rehab. This metric tells you whether your money is earning enough. Most experienced investors target 8-12% cash-on-cash for a conventional buy-and-hold, though with 7%+ rates in 2026, many portfolios are running 3-6% and relying on principal paydown and rent growth to justify the hold.
For a deep dive on this metric, see our cash-on-cash return guide.
7. Lease Expiration Date
This is the most actionable number in your spreadsheet, and the one most investors forget to include. Every lease expiration is a decision point: renew at the current rate, adjust to market, or prepare for turnover. If you don't know which leases expire in the next 90 days, you're making those decisions reactively instead of with data.
For multi-unit properties, track each unit's lease date separately.
Portfolio-Level Roll-Ups
Tracking per-property numbers is step one, but the spreadsheet becomes truly useful when it rolls everything up into a portfolio view with these four totals:
Total monthly cash flow across all properties. This is the number that matters most. If one property is negative but the portfolio is positive, you can carry it, but if the portfolio is negative, you have a structural problem.
Total annual NOI: gross income minus vacancy minus operating expenses, before debt service, across the portfolio. Lenders care about this number, and you should too, because NOI drives valuation. Your building's market value is roughly NOI ÷ cap rate, so underpriced rents cost you monthly cash flow and also lower what your buildings are worth.
Weighted average cash-on-cash return: total annual cash flow ÷ total cash invested. This tells you how your portfolio is performing as a whole, beyond the individual properties. A 4.7% property and a 0.6% property average out differently depending on how much capital is in each.
Lease expirations in the next 90 days: your action list. These are the properties where you need current rent comps before you set renewal terms, not after.
If you can't see these four numbers in one glance, your spreadsheet isn't doing its job.
Example: 4-Property Portfolio Spreadsheet
Here's what a working rental property spreadsheet looks like, with four properties, all numbers visible, and portfolio totals at the bottom.
Per-Property View
| Property A | Property B | Property C | Property D | |
|---|---|---|---|---|
| Type | 3BR SFH | Duplex (2 units) | 4BR SFH | Triplex (3 units) |
| Purchase price | $145,000 | $250,000 | $210,000 | $285,000 |
| Total cash invested | $42,000 | $65,000 | $62,000 | $75,000 |
| Gross rent/mo | $1,450 | $2,900 | $2,050 | $3,300 |
| NOI/mo | $825 | $1,642 | $1,126 | $1,877 |
| P&I/mo | $755 | $1,389 | $1,094 | $1,583 |
| Cash flow/mo | $70 | $253 | $32 | $294 |
| Cash-on-cash | 2.0% | 4.7% | 0.6% | 4.7% |
| Lease expires | Aug 2026 | Mar / Nov 2026 | Jun 2026 | Jan '27 / Apr / Sep 2026 |
Portfolio Dashboard
| Metric | Value |
|---|---|
| Total monthly cash flow | $649 |
| Total annual cash flow | $7,788 |
| Total annual NOI | $65,645 |
| Total cash invested | $244,000 |
| Weighted avg cash-on-cash | 3.2% |
| Leases expiring next 90 days | Property B Unit A (Mar), Property D Unit B (Apr) |
What This Tells You at a Glance
The portfolio cash-flows $649/mo, which is positive but thin. The 3.2% weighted cash-on-cash is below the 8% target, which is typical with 30-year fixed rates averaging 7.43% as of October 2026. The value in holding comes from principal paydown and long-term rent growth rather than current yield.
Property C is the weakest performer at 0.6% cash-on-cash. That raises a question this spreadsheet can't answer: is $2,050/mo at market? If Property C is $150/mo below comparable 4BR SFHs in that zip code, adjusting at the June renewal would bring cash flow from $32/mo to $140/mo and cash-on-cash from 0.6% to 2.7%. That single adjustment adds $1,296/yr in cash flow. At a 7% cap rate, the NOI increase also adds roughly $18,500 to the property's valuation.
The two immediate action items are the lease expirations in the next 60 days: Property B Unit A (March) and Property D Unit B (April). Do you have current comp data for those units? If you're pulling comps manually, that's 30–60 minutes of research per unit. If you're not pulling comps at all, you're setting renewal terms without knowing whether your rents are at market, which is the most expensive blind spot in a rental portfolio.
The Three Things Most Rental Spreadsheets Get Wrong
Most rental property spreadsheets are laid out fine, and the trouble starts about three months after you build one.
1. Stale Rent Data
The cost of stale rent data compounds in ways most investors don't think about. That $125/mo gap on Property A is $1,500/yr in lost NOI, and NOI is also a valuation input. Building value = NOI ÷ cap rate, so at a 7% cap rate, $1,500/yr in suppressed NOI means Property A is worth roughly $21,000 less than it should be. Your spreadsheet says the property is performing at $9,900/yr NOI, while the market says it should be $11,400.
Across a 4-property portfolio, if each property is running $75-150/mo below market, you're looking at $3,600-7,200/yr in lost cash flow and $50,000-100,000 in understated portfolio value. A gap that size can be the difference between refinancing at favorable terms and not qualifying.
2. No Market Context
A spreadsheet tracks what you're collecting, but it can't tell you what you should be collecting.
The gap between your current lease rate and median market rent is the most important number for every lease renewal decision, and it's the one number your spreadsheet will never generate on its own. You can add a "market rent" column, but who updates it? How often? With what data? In practice, that column either stays empty or shows whatever number you entered 6 months ago.
This is the core limitation: a spreadsheet is a record of your decisions, and it can't tell you whether those decisions are still right. Knowing that Property C cash-flows $32/mo is useful, but knowing that Property C should cash-flow $140/mo if you adjusted rent to market is what actually changes your returns. A spreadsheet can't show you that unless you do manual comp research for every property on a recurring basis.
3. Breaks at Scale
A spreadsheet works at 1-3 properties, but somewhere between property 3 and property 5, it starts to break down.
Formula errors creep in: a SUM range that doesn't include the new row, a vacancy rate hardcoded at 5% in one cell and 8% in another, or an expense column that references the wrong cell after you inserted a property in the middle. Tabs multiply, and soon you have one version, your partner has another, and your PM has a third. Excel files get emailed back and forth, and nobody's sure which is current.
The spreadsheet doesn't break all at once, but it gradually becomes something you don't trust. You stop updating it monthly because it takes 20 minutes and you have tenants to deal with, and the "last updated" date slips from 2 weeks to 2 months to 6 months. By the time you need accurate numbers for a refinance, a new acquisition, or a year-end tax conversation, you're rebuilding from scratch.
When to Replace Your Spreadsheet
A spreadsheet is a reasonable starting point for 1–2 properties. Consider replacing it when any of these are true:
You own 3+ properties and updates take more than 15 minutes a month. Consider real estate portfolio management software. The maintenance burden is a recurring time cost, and the more you skip it, the less you trust the numbers when you need them.
You've set renewal terms without current comp data. If you've ever renewed a lease at the same rate, or guessed at an increase, because you didn't have time to pull comps, you left money on the table in cash flow, NOI, and building value. You won't know how much until you eventually do the research and see the gap.
You need lender-ready documentation. A bank evaluating your portfolio for a refinance or new acquisition wants a clean rent roll, current NOI, and lease dates in a presentable format, and a screenshot of your Excel file with conditional formatting and frozen panes won't meet that bar. If you've spent a weekend reformatting a spreadsheet for a lender, you know how much time it takes.
You have a partner or PM who needs access. Emailing Excel files creates version control problems immediately. "Which version has the updated insurance numbers?" is a question nobody should have to ask.
You've caught a formula error that changed your numbers. If you've discovered that your cash flow was overstated by $200/mo because a cell reference was wrong, that's the moment you stop trusting the spreadsheet, and a spreadsheet you don't trust causes more problems than it solves.
What to Look For in a Replacement
You're not a REIT, so you don't need a $500/mo enterprise platform. Four things matter:
- Live rent data: current market comps, updated automatically, instead of whatever you entered 6 months ago.
- Portfolio-level view: total cash flow, total NOI, all lease dates, weighted returns, one screen.
- Lender-ready exports: PDF documentation that contains the numbers a bank actually needs, generated in seconds.
- Low cost: proportional to a 1–50 unit portfolio, not priced for institutional investors.
Operator doesn't replace your bookkeeping. What it adds is what your properties should rent for, alongside what they currently rent for, so when it's time to set renewal terms, the comp research is already done. That's one less recurring task on a list that's already too long.
Get Started: Free Spreadsheet Template
If you're not ready for software yet, start with our spreadsheet template. It includes the 7 per-property metrics above, portfolio roll-up formulas, and a 90-day lease expiration tracker.
Download the free rental property spreadsheet template →
FAQ
What should a rental property spreadsheet track?
Seven things per property at minimum: gross scheduled rent, vacancy loss (budget 8%), itemized operating expenses (taxes, insurance, management at 10%, maintenance at 5%, CapEx reserves at 5%), debt service (monthly P&I), monthly net cash flow, cash-on-cash return, and lease expiration date. At the portfolio level, you need total monthly cash flow, total annual NOI, weighted average cash-on-cash return, and a list of lease expirations in the next 90 days. If your spreadsheet is missing any of these, it's hiding information you need to make renewal and acquisition decisions.
How often should I update my rental property spreadsheet?
Monthly at minimum: that's the target, but it's also the problem, because most investors start with good intentions and slip to quarterly or less. The numbers that change most are the ones that matter most: market rents (which determine whether you're pricing renewals correctly), insurance premiums (which change at annual renewal), and property taxes (which can jump 10-20% after reassessment). At 3+ properties, a monthly update takes 15-30 minutes and requires pulling fresh rent comps for any property approaching renewal.
When should I switch from a spreadsheet to portfolio software?
When the maintenance burden exceeds the value, typically between property 3 and property 5. Specific triggers: you're spending more than 15 minutes a month on updates, you've set renewal terms without current comp data, you need lender-ready documentation and your spreadsheet isn't presentable, you share portfolio data with a partner or PM and you're emailing files back and forth, or you've caught a formula error that gave you wrong numbers. Any one of these means the spreadsheet is now working against you.
How does Operator replace a rental property spreadsheet?
Operator keeps every property you own in one dashboard, shows cap rate and cash-on-cash for each, and checks your rents against live market comps every month, so you see where your lease rates sit against market rent without pulling comps by hand. Portfolio totals update on their own, and it builds a lender-ready PDF from your portfolio when you need one.
Can I export my data from Operator to Excel?
Not today. Operator builds lender-ready PDFs from your portfolio for refinance and acquisition conversations.



