Skip to main content
LetCompliance
Running Your Let

Rent ledger: what a landlord’s tenant ledger must show, with a three-month example

A tenant ledger is the running record of every rent charge and every payment on one tenancy, with the balance after each line. The six columns it needs, how part payments and arrears carry forward, and a worked three-month ledger.

13 min read

Sample account, the Rent page, whoever owes most first: Ellie Northcott, 18 Harrowden Terrace, Sheffield, Room 1, £525 a month, overdue since 20 Oct 2026, £525 and 1 month’s rent owed; Lewis Grantham, Room 4, £495 a month, overdue since 24 Sept 2026, £495 and 1 month’s rent owed, Ground 8 from about 25 Nov 2026; Hannah Okafor, Room 3, £120 a week, overdue since 19 Oct 2026, £120 and 1 week’s rent owed; each with Mark paid, Part payment, Chase and Statement; then Aisha Rahman, Room 5, £575 a month, due today, up to date
Sample account, the room board on a phone: Room 4, Lewis Grantham, £495 a month, £495 behind
Sample account with made-up details, 18 and 21 Oct 2026

See how LetCompliance tracks rent arrears

A rent ledger, often called a tenant ledger, is the running record for one tenancy of every rent charge and every payment made against it, with the balance after each line. It needs six columns: the date the rent fell due, the amount due, the date each payment arrived, the amount paid, how it was paid, and the running balance.

Kept that way from the first rent day, the ledger answers three people. The tenant who says "but I paid that". Your accountant, who wants the rent received for the year. And, if the rent stops, the court: a possession claim for arrears is built on the same dates and amounts, with a running total.

This guide sets out the columns, how part payments and arrears carry forward, and a three-month ledger worked line by line. The court and Ground 8 parts are for private tenancies in England.

The six columns a tenant ledger needs

ColumnWhat goes in itWhy it matters
Date dueThe rent day for each period: every month, week or fortnight the tenancy runsArrears are the gap between what fell due and what arrived, so every charge goes in, paid or not
Amount dueThe rent for that periodA rent increase shows from the period it starts, not before
Date paidThe day the money reached you, from the bank statementIt decides which periods were late and settles "I paid on time"
Amount paidEach payment as it arrived, even a part paymentTwo payments in a month are two lines, never one total
MethodStanding order, Direct Debit, bank transfer, card, cashIt is the first thing you check when a tenant disputes a payment
BalanceLast balance, plus rent due, less paidThe figure a tenant, an adjudicator and a judge read first

Keep one ledger for each tenancy, not one for each tenant or each property. Joint tenants share one rent and one balance, however they split the payments between them. In a house let by the room on separate tenancies, each room has its own ledger.

Above the lines, write who and what it covers: the landlord, every tenant named on the tenancy, the address (and the room), the start date, the rent and how often it is due. The rent statement guide has the full list.

Ledger and statement: two jobs

The ledger is the working book. You add to it as things happen: a charge on each rent day, a payment on the day the money arrives. It is never rewritten, only added to.

A rent statement is drawn from the ledger for a period and a reader: a year for your accountant, six months for a tenant's mortgage application, two years for a possession claim. If the ledger is right, every statement is a printout of it. The free rent statement builder turns your lines into a PDF.

Keep the ledger the tax year's way too. GOV.UK asks landlords to keep the dates the property was let, all rent received, and the rent books, receipts and bank statements behind them. A ledger with the bank statement beside it is that record.

How part payments and arrears carry forward

Every rent day raises a charge. Write the charge in on the due date whether or not anything arrives. A ledger that only lists payments cannot show arrears.

A part payment goes in on the day it lands. If the tenant pays £500 towards £950, the line says £500.00, dated, and the balance shows £450.00 owed. When the rest arrives, it is a new line with its own date.

The balance never restarts. Arrears carry forward in the balance column from one period to the next. The common mistake is to mark next month "paid" when the tenant pays next month's rent in full. The month's rent was paid, but the balance still owes last month's shortfall.

