A rent roll is the running list of every unit you manage, who lives or operates in it, what they owe each month, and where the lease stands. Owners ask for it, lenders ask for it, and buyers read it before they read anything else. When the rent roll and the accounting records disagree, someone notices, usually at the worst moment. Keeping the two in step is bookkeeping work, and that is where specialized property management accounting earns its place.
What a Rent Roll Is, in Plain Terms
Think of it as a snapshot of income potential on a given date. Each row is a unit. Each column answers a question about that unit: is it occupied, under what lease, at what rent, and is the tenant current on payments. Investopedia’s overview of property management describes the manager’s job as running day-to-day operations for an owner, and the report is the document that shows the owner whether those operations are producing income.
It is not the same thing as a tenant ledger. A ledger follows one tenant’s charges and payments over time. The report sits one level up and lists all the tenants together, one line each.
What Belongs on a Rent Roll
Formats differ from one company to the next, but a useful rent roll usually carries these fields:
- Unit number and unit type (studio, two-bedroom, suite, retail bay)
- Tenant or entity name and the lease start and end dates
- Current monthly rent and any recurring charges billed with it, such as parking or pet rent
- Security deposit held for that unit
- Balance due or credit on the tenant account as of the report date
- Status: occupied, vacant, on notice, or month-to-month
Commercial portfolios often add square footage, rent per square foot, and lease escalation dates. Residential portfolios add the move-in date and renewal status. Whatever you include, keep the column set consistent from month to month so the reports can be compared.
Why Owners, Lenders and Buyers Care About It
Owners use the rent roll to see whether their building is performing. A lender reviewing a loan application on an income property will usually want to see current rents and lease terms before anything else. A buyer doing due diligence reads the report and then checks whether the bank deposits back it up.
That last step is the important one. A report that says a unit pays a given amount is only a claim until the general ledger and bank statements confirm it. When you hand the report to a third party, you are vouching for it.
How the Rent Roll Ties to Your Accounting
Every number on the rent roll should trace to a transaction. Rent charges should match what was posted to income. Security deposits listed on the report should match the liability balance in the trust account. Tenant balances should add up to accounts receivable.
Here is a quick, hypothetical example. Say the report lists 20 units with a total monthly scheduled rent of a certain amount, and the general ledger shows income posted for only 19 of them. Either a unit was vacant and the report is stale, or a charge was never posted. Both are fixable, but you only find them if someone compares the two reports every month.
This comparison belongs in the month-end routine. Our month-end closing checklist walks through where it fits among the other close tasks.
Common Errors That Make a Rent Roll Unreliable
- Vacant units still showing the previous tenant’s rent.
- Lease renewals or rent increases entered on the lease but never updated in the accounting system.
- Concessions (free rent, discounts) recorded as full-rent charges, or not recorded at all.
- Deposits listed on the report that do not match the trust account balance.
- Move-outs processed in the property system but not reflected in the ledger, leaving phantom receivables.
- Different versions of the report circulating because someone exported it before a late correction.
None of these is exotic. They come from timing gaps between the person who handles leasing and the person who keeps the books. Closing that gap is mostly a matter of routine.
Reading Lease Expirations on the Report
One column deserves more attention than it usually gets: the lease end date. Sort the units by expiration and you can see how many leases end in the next three, six and twelve months. If a large share ends in the same month, you face a possible wave of vacancies and turnover costs at once. Spreading renewals across the year, where the market allows it, smooths cash flow and gives the owner steadier statements.
Month-to-month tenants should be flagged separately. They can be perfectly good tenants, but the income they represent is less certain than a signed term, and a buyer or lender will read that difference. Accurate dates on the report are what make this analysis possible in the first place.
Rent Roll vs. Occupancy: Reading What the Numbers Say
Occupancy is the share of units that are occupied. The report gives you that and more, since it also shows rent levels and lease expirations. A building can be fully occupied and still underperform if leases are expiring in a cluster or if rents are below what comparable units are asking.
Vacancy is the other side of the picture. Investopedia explains the vacancy rate as the percentage of units that are unoccupied at a given time. If you track it monthly next to the report, you can see whether a soft month was a one-off or a pattern. Owners appreciate seeing lease expirations laid out a few months ahead, because it turns a vague worry into a schedule.
What Changes for Commercial Properties
Commercial reports carry extra columns: square footage, base rent, escalation dates, and reimbursements for taxes, insurance and common-area costs. Those recoveries are usually estimated during the year and trued up later, so the report should show the estimate billed and the balance still to be settled. If your portfolio mixes residential and commercial units, keep separate versions instead of forcing both into one layout. The columns that help a lender read a shopping center are not the ones a homeowner-investor needs for a duplex.
A Monthly Routine for a Reliable Rent Roll
The routine does not need to be complicated. What matters is that it happens on the same schedule every month, before owner statements go out.
- Export the report after all charges for the month are posted.
- Compare total scheduled rent on the roll to rental income posted in the general ledger.
- Compare tenant balances on the roll to the accounts receivable aging.
- Compare deposits on the roll to the security deposit liability and the trust bank balance.
- Investigate every difference and correct it at the source, not just on the report.
- Save a dated copy so you can answer questions about any past month.
For the deposit comparison, see our guide to security deposit trust account reconciliation. And if you are a broker or realtor with rental listings under management, the same discipline applies. The National Association of REALTORS® and IREM both publish material for professionals who manage income property.
If keeping this routine on schedule is a struggle for your team, our monthly property management accounting service closes the books each month and reconciles the balances that feed the report, so the report you send is one you can stand behind.
How It Feeds Owner Reporting
This report is rarely the only thing an owner sees. It usually travels alongside an income statement, a balance sheet and an owner statement. When the report ties to those reports, the package tells one consistent story. When it does not, the owner starts asking questions, and every answer costs you time.
Our article on owner statements shows how the pieces fit together. As a rule, prepare the report after the ledger is closed rather than before, so the two cannot drift apart mid-month.
Rent Roll FAQ
How often should I update a rent roll?
Update the rent roll whenever a lease, rent amount or occupancy status changes, and finalize it at each month end after charges are posted.
Who usually asks to see a rent roll?
Owners, lenders, buyers and insurers commonly ask for a current rent roll, so keep a dated copy of each month’s version on file.
How Property Ledger Solutions Helps With Your Rent Roll
We are an accounting office, not a property management company. For property managers and brokers, we take over the bookkeeping side of the report: posting charges and receipts, keeping accounts receivable current, reconciling bank and trust accounts, and closing each month so the report ties to the ledger. Our Property Management Accounting work covers trust account reconciliations, owner statements, security deposit accounting and cash flow reporting, all of which feed the numbers on your report.
To your clients and tenants, we’re simply the accounting support behind you – the relationship stays yours. If you would like a second set of eyes on how your report ties to your books, request a free consultation. There is no cost or commitment, and we speak Spanish as well as English.