How to Conduct a Month-End Rent Roll Reconciliation: Process, Checks, and Red Flags

The rent roll is the most referenced document in property management. Lenders use it for covenant compliance. Asset managers use it for valuation. Investors use it for income forecasting. Property accountants use it to confirm what rent should have been collected each period. It is treated as authoritative the moment it is produced — and in most portfolios, it is never formally reconciled to the general ledger.

That gap is where revenue errors live. A tenant whose rent escalation took effect on the first of the month but wasn't updated in the system. A lease that expired but the tenant is still being billed at the old rate. A concession applied in the leasing system that was never posted in the accounting system. A move-out processed operationally but not reflected in the rent roll, so the unit shows as occupied and generating income it isn't generating. None of these errors are visible from the rent roll alone. They only surface when the rent roll is reconciled line by line to the actual charges posted in the GL, the actual receipts collected in the bank, and the actual lease terms in the lease management system.

A rent roll reconciliation is not a complicated process. It is a structured comparison of what the rent roll says should be charged against what the accounting system actually charged, what was collected, and what the lease terms require. Done monthly as part of the close, it catches errors at the source — in the period they occur — rather than at audit or investor due diligence, when correcting them is significantly more expensive and reputationally damaging.

This guide covers the full rent roll reconciliation process: what the rent roll must contain, the eight checks every reconciliation must include, how to investigate and clear variances, and the red flags that indicate a systemic problem rather than a one-off posting error.

Why the Rent Roll Is Trusted More Than It Should Be

The rent roll earns its authority by being comprehensive: it shows every unit or tenancy in the portfolio, the rent being charged, the lease term, the occupancy status, and the collection position in a single document. No other report covers all of these dimensions simultaneously, which is why it becomes the default reference for almost every income-related question in property management.

The problem is that the rent roll is typically a system-generated snapshot of lease data — and lease data is only as accurate as the inputs that maintain it. When a rent escalation is processed in the leasing module but the billing charge isn't updated to match, the rent roll shows the new rate while the GL posts the old one. When a tenant moves out and the lease is closed in the operational system but the accounting period isn't adjusted, the rent roll shows a vacancy while the GL still shows a receivable for rent that was never due. When a free rent period ends and full billing should resume, the rent roll reflects the resumption while the billing system continues the concession because nobody triggered the change.

The Cost of Unreconciled Rent Roll Data

Unreconciled rent roll errors are not neutral. They distort income reporting in both directions. Overbilling errors expose the landlord to tenant disputes, credit note obligations, and reputational damage with tenants whose goodwill the leasing team has worked to build. Underbilling errors produce income shortfalls that show up in budget variance analysis without a clear explanation, because the rent roll and the budget agree but the GL doesn't match either.

At portfolio scale, a rent roll that hasn't been reconciled for three or four months will contain a layered accumulation of errors: some from incorrect escalation application, some from lease events that were processed operationally but not reflected in billing, some from concessions applied inconsistently across the leasing and accounting systems. Unwinding that accumulation takes significantly longer than preventing it would have.

IREM's income management guidance identifies rent roll accuracy as a foundational requirement for reliable property-level financial reporting, noting that income variances traced to rent roll discrepancies are among the most common findings in property management financial audits.

What a Rent Roll Must Contain to Be Reconcilable

A rent roll that cannot be reconciled to the GL is one that is missing fields. Reconciliation requires that every charge in the accounting system can be traced to a specific lease, and every lease can be traced to a specific charge. The rent roll must therefore contain every field required to make that tracing possible.

Required Rent Roll Fields

A rent roll missing any of these fields cannot be fully reconciled. The most commonly missing fields are the effective rent (after concessions), the rent escalation date, and the lease area — all of which are required to verify that the billing system is applying the correct charge.

The Rent Roll Reconciliation Framework

