When does a spreadsheet stop working for your rentals?

A spreadsheet is the best tool for managing rentals — until it suddenly is not. This is a guide for figuring out which side of that line you are on.

There is a version of the rental business that runs perfectly on Google Sheets, and another version that runs catastrophically. The difference is not door count alone. It is a combination of door count, complexity, and how much your time is worth.

Here is a framework for deciding.

The phase where spreadsheets work

If you own one to three rental units, a spreadsheet is genuinely fine.

A single tab with columns for date, tenant, property, amount, and a column for notes covers the entire bookkeeping. A second tab for expenses. Maybe a third tab for an annual summary. You enter rent when it comes in. You scan vendor receipts into Google Drive. At tax time you sort the expense tab by category and hand the summary to your CPA, who does the rest.

This works because the cognitive load is small. You can remember everything that matters. Mrs. Garcia paid on the 3rd. The HVAC repair on Unit 2 in March was $480. The vacancy in November lasted 23 days. You know it because you lived it.

Do not switch software during this phase. The software costs money, takes time to set up, and the spreadsheet you have is doing the job. Anyone who tells you that you need property management software at three doors is selling you software.

The threshold

The phase where spreadsheets work has an edge. Most landlords find it between four and eight doors. Some find it earlier if they have a complex situation (multiple property types, multiple jurisdictions, partners, or LLCs). Some never find it because they are operating an extremely simple business and they enjoy bookkeeping.

The edge looks like this:

• You miss a late fee one month because you forgot which tenants are subject to the new policy
• A vendor sends you an invoice and you cannot immediately match it to which property the work was on
• You catch a duplicate entry in your books two months after it happened
• Year-end takes you a full weekend instead of an afternoon
• You realize you have been undercollecting from a tenant for six months because the spreadsheet had the wrong rent amount
• A bank refinance asks for a current rent roll and you do not have one to hand them

Any one of these is a signal. Two or more in the same year is the signal.

The underlying problem is not the spreadsheet. It is that your portfolio has more state than your working memory can hold. A spreadsheet is a passive record of state; it does not tell you anything you do not ask it. When the state exceeds the memory, things slip.

What software has to do better

Software that is worth switching to has to do certain things demonstrably better than a spreadsheet. If it does not, switching is a downgrade.

Rent collection. This is the biggest one. Software should be the source of truth for whether a tenant has paid. It should pull from your bank, post the payment to the right tenant ledger, apply late fees by your policy, and reconcile automatically. A spreadsheet requires you to know all of this and enter it manually. See rent collection for the full breakdown of what this looks like in DealProp.

Maintenance dispatch. A spreadsheet is a terrible place to track work orders. The state of a work order changes — reported → triaged → dispatched → in progress → completed → invoiced — and a spreadsheet cannot communicate any of that to a tenant or vendor. Software can.

Expense categorization. A spreadsheet does this only if you remember to categorize. Software should categorize automatically (IRS Schedule E line items for rentals) and let you override.

Reporting. A spreadsheet can give you a year-end summary if you build it. Software should give you cash flow per property in real time without you having to ask.

Data portability. This is the one most landlords overlook. The software has to be willing to give you your data back. CSV export. No exit fee. The day you decide to stop using it, you should be able to leave with everything you put in. See your data for the version of this commitment that ships with DealProp.

What software should not do worse

There is a long list of failure modes that software introduces where a spreadsheet had none.

Lock-in. Some platforms charge an exit fee or make export deliberately painful. If you cannot get your data out at any time, you are trading the spreadsheet's freedom for software's convenience. Bad trade.

Complexity. Some platforms are built for 1,000-unit operators and try to sell that complexity down to small landlords. You do not need a portfolio manager dashboard if you have 12 doors. You do not need syndication-style distributions or institutional reporting layers. The software should fit your size.

Required onboarding. If switching takes more than a week of part-time work, the cost is too high. A good system imports a CSV of your rent roll and your tenants in an afternoon. Anything beyond that is the vendor's problem to solve, not yours.

Data selling. Some platforms make money by selling aggregated data or by adding ad networks. You are paying them; they should not also be selling you. Check the privacy policy before you sign up.

Per-feature pricing. Some platforms split features across tiers in a way that forces you to upgrade for things that should be in any plan. Rent collection on the basic tier but no maintenance dispatch unless you upgrade is a sign of bad pricing logic.

The honest non-answer

If you have three doors and the spreadsheet works, do not switch. You do not owe software adoption to anyone.

If you have eight doors and you are missing things, switch. The cost of the software is less than the cost of one undercollected rent or one wrongly-categorized expense.

If you have fifteen doors and you are still on a spreadsheet, switch yesterday. You are paying the spreadsheet's hidden cost — your time and your mistakes — every month.

If you have fifty doors and you are still on a spreadsheet, you are either a saint of organization or you have a very specific situation where the math works out. We would love to meet you.

What the right software gives you back

When the software is doing its job, the question is not "should I switch?" It is "how did I ever do this on a spreadsheet?"

You stop being a clerk. You start being an owner.