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
| Column | What goes in it | Why it matters |
|---|---|---|
| Date due | The rent day for each period: every month, week or fortnight the tenancy runs | Arrears are the gap between what fell due and what arrived, so every charge goes in, paid or not |
| Amount due | The rent for that period | A rent increase shows from the period it starts, not before |
| Date paid | The day the money reached you, from the bank statement | It decides which periods were late and settles "I paid on time" |
| Amount paid | Each payment as it arrived, even a part payment | Two payments in a month are two lines, never one total |
| Method | Standing order, Direct Debit, bank transfer, card, cash | It is the first thing you check when a tenant disputes a payment |
| Balance | Last balance, plus rent due, less paid | The 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.
| Date | Entry | Due | Paid | Method | Balance |
|---|---|---|---|---|---|
| 1 Sep 2026 | Rent for September | £950.00 | £950.00 owed | ||
| 1 Sep 2026 | Payment | £950.00 | Standing order | £0.00 | |
| 1 Oct 2026 | Rent for October | £950.00 | £950.00 owed | ||
| 6 Oct 2026 | Payment | £500.00 | Bank transfer | £450.00 owed | |
| 1 Nov 2026 | Rent for November | £950.00 | £1,400.00 owed | ||
| 3 Nov 2026 | Payment | £950.00 | Standing order | £450.00 owed | |
| 20 Nov 2026 | Payment | £200.00 | Bank transfer | £250.00 owed | |
| Totals | £2,850.00 | £2,600.00 | £250.00 owed |
Three things to read from it.
- 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.
- 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.
- 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:
- 1One tab for each tenancy, with the six columns above and the header details at the top
- 2A row for every charge on its due date, and a row for every payment on the day it arrived
- 3A balance formula that adds the charge and takes off the payment from the row above, never a typed figure
- 4Past rows left alone: correct a mistake with a new dated line, so the record shows what changed
Copy this header row to start:
| Date | Entry | Due | Paid | Method | Balance |
|---|---|---|---|---|---|
| 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.