The fields a rent roll has to carry, the order that makes the work go quickly, and the four places a copy and paste pass quietly goes wrong.
What does a rent roll actually need, and how do you get it out of the contracts?
A rent roll is the document every other number ends up resting on. A valuation, a budget, a lender’s pack and a service charge apportionment all start by asking the same thing: who is in which unit, on what terms, paying what, and until when. When the rent roll is wrong, nothing downstream of it is checkable, because the error is already inside the number everyone agreed to use.
Most of the time the source is a folder of PDFs, one contract per tenancy, scanned at various angles by various people. Here is how to get from that to a table you can defend.
Fix the key before you collect anything else
Give every row a unique identifier and settle it first, before a single figure is typed. Almost always this is the unit: a building reference and a unit reference together, written the same way every time.
This sounds like housekeeping and it is the step that saves the most work. The contract, the registration record and whatever spreadsheet the property is currently managed on will each name the same unit slightly differently. If you collect the figures first and try to match the rows afterwards, you are matching on tenant names and rent amounts, and both of those change legitimately. Match on the key, and you only have to solve the naming problem once.
Vacant units get a row too. A rent roll that lists only the occupied units answers a different question from the one people will use it for.
The fields, in the order worth collecting them
Work through the contracts in this order rather than reading each one end to end. It keeps you in one part of the document at a time and it means an interruption costs you one field rather than one contract.
- The key: property and unit, exactly as you settled it above.
- The tenant’s legal name, as written on the contract. Not the trading name, not the name on the door, and not the name of whoever signed.
- The term: start date and end date, both as dates rather than as a duration.
- The rent, with the period it covers stated beside it. An annual figure and a monthly figure in the same column is the most common single defect in a rent roll.
- The payment terms: how many instalments and when each falls due.
- The deposit held, and by whom.
- Anything recoverable that is not rent: service charge, a share of utilities, a marketing contribution. Separately, never folded into the rent figure.
- Break rights, renewal options and any notice period attached to either.
Everything above except the payment dates comes from the front page or the schedule of particulars in most standard forms. Collect those eight from each contract, then stop and do the schedule as its own pass.
Do the payment schedule separately, and do it last
The term and the payment schedule are two different calendars and they rarely line up. A lease starting mid month usually has a first instalment covering a stub period, and a lease with a rent free month has an instalment that is missing rather than zero. If you try to capture the schedule in the same pass as the term, you end up carrying the shape of one contract in your head while reading the next one.
Do them as a second pass and the pattern becomes obvious. It also gives you a natural check: add up the instalments you have entered for a row, and compare the total with the annual figure you took from the front of the same contract. Where the two differ you want to be able to say why in a few words, because there is usually a good reason and it is worth recording next to the row rather than rediscovering it later.
Four places this quietly goes wrong
The rent is not one number. Stepped rents, rent free periods and figures quoted inclusive of a charge that is separately recoverable all collapse into nonsense if the roll has a single annual rent column. Give yourself a column for the basis, even if it is empty on most rows.
The document you opened has been superseded. Addenda, side letters and renewal memoranda sit in the same folder as the original and look like more contracts. Before you start, sort the folder by unit rather than by filename and see which units have more than one document. Those are the rows to do carefully.
Dates get read in the wrong order. A folder that has passed through more than one system will contain both day first and month first conventions, sometimes in the same document. Any date at or below the twelfth of the month is ambiguous and will not announce itself. Check the term length against the stated duration on each contract: a lease that reads as fourteen months when the contract says one year has told you which convention that file uses.
The tenant name is a trading name. It matters more than it looks. The legal name is what a demand, a notice or a schedule of dilapidations has to carry, and the trading name is what everybody in the building calls them. Capture the legal name and put the trading name in its own column if you need it.
What to check before you send it to anyone
Five checks, and none of them takes long once the table exists.
- Every row has a key, and no key appears twice.
- Every occupied row has a start date, an end date, and an end date later than the start.
- Every rent figure has its period stated.
- Vacant units appear.
- Every row where the instalments and the annual figure disagree carries a note saying why.
If all five hold, the rent roll is not necessarily right, but it is now wrong in ways that someone can find. That is the whole purpose of the exercise: not a table that looks finished, but one that fails visibly when it is not.










