An HMO isn't one tenancy. It's five, with one boiler.
Track the house room by room.
FOR EACH ROOM (up to 10)
• Tenant, monthly rent, deposit and deposit scheme
• Tenancy start and end dates
• Occupancy — occupied or vacant
• Rent status — paid, due or arrears
PLUS THE SHARED BILLS
Gas, electricity, water, broadband, council tax, TV licence, cleaning,
gardening, insurance and anything else. The bills are yours in an HMO —
this is where they get counted.
THE DASHBOARD SHOWS
• Total rooms and rooms occupied
• Occupancy rate
• Rent from occupied rooms, versus full potential
• Rent you're losing to voids, every month
• Total monthly bills
• Net income — monthly and annual, after bills
• Deposits held, and rooms in arrears
There's a licence expiry field. Use it.
The gap between "full potential" and what you actually bank is the real
story of an HMO. Most people only see it at year end.
Excel (.xlsx). Works in Microsoft Excel and Google Sheets. Instant download.
Educational tool only. Not financial, tax or legal advice. Licensing rules
vary by council — check with yours. Correct as of July 2026.
An HMO isn't one tenancy. It's five, with one boiler.
Track the house room by room.
FOR EACH ROOM (up to 10)
• Tenant, monthly rent, deposit and deposit scheme
• Tenancy start and end dates
• Occupancy — occupied or vacant
• Rent status — paid, due or arrears
PLUS THE SHARED BILLS
Gas, electricity, water, broadband, council tax, TV licence, cleaning,
gardening, insurance and anything else. The bills are yours in an HMO —
this is where they get counted.
THE DASHBOARD SHOWS
• Total rooms and rooms occupied
• Occupancy rate
• Rent from occupied rooms, versus full potential
• Rent you're losing to voids, every month
• Total monthly bills
• Net income — monthly and annual, after bills
• Deposits held, and rooms in arrears
There's a licence expiry field. Use it.
The gap between "full potential" and what you actually bank is the real
story of an HMO. Most people only see it at year end.
Excel (.xlsx). Works in Microsoft Excel and Google Sheets. Instant download.
Educational tool only. Not financial, tax or legal advice. Licensing rules
vary by council — check with yours. Correct as of July 2026.
