Rent roll: structure, content and template for property owners

Laptop with a spreadsheet and the floor plan of an apartment building on a wooden table

In short: A rent roll (Mieterspiegel) is a list of all rental units in a property with use, area, rent, service charges, contract data and vacancies as at a reference date. It shows at a glance what income a property generates today and what it could generate if fully let. Owners need it for reporting, banks for financing and prospective buyers for valuation.

What is a rent roll?

A rent roll lists every lettable unit of a property on one line: apartments, commercial premises, parking spaces, hobby rooms and other ancillary units. Each line contains the data on the unit (use, location, rooms, area), the contract (start of tenancy, type of contract, termination date) and the income (net rent, service charges, gross rent).

Below the table are the totals and key figures. This makes the rent roll the shortest summary of an investment property: anyone who reads it sees income, vacancies and rent levels without opening a single tenancy agreement.

What is a rent roll needed for?

The content is always similar; the emphasis depends on the recipient.

PurposeRecipientWhat matters
Owner reportingOwners, board of directors, investment committeeDevelopment of income, vacancies, tenant changes since the last report
SaleProspective buyers, brokersComplete income, vacancies, types of contract, notices of termination, rent levels compared with the market
FinancingBankSecured actual income, mix of residential and commercial use; banks provide their own templates, for example Schwyzer Kantonalbank and Thurgauer Kantonalbank
ValuationValuerTarget and actual income, areas, rent per m², potential on re-letting
Authoritiese.g. housing promotionReview of rents; the canton of St. Gallen requires its own rent roll for this

In a sale, the rent roll is particularly important because the tenancy agreements pass to the buyer together with ownership (Art. 261 para. 1 CO). Whoever buys therefore takes over exactly the income and contracts shown in the rent roll.

Which columns belong in a rent roll?

Bank templates in Switzerland show what counts as minimum content. The Schwyzer Kantonalbank template distinguishes between required and optional fields. From this and from practice, the following overview results:

ColumnRequired or optionalWhy
Unit no. and use (apartment, commercial, parking, ancillary room)RequiredClear assignment, mix of uses
Location or floor, rooms, area m²RequiredComparison of rents per m²
Status let or vacant, start of tenancy or vacant sinceRequiredVacancies and length of tenancy
Net rent and service charges per monthRequiredIncome; service charges are pass-through items
Gross rent per monthRequired (calculated)Sum of net rent and service charges
Type of contract (open-ended, fixed-term, indexed, graduated)Optional, important for a saleDetermines how the rent can be adjusted
Fixed term until or next termination dateOptionalPredictability of income
Basis reference interest rate and consumer price indexOptional, important for a saleShows potential for increases or reductions
Target rent for vacant unitsOptionalBasis for target rental income
Rental depositOptionalSecurity held
RemarksOptionalRenovations, notices received, no personal data

The reference interest rate on which a rent is based is often the most interesting column for prospective buyers. If a rent is based on a higher rate than the current one, there is a claim to a reduction; if it is based on a lower one, there is room for an increase when rates rise. More on the pages on the reference interest rate and rent increases. If the landlord did not pass on everything at an earlier adjustment, a quantified reservation also belongs in the remarks (see rent reservation).

Which key figures belong in the rent roll?

The four key figures almost every recipient looks for can be calculated directly from the table. The terms are not used consistently in practice, so the definition belongs in the rent roll itself.

Key figureFormula in the template
Target net rental income p.a.Let units: net rent x 12; vacant units: target rent x 12
Actual net rental income p.a.Let units only: net rent x 12
Vacancy rate by income(target minus actual) : target
Vacancy rate by numbervacant units : all units
Gross yieldNet rental income p.a. (without service charges) : investment costs or purchase price

The courts of the canton of Zurich describe gross yield as the ratio of gross income, i.e. total rental income, to investment costs. Service charges are left out of the template because they cover operating costs and do not form income. Anyone who calculates differently should state this in the rent roll.

Worked example: key figures for an apartment building

An apartment building with six apartments and four parking spaces, purchase price CHF 3.8 million. On the reference date, one apartment is vacant and offered at CHF 2,200 net per month. One parking space is also free. All values are example values.

ItemCalculationCHF per year
5 apartments letNet rents 1,850 + 1,920 + 2,100 + 2,250 + 1,780 = 9,900 per month x 12118,800
1 apartment vacantTarget rent 2,200 x 1226,400
3 parking spaces let3 x 150 x 125,400
1 parking space vacant150 x 121,800
Target net rental incomeSum of all items152,400
Actual net rental income118,800 + 5,400124,200
Rent roll worked example, CHF per year: target net rental income 152,400, actual net rental income 124,200, loss of income due to vacancies 28,200 or 18.5 %. Example with 6 apartments and 4 parking spaces.

This gives the following key figures:

  • Loss of income due to vacancies: CHF 152,400 minus CHF 124,200 = CHF 28,200 per year.
  • Vacancy rate by income: 28,200 : 152,400 = 18.5 %.
  • Vacancy rate by number of apartments: 1 : 6 = 16.7 %.
  • Gross yield on target income: 152,400 : 3,800,000 = 4.01 %.
  • Gross yield on actual income: 124,200 : 3,800,000 = 3.27 %.