The Rent Roll Reconciliation Framework organises the monthly reconciliation into three sequential stages. Stage 1 prepares the data. Stage 2 runs the eight reconciliation checks that confirm the rent roll and the accounting system are in agreement. Stage 3 investigates and clears every variance identified in Stage 2 before the period is locked.

Stage 1: Prepare - Pull the Rent Roll and Set the Reconciliation Baseline

The reconciliation baseline is established by pulling three documents at the same point in time: the period-end rent roll, the tenant ledger from the accounting system for the same period, and the lease schedule (the master list of lease terms from the lease management system). All three must be as at the same date. A rent roll pulled on the last day of the period reconciled against a GL trial balance from two days later will produce phantom variances from transactions posted after period end.

Stage 2: Reconcile — The Eight Checks Every Reconciliation Must Include

The eight checks are run in sequence. Each check has a specific data source comparison, a pass criterion, and a defined investigation path for failures. Checks 1 to 4 verify the income side. Checks 5 to 6 verify the collection and arrears side. Checks 7 to 8 verify the lease data integrity that underpins the income figures.

Stage 3: Investigate and Clear — Work Through Every Variance Before Period Lock

Every variance identified in Stage 2 must be investigated and either corrected (if it is an error) or documented (if it is a timing difference or known exception that will resolve in the following period). No variance should carry into the next period without a documented explanation. An undocumented variance in one period becomes an unresolvable mystery three periods later.

Stage 1: Prepare — Pull the Rent Roll and Set the Reconciliation Baseline

The Three Documents Required

1. The Period-end rent roll :- Generated from the property management or leasing system at close of business on the last day of the period. It must reflect all lease events that occurred during the period: commencements, renewals, terminations, escalations, and concession changes.

2. The Tenant ledger :- The detailed listing from the accounting system of every charge, credit, and payment posted to each tenant account during the period. This is the GL-level record of what was actually charged and collected. The tenant ledger is the primary reconciliation target: every charge on the rent roll must have a corresponding entry on the tenant ledger.

3. The Lease schedule :- The master lease data record showing contracted rent, escalation terms, concession periods, and expiry dates for every active tenancy. The lease schedule is the authority. When the rent roll and the tenant ledger disagree, the lease schedule determines which is correct.

Establishing the Opening Position

Before the current period reconciliation begins, the prior period's closing reconciliation must be confirmed as cleared. Any variances carried from the prior period must be identified and their resolution confirmed. A reconciliation that starts with unresolved prior period items will produce a compounding variance position that becomes progressively harder to untangle.

The opening position for the current period reconciliation is: total scheduled rent per the rent roll at period start equals total rent charged in the GL at period start. If these figures don't agree at the opening position, the current period reconciliation will not close regardless of how accurately the current period checks are run.

Stage 2: Reconcile — The Eight Checks Every Rent Roll Reconciliation Must Include

Check 1: Scheduled Rent vs GL Charges

• What it compares: Total base rent per the rent roll for the period against total base rent charges posted in the GL for the same period.

• Pass criterion: The totals agree within rounding. Any difference greater than one dollar per tenancy line requires investigation.

• Common failure causes: A rent escalation applied in the leasing system but not reflected in the billing charge. A new lease commencement posted to the rent roll but not yet generating a billing entry. A concession applied in the billing system that isn't reflected in the rent roll effective rent field.

• How to check: Reconcile line by line, not in aggregate. A total that agrees can mask offsetting errors — a $500 overcharge on one tenancy offset by a $500 undercharge on another produces a zero net variance that conceals two billing errors. Line-by-line reconciliation catches both.

Check 2: Escalated Rent Applied Correctly

• What it compares: The current contracted rent for every tenancy with a rent escalation date falling within or before the current period against the actual charge posted in the GL.

• Pass criterion: Every tenancy with a past or current-period escalation date is being billed at the escalated rate. No tenancy is being billed at a pre-escalation rate after the escalation effective date.

