Rent tracking for an HMO is not complicated in principle. Six rooms, six tenants, six rent amounts, six payment dates. In practice it gets complicated fast. Tenants move in mid-month. Rooms sit empty between tenancies. Some tenants pay weekly, others monthly. This guide covers how to track it properly.
The core record you actually need
Every HMO landlord needs three things tracked per room, not per property. First, who is in the room and from when - with the exact start date because pro-rata calculations depend on it. Second, what the rent is and when it is due. Third, every payment received against that room, with the date it actually cleared. Without all three, you cannot tell at a glance whether you are owed money or who owes it.
The problem with standard rent tracking
Standard landlord apps and spreadsheets track rent at property level. Total rent due for the property each month, total received, balance. This is useless for an HMO where you have six different tenants who may each be in arrears by different amounts. You need to know that room 3 has not paid this month, not that the property total is short. That distinction matters enormously when you are having conversations with tenants.
Building the tracking model
The simplest effective model uses one row per expected payment, not one row per tenant. Every week or month, a row appears for each room showing what was due. When payment comes in, you match it to that row and record the date received and amount. Partial payments stay as partial payments. At any point you can filter by room and see the complete payment history.
Handling the complications
Mid-month move-ins need a pro-rata calculation for the first period. The formula is monthly rent divided by days in the month, multiplied by days occupied. This should be calculated once when the tenancy starts and recorded as the first expected payment amount. Voids between tenancies need to appear in the tracker as a gap, not as a missed payment.
When to move beyond spreadsheets
A spreadsheet model works well for portfolios up to around 15-20 rooms. Beyond that, the manual matching of payments to expected rows becomes time-consuming enough that errors start appearing. A custom web-based tool that automatically creates the expected payment rows, flags anything overdue, and shows a dashboard of the whole portfolio by room takes the manual work out entirely.
Want to talk through your situation?
Book a free 30-minute call. Tell us what you need and we will tell you the best approach and what it would cost.
Book a free scoping call