The difference between 4.01 % and 3.27 % shows why a rent roll should always state both values: showing only target income glosses over the vacant apartment; showing only actual income hides the potential.

What applies to data protection?

A rent roll with names contains personal data, i.e. information relating to identified or identifiable persons (Art. 5 let. a FADP). Processing must be proportionate and serve a recognisable purpose (Art. 6 para. 2 and 3 FADP). For passing it on, this means: only the data the recipient needs for their purpose goes out.

  • Sale and valuation. Prospective buyers and valuers need rents, areas and contract data, but usually no names. Unit numbers or “tenant A, B, C” are enough instead of names. Specialist articles and property management software recommend redacting names or anonymising them automatically.
  • Financing. Some bank templates include the tenants' name as a field. It is worth clarifying before sending whether the bank really needs it.
  • Sensitive personal data. Information on health or social assistance measures is sensitive (Art. 5 let. c FADP) and does not belong in a remarks column either, for example “rent paid by social services”.
  • After the purchase. With the transfer of ownership, the tenancies pass to the buyer (Art. 261 para. 1 CO). From then on, the buyer needs the complete contract data.

Processing that violates these principles can infringe the personality of the persons concerned and is only permitted with a justification, such as consent or an overriding interest (Art. 30 and 31 FADP).

How often should the rent roll be updated?

A rent roll is only correct on the reference date. In larger properties, tenant changes, vacancies and rents change constantly, which is why the reference date belongs clearly visible in the header.

OccasionWhat to update
Change of tenantStart of tenancy, rent, deposit, status
Rent adjustmentNet rent, basis reference interest rate and consumer price index
Notice receivedRemark, termination date
VacancyStatus vacant, vacant since, target rent
Annual accounts or reportingEntire rent roll to a new reference date
Sale or refinancingReference date immediately before sending

An outdated rent roll does more damage in a sale than a vacancy: the actual letting status comes to light in the due diligence at the latest.

From the property manager's point of view: a rent roll without duplicate entry

For property managers, the rent roll is rarely a one-off. It is due every quarter for reporting, for banks at every refinancing and for owners on request. To avoid doing it by hand every time, three rules help:

1. One source. The data comes from the property accounting or management software, not from a separately maintained Excel list.

2. Fixed columns, changing views. One complete internal rent roll, and from it a view with or without names depending on the recipient.

3. Secure sending. Rent rolls contain income figures and often personal data. They do not belong as an open email attachment to a large distribution list.

With Allthings Dossier, property managers make documents available securely online for tenants and owners, without unprotected email, for example quarterly reporting for the owners. More on working with entire portfolios on the page property management.

Sources

  1. Federal Act on Data Protection (FADP), Art. 5, 6, 30 and 31 (fedlex, SR 235.1, version of 7 July 2025)
  2. Swiss Code of Obligations (CO), Art. 261 (fedlex, SR 220, version of 1 October 2026)
  3. Courts of the canton of Zurich: excessive return (net and gross yield)
  4. Schwyzer Kantonalbank: rent roll template (Excel, required and optional fields)
  5. Thurgauer Kantonalbank: rent roll template (Excel)
  6. Fairwalter: what information should the rent roll contain?
  7. law.ch: real estate as an investment, the desire for comparability (terms gross yield and target rental income)

Information as of 4 November 2026.

FAQ

Frequently asked questions

What is a rent roll?

A list of all rental units in a property with use, area, rent, service charges, contract data and vacancies as at a reference date, supplemented by totals and key figures.

Is a rent roll required by law?

No, there is no general statutory obligation. Banks, prospective buyers and funding bodies regularly ask for one, however.

What information does a rent roll need as a minimum?

For each unit: use, location, area, let or vacant, start of tenancy, net rent and service charges, plus the reference date and property details in the header.

Do tenants' names belong in the rent roll?

Only if the recipient needs them for their purpose. For sales and valuations, unit numbers are usually enough, because personal data may only be processed proportionately (Art. 6 FADP).

What is the difference between target and actual rental income?

Target rental income is the income if fully let; actual rental income is the income from the units actually let. The difference is the loss of income due to vacancies.

How do you calculate the gross yield of a property?

Annual net rental income without service charges divided by investment costs or purchase price. In the template it is calculated on both target and actual income.

How often does a rent roll have to be updated?

At every change of tenant, every rent change and every vacancy, but at least before every time it is sent. The reference date shows how up to date it is.

What is the difference between a rent roll and a rent index?

The rent roll (Mieterspiegel) lists the tenancies of a specific property. A rent index (Mietspiegel) is a German term for the customary local comparative rent of a municipality.

Easy. Pragmatic. Swiss. This is how real estate business works today.

Book an appointment now
Customer login
Next
Contact

Contact the Allthings team

Our team usually answers within 24 hours.

Fill out the contact form

We process your data to answer your request. For more details, see our privacy policy.

Submit
Thank you! We will get back to you shortly.
Something went wrong while sending. Please try again or write to info@allthings.me.