• Common failure causes: Escalation dates that passed without triggering a billing update. CPI escalations where the index was updated in the lease schedule but not applied to the billing charge. Fixed escalations that were configured incorrectly at lease setup. For a detailed breakdown of how CPI, fixed, and percentage-based escalation clauses should be applied and automated, see how to handle rent escalation clauses: CPI, fixed, and percentage-based automation.

Check 3: Concessions and Free Rent Applied Correctly

• What it compares: The concession schedule for each tenancy (free rent periods, rent abatement, step-up periods) against the actual charges posted in the GL.

• Pass criterion: Tenancies within a free rent or abatement period are being billed at zero or the agreed reduced rate. Tenancies whose concession period has ended are being billed at the full contracted rate. No tenancy is receiving a concession that its lease doesn't entitle it to.

• Common failure causes: Free rent periods that ended but the billing system continued posting zero charges. Concessions applied to the wrong period. Step-up rent structures where the first step was applied but subsequent steps were not. Concession entries in the leasing system that were not mirrored in the accounting system.

Check 4: Occupancy Status vs Billing Status

• What it compares: The occupancy status of every unit on the rent roll (occupied, vacant, or on notice) against whether a rent charge was posted for that unit in the GL.

• Pass criterion: Every occupied unit has a rent charge for the full period (or a correctly prorated charge for a partial period). Every vacant unit has no rent charge. Every unit on notice has a charge correctly calculated to the vacating date.

• Common failure causes: A tenant move-out processed in the operational system but not reflected in the billing system, which continues posting rent charges on a vacant unit. A new tenant commencement in the billing system before the lease start date. A unit marked as vacant on the rent roll but still carrying a rent receivable balance on the tenant ledger from a prior period that was never cleared.

Check 5: Rent Collected vs Rent Charged

• What it compares: Total rent collected (payments posted to the bank and applied to tenant ledgers) against total rent charged in the GL for the period.

• Pass criterion: Total collections equal total charges less any agreed and documented outstanding balances. The difference between charges and collections is the current-period arrears balance, which must reconcile to the outstanding balance shown on the rent roll.

• Common failure causes: Payments received but posted to the wrong tenant account. Payments received in the period but not yet applied against the correct charge. Payments applied against future rent rather than current-period arrears. Bank receipts that arrived in the period but were not posted until after the period closed.

Check 6: Arrears Balance vs Tenant Ledger

• What it compares: The outstanding balance (arrears) shown on the rent roll for each tenancy against the net receivable balance on the tenant ledger in the GL.

• Pass criterion: Every tenancy's arrears balance on the rent roll matches the receivable balance on the tenant ledger to the cent. Any difference indicates either a collection posted in one system but not the other, or a charge posted in one system but not the other.

• Common failure causes: A payment applied in the property management system but not yet posted to the GL. A credit note raised in the accounting system but not reflected in the operational system's tenant balance. A prior period adjustment that changed the GL balance but was not reflected in the rent roll arrears figure.

Check 7: Lease Expiry and Active Status

• What it compares: The lease expiry date for every tenancy on the rent roll against the current period date, to confirm that every tenancy generating a rent charge has a current, active lease.

• Pass criterion: No rent charge has been posted for a tenancy whose lease expired before the current period start date without a documented renewal, holdover arrangement, or extension.

• Common failure causes: Leases that expired but were not formally renewed, with the tenant continuing in occupation on a holdover basis and the system continuing to post charges without a valid lease document. Renewal agreements executed but not updated in the leasing system, leaving the system billing against an expired lease date. For how critical lease dates — including expiries, break options, and renewal deadlines — should be tracked to prevent these situations, see how to track critical lease dates across a portfolio without missing expirations.

Check 8: Security Deposit Register vs Accounting System

• What it compares: The security deposit amount shown on the rent roll for each tenancy against the security deposit liability balance held in the accounting system.

• Pass criterion: Every tenancy with a security deposit on the rent roll has a corresponding liability entry in the accounting system of exactly the same amount. The total security deposits per the rent roll equals the total security deposit liability balance in the GL.

