Real Estate · Updated · 2026-09-14
How Landlords Should Track Rent: From Paper Ledgers to On-Device Apps (2026)
A landlord's books are not personal finance: receivables aren't receipts, deposits aren't income, and vacancy is a cost. The four common ways to track rent, the six things worth recording, and the five checks that actually matter when picking a tool.
"It's just a few rent payments a month — I'll keep track as I go." That's how most landlords start, and how most end up confused by year two: was the deposit returned, did the utilities settle, how long has that unit been empty — all of it living in memory. Rental bookkeeping is not personal bookkeeping. This guide isn't a ranking; it covers two things: what a landlord's books should actually record, and which of the four common approaches fits whom.
What Makes Rental Books Different
Receivable is not received. Personal finance tracks money going out; a landlord's ledger is mostly money that should come in. Rent due on the 1st that arrives on the 8th at 93% — both the date gap and the amount gap are information. A simple income log can't show you who owes what, or for how long.
Deposits aren't income, and repairs aren't just expenses. A deposit is a liability you owe back at move-out; repair spending hits the unit's real yearly yield. Mix them together and no spreadsheet can tell you what each unit actually earned.
Vacancy is a cost. An empty month isn't "zero income" — it's "minus one month of rent." Landlords who can't state their real occupancy rate also can't decide whether to cut the price or wait.
One unit, one book — times every unit you own. Rooms, lease terms, billing cycles, meter baselines all differ. Structure the ledger as property → room → lease → bill from unit number one, or unit number two is where it falls apart.
The Four Common Approaches
Paper / notes app. Zero cost, always at hand — and it breaks at three units. Finding "when does unit 3's lease end" takes minutes, overdue rent lives in your head, and a lost phone means a lost ledger. Fine for one or two stable, long-term tenants.
Spreadsheets. The structured starting point: a row per unit, a column per month, a pivot table for yearly income. The catch is discipline — recurring bills are pulled by hand, meter differences calculated by hand, overdue rent chased from memory. And a spreadsheet keeps quietly rotting after "I just tweaked one formula." If you'll maintain the template, it's the best value in town.
Generic expense trackers. Logging "received 1,200" is easy, but their model is transactions, not tenancy: no lease cycles, no receivables concept, deposits and rent in one undifferentiated stream. Fine as a side tool; wrong as your main rent ledger.
Dedicated rent-tracking apps. Built around property → lease → bill: recurring bills issue themselves, overdue flags itself, meter readings become utility bills, cashflow reports come ready-made. The price is handing your data to an app — which is exactly why choosing one deserves care.
Five Checks Before You Commit
Offline use. Renting happens everywhere — at a viewing, in a stairwell, in a basement with no signal. No tool should ever say "no connection" when you need it.
Where the data lives. Tenant names, phone numbers and rent figures are sensitive. On the device, or uploaded into somebody's cloud account? Worth checking explicitly, not assuming.
Duplicate-proof billing. Two bills for one month's rent, or a mistyped meter baseline billed twice — good tools make these impossible by design rather than relying on your diligence.
A cashflow view. Beyond "how much came in": net flow this month, vacancy loss to date, occupancy rate. These are the numbers behind pricing and renewal decisions.
Export. The data is yours. Full CSV export means your records follow you — to a new tool, to your accountant, to your own analysis.
Who Should Use What
An honest conclusion, no rankings:
- One or two units, stable tenants → paper or a spreadsheet is enough; don't pay for a tool.
- Happy to maintain a template → spreadsheets have a high ceiling; the cost is that everything runs on your discipline.
- Three or more units / subletting or managing → get a dedicated tool, and start by separating receivable, received and vacancy into their own lines.
- Privacy-minded, unwilling to upload tenant data → on-device tools. The one we're building, RentPilot, takes that line: offline, no account, no cloud sync — the ledger lives only on your phone. Coming to the App Store and Google Play.
Asking for rent has its own craft — see rent reminder templates for copy-paste scripts. If you sublet, your books run on two lines; see sublet math.