Hiring guide
Rental property reporting: bridge occupancy, rent due and collected cash
By CFO Index · Published
A nearly full building can still have a cash shortfall. Occupancy measures the use of units, while rent due and receipts answer different financial questions. A useful property report connects the three without counting last month's arrears as evidence that this month's tenants paid on time.
Fix the property perimeter and occupancy cutoff
List the buildings, unit IDs, reporting entity and reporting date. Define whether occupancy means physical presence, an active lease or another explicitly named status. Distinguish ready-to-let vacancies, refurbishment units and signed leases that have not started. Keep the denominator stable or reconcile every change. A month-end snapshot is not average occupancy for the month: if units turn over during the period, calculate and label a separate unit-day measure rather than switching definitions silently.
Build the rent schedule from the actual leases
Retain lease dates, agreed rent, concessions, billing periods, due dates and approved variations by unit. Buildium's rent-roll description identifies lease, rent, payment and unit-status information as useful fields. That vendor description supplies context, not a universal legal standard or an endorsement. Reconcile your own rent roll to the tenant ledger and bank allocation. Keep security deposits, fees and rent separate; their permitted use and accounting treatment depend on the actual arrangements and applicable rules.
Compare occupancy with current-month collection
Hypothetical example: a ten-unit building has nine occupied units throughout a month. Each occupied unit owes €1,000 rent, with no concessions, prorating, fees or tax in the illustration. Physical occupancy is 90% and current rent due is €9,000. By the cutoff, €7,500 has been allocated to that month's rent. The current-period collection ratio is €7,500 / €9,000 = 83.33%. Dividing by all ten units' hypothetical rent would answer a different question.
| Measure | Calculation | Result |
|---|---|---|
| Physical occupancy | 9 occupied / 10 units | 90% |
| Current rent due | 9 × €1,000 | €9,000 |
| Current rent collected | Allocated current-month receipts | €7,500 |
| Current collection ratio | €7,500 / €9,000 | 83.33% |
| Total rent cash this month | €7,500 current + €1,000 old arrears | €8,500 |
Explain the arrears roll-forward
Continue the hypothetical case with €2,000 opening rent arrears. Collect €1,000 of those old arrears and €7,500 of the current €9,000 due. With no credits, write-offs or other adjustments, closing arrears are €2,000 + €9,000 − €8,500 = €2,500. Total rent cash is €8,500, but using it as current-month collections would overstate that ratio. Retain receipt allocation by tenant and period; flag unidentified cash instead of assigning it to whichever month makes the report look best.
Translate the bridge into dated cash decisions
Separate the vacancy plan from collection actions. A vacant unit may need maintenance and a lease start before it generates rent; an occupied unit with arrears needs a different owner and evidence. Put expected receipts beside dated operating bills, debt payments and agreed works. For illustration, €8,500 receipts against €9,200 outflows creates a €700 period cash deficit before opening cash. That difference is not net operating income or an investment return. Test promised arrears receipts as uncertain until verified.
Keep collection actions within the proper authority
Assign operations the unit-status evidence, property management the lease and billing corrections, and finance the receipt reconciliation and forecast. Record disputes and approved payment plans without treating an unconfirmed promise as guaranteed money. Lease changes, enforcement, notices and deposit use need the relevant contractual and jurisdiction-specific review. A CFO reporting checklist does not authorise an eviction, rent increase or transfer of protected funds. Share unit-level evidence with appropriate privacy controls.
Accept a report that survives turnover and late cash
Ask the CFO to demonstrate a mid-month move-in, a vacant unit excluded under a stated definition, a concession and a late receipt applied to an older period. The report passes when occupancy definitions remain visible, rent due traces to leases, allocated receipts reconcile to bank cash and arrears bridge without unexplained differences. Compare buildings only after aligning those definitions. The recurring output should identify the next operational or cash decision, not merely celebrate a high occupancy percentage.