Blog

Rent roll: what it is and how to keep one clean

Zrico team ·
In short

A rent roll is a list of every unit in a property with its tenant, lease dates, rent, deposit and balance as of a date. A clean one ties to your books: rent charged matches rental income, deposits match the deposit liability, and balances match receivables.

The rent roll is the most requested report in property management. Owners ask for it monthly, lenders ask for it at refinancing, buyers ask for it before they make an offer, and new software asks for it when you switch. It is also one of the easiest reports to let drift, because it is built from lease data that people edit by hand. This post covers what belongs on a rent roll, a worked example, and the checks that keep it honest.

What is a rent roll?

A rent roll is a snapshot of a property's leases on a given date. Each row is a unit. It shows who lives there, on what terms, and what they owe. It is not a ledger: it doesn't show every charge and payment. It summarizes the current state of each lease.

What columns should a rent roll have?

  • Unit, with type or size (beds and baths, or square feet for commercial).
  • Tenant name, or Vacant.
  • Status: occupied, vacant, on notice, or month-to-month.
  • Lease start and lease end.
  • Move-in date, if different from lease start.
  • Contract rent: what the lease says.
  • Market rent: what you would ask today.
  • Recurring charges: parking, pet, storage and so on.
  • Concessions: any recurring discount, with its end date.
  • Security deposit held.
  • Current balance: past due, or a credit.

A worked example

Here is a four-unit rent roll for Maple Court as of November 1:

  • 1A: Maria R., lease Feb 1, 2026 to Jan 31, 2027, rent $1,850, deposit $1,850, balance $0
  • 1B: Vacant, market rent $1,900
  • 2A: D. Kim, month-to-month, rent $1,725, deposit $1,700, balance $125 past due
  • 2B: J. Rivera, lease Jun 1, 2026 to May 31, 2027, rent $1,950, concession -$100 a month through Nov 30, deposit $1,950, balance $0

From those rows you can compute the numbers owners and lenders ask about:

  • Gross potential rent: leased rents plus market rent on vacant units: $1,850 + $1,725 + $1,950 + $1,900 = $7,425
  • Vacancy loss: $1,900
  • Concessions: $100
  • Net rent charged: $7,425 - $1,900 - $100 = $5,425
  • Physical occupancy: 3 of 4 units = 75.0%
  • Economic occupancy: $5,425 / $7,425 = 73.1%
  • Deposits held: $1,850 + $1,700 + $1,950 = $5,500
  • Receivables: $125

The five checks that keep a rent roll clean

Run these at every month-end, before the rent roll goes to anyone:

  1. Rent ties to income. Net rent charged on the rent roll ($5,425 here) should equal rental income posted for the month, adjusted for any prorated move-ins or move-outs. A difference usually means a rent change that was entered on the lease but not on the recurring charge, or the other way around.
  2. Deposits tie to the liability. Deposits on the rent roll ($5,500) should equal the security deposit liability on the balance sheet for the property. A difference usually means a deposit refunded or applied without updating the lease.
  3. Balances tie to receivables. The total of current balances ($125) should equal the receivables aging for the property. Credits should show as credits, not be netted away.
  4. Every lease end has a status. Any lease end date in the past should be month-to-month, renewed or moved out. A lease that ended in March and still says active is the most common rent roll error.
  5. Concessions have end dates. A concession with no end date becomes permanent by accident. Check each one against the lease.

Common problems and their causes

  • Stale market rent: market rent was set at acquisition and never updated, so vacancy loss is understated.
  • Two rents: the lease document says $1,950 but the recurring charge says $1,900. Decide which is right and fix the other.
  • Missing units: a unit offline for renovation drops off the roll. Keep it, marked as down, so the unit count stays right.
  • Notice not recorded: a tenant gave notice by email and the rent roll still shows them staying.
  • Mixed dates: a rent roll run on the 3rd includes payments from the 1st and 2nd but is labeled as of the 1st. Always run it as of a specific date.

A monthly rent roll routine

  1. On the first business day, run the rent roll as of the last day of the prior month and save it. Never overwrite a saved month.
  2. Run the five checks above and note each difference with its cause.
  3. Update market rent on vacant units and on any unit where you changed the asking rent.
  4. Review every lease ending in the next 90 days and record its renewal status.
  5. Compare unit count, occupancy and net rent charged with last month. Any change should have a reason you can name: a move-in, a move-out, a renewal or a rent change.
  6. Send the owner the summary and the exceptions, with the full rent roll attached.

Saving each month's rent roll as of month-end gives you a history that lenders and buyers will ask for later, and it lets you answer the question of what changed without rebuilding the past from ledgers.

Rent rolls for different readers

Owners usually want the summary numbers and a list of exceptions: vacancies, notices, past-due balances and leases ending soon. Lenders and buyers usually want every row, every recurring charge and the lease dates, often for each month of the past year. Commercial rent rolls add square footage, rent per square foot, escalations and recovery terms. Build one clean source and produce each view from it, rather than keeping separate spreadsheets.

Rent rolls and switching software

When you move to new software, the rent roll is usually the backbone of the import. Every unit, tenant, lease and balance flows from it, and the checks above become the tie-out: tenant balances against receivables, deposits against the deposit liability. A clean rent roll before a switch saves days afterward.

How Zrico helps

Zrico builds the rent roll, including an itemized version with each recurring charge, from the same leases and ledgers your accountants use, so it doesn't drift from the books. Rent rolls and other reports are covered at /product/reports, and the deposit and receivable tie-outs live in /product/accounting. A free rent roll layout with the columns above is at /templates/rent-roll. If you are switching, the rent roll is required for the import, and the guided switch at /switch checks it against your trial balance before go-live.

See Zrico run your portfolio.

Bring a property. We will show you, on your own data, what Zrico would have handled last month.