Home and property

What is a rent roll, and why a small landlord needs one

A rent roll is a one-page list of every unit you let out, with tenant, rent, deposit and dates. Learn how it differs from a ledger and what fields to keep.

Editorial illustration for What is a rent roll, and why a small landlord needs one

A rent roll is a one-page list of every flat or room you let out, showing who lives there, what rent is due, what deposit you hold and when the agreement ends. It is a snapshot of the portfolio today, kept current, and it is what you would hand to a lender, a buyer or your CA when they ask what the property earns.

How is a rent roll different from a ledger?

A rent roll answers the question what should be happening right now. A rent ledger answers what actually happened, month by month: each payment received, each shortfall and each adjustment, in date order. The roll has one row per flat; the ledger has many rows per flat over time.

Both differ from a bank statement, which shows only money that moved. A statement cannot tell you that a flat is vacant, that a tenant paid for two months at once, or that a deposit exists. The roll supplies the context and the statement supplies the evidence.

RecordRowsAnswersSource
Rent rollOne per unitWhat is due and under what termsAgreements
Rent ledgerOne per payment or due dateWhat was due and what was receivedBank statement and receipts
Bank statementOne per transactionWhat moved in your accountYour bank

What six fields make a rent roll useful?

  1. Unit: a flat number or a nickname you will recognise, such as 2B or Rear room.
  2. Tenant: name and a contact number, plus the name that appears on the payments if it differs.
  3. Agreement dates: start date, end date and the notice period written in the agreement.
  4. Monthly rent: the agreed amount, and the due day of the month.
  5. Deposit held: the amount, the date received and how it was paid.
  6. Status: paid up, partly paid, late or vacant, updated when each month closes.

If you add a seventh, make it the date of the next revision of rent, since forgotten revisions are the commonest quiet loss for a landlord with a long-standing tenant.

Why would an owner of one to five flats need one?

Because memory stops working at about the third tenant. With one flat, you know when the rent comes. With four, you cannot recall which agreement ends in which month, who sent the rent in two instalments or whose deposit was received in cash. A roll turns that into a ten-minute monthly check.

It also helps in practical ways: calculating what a vacant month cost, preparing figures for your CA at year end, or proving the rent history if a bank asks for it.

How do you keep one up to date?

  • Update the status column once a month after the due date, not whenever you remember.
  • Change the roll the same day a tenant moves in or out, or an agreement is renewed.
  • Keep the signed agreements and receipts in a folder named by unit.
  • Hold a copy of the roll in a second place, such as another device.

Where does an expense tracker help?

The roll lists what should arrive; your bank statement shows what did. If you use SpendixAI for your own spending, you can upload the account statement the rent lands in and review the rows before saving, which gives you the evidence side of the story. The roll itself, with its tenant and agreement details, is still best kept as a simple sheet.

First steps

Open a sheet, add one row per unit, fill the six fields from the signed agreements and the last three months of statements, and mark what is missing. Then set a monthly reminder on the day after the rent due date.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports