Blog · Board and management reporting
Real estate financial reporting compares property rental income, operating costs and cash with supporting records. Build an internal monthly property review from ledger and budget exports, with a worked operating result and a separate cash reconciliation.
Real estate financial reporting compares rental income, operating costs and cash by property, with the budget alongside each result. For an internal monthly review, start with reconciled property-ledger exports and show operating performance separately from financing and capital spending. The report should explain what changed and identify the records that support the explanation.
Choose the month, properties, ownership scope and accounting basis before extracting data. This example is an internal review for an illustrative US company that owns two operating rental properties. It uses accrual-based income and expenses, with a separate cash schedule.
Keep a stable property identifier on every ledger and budget row. Retain the posting date, account, journal identifier, tenant or supplier, description and amount. Map accounts to rental income, operating costs, financing, capital spending and other balance-sheet movements.
The wider financial reporting process explains how reconciled statements fit together. This property review adds the operating breakdown needed by property managers; it does not replace the company's financial statements.
Define the operating subtotal in writing. Here, net operating income, or NOI, means rental income minus property operating costs, before depreciation, interest, income tax and capital spending. Use that definition consistently rather than assuming every recipient calculates the subtotal the same way.
In Excel, place actuals in a table called Ledger and the approved budget in Budget. Both need Month, Property, Category and Amount columns. Normalize income and expense amounts to positive report values, with credits or reversals reducing the appropriate category.
Put the reporting month's first-day date in K1. On the review sheet, A holds the property, B budget rental income, C actual rental income, D budget operating cost and E actual operating cost. For actual income in C2 and actual cost in E2:
=SUMIFS(Ledger[Amount],Ledger[Month],$K$1,Ledger[Property],$A2,Ledger[Category],"Rental income")
=SUMIFS(Ledger[Amount],Ledger[Month],$K$1,Ledger[Property],$A2,Ledger[Category],"Operating cost")
Use the same formulas with Budget replacing Ledger for B2 and D2. Microsoft's SUMIFS guidance explains how the property, month and category conditions select the amounts. Build the property list from both exports so a property with missing actuals or no budget is visible.
Calculate budget NOI in F2, actual NOI in G2 and the NOI variance in H2:
=B2-D2
=C2-E2
=G2-F2
September 2026 results are below. All amounts are whole USD; no rounding is required. A negative NOI variance means the operating result is below budget.
| Property | Budget rent (USD) | Actual rent (USD) | Budget operating cost (USD) | Actual operating cost (USD) | Budget NOI (USD) | Actual NOI (USD) | NOI variance (USD) |
|---|---|---|---|---|---|---|---|
| Oak | 100,000 | 96,000 | 35,000 | 38,000 | 65,000 | 58,000 | -7,000 |
| Pine | 80,000 | 82,000 | 30,000 | 29,000 | 50,000 | 53,000 | 3,000 |
| Total | 180,000 | 178,000 | 65,000 | 67,000 | 115,000 | 111,000 | -4,000 |
Oak's $4,000 rental-income shortfall and $3,000 cost overrun explain its $7,000 NOI shortfall. Pine's $2,000 extra income and $1,000 lower cost explain its $3,000 improvement. The portfolio bridge is $115,000 minus $2,000 of rent shortfall minus $2,000 of extra costs, which equals $111,000.
Investigate Oak first. Check the tenant ledger and lease records before attributing lower income to vacancy or concessions. Check invoices and accruals before calling higher costs a recurring maintenance problem. The table measures the differences; supporting records establish their causes.
The SEC's statement guide distinguishes period income from cash movements. This matters when rents are billed before collection or operating expenses are accrued before payment.
In this simplified month, all recognized rent was billed, with no credits, write-offs or other receivable adjustments. There are no payable adjustments beyond the operating expenses and payments shown:
| Control balance | Opening (USD) | Additions (USD) | Collections / payments (USD) | Closing (USD) |
|---|---|---|---|---|
| Rent receivables | 24,000 | 178,000 | 174,000 | 28,000 |
| Operating payables | 9,000 | 67,000 | 65,000 | 11,000 |
Each closing balance equals opening plus additions minus collections or payments. Tie these balances to the tenant and supplier records, then to the ledger. The $174,000 collected minus $65,000 paid produces $109,000 of property operating cash before financing and capital spending.
| Cash bridge | Amount (USD) |
|---|---|
| Opening cash | 70,000 |
| Rent collected | 174,000 |
| Operating costs paid | -65,000 |
| Mortgage interest paid | -20,000 |
| Loan principal paid | -12,000 |
| Capital improvements paid | -8,000 |
| Closing cash | 139,000 |
Sum the bridge and tie $139,000 to reconciled bank cash. Keep refundable tenant deposits in a separate category; the IRS rental-income guidance also distinguishes deposits intended for return from rental income. Tax reporting rules require their own review.
For interpretation of the completed statements, use real estate financial statement analysis. A real estate dashboard can organize the review, while real estate financial modeling addresses forward assumptions.
Covirage is not affiliated with Microsoft.
Upload a property-ledger and budget file or Google Sheet; Covirage maps the columns, and its tools compute and check the income, cost and variance comparisons. The external AI model explains the results with every figure traced to its rows, supporting a review grounded in the property records. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting for the supporting reporting workflow.
Include rental income, operating expenses, the defined operating subtotal, budget variances, rent receivables and cash movements. Show each property separately before the portfolio total. Add supported explanations and responsible owners for the differences that require a decision.
No. A defined property operating subtotal can include accrued revenue and expense that have not been collected or paid. Cash also changes through loan payments, capital spending and other movements excluded from that subtotal. Reconcile the two views rather than using either as a substitute.
Use the classification approved by your accounting team. A capitalized improvement belongs in the asset and capital-spending records rather than being charged again as a current operating expense. Show its cash payment separately in the property cash bridge.
Separate the rental-income variance from the operating-cost variance, then inspect the supporting tenant ledger, lease records and supplier invoices. Identify whether the cause is recurring activity, timing, an approved change or a posting error, and assign a responsible manager.