What Is a Rent Roll and Why Does It Matter for Your Books?

If you manage rental properties, you’ve probably heard the term rent roll. You may even have one: a spreadsheet listing your tenants and what they pay. But a rent roll used properly is more than a contact list. It’s a financial document that should connect directly to your books.

Rent roll reconciliation is a key part of our property management accounting service. Here’s what a complete rent roll looks like and how to use it.

What a Rent Roll Should Include

At minimum, a rent roll should show:

Property address and unit number
Tenant name
Lease start and end date
Monthly rent amount
Security deposit collected
Current balance: whether the tenant is current, has a credit, or is past due

More detailed rent rolls also include move-in dates, lease type (month-to-month vs. fixed), any concessions or rent abatements, and notes on upcoming renewals or vacancies.

The goal is a single document that tells you the current state of your entire portfolio’s income.

How the Rent Roll Connects to Your Books

Your rent roll is the source of truth for what your rental income should be each month. Your bank deposits tell you what you actually collected. Any gap between those two numbers is what needs to be investigated.

This is called rent roll reconciliation, and it’s something your bookkeeper should do every month:

Pull the expected income from the rent roll (rent due × occupied units)
Compare it to rent deposits recorded in QuickBooks
Identify and document any discrepancies: late payments, partial payments, vacancies, or recording errors

If a tenant paid short, that difference sits as an accounts receivable until it’s collected. If a unit is vacant, it shows up as lost income. If extra charges like late fees were assessed, they need to appear in the books too.

Without this reconciliation, you might not notice that one tenant has been consistently paying $50 short for four months, or that a deposit was recorded twice. Related to this, make sure you’re also recording security deposits correctly so they don’t distort your income numbers.

Vacancy Tracking

Your rent roll is also the right place to track vacancies. A vacant unit is revenue you’re not collecting, and the rent roll should make that visible at a glance. When you reconcile each month, you’ll see exactly which units are driving gaps between expected and actual income.

Over time, vacancy data becomes useful for portfolio analysis: Which properties or unit types have the highest turnover? Are there seasonal patterns? Where is deferred maintenance contributing to longer vacancies?

What Lenders Want to See

Whenever you’re refinancing, getting a new loan, or selling a property, lenders and buyers will ask for your rent roll. It’s part of their due diligence to confirm that the income you’re claiming is backed by actual leases.

A well-maintained rent roll that matches your bank records and P&L is a strong signal that the books are accurate and the business is well-run. An inconsistent or outdated rent roll, or one that doesn’t match what the financial statements show, slows the process down and raises questions.

Tools for Keeping It Current

Some property management software (AppFolio, Buildium, Rent Manager) generates rent rolls automatically. If you’re self-managing, a well-organized spreadsheet is fine as long as it’s updated consistently.

The key is treating it as a live document, not something you pull together once a year when someone asks for it. Your bookkeeper should be able to request your rent roll at any time and reconcile it to your books without significant cleanup.

If you’re not sure whether your rent roll and your QuickBooks records are in sync, book a free consultation and we can walk through the reconciliation together.