← All prebuilt solutions
Property

HMO & Rent Arrears Tracker

Rooms, tenants, rent, arrears letters, bills, compliance and profit for houses in multiple occupation

£20

Secure checkout. Your download link is sent as soon as payment clears.

HMO & Rent Arrears Tracker

Overview

Running houses in multiple occupation means dozens of rooms, tenants coming and going, rent arriving in many small payments (often split between Universal Credit and the tenant), bills you pay on the tenants' behalf, and a long list of safety certificates and licence conditions. This workbook keeps all of it in one place. You record properties, rooms and tenancies once, then log rent receipts, bills, expenses and compliance checks as they happen – and it works out who owes what and for how long, drafts the arrears letter, shares the bills between rooms, flags anything overdue, and shows occupancy and profit for every property.

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

Properties

Houses, licences and mortgage interest, with rooms, occupancy and licence status. What you do: enter the yellow columns.

Properties
Rooms

Step 2

Rooms

Rooms with size check, status, current tenant, voids, occupancy and bills share. What you do: enter the yellow columns.

Step 3

Tenants

Every tenancy with deposit and right to rent checks. What you do: enter the yellow columns.

Tenants
Receipts

Step 4

Receipts

Every rent payment received. What you do: add a row for each payment.

Who it is for

Made for people like you

  • Example – text
  • HMO landlords and room-let investors – Arrears, compliance and profit for every house and room on one dashboard.
  • Letting and property managers – A daily arrears list with the right next step and a ready-to-print letter.
  • Landlords with student or professional lets – Bills-included costs per room, voids and occupancy.
  • Accountants and bookkeepers – A per-property P&L for the period you choose.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your details (they print on letters), the report date, the date rent tracking starts, the P&L period, your arrears rules, the bills apportionment method, the compliance intervals and the letter wording.
  2. Properties – One row per house with a short Property ID (e.g. P01), the licence details and the monthly mortgage interest.
  3. Rooms – One row per lettable room with a unique Room ID, its property, size, maximum occupants, advertised rent and whether bills are included.
  4. Tenants – One row per tenancy: Tenant ID, room, dates, rent, frequency and rent day, any opening arrears, the deposit and right to rent details.
  5. Receipts, Bills, Expenses – Log every rent payment, utility bill and running cost as it happens.
  6. Compliance – One row per certificate or check per property, with the date it was last done.
  7. Arrears and Letters – Check the Arrears sheet, then pick a tenant and a letter on the Letters sheet and print it.
  8. Dashboard – Review occupancy, arrears, compliance, tenancy checks and profit.

Key features

  • Properties with licence type and expiry, rooms with size checks, rent and bills, and every tenancy with deposit protection and right to rent follow-ups.
  • Rent schedule against a receipts log – arrears for every tenant, matched oldest-first and aged 0–30 / 31–60 / 61–90 / 90+ days, with the Renters' Rights Act Ground 8 threshold.
  • Merge-field arrears letters – polite reminder, firm reminder and a Section 8 warning – filled in for any tenant with their payment history.
  • Utility bills shared between rooms, a compliance calendar with traffic lights, voids and occupancy, a per-property P&L and a dashboard.

What’s included

  • Dashboard – Occupancy, arrears, compliance and profit
  • Settings – Your details, rules and letter wording
  • Properties – Houses and licences
  • Rooms – Rooms, sizes, voids and bills share
  • Tenants – Tenancies, deposits, right to rent
  • Receipts – Rent received
  • Bills – Utility bills
  • Expenses – Running costs
  • Compliance – Certificates and checks
  • Rent Schedule – Due vs received by month
  • Arrears – Who owes what and how old
  • Letters – Printable arrears letters
  • Property P&L – Profit by property
  • Guide – How to use this workbook

How buying works

Your file is only released 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 download link arrives as soon as payment clears.

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