← All articles

Stop tracking rent in spreadsheets: a simpler ledger for small landlords

·5 min read

If you self-manage two, five or ten properties, you almost certainly started with a spreadsheet. It worked at first — one row per tenant, a column per month, a green cell when the rent landed. Then a tenant paid late. Then one paid half. Then another paid two months in one go. And quietly, your spreadsheet stopped matching reality.

Where spreadsheets break for landlords

Spreadsheets are great for fixed numbers. Rent isn't fixed — it's a stream of charges and payments that are supposed to line up but rarely do. The moment any of these happen, your spreadsheet starts lying to you:

  • A tenant pays a partial amount and you have to remember which month it covers.
  • A tenant catches up two months in one transfer and you have to split it.
  • A payment bounces or was logged wrong and you have to reverse it without breaking the totals.
  • You add a new tenancy mid-year and have to backfill the missing months.
  • You want to see who, across the whole portfolio, is actually behind right now.

None of these are exotic. They are the normal life of being a landlord. But each one quietly creates a discrepancy between your spreadsheet and what the tenant thinks they owe.

What a proper rent ledger does instead

A rent ledger treats every tenancy as its own running account. Each month a charge is added automatically. Each payment is recorded against that tenancy and allocated to the oldest unpaid month first — the way landlords naturally think about it. The current balance, the oldest unpaid month and the next due date are always live, never stale.

Done right, that's all you need. You don't need a maintenance ticketing system, a marketing module, a compliance dashboard or an onboarding call. You need rent, payments, arrears and statements — clearly.

Why this matters more for small portfolios

Big letting agencies have entire teams managing this in expensive enterprise software. Small landlords don't. If you have a handful of properties, you don't need a platform built for a thousand units — you need one built for ten. Something cheap, simple, and focused on the part that actually matters: did the rent come in, and if not, by how much are we behind?

That's the whole reason Nestria exists: a simple per-tenancy rent ledger for self-managing landlords. Not legal software. Not compliance software. Not enterprise property management. Just a clear ledger that always matches reality.

Try Nestria free for 14 days.

A simple rent ledger for small self-managing landlords. No credit card required.