A credit carries too. If a tenant pays more than is owed, the balance goes into credit. Write it as a credit and let the next charge use it up. If you agree the extra was for something else, record it there, not in the rent.

Keep anything that is not rent out of the rent balance. The deposit is not rent: it is held under a protection scheme and has no place in the ledger. A late rent interest charge, a lost key or a bill the tenant pays you go on their own lines, outside the rent balance. Ground 8 counts "rent lawfully due from the tenant", so a balance that mixes in other charges overstates the arrears.

Universal Credit paid to the tenant. Record what arrives and when. Where a tenant is waiting for a Universal Credit payment that covers housing, note it against the period: Ground 8 leaves that amount out of the count until it is paid. The Ground 8, 10 and 11 comparison works the figures.

Rent through a letting agent. The tenant paid the full rent, so the tenant's ledger shows the full rent paid. The agent's fee is your cost, recorded with your expenses, never as the tenant's arrears.

A worked three-month ledger

Example figures. A flat let at £950 a month, rent due on the 1st, nothing owed before September 2026.

DateEntryDuePaidMethodBalance
1 Sep 2026Rent for September£950.00£950.00 owed
1 Sep 2026Payment£950.00Standing order£0.00
1 Oct 2026Rent for October£950.00£950.00 owed
6 Oct 2026Payment£500.00Bank transfer£450.00 owed
1 Nov 2026Rent for November£950.00£1,400.00 owed
3 Nov 2026Payment£950.00Standing order£450.00 owed
20 Nov 2026Payment£200.00Bank transfer£250.00 owed
Totals£2,850.00£2,600.00£250.00 owed

Three things to read from it.

  1. 1October's shortfall survives November's full payment. The standing order on 3 November paid November's rent in full, yet the balance still shows £450.00. A ledger kept month by month, with each month ticked "paid" or "unpaid", would have shown November paid and lost the £450.
  2. 2The totals check the balance. £2,850.00 due less £2,600.00 paid is £250.00, the last figure in the balance column. If the two ever disagree, a line is missing or wrong.
  3. 3The dates show the pattern. One payment five days late and short, then a top-up three weeks into the month. One late month means little. The same pattern for a year is what persistent late payment (Ground 11) looks like on paper.

This tenant owes £250. Ground 8 on this rent needs at least £2,850 unpaid, three months' rent, both on the day a notice is served and on the day of the hearing. The ledger is how you know where you stand on both days.

Why the ledger is the evidence if the rent stops

When a possession claim for arrears goes to court in England, Practice Direction 55A, paragraph 2.3, sets out what the particulars of claim must contain: a schedule of the dates and amounts of all payments due and payments made under the tenancy for the two years before the claim is issued (or from the first missed payment, if that was later), a running total of the arrears, and the daily rate of the rent. For the flat above, the daily rate is £11,400.00 a year divided by 365 days, £31.23.

That schedule is the ledger above, line for line. A landlord who has kept one from the first rent day prints it. A landlord who has not rebuilds two years of payments from bank statements under a deadline, and that is where payments get matched to the wrong month and a balance stops adding up.

The same figures run through the rest of an arrears case:

  • The Section 8 notice states the arrears on the day it is served, and for Ground 8 they must be at the threshold that day and again at the hearing
  • Grounds 10 and 11 turn on rent unpaid when the claim is issued and on the history of late payment, which is the date column
  • A deposit dispute over unpaid rent at the end of the tenancy goes to the adjudicator with the same record
  • A money claim against a former tenant starts from the closing balance

The steps when the rent stops are in tenant not paying rent, and rent arrears software shows how the arrears are tracked and chased from the ledger.

Matching the ledger to the bank

Once a month, put the bank statement beside the ledger and tick each rent payment against its line. A payment with no ledger line is rent not yet recorded, or money that is not rent at all. A ledger line with no bank payment is a mistake, or a payment that never arrived.

Three cases catch most landlords out:

  • Joint tenants paying separately. Two payments of £475 make one month's £950; record both against the one tenancy
  • A short payment that looks full. £945 against £950 is a part payment with £5 still owed, not "near enough"
  • Rent through an agent. One deposit from the agent, after fees, can cover several tenancies; split it back to each ledger at the full rent

