T12 Parsing
Extract and standardize T12 operating statements with AI. Parse income and expenses from any format, calculate NOI instantly, and get analysis-ready data in seconds.
What is a T12?
A T12 (Trailing Twelve Months) operating statement shows 12 months of actual income and expenses for a property. It's essential for calculating NOI and evaluating property performance.
12 Months of Data
Shows actual performance over the trailing twelve-month period.
Income Categories
Base rent, CAM, parking, late fees, and other revenue sources.
Expense Categories
Property taxes, insurance, utilities, repairs, management fees.
NOI Calculation
Net Operating Income = Total Income - Operating Expenses.
Sample Parsed Output
See how CleanRoll.ai transforms messy T12 data into clean, standardized tables.
Income
| Category | Jan | Feb | Mar | Annual |
|---|---|---|---|---|
| Base Rent | $15,000 | $15,000 | $15,200 | $182,400 |
| CAM Reimbursement | $2,000 | $2,000 | $2,000 | $24,000 |
| Parking Income | $800 | $800 | $800 | $9,600 |
| Total Income | $17,800 | $17,800 | $18,000 | $216,000 |
Expenses
| Category | Jan | Feb | Mar | Annual |
|---|---|---|---|---|
| Property Management | $890 | $890 | $900 | $10,800 |
| Property Taxes | $1,500 | $1,500 | $1,500 | $18,000 |
| Insurance | $400 | $400 | $400 | $4,800 |
| Total Expenses | $5,200 | $5,200 | $5,300 | $63,600 |
Net Operating Income (NOI)
Total Income - Total Expenses
$152,400
$216,000 - $63,600
How It Works
Upload Your T12
Drag and drop your T12 operating statement in Excel, CSV, or PDF format. Works with exports from any property management system.
AI Extracts Data
Our AI identifies income and expense line items, categorizes them into standard categories, and extracts monthly values.
Review & Export
Review the parsed data, verify categorization, and export to clean Excel or CSV. NOI calculated automatically.
Standard Categories
Our AI categorizes income and expenses into industry-standard categories for consistent analysis across your portfolio.
Income Categories (18)
Expense Categories (27)
Why Use T12 Parsing?
Instant Processing
Parse complex T12 statements in seconds, not hours. No manual data entry required.
Smart Categorization
AI maps line items to 18 income and 27 expense categories based on industry standards.
Auto-calculated NOI
Net Operating Income is calculated automatically once income and expenses are parsed.
Rent Roll Reconciliation
Compare T12 collections against rent roll scheduled income to identify variances.
Ready to Parse Your T12?
Upload your T12 operating statement and get clean, standardized data in seconds. 3 free documents, no credit card required.