You just got a T12 from the broker on a deal your team wants to move on. The numbers are all there: twelve months of revenue, expenses, line by line. But the chart of accounts doesn’t match your underwriting template, some expense categories look like they were made up on the spot, and there’s a spike in R&M in month eight that nobody has explained. You know the right next step: map every line item to a standardized chart of accounts, add trailing period columns so you can see the trends, and then walk each category looking for variances that need a follow-up question before you put this deal in front of your IC. But doing that properly takes 30 minutes you don’t have when there are two more T12s sitting in your inbox and a site visit this afternoon. That’s exactly what this task is built to fix. underwriting 10 min Audit T12 Operating History Mapped T12 Excel on a standard chart of accounts plus chat findings flagging revenue and expense variances by severity, with follow-up diligence questions for each anomaly. Who It’s For Acquisitions analysts, asset managers, and underwriters who need a fast, structured audit of a property's trailing 12-month operating history. What You Get Back A standardized Excel file mapped to a standard chart of accounts, plus a detailed variance and anomaly analysis with severity ratings and follow-up questions. Why It Matters Turns a 30-minute manual T12 scrub into a 10-minute task, so every deal gets the same level of diligence regardless of how many are on your desk. Task Inputs Property Type Optional Multifamily, Office, Retail, Industrial, or Hotel. If not provided, the AI coworker will infer from the document. Additional Context Optional Unit count, property name, known one-time events, or anything else that helps the AI coworker interpret the financials. T12 / Operating History Required Trailing 12-month income statement (Excel or PDF) Skills Used T12 Analysis Considerations Tools Used Add T1 T3 T6 and T12 to Income Statement Map Income Statement to Standard COA Multi-Period Code Interpreter What This Task Does You upload the T12 (Excel or PDF) and optionally tell the task what property type you’re looking at and any context that might matter: unit count, property name, known one-time events like a management transition or a roof replacement. That’s the entire setup. From there, your Real Estate Analyst (with Memory) AI Coworker takes the raw T12 through a three-step process. First, it enriches the file with trailing period columns (T1, T3, T6, and T12) so you can see short-term and long-term trends at a glance. Then it maps every line item to a standardized chart of accounts based on the property type. Finally, it walks every line item across all twelve months using dual-gate thresholds (5% change and $5,000 change), flags variances by severity (HIGH, MEDIUM, LOW), identifies multi-month patterns, and generates category-specific follow-up questions for each anomaly. You get the mapped Excel file and a structured analysis in chat. The whole process takes roughly 10 minutes of your time. The AI does the rest. Who This Task Is For Every T12 that crosses your desk deserves a proper audit. But when you’re screening multiple deals a week, the ones that get a thorough line-by-line review are usually the ones where someone had time. The rest get a quick scan and a gut check. This task closes that gap. This task is built for: Acquisitions analysts who are underwriting new deals and need a clean, standardized T12 with flagged anomalies before building their model Asset managers who review monthly or quarterly operating statements across a portfolio and need to spot variances quickly Underwriters and lenders who need a structured audit trail with severity ratings and follow-up questions for their credit memo Brokers preparing listing packages who want to identify and address any red flags in the financials before a buyer’s team finds them first In short: if you already have the T12, this task gives you the audit. Why It Matters The T12 is the foundation of every acquisition underwriting. If you miss a variance in the operating history, it shows up later as a surprise: in your model, in your IC memo, or worse, after you’ve closed. The manual process of mapping line items, adding trailing columns, and walking each category for anomalies is not complicated. It’s just time-consuming. You already know how to read a T12. You know what a suspicious R&M spike looks like. You know that a flat utility line in a market with rising rates deserves a question. The problem is not skill. It’s bandwidth. When you’re looking at five deals this week and each one comes with a T12 in a different format, the thorough audit is the first thing that gets compressed. You scan instead of scrub. You flag the obvious and hope you didn’t miss the subtle. Without this task, the deals that don’t get a proper T12 audit ar