Kolena AI Agent
T-12 Extraction
Pull twelve months of trailing financials into a clean, cited NOI spread that is comparable across properties.
Impact
Hours of manual keying per property spread eliminated, with T-12s normalized to a comparable format as fast as they arrive
per operating statement
Volume fit
Works best for
teams spreading T-12s for every acquisition or across a portfolio, where formats differ property to property
Too small for
a single property with an already-standardized spread template that needs no normalization
Typical inputs
Documents
- Trailing twelve-month operating statement (T-12)
- Monthly profit and loss statements
- Rent roll (for unit count and occupancy)
- Prior-year operating statements
Systems
- Yardi
- RealPage
- AppFolio
- Entrata
- MRI
- Google Drive
- SharePoint
Output
A standardized, cited T-12 spread with the NOI build, operating metrics, add-backs, and validation flags
Delivered to
- Deal folder
- Underwriting model
- Asset-management system
- Investment committee package
What it extracts
· 13 fields
- Form
Statement Overview
The identifying facts of the statement - property, type, unit count, period, basis, and source system - so a reviewer can orient before reading the numbers.
- Classification
Source Accounting System
Which property-management or accounting system produced the export, since each labels the same line items differently and that guides normalization.
- Classification
Reporting Basis
Whether the statement is cash, accrual, or modified basis, which determines whether incurred-but-unpaid expenses are captured in NOI.
- Table
Rental Income and Effective Gross Income
The income waterfall normalized to a standard chart - gross potential rent net of loss to lease, vacancy, concessions, and bad debt, plus other income, to effective gross income.
- Table
Operating Expenses
Every operating cost mapped to a standard expense category with per-unit and percent-of-EGI figures, keeping capital and financing items out.
- Table
NOI Reconciliation
The NOI waterfall - GPR to EGI to Total Operating Expenses to NOI - with a foots check that each subtotal ties back to its supporting detail.
- Table
Monthly Trend
Month-by-month EGI, operating expenses, and NOI across the trailing twelve months, exposing seasonality, spikes, and missing periods for run-rate work.
- Table
Below-the-Line Items
Capital expenditures, replacement reserves, debt service, depreciation, and taxes captured separately so they never leak into operating expenses or NOI.
- Table
Non-Recurring and Add-Back Items
One-time or extraordinary items flagged with a recommended normalization treatment, mirroring the servicer NOI-adjustment step.
- Form
Operating Metrics
The standard trailing twelve-month KPIs - NOI, NOI margin, expense ratio, physical and economic occupancy, per-unit figures, and ADR/RevPAR for lodging.
- Form
Period Coverage and Annualization
Whether the statement is a true trailing twelve months or a shorter period, and how any annualized run rate was derived, so a partial year is not misread as full.
- Table
Data Quality and Validation Flags
The footing, sign, classification, and reasonableness checks an analyst runs before trusting a spread, each marked Pass, Fail, or Review.
- Text
Normalization Notes
A narrative of the mapping judgment calls, reclassifications, and assumptions made while building the spread, so a reviewer knows where to double-check.
Prerequisites
- Your standard chart of accounts or spread template
- The property unit count and rentable area for per-unit metrics
- The full twelve months of the statement, not a partial period
Human review
An analyst reviews the normalized mapping, the NOI reconciliation, the non-recurring add-backs, and the validation flags before the spread feeds a model or an investment memo.
Where it fits
Acquisition and asset-management underwriting
Deal intake - trailing twelve-month operating statements arriving from the property, seller, or GP by email or Drive in each system's own export format
This step
T-12 extraction and normalization
After
Who uses it
Grounded in
- CREFC Investor Reporting Package (IRP) - Chart of Accounts, Operating Statement Analysis Report, and NOI Adjustment Worksheetverified as of 2026-07-22
Related agents
Browse all agents →Deal Underwriting
Consolidate a broker OM, the T-12 and rent roll, the Argus/underwriting export, and market data into one cited underwrite with a full return model and a go / no-go call.
Quarterly Budget Variance
Turn a property's quarterly budget-comparison export into a cited budget-versus-actual variance report and drafted investor-letter commentary.
IC Memo
Read the deal package and draft the investment-committee memo - sections, computed return metrics, cited evidence, and a recommendation.
See T-12 Extraction on your documents
We'll run it against a file of yours and walk through every cited field.