How is a rent roll used in property management accounting?
A rent roll is an operational summary of units, leases, occupancy and scheduled rent. In accounting, it is used as a starting point to test whether lease-based expectations can be explained by tenant charges, collections and rental income recorded in the books. It is not a substitute for the tenant ledger, bank reconciliation or general ledger; each record answers a different question.
A rent roll normally lists units, tenants, lease dates, occupancy and scheduled rent. It helps a property manager understand what the leases say should be happening at a property. For accounting, the next question is whether the rent activity can be traced through tenant charges, receipts and the general ledger.
Those records will not always show the same total. A rent roll may reflect scheduled rent, while accounting reports show posted charges, cash activity or recognized income for a defined period. A useful reconciliation explains the differences; it does not simply force the totals to match.
What a rent roll shows — and what it does not
Depending on the property-management platform and report settings, a rent roll may include:
- Property, building, unit and occupancy status.
- Tenant or leaseholder and lease start or end dates.
- Contractual or scheduled rent and billing frequency.
- Lease changes, concessions or other rent-related fields where configured.
- Vacant units and upcoming expirations.
It may not show every posted charge, payment allocation, bank deposit, credit, write-off or accounting adjustment. Before using the report, confirm its effective date, filters, property scope and whether it reports current scheduled rent, a selected period or another configured view.
Rent roll, tenant ledger and general ledger: different jobs
These records should support one another, but they are not interchangeable.
| Record | Main question it answers | Useful accounting check |
|---|---|---|
| Rent roll | What leases, units and scheduled rents are currently represented? | Confirm lease, occupancy, unit and rent changes are reflected correctly. |
| Tenant ledger | What charges, receipts, credits and balances were posted for each tenant? | Trace differences to transaction-level activity and unapplied cash. |
| Bank activity | What money cleared or was deposited during the period? | Match receipts and deposits, allowing for timing and batch differences. |
| General ledger | What amounts were recorded in the accounting accounts and property dimensions? | Reconcile relevant control accounts and rental-income postings to supporting detail. |
The exact relationship depends on the software setup and accounting policy. If property operations and the general ledger sit in separate systems, document which system is the source for lease terms, tenant transactions, cash and financial reporting.
A practical monthly rent-roll reconciliation
- Fix the reporting scope. Select the same property or entity, reporting date and unit population across the reports. Record the rent-roll filters and report date so the comparison can be repeated.
- Review lease and occupancy changes. Check new leases, renewals, rent changes, move-ins, move-outs, vacant units and approved concessions against the source lease or client-approved records.
- Compare scheduled rent with tenant charges. Identify units where the amount billed differs from the lease-based expectation. Check prorations, credits, concessions, timing and posting errors before deciding whether a correction is needed.
- Trace receipts and unapplied cash. Compare tenant ledger receipts with payment batches and bank activity. A payment may be received but not yet allocated to the correct tenant or period.
- Reconcile tenant balances. Compare tenant-level balances with the receivables control account and investigate unexplained differences, duplicate charges, credits and old balances.
- Check property and account coding. Confirm rental income and related transactions are assigned to the correct property, entity and accounts under the client's chart of accounts.
- Document and review exceptions. Keep the amount, tenant or unit, period, evidence checked, responsible person, next action and final disposition. Escalate items that need client approval rather than posting unsupported adjustments.
For transaction-level charges, receipts and balances, use the tenant ledger reconciliation checklist. For bank-side matching, see the property management bank reconciliation guide.
Example: explaining a rent-roll difference
Consider an illustrative unit with scheduled monthly rent of $1,500. The tenant moves in partway through the month, and the approved first-month charge is prorated to $750. The rent roll may still display the recurring monthly amount of $1,500, while the tenant ledger shows a $750 charge for the partial month. If the tenant pays $500 before month-end, the remaining $250 is an open tenant balance, subject to the account's other activity and cutoff.
These figures are illustrative, not a prescribed accounting treatment. The reconciliation should show why the scheduled amount, posted charge and cash received differ. The correct posting and income recognition depend on the lease, accounting policy, reporting period and system configuration.
| View | Illustrative amount | What it represents |
|---|---|---|
| Recurring scheduled rent | $1,500 | Lease-based monthly amount shown for the unit. |
| Tenant charge for partial month | $750 | Illustrative prorated charge posted to the tenant ledger. |
| Cash received by cutoff | $500 | Payment recorded for the tenant; confirm it against bank activity. |
| Remaining tenant balance | $250 | Unpaid portion of the illustrative posted charge, before other adjustments. |
The point is not to make all four amounts equal. It is to identify what each amount measures and retain enough evidence for a reviewer to follow the bridge from lease terms to the accounting records.
Common reasons rent-roll and accounting totals differ
- Timing: a lease change, payment or adjustment is effective in one period but posted in another.
- Proration: move-ins, move-outs or mid-month changes create charges below or above the recurring rent amount.
- Concessions and credits: approved incentives or adjustments affect tenant charges differently from the scheduled lease amount.
- Vacancy and lease status: a unit may be vacant, pending move-in or shown differently depending on the report date and filters.
- Unapplied receipts: cash has been received but is not yet allocated to the correct tenant or charge.
- System or coding differences: property dimensions, account mappings, report settings or interfaces may not align.
A difference is not automatically an error. It becomes a control issue when it cannot be traced, explained and assigned for resolution. Do not post a balancing entry simply to make the reports agree.
How software affects the workflow
Platforms such as AppFolio, Buildium and Yardi can produce rent-roll and tenant reports, but the available fields and calculations depend on the product, permissions and configuration. Some property managers also maintain the general ledger in a separate accounting system. In that setup, define the handoff, report timing and property or account mapping before comparing totals.
Use the reports available in the client's existing system and confirm what each report includes. A report name alone is not enough to establish whether it shows scheduled rent, posted charges, collections or another measure.
For a repeatable rent roll report review, save the report date, property filters, included status categories and column definitions with the close workpapers. If a system export is compared with a separate accounting file, document the field mapping and any timing or interface rules. This makes the next month's review easier to reproduce and helps distinguish a true accounting variance from a report setup difference.
What to check in a commercial real estate (CRE) rent roll report
Commercial rent rolls may need more than a tenant name, unit and monthly rent. Depending on the lease structure and the report, useful fields can include rentable square footage, base rent per square foot, lease commencement and expiration dates, rent steps or escalation dates, free-rent periods, renewal options and expense-recovery terms. For multi-tenant properties, check whether common-area maintenance (CAM), tax and insurance recoveries are shown separately from base rent.
Do not assume that a rent-roll total includes every recovery or that a listed recovery is earned, billed or collected. Compare the lease terms with the billing detail, tenant ledger and accounting entries for the same period. Keep base rent, additional rent and reimbursements distinguishable so that a reviewer can trace each amount to its source.
What should be ready before owner reporting?
Owner reporting should be based on reconciled accounting records, with the rent roll used to explain lease and occupancy details. Before statements are prepared, check that:
- The reporting period and property or owner scope are consistent.
- Material lease changes, vacancies and rent variances have been reviewed.
- Tenant charges, receipts and unapplied cash have been investigated.
- Relevant receivables and rental-income balances tie to supporting records or have documented exceptions.
- Open items affecting the statement are resolved or disclosed under the agreed review process.
For unpaid balances grouped by age and the related control-account checks, see the property management receivables aging reconciliation guide. The broader property management month-end close checklist covers how rent-roll review fits into the wider close.
Frequently asked questions
Should the rent roll total match rental income in the general ledger?
Not necessarily. A rent roll may show scheduled or contractual rent, while the general ledger reflects posted accounting activity. Concessions, prorations, vacancies, credits, cutoff and the report settings can explain differences. The difference should be itemized and supported rather than forced to zero.
Which report should an owner statement be built from?
Use reconciled accounting records as the financial basis, and use the rent roll to explain occupancy and lease details. Confirm that the reporting period, property and owner scope agree before issuing the statement.
How often should a rent roll be reconciled?
Review it monthly as part of the accounting close, and investigate material lease or occupancy changes when they occur. The appropriate frequency for interim checks depends on the portfolio and the client’s operating controls.
Can a rent roll replace a tenant ledger?
No. A rent roll summarizes lease and occupancy information. The tenant ledger provides transaction-level charges, receipts, credits and balances needed to explain what happened in the account.
How do you reconcile a rent roll to tenant accounts receivable?
Use reports for the same property, cutoff date and reporting scope. Compare tenant-level balances and posted charges with the accounts receivable detail and its general-ledger control account. Investigate unapplied cash, credits, write-offs, move-in or move-out prorations, duplicate entries and timing differences. The rent roll can help identify lease or occupancy changes, but it may not contain the transaction detail needed to prove the receivable balance.
Does a rent roll show rent collected or only rent scheduled?
That depends on the report and its settings. Many rent rolls emphasize lease terms and scheduled rent; some property-management reports also include billed amounts, receipts or tenant balances. Check the report definition and period before treating a column as cash collected. Use the tenant ledger and bank activity to verify receipts.
Can rent roll reconciliation be automated?
Software and spreadsheet rules can compare mapped fields, flag missing units or unusual variances, and reduce repetitive matching. They cannot determine by themselves whether a lease amendment is approved, a concession is valid, a payment belongs to a particular tenant or an accounting adjustment is appropriate. Review exceptions against source records and retain approval for changes.