Skip to main content

AI T12 analysis · Updated November 2026

AI T12 analysis for commercial real estate, from the seller's statement to your model

How AI gets a seller's T12 onto your chart of accounts, finds the one-time items, annualizes the trailing columns, checks the pro forma and ties income to the rent roll. Your workbook does the math.

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
Institutional T12 categories, common seller labels and the check for each
Your categorySeller labels you will seeWhat the AI checks
Gross potential rentRental income, base rent, market rent, scheduled rentAt 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 leaseLoss/gain to lease, LTL, below-market rentGPR at market less in-place rent on occupied units. It ties to the rent roll's market vs. in-place columns.
VacancyVacancy loss, physical vacancy, down unitsMonths should follow the occupancy trend from the rent roll.
Non-revenue unitsModel, employee, office, down unitsGets its own line. Sellers often bury these inside vacancy or concessions.
ConcessionsFree rent, move-in specials, abatementCompare with the concession column on the rent roll and the leases.
Bad debtWrite-offs, collection loss, credit lossRead it against the aged receivables report, not just the line.
Expense reimbursementsCAM recovery, tax and insurance recovery, utility billbackMust match the recovery terms in each lease.
Other incomeParking, storage, laundry, late fees, application feesRecurring items stay. Insurance proceeds and termination fees come out.
Real estate taxesProperty tax, tax escrow, assessmentsFlag refunds, appeals and accruals booked in one month.
InsuranceProperty, liability, umbrella premiumsCheck against the current policy period and renewal.
UtilitiesElectric, gas, water, sewer, trashLook for catch-up bills and seasonal months.
Repairs and maintenanceMake-ready, turnover, contract services, landscapingPull out replacements that are really capital work.
PayrollSalaries, benefits, payroll taxes, bonusesMatch to the current staffing plan and site headcount.
Management feeProperty management, asset managementAsset management fees are owner level. They move below the line.
General and administrativeOffice, legal, accounting, software, bank feesLegal spikes often trace to one dispute or eviction wave.
Below the lineCapital projects, reserves, debt service, depreciation, leasing commissions, TIOut 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.
Common one-time items in a T12 and how to treat them
One-time itemHow it shows upUsual treatment
Insurance claim proceedsA large month in other income, often next to a repairs spikePull it from income, and make sure the matching repair comes out too.
Lease termination feeOther income in one month, a tenant gone from the rent rollTake it out and underwrite the space as vacant, with downtime.
Tax refund or appeal settlementA negative tax month or a credit in other incomeRemove it, then underwrite taxes at the go-forward assessment.
Capital replacement in repairsRoof, boiler or parking lot work in repairs and maintenanceMove it below the line, into the capital plan.
Accrual true-upOne month that reverses earlier monthsSpread it across the months it belongs to, or ask for cash basis.
Utility catch-up billTwo or three months billed at once after a meter issuePut it in the right months before you read the trend.
CAM reconciliation true-upA prior-year recovery booked in the current yearBook 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.
Seller pro forma vs T12: where the gaps usually are and the evidence to ask for
LineWhat the pro forma often assumesEvidence that would support it
RentsEvery unit or suite at market rentRecent leases and renewals on the rent roll at that rent, and how many are left to roll.
VacancyA stabilized rate below the trailing monthsMonthly occupancy trend, current traffic and leasing pipeline.
Other incomeNew fees or a utility billback not yet in placeWhether the program is live, on which leases, and since when.
Real estate taxesThe seller's current assessmentThe reassessment rule in that jurisdiction applied to your price.
InsuranceLast year's premiumA current quote for your coverage and deductibles.
Repairs and maintenanceLower, assuming renovations are doneThe 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.

  1. 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
  2. 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.
  3. 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.
  4. Reimbursements against lease terms. On commercial assets, recovery income should follow each lease's structure: net, base year or gross. AI lease abstraction
  5. Bad debt against delinquency. The rent roll's balance column and the aged receivables report should explain the bad debt line.
  6. 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.

Next step

See where AI saves your firm time across your firm.

Ten minutes. An honest read on where you stand, the highest-value opportunities, and which engagement fits, if any.