Blog · Board and management reporting
Compare occupancy, rental income, operating costs and overdue rent across a commercial property portfolio. A worked US example shows the portfolio calculations, a single-cost variation and the checks that keep the comparison reliable.
Real estate dashboards compare occupancy, rental income, property costs and arrears on a consistent basis across the portfolio. They should show both the portfolio total and the property rows that explain it. For an operating review, the useful question is which property needs a leasing, maintenance or collection decision next.
Start with a rent roll, a monthly income-and-expense export and a tenant receivables aging report. Give each property a stable identifier across those files. Preserve tenant and lease identifiers underneath the property summary so a manager can follow an exception to the relevant agreement or invoice.
Use a single month-end cutoff. Occupancy and arrears are balances at that date; income and expenses cover the month ending on that date. Label the distinction on the dashboard so a reviewer does not mistake a balance of old unpaid invoices for this month's rental income.
The OCC's Commercial Real Estate Lending handbook describes rent rolls and operating statements as important information for reviewing income-producing property. The same records give an operating team a grounded comparison, provided their property lists and dates agree.
Suppose a US property operating company reviews its portfolio for September 2026. Harbor is an office building, Mesa is a neighborhood retail property and Oak is a light-industrial property. All figures are in USD, and all properties use rentable square feet measured consistently.
For this example, leased area means area covered by commenced leases at September 30, 2026. Rental income is the month's recognized rental revenue. There are no other property revenues or tenant reimbursements in the example, and the cost column includes the company's complete defined property operating expenses.
| Property | Rentable area (sq. ft.) | Leased area (sq. ft.) | Rental income (USD) | Operating expenses (USD) | Overdue rent at cutoff (USD) |
|---|---|---|---|---|---|
| Harbor | 50,000 | 45,000 | 90,000 | 36,000 | 12,000 |
| Mesa | 30,000 | 24,000 | 48,000 | 21,600 | 6,000 |
| Oak | 20,000 | 16,000 | 32,000 | 14,400 | 2,000 |
| Portfolio | 100,000 | 85,000 | 170,000 | 72,000 | 20,000 |
Keep the dashboard's first row of measures tied to these inputs:
Leased occupancy = Leased rentable area / Total rentable area
Net operating income = Property operating revenue − Property operating expenses
Operating expense ratio = Property operating expenses / Property operating revenue
Exclude financing costs, depreciation and capital expenditure from this operating comparison. Finance should publish the expense definition and explain its relationship to the ledger. The resulting operating income is not the company's final net income or its cash balance.
| Property | Leased occupancy | Net operating income (USD) | Operating expense ratio | Overdue rent (USD) |
|---|---|---|---|---|
| Harbor | 90.0% | 54,000 | 40.0% | 12,000 |
| Mesa | 80.0% | 26,400 | 45.0% | 6,000 |
| Oak | 80.0% | 17,600 | 45.0% | 2,000 |
| Portfolio | 85.0% | 98,000 | 42.4% | 20,000 |
Harbor occupancy is 45,000 / 50,000 = 90.0%. Its operating income is 90,000 − 36,000 = $54,000, and its operating expense ratio is 36,000 / 90,000 = 40.0%. Apply the same definitions to the other property rows. Percentages throughout are rounded to one decimal place after calculation.
The portfolio calculations use totals: 85,000 / 100,000 = 85.0% occupancy and 72,000 / 170,000 = 42.4% operating expenses. Operating income is 170,000 − 72,000 = $98,000. The property income check gives the same result: 54,000 + 26,400 + 17,600 = $98,000.
The action list is more specific than the totals. Mesa and Oak have lower occupancy than Harbor, but that does not establish why space remains unleased. Harbor has the largest overdue balance, making its tenant aging a collection-review priority. Compare invoice status and disputed amounts before deciding which tenant requires follow-up.
Now increase Harbor's operating expenses by $6,000 for a repair recognized in September. Change nothing else: leased area, rental income and overdue rent remain as above. This isolates what a cost change does to the dashboard.
| Cost measure | Original (USD) | Revised (USD) | Change (USD) |
|---|---|---|---|
| Harbor operating expenses | 36,000 | 42,000 | 6,000 |
| Harbor operating income | 54,000 | 48,000 | -6,000 |
| Portfolio operating expenses | 72,000 | 78,000 | 6,000 |
| Portfolio operating income | 98,000 | 92,000 | -6,000 |
| Ratio | Original | Revised | Change |
|---|---|---|---|
| Harbor expense ratio | 40.0% | 46.7% | 6.7 percentage points |
| Portfolio expense ratio | 42.4% | 45.9% | 3.5 percentage points |
| Portfolio leased occupancy | 85.0% | 85.0% | 0.0 percentage points |
Harbor's revised expense ratio is 42,000 / 90,000 = 46.7%. Portfolio operating income becomes 170,000 − 78,000 = $92,000; its expense ratio becomes 78,000 / 170,000 = 45.9%. Percentage-point changes use the unrounded ratios before rounding.
The cost event changes earnings without changing leasing or collections. Do not explain the lower operating income as a vacancy problem. Confirm the repair's accounting classification and owner, then decide whether it is recurring work that should alter the operating budget.
First, reconcile rentable and leased area to the approved rent roll. Exclude terminated leases and future commencements according to the published definition. Next, tie monthly income and expenses to the property ledger, including allocations and accruals. Finally, reconcile the overdue balance to the aging report after unapplied receipts and adjustments are resolved.
If the cost export has repeated property IDs in column A and operating expense amounts in column B, an Excel property subtotal for Harbor is:
=SUMIFS(B2:B1000,A2:A1000,"Harbor")
Expand the range to include every exported row and restrict the file to the reporting month. Microsoft's SUMIFS documentation explains how criteria select the amounts summed. Covirage is not affiliated with Microsoft.
Use real estate dashboard Excel methods for spreadsheet construction and real estate financial reporting for the wider reporting package. The dashboard's operating balances connect to the real estate balance sheet, but do not replace it. Future assumptions belong in real estate financial modeling; leasing inquiries and signed prospects belong in real estate lead conversion, outside the current occupancy denominator.
Upload your rent roll, property income-and-expense export and tenant aging to Covirage, which maps the columns so its tools can compute and check the comparisons. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.
See self-service analytics for the supporting approach to business-file analysis.
Start with leased occupancy, rental income, property operating expenses, net operating income and overdue rent. Add lease expirations or maintenance exceptions when they support a current decision. Keep actual results, budgets and balances clearly labeled because they describe different aspects of property performance.
Divide total leased rentable area by total rentable area using the same measurement basis and reporting date. Sum areas before calculating the percentage. A simple average of property occupancy rates gives a small property the same influence as a much larger one.
No. Arrears are unpaid amounts past their contractual due dates at a particular date. Rental income describes the reporting period under the company's accounting policy. Track overdue balances separately, and identify credit adjustments, write-offs and unapplied cash before interpreting a collection problem.
A portfolio operations lead should own its decisions and definitions. Property managers confirm leases, vacancy and local exceptions; finance reconciles income, expenses and receivables. Agree on one reporting cutoff and require an owner for each unresolved difference before distributing the dashboard.