Apartment Rent Roll vs. Ledger: What Owners Should Reconcile

A rent roll shows the lease terms and recurring charges the property is using. A resident ledger shows the charges, payments, credits, and balances recorded for that account. Compare them because a clean rent roll can hide an unpaid balance, while a ledger balance can be wrong if the underlying lease or credit was entered incorrectly.

Start with the same date and the same units

Ask for the rent roll and ledger as of the same month-end. Confirm the property, unit count, occupied units, vacancies, move-ins, and move-outs. A rent roll printed today and a ledger closed two weeks ago will produce differences that have nothing to do with collections.

For each exception, go back to the signed lease and any amendments. Check the effective rent, start date, increases, concessions, and other recurring charges. Do not resolve a mismatch by changing a spreadsheet until the source document and transaction history support the change.

Follow the charge through the ledger

For a selected month, the owner should be able to see the opening balance, each charge, each payment, each credit or adjustment, and the ending balance. Ask what created any manual adjustment and who approved it. A line marked “balance due” does not tell you whether a payment is pending, a concession was applied, or a charge was entered twice.

For example, suppose the monthly lease charge is $2,400, a documented $100 concession applies, and the resident pays $2,300. A zero ending balance may be correct. Without that concession record, the $100 difference is an exception to investigate. The arithmetic is simple; the source record determines the answer.

Tie the detail to the owner's report

The rent roll, resident ledgers, and property-level financial report should tell a consistent story, even though they answer different questions. Scheduled charges are not the same as collected cash. Bank deposits may also fall in a different reporting period. Ask your manager to label those timing differences instead of forcing the numbers to match.

A useful monthly exception list identifies the unit, the amount, the period, the source document or transaction, the reason for the difference, the person assigned to resolve it, and the date of the next update. Keep resident details inside the authorized owner and management workflow.

Five questions to ask your manager

1. Which rent roll and ledger dates are we comparing?
2. Which lease or amendment supports each recurring charge and concession?
3. Which balances changed because of payments, credits, reversals, or write-offs?
4. Which differences are timing, and which need a correction?
5. Who owns each unresolved exception, and when will I see the answer?

Primary servicing and management references

Freddie Mac's multifamily property reporting guide calls for rent rolls and operating statements as separate attachments in its servicing process. That is a useful reminder that no single report tells the full operating story. Coastline's multifamily management guide and monthly reporting guide show what an owner should expect from the management team.

Related Coastline resources

• What to look for in a multifamily property management company
• What should be included in a monthly property management report
• California rent increase owner checklist
• Coastline Equity property management services
• Coastline Equity owner resources

Request a performance review

If the rent roll and owner report do not connect, Request a Property Management Performance Review.

This educational guide is not financial or accounting advice. Work with your CPA and property management team to reconcile property ledgers against executed lease files.