Disclosure
Pacific Software Ventures (PSV) builds AI systems that read T12s and fill underwriting models for CRE firms, so we have a stake in what you pick. The workflow and checks below work with any tool, ours included, and every result links to its full case study.
What is AI T12 analysis?
AI T12 analysis means an AI reads the seller's trailing twelve month operating statement, maps every line to your institutional categories, flags one-time items and odd months, checks the seller's pro forma line by line and ties income back to the rent roll. It writes each normalized line into your model's input tab with the file, row and month it came from. Your workbook formulas compute NOI, annualized figures and ratios, so the AI never types a result. An analyst reviews every adjustment, and the underwriter decides what gets underwritten.
How does AI normalize a T12 to institutional categories?
Every seller's accountant names lines differently. T12 normalization means mapping each seller line to one fixed chart of accounts, so every deal lands in the same rows of your model. The AI does it in four passes.
- Read the statement as a grid. Ask for the Excel export, not the PDF. The AI finds the month columns, the total column, each line label, the subtotals and the NOI line, and records the sheet and row of every value. Ask whether it's cash or accrual basis first, because that changes how lumpy bills and true-ups read.
- Check the arithmetic before anything else. Each line's months should add to its total. Each section should add to its subtotal. Income less expenses should equal the stated NOI. A formula in your workbook runs this check, not the AI. If it doesn't foot, send it back to the seller.
- Map every line to your chart of accounts. The AI proposes a category for each seller line from your written mapping guide, with the reason in a few words. Lines it can't place go on a review list for the analyst. Then a workbook formula checks each expense line per unit or per square foot against your own comparable assets. The table below is a common institutional set.
- Move below-the-line items out of NOI. Capital work, debt service, depreciation, amortization and owner-level fees don't belong in NOI. Neither do leasing commissions and tenant improvements on commercial assets. Each move gets listed with its source row.
| Your category | Seller labels you will see | What the AI checks |
|---|---|---|
| Gross potential rent | Rental income, base rent, market rent, scheduled rent | At market rent (common in multifamily), it ties to the rent roll's market rent column. At in-place rent (common on commercial assets), it ties to in-place plus vacant space at asking. Confirm which the seller used. |
| Loss to lease | Loss/gain to lease, LTL, below-market rent | GPR at market less in-place rent on occupied units. It ties to the rent roll's market vs. in-place columns. |
| Vacancy | Vacancy loss, physical vacancy, down units | Months should follow the occupancy trend from the rent roll. |
| Non-revenue units | Model, employee, office, down units | Gets its own line. Sellers often bury these inside vacancy or concessions. |
| Concessions | Free rent, move-in specials, abatement | Compare with the concession column on the rent roll and the leases. |
| Bad debt | Write-offs, collection loss, credit loss | Read it against the aged receivables report, not just the line. |
| Expense reimbursements | CAM recovery, tax and insurance recovery, utility billback | Must match the recovery terms in each lease. |
| Other income | Parking, storage, laundry, late fees, application fees | Recurring items stay. Insurance proceeds and termination fees come out. |
| Real estate taxes | Property tax, tax escrow, assessments | Flag refunds, appeals and accruals booked in one month. |
| Insurance | Property, liability, umbrella premiums | Check against the current policy period and renewal. |
| Utilities | Electric, gas, water, sewer, trash | Look for catch-up bills and seasonal months. |
| Repairs and maintenance | Make-ready, turnover, contract services, landscaping | Pull out replacements that are really capital work. |
| Payroll | Salaries, benefits, payroll taxes, bonuses | Match to the current staffing plan and site headcount. |
| Management fee | Property management, asset management | Asset management fees are owner level. They move below the line. |
| General and administrative | Office, legal, accounting, software, bank fees | Legal spikes often trace to one dispute or eviction wave. |
| Below the line | Capital projects, reserves, debt service, depreciation, leasing commissions, TI | Out of NOI, but listed so nothing disappears. |
How does AI spot one-time items and annualize a T12 correctly?
A T12 tells you what happened over the last twelve months, not what happens after you close. Your underwritten year adjusts for anything that won't repeat or that changes on sale. The AI finds the candidates and shows the evidence. The underwriter decides which adjustments stand.
- Scan every line month by month. The AI compares each month with the line's own pattern and flags spikes, zero months, negative entries and reversals.
- Read the notes and the general ledger detail. Ask the seller for the GL detail behind the flagged months. The AI matches entries to flags, so a repairs spike turns into a named roof replacement. Unexplained flags stay on the diligence list.
- Annualize trailing columns with care. A T3 multiplied by four and a T1 multiplied by twelve show the recent run rate after a rent increase or a new contract. But they carry seasonality: winter utilities, summer turnover, a tax installment. The workbook computes all three from the monthly inputs, and the underwriter picks one per line and notes why. A common lender and acquisitions convention is annualized T3 income against T12 expenses. So a recent rent bump counts, and seasonal costs still get a full year.
- Handle a partial-year statement honestly. Only nine months? Fill the gap from the same months of the prior year. Don't scale up. And never annualize a lumpy bill, like a premium or tax installment, from a few months of cash. Use the policy premium or the tax bill itself.
- Reset what changes on sale. Taxes reassessed at your purchase price (in states that reassess on transfer), insurance at your current quote, the management fee at your contract rate, payroll at your staffing plan. Each is its own input row, never an edit to the seller's actuals.
| One-time item | How it shows up | Usual treatment |
|---|---|---|
| Insurance claim proceeds | A large month in other income, often next to a repairs spike | Pull it from income, and make sure the matching repair comes out too. |
| Lease termination fee | Other income in one month, a tenant gone from the rent roll | Take it out and underwrite the space as vacant, with downtime. |
| Tax refund or appeal settlement | A negative tax month or a credit in other income | Remove it, then underwrite taxes at the go-forward assessment. |
| Capital replacement in repairs | Roof, boiler or parking lot work in repairs and maintenance | Move it below the line, into the capital plan. |
| Accrual true-up | One month that reverses earlier months | Spread it across the months it belongs to, or ask for cash basis. |
| Utility catch-up bill | Two or three months billed at once after a meter issue | Put it in the right months before you read the trend. |
| CAM reconciliation true-up | A prior-year recovery booked in the current year | Book it to the year it belongs to, and check the reconciliation statement. |
How does AI reconcile a seller's pro forma with the T12?
The OM's pro forma is the seller's argument about next year. The T12 is the evidence. Pro forma vs T12 work means putting them side by side and asking, line by line, what has to be true for each gap to close. The AI builds the comparison and drafts the broker questions. How much of each gap you believe is the underwriter's call.
- Line up the categories first. The AI maps both to the same chart of accounts so every row compares like with like. Pro forma lines with no T12 match get their own list.
- Ask what evidence supports each gap. A rent increase needs recent leases on the rent roll at the higher rent. An expense cut needs a signed contract or a staffing change that already happened. No evidence? It's a seller assumption, labeled as one.
- Separate the seller's plan from your plan. Your own rent and cost plans go in your business plan with your capital and timing, not in the starting NOI. Otherwise you're paying the seller for your own work.
| Line | What the pro forma often assumes | Evidence that would support it |
|---|---|---|
| Rents | Every unit or suite at market rent | Recent leases and renewals on the rent roll at that rent, and how many are left to roll. |
| Vacancy | A stabilized rate below the trailing months | Monthly occupancy trend, current traffic and leasing pipeline. |
| Other income | New fees or a utility billback not yet in place | Whether the program is live, on which leases, and since when. |
| Real estate taxes | The seller's current assessment | The reassessment rule in that jurisdiction applied to your price. |
| Insurance | Last year's premium | A current quote for your coverage and deductibles. |
| Repairs and maintenance | Lower, assuming renovations are done | The property condition report and the scope already completed. |
How does the T12 tie to the rent roll?
A T12 shows what was collected and spent over a year. A rent roll shows who's in the building today, and on what terms. Every gap should have a reason. The AI runs six checks and lists each gap with both sources.
- Rental income against in-place rent. The latest month of rental income should sit close to the rent roll's monthly in-place total. The workbook computes the difference. The AI explains it. AI rent roll analysis
- Vacancy against occupied units or square feet. Vacancy loss in recent months should reflect the vacant units or suites on the rent roll, at their asking or last rent.
- Concessions against the concession column. Free rent on the rent roll and in the leases should hit the concessions line in the right months, not get netted out of rent.
- Reimbursements against lease terms. On commercial assets, recovery income should follow each lease's structure: net, base year or gross. AI lease abstraction
- Bad debt against delinquency. The rent roll's balance column and the aged receivables report should explain the bad debt line.
- Other income against the units that pay it. Parking, storage and pet fees on the rent roll should roughly match the other income lines. Rent roll reconciliation
Should AI type NOI and results into the underwriting model?
No. We don't let it, and you shouldn't either. A language model can describe a calculation correctly and still get the sum wrong, and one wrong digit moves your price. So split the job: the AI writes inputs with their sources, and your workbook's formulas produce every total, ratio and annualized figure.
- An input tab with a source on every row. Each normalized line gets a row: your category, the seller's label, twelve monthly values, and the file, sheet and row they came from.
- Adjustments as their own rows. Every removal, reclassification and buyer reset is its own row with a reason and a source, so the bridge to underwritten NOI is visible.
- Formulas for everything computed. NOI, annualizations, expense ratio, per unit figures and pro forma gaps are formulas. The AI quotes the output cell. It never retypes it. NOI calculator
- A control total that must match. A formula checks that the normalized lines add back to the seller's reported NOI before adjustments. If they don't match, something got dropped or counted twice.
- A reviewer signs the adjustments. The analyst accepts or rejects each flag and adjustment. The underwriter signs the underwritten year. AI underwriting for CRE
Examples: T12 and underwriting work at real firms
Each line is the client's published result, quoted from its case study.
- Westlake Realty Group, underwriting in its own model. Westlake Realty Group cut per-deal underwriting from 6-8 hours of senior time to a 20-minute review, in its own model with every number traced to source. Read the case study
- Silverado Interests, underwriting prep by email. Silverado Interests' AI analyst works deal screening, underwriting prep and investor reporting from one email address the Dallas team forwards work to. Read the case study
- Accomplish Collective, inside its own tenant. A real estate sponsor put four AI employees on deal sourcing, underwriting, asset management and investor reporting, inside its own Microsoft 365 tenant. Read the case study
What should stay with the analyst and the underwriter?
Your team keeps the mapping guide, the call on whether a flagged month is really one-time, which trailing period each line uses, how much of the pro forma to believe, the buyer resets and the underwritten NOI. The AI shows the evidence. It doesn't decide what the property will earn.
Build it, do it yourself, or buy software?
- Have PSV build it into your model (ours). We set up the reading, mapping, flags and reconciliation against your chart of accounts and your workbook, inside your firm's tenant. Then we stay on as your AI team and keep the guide and checks current. What you own is set out in the terms. AI consulting for CRE
- Do it yourself in an AI assistant. Claude, ChatGPT or Copilot can map and flag a T12 if you give it your mapping guide, make it cite the row and month for every value, and keep the math in your spreadsheet. Your team maintains them. ChatGPT prompts for CRE
- Buy point software. Extraction products read rent rolls and T12s into their own screens. Your team connects the output to your model and runs the reconciliation. Our list compares them. Best AI rent roll and T12 software
Common questions
- What is AI T12 analysis?
- An AI reads the operating statement, maps each line to your categories, flags one-time items, checks it against the pro forma and rent roll, and fills your model's input tab with sourced values. Your formulas compute NOI. Your team signs off on the adjustments.
- Can AI find one-time items in an operating statement?
- It can flag the candidates: spikes, zero months, reversals, insurance proceeds, termination fees, tax refunds and capital work booked to repairs. Whether an item is really one-time is still the underwriter's call.
- How does AI compare a seller's pro forma with the T12?
- It maps both to the same categories, lists the gap on each line for your workbook to compute, and says what evidence would back it up, like recent leases at the higher rent or a signed contract for a lower expense. Gaps with no evidence get labeled as seller assumptions.
- Should a T3 or T1 be used instead of the full T12?
- Use them side by side. They show the recent run rate, but they carry seasonality and lumpy bills. Compute all three in your workbook and pick per line, with a note.
- Can Claude, ChatGPT or Copilot analyze a T12 on their own?
- Each one can read and map a statement if you hand it your mapping guide, make it give the row and month for every value, and keep the arithmetic in your spreadsheet. Use a business plan whose data terms you've read.
- Is it safe to upload a seller's T12 to an AI tool?
- It can be, if the tool runs inside your firm's own tenant or workspace, keeps a log and doesn't train a shared model on your files. Check your confidentiality agreement with the seller too. Keep data vendors' exports out unless you have their written permission. The seller's statement, the rent roll, the leases and your own records are where the AI should work.
- How much time does AI save on T12 and underwriting work?
- Depends on how many statements you read and how your model is built. One published example: Westlake Realty Group cut per-deal underwriting from 6-8 hours of senior time to a 20-minute review, in its own model with every number traced to source.