• Common failure causes: Deposits received but posted to the wrong account (revenue rather than liability). Deposits returned on move-out but not removed from the rent roll. Top-up deposits received mid-tenancy but not added to the rent roll deposit figure. Interest on deposits calculated in the accounting system but not reflected in the rent roll balance.
  
  FASB ASC 842 governs the recognition and presentation of lease income and lease-related receivables under GAAP, including the treatment of lease incentives, variable lease payments, and security deposits
  - all of which must be consistently reflected in both the rent roll and the accounting records for the reconciliation to close cleanly.

Stage 3: Investigate and Clear - How to Work Through Variances and Red Flags

The Variance Investigation Sequence

Every variance identified in Stage 2 must be investigated in the period it is found. The investigation sequence is:

• Step 1: Determine the source. Is the variance in the rent roll (lease data incorrect), in the GL (posting incorrect), or in the lease document itself (lease terms were agreed differently from what was set up in the system)? The source determines where the correction must be made.

• Step 2: Quantify the impact. How many periods has the error been present? A billing error discovered in month three that has been present since lease commencement requires a correction that covers all three periods, not just the current one. Quantifying the full impact before correcting prevents partial fixes that leave prior-period errors unaddressed.

• Step 3: Determine the correction required. If the error is in the billing system, the charge must be corrected and a credit note or supplementary invoice issued to the tenant. If the error is in the rent roll data, the lease record must be updated. If the error is in the GL posting, a journal entry correcting the misposted amount must be raised and approved.

• Step 4: Document the variance and its resolution. Every variance and every correction must be documented in the reconciliation workpaper: the variance identified, its source, the periods affected, the correction made, and the date of correction. This documentation is the audit trail for any subsequent review of the reconciliation and the basis for the prior-period adjustment disclosure if the error is material.

When a Variance Cannot Be Cleared in the Current Period

Some variances cannot be resolved before the period closes — for example, a disputed charge where the tenant is contesting the amount, or a lease renewal that is under negotiation and hasn't been formally documented. These variances must be documented as open items with a named owner and a resolution deadline. They should not be carried forward silently into the following period's reconciliation without a note explaining why they remain open.

Rent Roll Red Flags: What Each Variance Type Tells You

Not all variances are equal. Some indicate one-off posting errors that are easy to correct. Others indicate systemic problems in the billing setup, the lease data, or the integration between the leasing and accounting systems that will continue producing errors until the root cause is addressed.

The most serious red flag is a pattern of the same error type across multiple tenancies in the same period. A single tenancy with a billing error is a data entry problem. Five tenancies with the same billing error in the same period is a system configuration problem or a failed billing run. The investigation must go to the root cause — the system event that produced the error — not just to correcting the individual tenancies affected.

How to Structure the Rent Roll Reconciliation for Multi-Property Portfolios

Property-Level Reconciliation Before Portfolio Roll-Up

In a multi-property portfolio, rent roll reconciliation must be completed at property level before any portfolio-level summary is produced. A portfolio rent roll that rolls up data from five properties before each property's data has been independently reconciled will carry errors from each property into the portfolio summary, where they are much harder to identify and isolate.

The standard approach is to run the eight-check reconciliation for each property separately, clear all variances at property level, and then consolidate the reconciled property-level data into the portfolio summary. The portfolio summary is the output of completed property reconciliations, not an independent document.

The Multi-Property Reconciliation Summary

For asset managers and ownership groups reviewing multiple properties, the reconciliation output should include a portfolio summary that shows:

This format makes variances and open items visible at a glance. A portfolio manager reviewing this summary can immediately see that Retail Centre B has an $800 billing discrepancy with one open item requiring resolution, while the other three properties have reconciled cleanly.

