Monthly owner report for a three-property portfolio

A rebuilt sample of the monthly report that each asset owner received: occupancy, rent roll, NOI against budget, capital projects and the NOI share of each owner.

Role
Property & Portfolio Operations Manager
Period
2017 – 2022 · sample rebuilt in 2026
Stack
Excel, NOI, Rent roll
Evidence
Sample data
Question
For each property and each owner: what did the month earn, where is it against budget, and what needs action?
Data
One sample month (June 2021): 3 properties, 15 units, a rent roll, expenses, a budget, ownership shares, capital projects and a 12-month NOI trend.
Method
Every number on the one-page report is a formula from the other tabs. NOI = effective gross income minus operating expenses. Capital projects and mortgage payments are not operating expenses.
ResultSample data
Portfolio NOI 15,425 against a budget of 23,350. A roof repair puts Property B 7,590 below its budget. The report flags one vacant unit, one unit on notice and one tenant in arrears.

Recreated sample data. All addresses, tenants, owners and amounts are false.

93%Physical occupancy
88%Economic occupancy
15,425CADPortfolio NOI
−7,925CADVariance to budget

Property coordination, 2017 – 2022

  1. Tenant. Sends a repair request.
  2. Me. Log it and pick the trade.
  3. Trade. Does the repair.
  4. Me. Check the work. Record the cost.
  5. Tenant. Pays the rent.
  6. Me. Collect it. Track the expenses.
  7. Owner. A statement to the owner. Records to the accountant.

Scope: The portfolio had 5 asset owners. Leasing and purchase support are not shown.

Two routines that fed the monthly owner report. My part is marked in each row.