Your monthly portfolio review has an occupancy column from every property manager, but one counts signed leases and another counts residents who have moved in. The delinquency column has the same problem: a current balance in one export and overdue rent in another. Property management KPIs can support comparisons once each manager reports the same eligible population, cutoff, and definition.
Start with a scorecard that ties each result to its calculation and source records. The specification below covers operating performance and approved budget comparisons; it leaves leasing funnel analysis to a separate report. Use the proposed definitions as a starting point, approve changes with the responsible owner, and keep those choices attached to every reporting period.
Set the comparison rules before ranking properties
Choose the property population first. A stabilized apartment community and a property in lease-up have different operating conditions, so label that status rather than interpreting their occupancy gap as a management finding. Keep acquisitions, dispositions, and changes in unit inventory visible; otherwise a portfolio total can move because its membership changed.
Decide whether a metric describes a point in time or activity during a period. Physical occupancy uses a snapshot; collections can follow charges due during a month and payments applied through a later cutoff. Put the reporting date beside the extraction date (when the export was produced), because a rerun after additional payments arrive can change the result without changing property performance.
For portfolio rates, sum comparable numerators and denominators before dividing. Averaging property percentages gives a small property the same weight as a large one. If an equal-property average serves a separate decision, label it as that measure and retain the weighted portfolio rate alongside it.
A property scorecard template with explicit definitions
Download the Excel KPI scorecard to calculate these seven measures for one property and reporting period. The workbook includes editable inputs, definitions, source references, and review states (missing inputs stay unavailable). Your operations and finance owners should approve the eligibility rules and map local statuses before using the results to compare properties.
| Metric | Calculation | Date and status | Exclusions to record | Evidence and owner |
|---|---|---|---|---|
| Physical occupancy | Occupied eligible units / all eligible units | At period end; occupied requires an actual move-in without a completed move-out | Exclude preleases from occupied units. List approved units removed from eligibility and the reason. | Unit inventory and resident status history; property operations owner |
| Current-period rent collections | Receipts applied to eligible rent charges due in the period / those eligible rent charges | Charges by due date; receipts applied through the declared cutoff, net of reversals | Separate deposits, fees, prior-period arrears, and unapplied cash. Apply approved credit rules to both sides. | Charge and receipt-application records; collections owner |
| Overdue rent balance | Eligible unpaid rent past its stated due date; report dollars by approved age bands | As of cutoff; retain due date, payment applications, and approved credits | Separate future charges and non-rent balances. Flag disputes without assuming they erase the balance. | Aged charge-level receivables; collections owner |
| Renewal retention | Eligible expiring leases renewed / eligible leases expiring in the period | Lease expiration period; use an approved renewal-completion status and outcome cutoff | Separate transfers and month-to-month continuations. Preserve unresolved outcomes in the eligible denominator. | Lease expiration and renewal records; leasing owner |
| Turn time | Elapsed calendar days from possession returned to approved ready-to-show status | Turns completed in the period; show open turns with their current age alongside completed-turn results | Segment major renovation holds; retain their elapsed days rather than losing them from the report. | Move-out, possession, inspection, and ready timestamps; maintenance owner |
| Maintenance backlog aging | Count open eligible work orders by age since request creation | As of cutoff; include pending and on-hold work, grouped by approved priority | Separate canceled duplicates and project work. Keep resident requests awaiting vendors in the backlog. | Work-order status history and creation timestamps; maintenance owner |
| NOI against approved budget | Approved actual net operating income minus approved budget NOI; report dollar variance | Same period, accounting basis, property population, and account mapping on both sides | Use finance-approved operating revenue and expense scope; separate financing and capital items. | Property ledger, account mapping, and approved budget version; finance owner |
Net operating income, or NOI, is property revenue less operating expenses. It differs from cash collections and requires an approved account scope, so have finance resolve classifications before applying the template. Keep the original approved budget beside any later reforecast; otherwise a budget revision can hide the variance the review was meant to explain.
Keep a property-level scorecard separate from individual staff evaluation. A work-order backlog can reflect vendor capacity or a renovation program as well as onsite execution. Use the report to select the records that need review, then assign a cause and an action from the supporting evidence.
Add leasing funnel measurements when the review needs to explain demand conversion. Leasing funnel: measuring lead-to-lease conversion covers stage and cohort choices that should stay separate from a point-in-time occupancy snapshot.
Attach a measurement record to every scorecard result
Create a companion sheet called Measurement Records. Use one row per property, metric, and reporting period, with these column names: property_id, metric_id, period_start, period_end, as_of, extracted_at, definition_version, numerator, denominator, result, source_reference, exclusion_reference, owner, and review_status. For a balance or duration, leave the denominator empty and retain the charge total or event timestamps used in the calculation.
The source reference should identify the saved export and the record IDs behind the result. An exclusion reference should point to the removed records and approved reason, such as a duplicate work order. Give mappings their own version: a manager changing a unit status label must not make occupied units disappear from the next extraction.
Keep resident-level evidence restricted to people who need it. A portfolio summary can expose overdue totals without exposing names or payment details to every viewer. Record the access requirement with the evidence location so a shared scorecard does not become an unrestricted copy of the resident ledger.
Build a scorecard from a property export
Start with a dated export and an approved metric definition. Keep the source records alongside the result before extending the scorecard across your portfolio.
Review evidence gaps before interpreting performance
Give each result a review status such as ready, incomplete, or definition mismatch. A missing property export should remain a visible gap in the portfolio summary. Substituting zero makes absent collections look like failed collections, while dropping the property can make the portfolio rate look better.
Resolve changed definitions before explaining changes in performance. If the eligible unit population moves, show which units entered or left it. If a maintenance request closes and reopens, retain the event history so a current status does not erase the delay. Corrections should identify the affected periods and preserve the previously issued results.
Set escalation thresholds with the owner for each property group and record the action they trigger. A threshold needs a decision attached, such as reviewing aged vendor holds or checking unapplied payments. Avoid importing a generic benchmark when the property type, operating stage, and measurement basis differ from the benchmark population.
Permute: repeat the scorecard against governed data
Permute sells a financial intelligence layer that connects business data, reconciles records, and applies declared definitions for reporting and AI. We can start with supplied property-management exports alongside approved accounting and spreadsheet sources such as QuickBooks, Excel, and Google Sheets. Matching property and unit identifiers keeps renamed properties or manager-specific codes from splitting the same asset across reports.
We encode the approved metric definitions, exclusions, and source precedence once, then reuse them when producing the scorecard. A static workbook retains its last input snapshot; a recurring workflow refreshes the output from available sources and exposes missing or stale inputs. Client dashboards provide a shared reporting artifact with the measurement basis behind its values.
A portfolio operations leader can ask which properties have aging maintenance requests and inspect the records included in that result. We supply governed data underneath ChatGPT, Claude, and Copilot, with the relevant definitions and source evidence available for analysis. Review access requirements before deciding which resident-level records belong in a shared reporting workflow.
Keep operating decisions and accounting judgment with their owners
This reporting workflow reads source records and produces analytical outputs; it does not change leases, resident balances, or work orders in property operating systems. Your owners approve the definitions, resolve disputed data, and decide the resulting action. We do not select professional accounting treatments, perform statutory consolidation with intercompany eliminations, or act as a forecasting engine.
The scorecard also leaves rent pricing, resident screening, and maintenance dispatch in their existing workflows. A late export or incomplete event history limits what the report can establish, so retain that limitation beside the result. For the broader reporting context, see financial visibility for real estate.
A comparable portfolio scorecard starts with the same population, cutoff, and approved definition for every property. Preserve the source records and exceptions so occupancy and delinquency differences in the monthly review can be traced before they become management judgments. Separate data gaps from operating gaps, and keep revised results identifiable. The next review can then compare performance against the same measurement basis and assign actions to the right owner.
Review the evidence behind your portfolio scorecard
Bring reports from your property managers. We will examine differences in definitions, source coverage, and access before scoping a repeatable reporting workflow.
Questions about a portfolio property scorecard
What if a new manager cannot provide historical event data?
Begin with the periods for which the required evidence exists and label the historical gap. Do not reconstruct move-in, ready, or payment-application dates from a current status alone. Keep the old report as a separate reporting basis until the owners can approve a supported comparison.
Can the scorecard survive a change in property manager?
Yes, if the property identity and approved definitions remain stable while source mappings change. Preserve both managers’ source references at the handover and flag any period with incomplete coverage. Compare the affected period after its missing records have been resolved or its limitation has been disclosed.
What should a rate show when its denominator is zero?
Show the rate as not applicable and retain the zero denominator. A period without eligible lease expirations does not establish a retention result. Distinguish that condition from missing data, which should carry an incomplete review status.