What is a rent roll and why property managers need one
A rent roll is a single table covering every active lease: who the tenant is, which unit they occupy, at what rent, until what date, and whether they are paying on time. One row per lease. It is the property manager’s working document and the first thing a buyer or a bank asks for.
What a rent roll actually is
Your owner calls and asks three things. How much does the building bring in per month, how much space is sitting empty, and how many leases expire before the end of the year. If answering takes half a day of digging through folders and chat threads, you do not have a rent roll.
A rent roll answers all of that in one table. The name comes from the older practice of keeping a literal roll of rents owed, and it stuck.
The important property: a rent roll describes the current state, not history. It shows what is happening with the asset right now and what is coming in the next few months.
What belongs in a rent roll
The minimum set of columns, without which the table does not earn its keep:
| Column | What goes in it | Why it matters |
|---|---|---|
| Unit | property, unit, floor, area (m²) | ties the row to a physical asset |
| Tenant | legal name, company registration number | who is liable under the lease |
| Rent | amount and currency (EUR/MDL/USD/RON) | basis for income calculation |
| Rent per m² | amount / area | lets you compare units to each other |
| Term | start date and end date | planning renewals |
| Deposit | amount and where it is held | an obligation that comes due at move-out |
| Frequency | monthly, quarterly, annual | building the payment schedule |
| Payment status | paid, N days overdue | day to day control |
| Indexation | present or not, and on what rule | income forecasting |
Beyond that, owners add what they need: sublease, utilities, the responsible manager, early exit terms.
Keep the lease end date in a sortable column. That one field turns the table from a reference sheet into a tool. Sort ascending and you immediately see who you need to talk to about renewal this quarter.
How a rent roll differs from an income statement
The two get confused often, and they answer different questions.
| Rent roll | Income statement | |
|---|---|---|
| Period | snapshot on a date | a period (month, year) |
| Built from | leases | actual receipts and costs |
| Answers | ”what is contracted" | "what did we earn” |
| Read by | manager, buyer, bank | owner, accountant |
Here is a typical mismatch. The rent roll shows a unit let at 1,200 EUR a month, so 14,400 EUR contracted for the year. The income statement for the same year might show 11,000 EUR, because the tenant moved in during March and had two rent free months for fit-out. Both numbers are correct. They describe different things.
Practical rule: use the rent roll for decisions about the future (renew, raise, replace) and the income statement to assess the past.
Why buyers and banks ask for it first
When a building goes to market, the buyer is not looking at walls. They are looking at cash flow, and the rent roll is that cash flow written down in a structured way. It feeds valuation directly: net operating income goes into the cap rate formula and out comes a number.
What gets scrutinised hardest:
- How many leases expire in the next 12 months. If it is half of them, the buyer prices in the risk.
- The spread in rent per m². Wide variation between comparable units usually means some tenants are still on old terms.
- Vacancy. Empty units belong in the table. Leaving them out is not an omission, it is a misrepresentation.
- Tenant concentration. One chain across 60% of the floor area is both stability and a single point of failure.
From experience: a rent roll assembled the day before a deal always looks worse than one kept continuously. The rushed version surfaces leases with unsigned amendments and deposits nobody can account for.
How to build one
Steps for anyone whose data currently lives in scattered files:
- Collect every active lease in one place. Include amendments. What matters is the rent in force, not the rent originally signed.
- Write one row per lease, not per tenant. A single tenant may hold three units on different terms.
- Label the currency explicitly. Not “1,200” but “1,200 EUR”. Mixing currencies in one column without a marker is the most common fault in hand built spreadsheets.
- Include vacant units. A rent roll without them flatters the asset.
- Record deposits and reconcile them against the bank. A deposit is a liability, and when a tenant moves out, “how much do we owe back” should not trigger an archaeology project.
- Decide who updates the table and when. A rent roll goes stale within a week.
That last step is usually what kills the effort. A manually maintained table survives exactly until the first busy week.
Common mistakes
- One implicit currency. Euro and leu properties in the same column with no marker produce a meaningless total.
- No snapshot date. Without “as at 1 August 2026” written on it, the table misleads a month later.
- Rent without frequency. 3,600 per quarter and 3,600 per month look identical on the page.
- Deposits recorded but never reconciled. The figure is in the table, the money is not in the account.
- Vacant units left out. Occupancy then gets calculated from the rows that exist, and the building looks fully let.
How KX Estate handles it
A hand maintained rent roll is always a copy of reality running a few days behind. KX Estate derives it from the underlying records instead. A lease is entered once, the payment schedule unfolds from it automatically, statuses and arrears update themselves, and Open Banking reconciliation closes out paid items. Multi-currency EUR/MDL/USD/RON with National Bank rates is handled per property, so amounts never get silently mixed. The rent roll stops being something you assemble and becomes something you open.
In short: a rent roll is a dated snapshot of active leases, carrying unit, rent, term, deposit and payment status on every row. It answers “what is contracted”, not “what did we earn”, and it is the first document a buyer or lender will ask to see.
Frequently asked questions
How is a rent roll different from a lease register? In practice, barely at all. A rent roll usually implies the table also carries current payment status, not just the lease details.
Do I need a rent roll for a single property? For one unit the lease itself is enough. It starts paying off at three or four leases, when end dates and payment cycles no longer fit in your head.
How often should it be updated? It should reflect today. If you maintain it by hand, weekly is a reasonable floor, plus before any conversation with an owner or a prospective buyer.
Should subleases go in the rent roll? Yes, as separate rows marked as sublease and referencing the head lease. Otherwise the income gets counted twice.
What does a bank look for in a rent roll? Stability of the income stream: lease terms, the share of area with rent expiring soon, vacancy, and how concentrated the income is in one tenant.
Try KX Estate
Manage commercial real estate: properties, contracts, payments and analytics in one place.