Skip to main content
LetCompliance

The whole book on one sheet, England

Rent roll template. Every home’s rent as a month and a year, totalled as you go.

A rent roll lists each let home with its rent and what it brings in, so an agency or a portfolio landlord sees the whole book at once. This builds one as an Excel workbook: the month worked out from any rent period, the year, the share let, the arrears and the fees, all as formulas that keep adding up as rows are added.

Build my rent rollLetCompliance software, from £7.99 a month

LetCompliance is online software that runs your whole let: finding and referencing the tenant, the agreement, the rent, repairs and the tax. The workbook costs nothing and needs no account.

Written for

  • Letting agents
  • Portfolio landlords
  • House shares
  • Weekly rents
Recognised by HMRC for Making Tax Digital
a weekly rent as a month, so £200 a week is £866.67
× 52 ÷ 12
GOV.UK’s guide for landlords
weekly, fortnightly, four-weekly or monthly
4 periods
a periodic tenancy runs a month or less
with the formulas in every one
500 rows
the homes you enter filled in

Last updated . Law checked against legislation.gov.uk and GOV.UK on . Sources

The rent roll

Build the rent roll, with the totals worked out.

Add each home or room, with its rent and how often it is due, whether it is let, under notice or empty, and any arrears and management fee. The workbook downloads here, with a copy sent to your inbox. It carries no logo and no mark of this site: it is your record.

0 of 2 required detailsAbout 3 minutes
The roll
The homes

One block for each home, or each room in a house let by the room. An empty home keeps its rent so the workbook shows what it would bring in. The management fee is a percentage of the rent, without VAT. Up to 40 here; the workbook has room for more.

Home 1

The totals show here as you add homes.

Where to send it

Downloads here, with a copy by email. Guidance only, not tax advice.

LetCompliance emails the workbook to the address above with a note on what the account does, and sends more only if you tick the box above. Data controller: LetCompliance (UK). See the privacy policy and terms.

Share this template

𝕏

The answer

What a rent roll is, and how to keep one

A rent roll is the list of homes a landlord or a letting agency lets, each with its rent and what it is contracted to bring in. Added up, it gives the income a month and a year from the homes let, and beside it the homes empty, the arrears and, for an agency, the fees. The template builds it as an Excel workbook, a row for each home or room, with the totals worked out by formulas so the file keeps adding up as it changes.

Rent is charged by different periods, so the roll turns each into a month. A weekly rent is weekly × 52 ÷ 12, the conversion GOV.UK’s Universal Credit guide for landlords gives: £200 a week is £866.67 a month, not £800: a year has 52 weeks, not 48. Fortnightly is × 26 ÷ 12 and four-weekly × 13 ÷ 12. GOV.UK says an assured periodic tenancy runs on a rolling basis and cannot be for longer than a month at a time, so those four periods are the ones the lists offer.

Each row has a status: let, notice given or empty. A home under notice is still let and still in the roll until it ends. An empty home keeps the rent it is let at, so the Summary tab shows what the empty homes would bring in a month, the figure a void costs, beside the share of homes let.

Arrears go beside each home and are added up against a month’s roll, so a rising share shows before it becomes a problem. For an agency, the management fee goes in as a percentage of the rent, without VAT, and the roll works out each home’s fee a month and the total, on the homes not empty.

A spreadsheet is only as current as its last edit. Kept by hand, a rent roll drifts from the tenancies: a rent rise not copied across, a room let again at a new figure, a home that went empty. Drawing it from the tenancy records keeps it right without retyping.

What this does not do: value a lettings business, keep an agency’s client account, or decide what a home should rent for. It is a record of the figures entered, for homes let in England. Sources, read on 19 November 2026: GOV.UK’s Universal Credit and rented housing: guide for landlords and Assured periodic tenancies: a guide for tenants.

What the account adds

After the workbook: the roll kept by the tenancies.

Six things an account does with the same homes.

  1. 01Trial and paid plans

    The rent roll in Reports

    Each property’s rent as charged and its monthly figure, as things stand today, as a PDF or a spreadsheet.

  2. 02Trial and paid plans

    Rent by Direct Debit

    Collected into your own Stripe account, with no commission taken.

  3. 03Trial and paid plans

    Who is behind

    The Rent page shows what is due, what is paid and the arrears, across every property.

  4. 04

    Room by room

    A house let by the room keeps each room’s rent, tenant and arrears on its own line.

  5. 05Agency plans

    Landlord clients

    In an agency workspace, each landlord’s homes, their statement each month and the fees taken off the rent.

  6. 06Trial and paid plans

    The rent statement

    Month by month for a tenancy: charged, paid and the balance carried forward.

One login, the whole let. You are on step 10 of 12.

A rent roll is the rent at one glance. The account covers the rest of the let: the advert and applications, referencing, the signed tenancy, the deposit, the check-in, the rent every month, and the tax figures at the end of the year.

See the whole let in one account

FAQ

Rent roll questions, answered.

What is a rent roll?

A list of the homes a landlord or letting agency lets, each with its rent and what it brings in, added up to the month’s and the year’s income from the homes let, usually with the arrears and the empty homes beside it.

How do you turn a weekly rent into a monthly one on a rent roll?

Weekly × 52 ÷ 12, as GOV.UK’s Universal Credit guide for landlords does: £200 a week is £866.67 a month, not £800. Fortnightly is × 26 ÷ 12 and four-weekly × 13 ÷ 12.

Should empty homes be on the rent roll?

Yes, at the rent they are let at, but outside the roll’s total. The Summary tab shows them as rent not coming in a month, beside the share of homes let.

Do the management fees include VAT?

No. The fee goes in as a percentage of the rent without VAT, so the figure is the agency’s own income before its costs. VAT charged on a fee is collected for HMRC.

Can I use it for a house let by the room?

Yes. Give each room its own row, with the room in the unit column, its own rent and its own tenant. The roll adds the rooms up like any other homes.

Does this value my lettings business?

No. It adds up the rent the homes are contracted to bring in. What a lettings book is worth depends on far more than the rent roll, and this does not work that out.

Can LetCompliance keep the rent roll for me?

Yes, from the tenancies themselves. On the trial and every paid plan, from £7.99 a month, Reports has a rent roll with each property’s rent as charged and its monthly figure, as a PDF or a spreadsheet, and the Rent page shows who is behind. In an agency workspace each landlord client gets a statement each month, with the fees taken off the rent.

Run the whole let from one login.

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.