← All prebuilt solutions
Property

Commercial Rent Roll & Lease Events

Every commercial tenancy in one place – passing rent, reviews, breaks, expiries, WAULT and arrears

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Commercial Rent Roll & Lease Events

Overview

Missing a rent review or break notice deadline can cost a landlord a year or more of higher rent, or leave a unit unexpectedly empty. This workbook keeps the key dates for every commercial tenancy in one place and warns you in good time.

Price
£20
Who it’s for
Property
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Rent Roll

Every tenancy with its next event and alert. What you do: one row per tenancy.

Rent Roll
Rent Account

Step 2

Rent Account

Demands, payments and credits by tenant. What you do: one line per demand or payment.

Step 3

Settings

Report date and warning window. What you do: set once.

Settings

Step 4

Who it is for

Made for people like you

  • Example – text
  • Commercial landlords – Never miss a rent review or break notice deadline.
  • Property companies and SIPPs – Report passing rent and WAULT to lenders and trustees.
  • Managing agents – Track rent demands and arrears by tenant.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Leave the report date as today or enter a date, and set how far ahead you want warnings.
  2. Rent Roll – Enter each tenancy from the lease. Use "Vacant" for empty units.
  3. Rent Account – Record each demand you issue and each payment you receive, choosing the tenant from the list.
  4. Dashboard – Check passing rent, WAULT, events due and arrears.

Key features

  • Keeps every commercial tenancy on one rent roll – tenant, lease dates, passing rent, service charge, deposit and VAT position.
  • Works out the next lease event for each tenancy (rent review, break notice deadline or expiry) and flags anything due within your warning window or overdue.
  • Tracks rent demands and payments to show arrears by tenant, with passing rent, WAULT and an expiry profile on the dashboard.

What’s included

  • Dashboard – Portfolio at a glance
  • Settings – Report date and warning window
  • Rent Roll – Every tenancy and its next event
  • Rent Account – Demands, payments and credits
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions