Commercial Real Estate Asset Performance and Occupancy Reporting Checklist

Role: Senior Real Estate Portfolio Analyst and Commercial Asset Reporting Specialist.

Context

• Portfolio Identifier: {{portfolio_name}}
• Operating Quarter: {{reporting_quarter}}
• Target Net Operating Income: {{target_noi}}
• Target Property Classes: {{property_types}}
• Minimum Physical Occupancy Floor: {{occupancy_floor_rate}}
• Target Debt Service Coverage Ratio: {{debt_service_coverage_ratio}}

Task

Formulate a rigorous quarterly reporting QA checklist to audit the financial and operational reporting packet for {{portfolio_name}}, confirming that net operating income, occupancy trends, tenant credit risks, and debt service compliance across {{property_types}} are validated before distribution to institutional investors.

Method

1. Reconcile gross potential rent against actual collected revenue and concession amortizations for {{reporting_quarter}}.
2. Cross-check reported physical and economic occupancy rates against {{occupancy_floor_rate}} across each individual asset.
3. Validate the calculated Net Operating Income against {{target_noi}} and isolate top-three operating expense variance drivers.
4. Confirm that lease expirations within the rolling 12-month window have updated renewal probabilities and weighted lease values.
5. Audit capital expenditure accounts to ensure correct classification between capitalized improvements and operating expenses.
6. Verify current debt service metrics against {{debt_service_coverage_ratio}} covenants to prevent default risk misstatements.
7. Cross-examine tenant accounts receivable aging tables to ensure bad debt provisions are accurately reflected.

Constraints

• MUST format checklist items with checkbox notation ([ ]), verification protocol, and validation owner.
• MUST NOT omit tenant-level arrears and credit exposure audits.
• Keep items concise, unambiguous, and restricted to reporting accuracy.
• All line items MUST reference explicit real estate financial statements (Rent Roll, Operating Statement, Balance Sheet).

Output format

A markdown checklist divided into: 1) Revenue and Rent Roll Reconciliation, 2) Operating Expense and NOI Validation, 3) Occupancy and Lease Expiration Audits, and 4) Debt Covenant and Compliance Check. Total length must be under 30 checklist items.

Self-review

• Verify that {{target_noi}}, {{debt_service_coverage_ratio}}, and {{occupancy_floor_rate}} are integrated into quantitative checkpoints.
• Check that property-specific nuances for {{property_types}} are accommodated.
• Confirm the checklist strictly follows binary verification standards.