Real estate
How to calculate rental occupancy rate when a flat is under refurbishment
Follow three flats through September and measure the effect of vacancies and repairs on a portfolio report.
A portfolio manager sees two of three flats occupied on 30 September. Can that snapshot explain how much lettable capacity went unused during the month? Download the synthetic rental history. Each row covers one continuous spell for a unit. The first day is included and the end day is excluded. Day 31 represents the boundary at 1 October, so a spell from day 1 to day 31 contributes 30 unit-days.
Flat A was occupied all month. Flat B was vacant for the first ten days and occupied for the remaining twenty. Flat C spent fifteen days under refurbishment and fifteen days vacant. Under this reporting agreement, occupied and vacant days count as lettable. Refurbishment days count towards total portfolio capacity but sit outside lettable capacity.
Reconcile the three flats to 90 calendar unit-days. Of those, 50 were occupied, 25 were vacant and 15 were under refurbishment. Lettable occupancy was 50 ÷ 75, or 66.7%. The month-end snapshot happens to yield the same percentage. To see why the measures differ, move Flat B’s tenancy start from day 11 to day 16 in the Real estate worksheet. Update both adjoining spell boundaries. Occupied days drop to 45 and lettable occupancy to 60%. The month-end snapshot still shows two occupied flats.
Before publishing the rate, check each unit’s spells for overlaps and gaps against its inventory dates. A duplicate occupied spell inflates both numerator and denominator. A missing vacant spell can quietly improve the reported percentage. Ask the property manager to sign off refurbishment dates against work orders, since reclassifying vacancy as refurbishment also raises the rate. All unit labels and dates in this exercise are invented.
For a separate property-sales study, HM Land Registry publishes transaction prices for England and Wales. Choose a period and property type, record the extract date and account for registration lag. To reproduce the occupancy study you would instead need tenancy dates, inventory and refurbishment records. HM Land Registry Price Paid Data and reuse terms
Download the example workbook. The formulas cover the supplied rows. Extend the ranges before adding new records.
Decide what question the property manager needs answered
Imagine two phone calls on the last morning of September. A letting agent wants a list of flats that can be offered for viewings today. The asset manager wants to know how much September capacity went unused across the portfolio. Both ask about occupancy. The agent needs the current state of each unit. The asset manager needs the history of each unit over the month. Give the first person a dated inventory and the second a calculation in unit-days. Putting the same percentage in both emails can give each reader the impression that the other question has been answered.
Ask one more question before choosing the headline. A manager responsible for marketing can influence how quickly a ready flat lets. A manager responsible for refurbishment can influence how quickly it becomes ready. Excluding refurbishment days from the letting team's denominator makes sense for evaluating the time they had a property available to market. Those same days matter to the owner considering lost capacity across the entire asset. In the example, occupied time as a share of all owned capacity is fifty out of ninety days, about 55.6%. Put that beside the 66.7% lettable figure when both responsibilities are under review.
Build the timeline from documents the team recognises
Take one flat and start with its inventory entry. Write down the day it came under management and, if applicable, the day it left. Mark the reporting month on that line. Now add tenancy start and end dates from the tenancy record. Place any period of refurbishment on the same line using the work order and the date the flat returned to lettable stock. A maintenance invoice may arrive weeks after the work finishes. Using its posting date for the end of refurbishment could erase genuine vacancy from the report.
Agree how a handover day works. Suppose an outgoing tenant returns the keys on Monday and the incoming tenant takes possession on Tuesday. A source that records the last occupied date and a source that records the first free date can describe this transition with different dates. Convert both to a single convention before calculating durations. Then draw Monday and Tuesday as two boxes and ask the housing officer who had possession on each day. A one-day gap in a short month can matter across hundreds of units.
Where two systems disagree, keep the references that would let a person settle the question. A signed tenancy, a keys register and the booking diary can have different business meanings. A flat may be reserved while still standing empty. If the organisation wants to measure signed future lets, create a forward-looking indicator with the expected start date. Counting the reservation as occupied today could disguise a delay getting the property ready for its new tenant.
Compare buildings with the right weights
Consider adding a second building to a portfolio. Its single available flat was occupied for all ten days it was under management. The original building supplied fifty occupied days out of seventy-five lettable days. Combining the two produces sixty occupied days out of eighty-five lettable days, about 70.6%. Averaging 66.7% and 100% gives about 83.3%, which treats a building offering ten days as equally influential as one offering seventy-five. A report designed to describe a typical building might deliberately choose equal weights. A portfolio capacity report needs the underlying days.
Keep the counts when presenting month-on-month movement. A property acquisition near the end of a month adds fewer days to that month than to the next. Selling a mostly empty block can raise the portfolio rate while every remaining building performs exactly as before. Prepare a second comparison restricted to units held throughout both periods if the owner wants to assess operational change. Retain the full portfolio figure as well, because it still describes the capacity actually managed.
Also distinguish occupied time from income. A tenant can occupy a property during a rent-free period, while in arrears or at a discounted rent. Counting those days as occupied tells you about use of space. To explain rental income you also need the rent schedule, concessions, dates and the accounting treatment agreed with finance. A conversion from physically occupied days to cash received cannot be inferred from tenancy dates alone.
Check what happened to the vacant days
There are twenty-five vacant days in the sample. Ten came before Flat B's tenancy and fifteen came after the work on Flat C. Those are different conversations. Ask the letting agent when Flat B was listed and when a suitable applicant could move. Ask the property manager when Flat C was ready for viewings, whether the keys had been handed back and whether the letting team received the release notice. The monthly percentage points to a question. The sequence of events determines who can act on it.
Try changing the classification as an acceptance test. Move five days of Flat C from vacant to refurbishment and keep the total inventory unchanged. Occupied time stays at fifty days but lettable capacity falls to seventy days. The headline rises to about 71.4% without a single new tenant. That movement should be visible in the day counts and traceable to a work order. If your report shows only the headline, a reader may credit the letting team for an apparent gain caused entirely by classification.
At month end, ask the property manager to reconcile the per-unit calendar to the inventory list, including units with no tenancy event during the period. A flat that stayed empty all month may have generated no activity at all. Starting from tenancy transactions would make that flat disappear. Starting from the managed inventory gives it thirty days that someone must explain. Keep the exception list beside the approved report and identify the person who can resolve each gap before the next review.
Use the report at the next portfolio meeting
Bring the vacancy history for one flat to the meeting and ask the team to choose a next action. Suppose Flat C is now ready but the listing still shows the previous kitchen. Updating the photographs and booking a viewing is a decision the letting team can own. If the refurbishment contractor still holds the keys, the property manager has a different action. Both situations look like an empty flat to somebody driving past. Only one represents capacity the agent could reasonably have let yesterday.
Record the agreed action with the date somebody will check it. At the next meeting compare the actual day the flat became lettable, the day it was advertised and the day a tenant took possession. Over several turnovers those intervals can show where the business repeatedly loses time. The occupancy figure then becomes a way to find the next practical improvement, with enough evidence for the people doing the work to challenge or confirm the explanation.
Related resources
Data reconciliation: how to sign off a report when two systems disagree
A practical guide to choosing the control total, tracing a difference and deciding when a replacement report is ready to use.
First pass yield: why one batch can produce three different percentages
Use five inspections to separate first-time quality from successful rework and decide where to investigate.
How to measure on-time pickups when trips have missing timestamps
A dispatcher has five trips and three measured pickups. Work out what the punctuality figure can tell you before changing the rota.
Turn the trend into shipped software
I contract as a senior fullstack and data engineer, building the production systems your customers and your reporting depend on.