For private landlords and letting agents

Rent review calculator with CPI, rent history and RTB deadlines

A rent review in a pressure zone has to follow a formula, a notice period and a deadline for telling the RTB. The workbook estimates the new rent the way the RTB calculator does, keeps the full rent history of each tenancy and warns before registrations and notices fall due.

  • 20 properties and 40 tenancies
  • CSO all-items CPI from January 2020
  • Lower of CPI and 2% a year, pro rata
  • 90-day notice and 7-day RTB copy
Add to basket
Rent Review & Tenancy Register – Dashboard
10sheets
20properties
0macros

How the estimate is worked out

RENT CALCULATOR compares the CPI for the month before the new rent with the index when the rent was last set, and caps the increase at 2% a year pro rata. The CPI series is included up to September 2026 and can be extended month by month.

A look at the sheets

Rules and deadlines

  • A rent review at most once every 12 months, with the 24-month rule where it applies
  • Rent review notice served on the tenant no less than 90 days ahead
  • RTB to receive a copy within 7 days
  • RTB registration and annual renewal dates
  • Termination notice periods for landlord and tenant, by how long the tenancy has lasted

History and ledger

RENT HISTORY keeps every rent set or reviewed with the previous rent and the change. RENT LEDGER records rent received for 12 months per tenancy and shows arrears, and NOTICES lists rent review, warning and termination notices with their dates.

What is in the file

  • START
  • SETTINGS
  • PROPERTIES
  • TENANCIES
  • RENT HISTORY
  • RENT CALCULATOR
  • RENT LEDGER
  • NOTICES
  • CPI INDEX
  • DASHBOARD
File format
.xlsx
Tabs
10
Capacity
20 properties · 40 tenancies · 150 rent changes
Requires
Excel 2016+ / Microsoft 365
Macros
None

Questions people ask

Is this the official RTB calculator?
No. It follows the same method to give an estimate. Check the result with the RTB's own calculator before serving a notice.
Does it know the rules from March 2026?
The settings reflect the rules checked in autumn 2026, including the changes from March 2026. The cap and notice periods are editable.
Can I record properties outside pressure zones?
Yes. Each property has its own details, and the rent history works for any tenancy.

Review the rent right the first time

Add the rent review workbook to your basket and continue to payment.

Add to basket