What Is a Tenant Ledger? A UK Landlord's Guide to Portfolio Management

Most landlords with one or two properties track rent in a spreadsheet: a row per month, a column for "paid" or "not paid." It works — until a tenant pays late three months running, a deposit needs returning and nobody's sure of the exact protected amount, or a second property gets added and the spreadsheet has to be rebuilt from scratch to keep everything separate.

A tenant ledger is the proper version of that spreadsheet — and once you're managing more than one tenancy, the difference between a ledger and a rough spreadsheet stops being a nice-to-have.

What a Tenant Ledger Actually Tracks

A tenant ledger is a running record, kept per tenancy, of:

• Rent charged — the amount due and the date it's due, for every rent period of the tenancy
• Payments received — date, amount, and method for every payment actually received against that tenancy
• Running arrears balance — the live difference between what's been charged and what's been paid, updated automatically as payments come in
• Deposit details — the amount held, which government-backed scheme it's protected with (TDS, mydeposits, or DPS), and the protection certificate reference
• Charges and credits — anything added to or deducted from the tenancy balance, such as a late payment charge or a rent-free period agreed in advance

The key difference from a general income spreadsheet is that everything is tracked per tenancy, not pooled into one total. A landlord glancing at a tenant ledger can see instantly whether a specific tenant is up to date, one payment behind, or building persistent arrears — information that's genuinely hard to extract at a glance from a spreadsheet tracking totals across a whole portfolio.

Why This Matters More As Your Portfolio Grows

With one property, a landlord can usually hold the current state of the tenancy in their head. That stops being true at three or four properties, particularly if rent dates don't align, one tenant is a few days late most months, and a deposit dispute comes up on a property you haven't thought about in six months. A proper ledger removes the need to reconstruct payment history from bank statements when a dispute or an arrears conversation actually happens — the record already exists, dated and itemised.

Beyond the Ledger — What Full Portfolio Management Adds

A tenant ledger solves the rent-and-arrears problem. A full portfolio management tool sits on top of that and adds the property-level and portfolio-level information a landlord with more than a couple of units actually needs to run the business, not just track the rent:

Layer	What It Tracks
Tenant ledger	Rent charged, paid, arrears, deposit, per tenancy
Property record	Purchase price, mortgage, rental yield, maintenance history, expenses
Compliance calendar	Gas safety certificate renewal, EICR (electrical) renewal, EPC rating, right-to-rent checks
Portfolio rollup	Total income, total expenses, and net yield across every property in one view
Tax-year summary	Income and allowable expenses grouped by tax year, ready to hand to an accountant

The compliance calendar in particular is where landlords with a growing portfolio get caught out. A gas safety certificate needs renewing annually, an EICR every five years, and an EPC has its own validity period — with different renewal dates for every property, it's easy for one to lapse quietly among several others that are all in order.

What to Look for in a Landlord Portfolio Management Tool

• Per-tenancy ledger, not just a total income figure — you need to see each tenancy's arrears independently
• Multi-property view — the ability to see one property in detail and the whole portfolio rolled up, without switching between separate files or spreadsheets
• Compliance deadline tracking — gas safety, EICR, and EPC renewal dates flagged before they lapse, not discovered after
• Yield and expense tracking per property — so you can see which properties in the portfolio are actually performing, not just the total
• A tax-year summary export — income and expenses grouped in a format that's straightforward to hand to an accountant each year

If you'd rather this was already built rather than assembled from spreadsheets and reminders, our LandlordLedger Pro tracks rental yields, income, expenses, tenants, maintenance jobs, compliance deadlines, and tax-year summaries across your entire portfolio in one offline tool.

Three Things to Set Up This Week

1. Split your rent tracking by tenancy, not by total income. If you can't answer "is this specific tenant up to date?" in ten seconds, your current system isn't a ledger yet.
2. Record your deposit protection references somewhere durable. Not knowing which scheme a deposit sits in, or its exact protected amount, is one of the most common causes of a delayed or disputed deposit return.
3. Write down every property's compliance renewal dates in one place. Gas safety, EICR, and EPC dates scattered across separate paperwork are exactly how one quietly lapses.