A rent roll can look tidy while hiding an old rent amount, a vacant unit or a payment that belongs to last month. Here’s how to check what the rows are telling you.
A rent roll brings the rental arrangements for a property or portfolio into one place: which units are occupied, the lease dates and the scheduled rent. It’s useful when you’re checking income, handing records to someone else or trying to understand a number that looks wrong.
The total at the bottom needs context, though. Scheduled rent tells you what the agreements call for. It doesn’t show, on its own, what reached your bank. And a target rent for a vacant unit describes a possibility, not an existing rent obligation.
Put a date on the numbers
An “as of” date tells the reader when the lease information was current. A collection period says which payments you’re counting. For example, a rent roll dated October 28 might show collections from October 1 through October 28. That partial month needs to be identified if you compare it with a full September.
Give each unit or separately leased room its own stable identifier. When rooms are leased separately, do not also count the parent home's rent as another occupied rental. Mark inactive rentals and vacant rentals distinctly, and explain whether the report includes them.
Start with the signed lease
Check the start date, end date and current base rent against the signed lease and amendments. Watch for a future rent change that has been entered as if it already applies. If the arrangement is open-ended, record it that way instead of adding an arbitrary end date.
Keep base rent, recurring charges, credits and deposits distinguishable. When the software and an amendment disagree, note the difference and assign someone to resolve it. Changing a spreadsheet cell is not a way to change the rental agreement.
Follow a small example through the totals
For an illustrative three-unit property, two occupied units have monthly base rents of $1,600 and $1,750; the third is vacant. Scheduled occupied base rent is $3,350. A $1,800 target for the vacant unit belongs in a separate projection, not in that total.
Now suppose $3,100 has been received during the review period. The $250 difference is a question to investigate. Was a payment applied to an earlier balance? Is there a credit or reversal? Check the tenant ledger and payment status, then match the payout to the bank. A single bank deposit may combine several payments or arrive after fees have been deducted.
Use the payment-status guide when a receipt and payout appear to disagree. Preserve the original transaction references so the next reviewer can follow the same trail.
Leave the next reader enough information
Beside each unresolved difference, note the source, who is checking it and when they’ll follow up. Mark unknown amounts clearly. Otherwise the next person has to guess whether a blank means zero, a vacant rental or a number nobody has checked.
Keep contact details, identity documents and screening information out of a general rent roll unless the intended recipient has a specific authorized need. Use rental identifiers in a broad review copy and share supporting records through an appropriate restricted channel. A lender or buyer may require a different format and its own verification.
Download the rent-roll worksheet
Download the blank rent-roll reconciliation worksheet (CSV) to work through your own records. It has space for the snapshot and review notes, but no formulas or account connection. Keep the dated copy with its supporting records. The accounting guides cover related questions about rental income and records.
