Rent Roll → Occupancy and Leasing Reports
Purpose: Provides detailed information about current tenants, lease terms, rental rates, vacancy status, and potential lease expirations. It helps assess occupancy levels, tenant health, and future income stability.
General Ledger (GL) → T12 (Trailing 12 Months) and Financial Statements
Purpose: The GL feeds into the T12 and financial statements, which summarize income and expenses over the past 12 months. It gives insight into revenue trends, operating expenses, net operating income (NOI), and overall financial health.
T12: Commonly used by investors to analyze property performance over time, showing actual cash flows and trends.
Capital Roll Forward → Equity Changes
Purpose: Tracks the changes in equity, detailing capital contributions, withdrawals, dividends, and retained earnings. Helps understand how investor equity evolves over time and supports performance evaluations.
Cash Flows → Cash Flow Statements & Performance Analysis
Purpose: Shows operational cash inflows and outflows, highlighting a property’s liquidity and ability to cover expenses. Essential for evaluating financial performance, debt coverage, and profitability.
Loan Data → Debt Reporting
Purpose: Tracks loan balances, interest rates, amortization schedules, and compliance with covenants. Critical for understanding debt obligations, leverage ratios, and risk associated with debt service.
Accounts Payable/Receivable → Balance Sheets and Aging Reports
Purpose: Details current outstanding liabilities (payables) and pending receivables. Helps assess short-term liquidity, financial obligations, and how efficiently the property is managing its cash collections and payments.
CapEx Budget/Spending → Capital Expenditure Reports
Purpose: Tracks planned vs. actual capital expenditures (CapEx) for property improvements, repairs, or major renovations. Helps investors understand long-term investment strategies and property value enhancement efforts.
Operating Budget → Variance Reports
Purpose: Compares actual performance to budgeted expectations, highlighting variances in income, expenses, and NOI. This is useful for managing operational efficiency and identifying areas for improvement.
Property Valuation/Market Data → Appraisals and Comparative Market Analysis (CMA)
Purpose: Assesses the market value of the property through appraisals and comparison to similar properties. Important for evaluating appreciation, refinancing decisions, or sales opportunities.
Tax Records → Property Tax Reporting
Purpose: Includes property tax liabilities, assessed value, and payments. Essential for understanding the tax burden and ensuring compliance with local tax regulations.