Every small-portfolio landlord has the same spreadsheet. It's named something like Rent_Roll_2024_v7_FINAL_FINAL.xlsx. It has nine tabs, one of which is just blank. Conditional formatting hasn't been working for two years. The sums at the bottom haven't been right since you added a column in March.
You still trust it. But less than you used to.
How the trap forms
The rent roll spreadsheet starts as the single best decision you've ever made. You bought your first three-unit property. You needed a place to track tenants, rents, and lease ends. Excel was free, you knew it, and you typed in six rows.
Then you got a fourth unit. Then a partial payment came in late, and you added a column for it. Then a tenant renewed and the rent stepped up, so you added a "current rent" column and a "previous rent" column and a "new rent" column. Then one tenant has CAM, and another doesn't, so you added rows below the main table for property-level expenses. Then you added a percentage rent tenant and started a second tab just for them, because the formula needed monthly sales numbers.
Each addition was a sensible local decision. The aggregate is a system you can no longer fully reason about.
The four failure modes
1. The "current rent" column is a lie
The most common silent failure. A tenant's lease renewed in May with a rent step-up. You updated the current rent column. But you forgot to update the prior balance calculation, which still pro-rates against the old rent through the whole year. Your year-end statement to that tenant is off by hundreds.
2. The math at the bottom doesn't reflect the data above
You added a row in March without updating the SUM range. The aggregate column at the bottom is summing 23 of 24 rows. Nothing visibly broke. You'll discover this in November when your accountant asks why your reported rent roll is $7,840 below what's in your bank statements.
3. The audit trail is "look at the file"
Did Suite 4B's tenant ever short-pay April? Maybe. The cell shows the right number now. Whether that's because they paid in full, or paid in full last week with a $200 late fee that you ate, or whether you just typed it that way in October — you can't tell. The cell is the only record.
4. The spreadsheet becomes a single point of failure
It's on your laptop. Your laptop dies. The cloud backup is from three weeks ago. Or, equally common: the spreadsheet is in OneDrive and your bookkeeper saved a copy locally, and now there are two slightly different versions and nobody can remember which one is canonical.
When to give up
The right time to move off a spreadsheet isn't when the spreadsheet breaks. It's when you start spending more time defending the spreadsheet than entering data into it. A few specific moments to look for:
- You did your year-end accounting in February instead of January because you "needed to reconcile a few things."
- A tenant disputes a CAM number and you spend a half-day reconstructing how you arrived at it.
- You bought a new property and your first thought is "I have to figure out how to add another tab."
- You hired a part-time bookkeeper and the onboarding involves explaining the spreadsheet for three hours.
- You're afraid to let your accountant touch it.
If any two of those are true, you're past the point where the spreadsheet is saving you money.
What replaces it
The non-obvious part: you don't need much. A small-portfolio property management tool isn't trying to replicate Yardi. It's trying to replace the spreadsheet — properly. Which means:
- One row per lease, not per row of cells. A lease is a real object that knows its start date, end date, current rent, additional rent, lease type, and history.
- Payments attach to the period they cover. Not "Mar/Apr partial payment" written in the notes column.
- Math is read-only. You can't accidentally type over the formula. The "current rent" cell can't be wrong because it's not a cell — it's a derivation.
- The rent roll, the dashboard, and the year-end statement are all reading from the same underlying data. So they don't drift.
That's it. No machine learning, no enterprise integrations. Just the spreadsheet, redone with discipline at the moment of data entry.
The rent roll, but accurate.
RentRoll is the spreadsheet replacement for landlords managing 5–50 units. Free 14-day trial, no card required.
Start free →The transition
Moving off the spreadsheet feels like it'll take a weekend. It takes about an evening. Properties, units, tenants, leases, and a starting balance — that's the input. Most landlords managing 10 to 30 units have it set up in two hours and have the spreadsheet archived by week's end.
The thing you don't get back is the time. You get back the small mental tax of constantly wondering if the spreadsheet is right. That tax compounds.