The step-by-step version is in how to reconcile rent with your bank statement.

Keeping it in a spreadsheet

A spreadsheet works for one or two tenancies if you keep to four rules:

  1. 1One tab for each tenancy, with the six columns above and the header details at the top
  2. 2A row for every charge on its due date, and a row for every payment on the day it arrived
  3. 3A balance formula that adds the charge and takes off the payment from the row above, never a typed figure
  4. 4Past rows left alone: correct a mistake with a new dated line, so the record shows what changed

Copy this header row to start:

DateEntryDuePaidMethodBalance
Opening balance£0.00

The weak point is the rent day itself. A charge you forget to type is arrears the ledger never shows.

Let the tenancy keep the ledger

The ledger without the typing. In LetCompliance, rent collection software that posts each payment to the ledger, the rent is tracked on the tenancy. Each rent day raises the charge, and each payment is posted against it, whether it came by Direct Debit, a card link or a payment you mark received, with part payments dated as they arrive. The Rent page shows what is due, what is paid and what is owed across every property, and the Rent ledger report lists every charge with its due date, amount, paid date and status, as a CSV or a PDF.

The rent statement prints from the same record, month by month: charged, paid, the balance carried forward, the closing balance and the longest run of unpaid months. A bank statement imported as a CSV is matched to the rent due, to the penny, and nothing is recorded until you confirm it. All of that comes with the 3-day trial and every paid plan, from £7.99 a month.

If it ever comes to possession, the paid plans build the evidence bundle with the rent ledger in it and, in a landlord account, your answers for Forms N5 and N119, filled in from your notice, rent ledger and tenancy.

Frequently asked questions

What is a tenant ledger?

The running record for one tenancy of every rent charge and every payment against it, with the balance after each line. It is the record a rent statement is printed from, and the one an arrears claim is built on.

What should a rent ledger show?

Six columns: the date each rent fell due, the amount due, the date each payment arrived, the amount paid, how it was paid, and the running balance. Above the lines: the landlord, every tenant, the address, the start date and the rent.

How do I record a part payment of rent?

As its own line on the day it arrives, with the amount actually paid. If £500 arrives against £950, the balance shows £450 owed, and it carries into the next month until it is paid.

What is the difference between a rent ledger and a rent statement?

The ledger is the working record you add to as each charge and payment happens. A rent statement is drawn from it for a period and a reader: a tenant, an accountant, an adjudicator or a court. See what a rent statement must show.

Should the deposit go in the rent ledger?

No. A deposit is not rent and is protected under a scheme. Keep it, and other charges such as late rent interest, out of the rent balance: Ground 8 counts rent lawfully due from the tenant.

How far back does a rent ledger need to go for a possession claim?

Practice Direction 55A asks for the dates and amounts of all payments due and made for the two years before the claim is issued, or from the first missed payment if later, with a running total of the arrears and the daily rate of the rent.

Sources and scope

Every source above is a government or regulator’s page the guide cites, linked where it is used. The ledger figures are example figures. This is guidance, not individual legal advice.

Ask an AI about this guide

Opens your assistant with this page as its source.

Share this guide

𝕏
Free PDF, instant by email

Landlord Document Retention Schedule

How long to keep tax, safety, deposit and tenancy records in England, with the source and the reason for each. Print it and keep it with your property files.

  • Self Assessment records: at least 5 years after the 31 January deadline
  • Safety certificates, deposit and tenancy records by document
  • Capital improvement receipts: keep until the sale is settled
  • What UK GDPR means for keeping tenant data

The guides only come if you tick the box, and you can unsubscribe in one click.

You have read the guide. Now run the let.

Advertise and reference tenants, sign the agreement, collect the rent, log repairs and keep the tax figures ready all year. Certificates, deposits and deadlines are tracked alongside, so nothing expires unnoticed.

Plans from £7.99 a month, with a 3-day trial and no card. Making Tax Digital, recognised by HMRC, comes with every paid plan, not the trial.