The three options, side by side
| Notebook / shoebox | Property software ($30–50/mo) | Rental property spreadsheet | |
|---|---|---|---|
| Cost over 3 years | ~$0 cash | $1,080–$1,800 | $29 once |
| Who owes what, live | No — reconstructed from memory | Yes, automatic | Yes, formula balances |
| Tax categories built in | No — sorted in April | Yes | Yes — categories are the Schedule E lines |
| Online rent collection | No | Yes — its best feature | No — you log payments made elsewhere |
| Maintenance requests & tenant messaging | No | Yes | No |
| Your data if you stop paying | Yours, but unusable | Export, if the plan allows | Yours — it is a file on your computer |
| Breaks when… | The first dispute or audit | You have 2 doors and a $50/mo bill | You need automation at 15+ doors |
Option 1: The notebook (and its digital cousin, the scattered phone)
Real cost: zero dollars, and one to two weekends every spring, plus whatever a CPA charges to untangle it, plus the deductions quietly lost because a receipt faded. Fits: honestly, a landlord with one unit, one long-term tenant who has paid on time for years, and simple expenses. Breaks: at the first partial payment dispute, the first year with two properties, the first refinance that asks for a rent roll. The notebook's hidden flaw is that it records what you remember, and rent collection runs on what you can show.
Option 2: Property management software
Real cost: $30–50 per month, every month, whether you have vacancies or not — $360–600 a year, which for a two-unit landlord can exceed the entire annual profit on one door. In exchange you get genuinely valuable things a spreadsheet will never do: online rent collection, tenant screening, maintenance ticketing, a tenant portal. Fits: landlords at roughly 10+ doors, anyone whose bottleneck is tenant communication, and operators who value automation over cost. Breaks: at small scale, where the subscription is the largest “expense” after the mortgage — and the day you cancel, when your history lives in someone else's system.
Option 3: A purpose-built landlord spreadsheet
Real cost: a one-time $29–49 and a minute or two per transaction to log it. Fits: the self-managed middle — 1 to 10 properties — where the actual pain is not tenant portals but three narrower jobs: knowing who is short on rent, keeping expenses pre-sorted for taxes, and seeing per-property profit without a rebuild. Breaks: honestly, at scale. A spreadsheet does not collect rent, does not message tenants, and does not stop a determined user from typing over a formula. Past about 10–15 doors, or with a team needing simultaneous access and permissions, graduate to software and consider the subscription money well spent.
The honest summary: the notebook under-records, the software over-charges at small scale, and the spreadsheet covers exactly the record-keeping middle. Pick based on which failure you would rather avoid — not on which tool has the longest feature list.
What a landlord spreadsheet must have (whoever you buy it from)
- A payment ledger with calculated balances — due vs. received, shortfalls flagged automatically. Typed-in balances are how money disappears.
- Expense categories that match the tax form — if the dropdown is not the Schedule E line list, you will re-sort everything in April anyway.
- Per-property summaries from formulas — one property's loss should never hide inside another's profit.
- A lease/rent-roll view with expiry dates — renewals missed are vacancies earned.
- No macros, no lock-in — a plain file you can open in Excel or Google Sheets, back up, and keep forever.
That checklist is the design spec of the Rental Property Tracker: 8 sheets (plus an Airbnb module in the Bundle), a Sample Filled worked year so you can see the system before trusting it, and a Quick-Start Guide. One-time price, yours forever.
FAQ
Is a spreadsheet really enough for 8 properties?
For record-keeping, yes — income and expense logging, balances, per-property P&L and tax summaries are formula work, not server work. What a spreadsheet will not do at any scale is collect rent online or manage tenant communications; if those are your pain, that is software territory.
Why do landlords quit property software?
The most common reason at small scale is arithmetic: a $40/month subscription against one or two units is a large, permanent expense for features used a few times a month. The second is lock-in — records become hard to take with you. Neither applies to a file you own.
What about general accounting software like QuickBooks?
It is solid double-entry accounting, but it is a subscription, it is not rental-shaped (no rent roll, no per-property Schedule E view without customization), and most small landlords use a fraction of it. Landlords with multiple businesses or an accountant who runs their books in it are the exception.
My CPA wants everything in their system. Should I still track?
Yes — your CPA works from your records either way. Handing them a per-property Schedule E summary instead of a bank statement export is the difference between paying for their judgment and paying for their data entry.
Does the Tracker work in Google Sheets?
Yes — standard .xlsx, ordinary formulas, no macros. It also works in Excel and LibreOffice.