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.
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
- 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.
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.
- 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.
- 02Trial and paid plans
Rent by Direct Debit
Collected into your own Stripe account, with no commission taken.
- 03Trial and paid plans
Who is behind
The Rent page shows what is due, what is paid and the arrears, across every property.
- 04
Room by room
A house let by the room keeps each room’s rent, tenant and arrears on its own line.
- 05Agency plans
Landlord clients
In an agency workspace, each landlord’s homes, their statement each month and the fees taken off the rent.
- 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.
Before they move in
Once they are in
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.
Sources
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.