Skip to content

Why are rent collections below budget when occupancy is high?

By Aurevia Property Group ·

Use the same property, rent period and cutoff in every report. First explain the gap between budgeted rent and what residents owed. Then explain the gap between what they owed, what they paid and what reached the bank.

Reconcile rent in the order it moves

Ask the manager for the unit roster, signed rent and concession terms, resident ledgers and aging. Ask the bookkeeper for the deposit or processor detail and bank activity. A smaller property can tie each receipt directly. A larger team can tie settlement batches, then drill into the resident records behind exceptions.

The fictional worksheet tracks only this period’s rent. Reconcile collections against older balances, advance rent, deposits and other charges separately. Confirm whether the budget uses billed rent or expected cash before comparing it with receipts.

Fictional rent-to-bank worksheet for one reporting period
StepAmountEvidence and follow-up
Budgeted rent$50,000Start with the rent budget for the same units and period.
Vacancy and lease-rate difference−$1,200Tie the gap to the occupancy dates and signed rent. Split the two causes in the live worksheet.
Approved concessions−$800Check the signed terms and approved ledger credits.
Current-period rent due$48,000Match lease charges after credits.
Current-period rent unpaid at cutoff−$2,500Tie the balance to resident aging and check later payments separately.
Gross current-period payments$45,500Tie receipts to processor or deposit detail.
Still settling at cutoff−$900Check the settlement batch and subsequent bank date.
Processor fees withheld−$100Check the batch fee detail. Review any returns separately and trace reversals back to the resident ledger.
Net bank deposits by cutoff$44,500Match the settlement and bank records.

Assign the gap to the person who can explain it

The manager checks occupancy, rent terms and resident balances. The bookkeeper checks payment allocation, batches and bank timing. The asset manager explains which part of the gap can change the forecast and which issue needs a decision. Give unresolved dollars their own row and due date.

The fictional owner report shows a separate $1,779.50 shortfall. Its rent roll and resident ledgers are unavailable, so the cause remains open.

See the separate fictional owner report

Fannie Mae rent validation guidance for underwriting

Explore the services

Discuss what’s happening at your property

Tell us the property city, approximate unit count and the decision you’re working through. We’ll discuss which service fits and what a next step would involve.