NCREIF's portfolio reporting standards include rent roll accuracy and income reconciliation as components of institutional-grade property financial reporting, with the expectation that income variances are documented and explained in the period they occur rather than carried forward without resolution.

How Rent Roll Reconciliation Connects to NOI, Close, and Investor Reporting

Rent Roll Reconciliation as a Core Close Task

Rent roll reconciliation is not a standalone process that runs independently of the month-end close. It is one of the core close tasks in Stage 2, sitting between the posting of revenue entries and the production of the trial balance. A close that proceeds to trial balance without a completed rent roll reconciliation is a close built on unverified income data.

The rent roll reconciliation output — confirmed scheduled rent, confirmed GL charges, confirmed collections, and confirmed arrears — is the income foundation for every financial report produced in Stage 3 of the close. For how rent roll reconciliation fits within the full month-end close sequence and checklist, see how to build a month-end close checklist for property management finance teams.

How Rent Roll Accuracy Affects NOI

NOI is calculated from the income figures posted in the GL. If the rent roll hasn't been reconciled and the GL contains billing errors - missing escalations, incorrectly applied concessions, charges posted for vacant units - the NOI figure is wrong. An NOI that is wrong because the rent roll was never reconciled is particularly difficult to explain in budget variance commentary, because the budget and the rent roll both reflect the correct rent, while the actual income in the GL reflects the billing error.

A reconciled rent roll confirms that the income posted in the GL matches what the lease terms require, which means the NOI figure is an accurate reflection of operating performance rather than a reflection of billing system accuracy. For how NOI should be calculated and tracked across a multi-property portfolio using verified income data, see how to track NOI accurately across a multi-property portfolio.

Rent Roll Reconciliation in Investor and Lender Reporting

Investors and lenders who receive rent roll data as part of periodic reporting expect that document to accurately represent the income-generating capacity of the portfolio. A rent roll that hasn't been reconciled to the GL may show higher scheduled income than the accounting records support — an optimistic presentation that creates problems when the lender's own due diligence or an investor audit reveals the discrepancy.

Lender covenant compliance — particularly income coverage ratios and occupancy thresholds — is calculated from rent roll data. If the rent roll overstates income because billing errors haven't been identified and corrected, the covenant position may appear stronger than it is. Discovering that a covenant breach would have been triggered had the rent roll been accurate, after the fact, is a significantly worse position than identifying and addressing the billing error in the period it occurred.

For property management finance teams managing rent collection, billing accuracy, and income reconciliation across multi-tenancy portfolios, RIOO's rent collection and payments features and income and expense management tools support rent roll data integrity within a NetSuite-native environment, connecting lease terms, billing schedules, and payment posting in a single platform so the monthly reconciliation compares data from a unified source rather than reconciling across disconnected systems.

Frequently Asked Questions 

Q1. What is a rent roll reconciliation?
A rent roll reconciliation is the monthly process of verifying that the rent roll - the document showing every tenancy, the rent being charged, the lease status, and the collection position - agrees with the actual charges and receipts posted in the general ledger. It confirms that every lease is being billed at the correct rate, that all collections have been correctly posted against the right tenant accounts, that vacant units are not generating charges, and that arrears balances on the rent roll match the receivable balances in the accounting system. The reconciliation identifies billing errors, collection mispostings, and lease data discrepancies in the period they occur so they can be corrected before financial statements are produced.

Q2. How often should a rent roll reconciliation be performed?
Rent roll reconciliation should be performed monthly as part of the month-end close process. Running the reconciliation less frequently — quarterly or annually — allows billing errors to compound across multiple periods, making the correction more complex and the financial impact larger. A monthly reconciliation catches errors in the period they occur, when the correction is straightforward: update the billing charge, raise a credit note or supplementary invoice if required, and correct the GL posting. An error discovered six months later requires backdated corrections, prior-period adjustments, and potentially tenant communication to explain historical billing discrepancies.

