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.
- 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.
Property coordination, 2017 – 2022
- Tenant. Sends a repair request.
- Me. Log it and pick the trade.
- Trade. Does the repair.
- Me. Check the work. Record the cost.
- Tenant. Pays the rent.
- Me. Collect it. Track the expenses.
- 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.
More work
- Stay for the exhale
I turned a yoga teacher's classes into a membership product. I did the strategy, the design, the build and the operations.
- A bank reconciliation that explains each difference
A working sample of the reconciliation method from my years as Operations & Finance Lead. Excel formulas match 119 bank lines to 121 ledger entries, explain each difference and reconcile to 0.00.
- SQL case studies: revenue share, donor segments and a 3NF schema
Three SQL studies on small course datasets. Each one starts with a business question. Every figure is query output that you can run again.