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