Q3. What is the most common rent roll reconciliation error?
The most common error is a rent escalation that was applied in the lease management system but not reflected in the billing charge in the accounting system. The rent roll shows the new escalated rate, the GL posts the pre-escalation rate, and the difference accumulates every month until someone compares the two. This error is particularly common in portfolios with large numbers of leases with different escalation dates, where the billing update process is manual rather than automated. The second most common error is a vacant unit still carrying a rent receivable balance from a prior tenant whose account was not fully cleared on move-out.

Q4. What is the difference between the rent roll and the general ledger?
The rent roll is a lease management document that shows what rent should be charged based on current lease terms. The general ledger is the accounting record that shows what was actually charged, collected, and posted. In a well-managed portfolio, the two should agree: every charge on the rent roll has a corresponding GL entry, and every GL entry corresponds to a rent roll line. In practice, they diverge when lease events are processed in the leasing system but not in the billing system, when payments are posted to the wrong tenant account, or when concessions or escalations are applied inconsistently across the two systems. The rent roll reconciliation is the process of identifying and resolving these divergences every period.

Q5. How do you reconcile arrears on the rent roll?
Arrears reconciliation compares the outstanding balance shown for each tenancy on the rent roll against the net receivable balance on the tenant ledger in the accounting system. The two figures should match exactly. If they don't, the difference is traced to either a payment that was posted in one system but not the other, a credit note raised in the accounting system but not reflected in the operational balance, or a prior-period adjustment that changed the GL balance without a corresponding update to the rent roll. Every arrears variance must be investigated and cleared before the period closes, because an unresolved arrears variance in one period becomes a prior-period problem in the next.

Q6. What red flags should I look for in a rent roll reconciliation?
The highest-priority red flags are: a consistent monthly variance in the same direction for the same tenancy (indicating a systemic billing error rather than a one-off); the same error type appearing across multiple tenancies in the same period (indicating a system configuration problem or failed billing run); a vacant unit with a rent receivable balance (indicating a move-out was not fully processed in the accounting system); and an arrears balance that increases every month without a corresponding dispute or payment plan (indicating collections are being applied to the wrong account). Any variance that cannot be explained by a known timing difference or documented exception should be treated as a red flag requiring investigation before the period is locked.

Q7. How does rent roll reconciliation support investor reporting?
Investors and lenders receive rent roll data as part of periodic reporting and use it to assess the income-generating capacity of the portfolio, verify occupancy levels, and calculate covenant compliance metrics. A rent roll that has been reconciled to the GL is a document the finance team can stand behind: every figure has been verified against the accounting records and any discrepancies have been resolved. A rent roll that has not been reconciled may overstate income, overstate occupancy, or show arrears balances that don't match the accounting records — all of which create credibility problems if identified during investor due diligence or a lender audit.

Q8. What systems should be connected to enable accurate rent roll reconciliation?
Accurate rent roll reconciliation requires that lease data, billing charges, and payment receipts are all accessible from a common data source, or that the data flows automatically between connected systems with no manual re-entry step. When the leasing system and the accounting system are separate and disconnected, every lease event — commencement, renewal, escalation, concession, termination — must be manually replicated from one system to the other. Each manual replication step is a potential error point. The reconciliation process must then identify which manual replication steps were missed or incorrect, which takes significantly longer than verifying automated data flows. Portfolios that manage lease data and accounting data in a unified platform reduce the volume of reconciliation variances substantially, because the source data for both the rent roll and the GL entries comes from the same record.

A rent roll reconciliation is not an audit exercise. It is a monthly data quality check that confirms the income figures in the accounting system reflect what the leases actually require. Done consistently, it prevents billing errors from compounding, keeps arrears balances accurate, and ensures that the rent roll presented to investors and lenders reflects the same reality as the general ledger. The reconciliation itself takes a few hours for a single property and a structured half-day for a multi-property portfolio. The cost of not doing it — in billing errors uncollected, arrears misreported, and investor credibility damaged — is substantially higher.