The T-12 — trailing 12-month income statement — is the most important document in any CRE acquisition. It's the only place you'll find what the property actually earned, not what the broker says it could earn. AI T-12 extraction turns a 30-minute manual process into 10 seconds.
What Is a T-12?
A T-12 is a month-by-month income and expense statement for the trailing 12 months of property operations. It shows actual collected rent (not scheduled rent), actual vacancies, actual operating expenses, and actual NOI. Unlike the broker's pro forma, the T-12 is based on real operations — it's the financial truth of the asset.
T-12 vs. Pro Forma: Why It Matters
| Metric | T-12 (Actual) | Pro Forma (Broker) |
|---|---|---|
| Gross Income | Actual collected rent | Market rent × 100% occupancy |
| Vacancy | Real empty units | Usually 5% (optimistic) |
| Management Fee | What owner actually pays | Often omitted or understated |
| Repairs/Maintenance | Actual costs incurred | Normalized lower number |
| NOI | Real trailing number | 15–25% higher on average |
| Cap Rate | Conservative / realistic | Overstated to justify price |
How to Read a T-12
T-12s come in various formats — property management software exports (AppFolio, Buildium, Yardi), QuickBooks exports, or custom spreadsheets. The key numbers to extract:
- Gross Collected Rent: What tenants actually paid, month by month. Sum of 12 months.
- Vacancy/Credit Loss: The difference between scheduled and collected rent.
- Other Income: Laundry, parking, late fees, pet fees — real numbers.
- Operating Expenses: Every line item. Watch for missing management fees, deferred maintenance, or abnormally low repair costs in a sale year.
- Trailing NOI: Total income minus total operating expenses. This is your underwriting baseline.
AI T-12 Extraction in the Platform
The RealEstate-Analytics.ai Income Property Analyzer uses PDF.js with position-aware text reconstruction to extract T-12 data from PDF exports. Upload the document, and the AI identifies income and expense line items, maps them to standard categories, calculates trailing NOI, and populates the deal analyzer automatically. It handles AppFolio, Buildium, Yardi, and QuickBooks PDF formats.
Red Flags in a T-12
- Missing management fee: Owner-managed properties often don't show management cost. Add 8–10% before underwriting.
- Low repair costs in the sale year: Sellers defer maintenance before listing. Normalize CapEx reserves at $100–200/unit/year.
- Unusual income spikes: One-time settlements, insurance proceeds, or back-rent collections inflate trailing income. Normalize these out.
- Utilities not broken out: If utilities are owner-paid and buried in a lump sum, get the utility bills separately.
Upload Your T-12 Now
AI extracts NOI and populates the deal analyzer automatically.
Open the Income Property Analyzer →