Skip to main content

Free tool and guide

What is a T12 in real estate? and how to check one

A T12 shows what a property actually earned and spent over the last 12 months. Paste one into the free analyzer below to get NOI, T3 and T1 figures, and the questions to ask the seller.

A T12, or trailing 12 months, is a property's income and expense statement for its most recent 12 months, shown month by month. Buyers and lenders use it to see what a property actually did, as opposed to what an offering memorandum projects it could do.

T12 analyzer

Paste a T12 to total income, expenses and NOI, annualize the last 3 months and the last month, and flag totals that do not add up, one-month spikes, and missing lines. It runs in your browser: your numbers are not uploaded, saved or tracked, and there is no sign-up.

One line item per row, followed by its monthly columns. A month header row helps. PDFs need converting to a spreadsheet first.

Blank template

How each line was sorted

Change any line that is wrong. The results update straight away.

LineTotalTreated as
Gross potential rent$874,800
Vacancy-$43,600
Concessions-$6,500
Other income$27,500
Total income$852,200
Real estate taxes$106,800
Insurance$40,800
Property management$34,080
Payroll$67,200
Repairs and maintenance$35,200
Utilities$42,600
Marketing$6,000
Total operating expenses$332,680
Net operating income$519,520
Replacement reserves$12,000

Showing an invented sample property

T12 income
$852,200
Operating expenses
$332,680
NOI
$519,520
$10,823 per unit
Expense ratio
39.0%
Expenses divided by income
T3 annualized NOI
$536,960
Last 3 months times 4
T1 annualized NOI
$529,080
Last month times 12

What to ask about

  • "Replacement reserves" ($12,000) is treated as below the line and left out of NOI. If the seller's NOI excludes or includes it differently, the two figures will not match.
  • Repairs and maintenance in Aug: $9,800, against a typical month of $2,300. One-off, or something moved into this month?

Flags come from arithmetic and missing lines, not from market benchmarks. A flag is a question to ask, not a verdict.

What is in a T12

A T12 runs from income down to net operating income (NOI), one column per month:

  • Income: gross potential rent, less vacancy, concessions and bad debt, plus other income such as parking, laundry or fees. In commercial property, this also includes expense reimbursements from tenants.
  • Operating expenses: real estate taxes, insurance, property management, payroll, repairs and maintenance, utilities, marketing and administration.
  • NOI: income less operating expenses.
  • Below the line: debt service, capital expenditures and, often, replacement reserves. These come after NOI.

Download a blank T12 template (CSV). It opens in Excel and has the lines above.

The T12 formulas

Effective gross incomeGross potential rent, less vacancy, concessions and bad debt, plus other income
NOIEffective gross income, less operating expenses
Expense ratioOperating expenses divided by effective gross income
T3 annualizedThe last 3 months, times 4
T1 annualizedThe last month, times 12
Cap rateNOI divided by purchase price

How to analyze a T12, in order

  1. Check that it adds up. Monthly columns should tie to the totals, and the stated NOI should equal income less expenses.
  2. Read across, not just down. The annual total hides a roof repair in August or a tax bill paid in one month. Look for spikes and blanks.
  3. Compare the last 3 months with the 12. A gap tells you something changed. Find out what, and whether it lasts.
  4. Check it against other documents. Rent should tie to the rent roll, and collections to bank statements. Taxes should tie to tax bills.
  5. Rebuild it for your ownership. Ask what changes when you buy: taxes may be reassessed, insurance repriced, and management priced at market. Your Year 1 is not the seller's last year.

Where T12s mislead

  • Repairs moved below the line. Calling a repair a capital item raises NOI. Ask for the capital ledger.
  • A missing management fee. An owner who manages the property may show none, but you will likely pay one.
  • One-off income. A lease termination fee or insurance payout lifts income once. Take it out of your run rate.
  • Cash or accrual timing. A cash-basis statement shows bills when they are paid, so one month can hold a whole year's tax or insurance. Ask which basis it uses.
  • Concessions out of sight. Free rent can sit in a separate line, or inside rent. Compare collected rent with the rent roll.

T12, rent roll and pro forma

DocumentAnswersLooks
T12What did the property earn and spend?Back, 12 months
Rent rollWho pays what rent, today?A snapshot of today
Pro formaWhat could it earn and spend?Forward, on assumptions

To compare the T12 with the broker's numbers, use the offering memorandum checker.

Using AI to review a T12

An AI assistant can do the first pass, as long as it quotes the line and month for every finding, so you can check its work. Check your plan's data terms before you upload a deal document: see is AI safe for CRE deal documents? Here is a prompt to start with:

Review this T12 for a commercial real estate deal.
Check that the monthly columns add up to the stated totals.
List any expense line with an unusual month.
Name the line and month for each finding. If you cannot read a value, say so.

To go further, the Claude underwriting workflow covers the T12 with the OM and rent roll, and the CRE AI Institute's free lesson shows how the training works.

Frequently asked

What does T12 mean in real estate?
T12 stands for trailing 12 months. It is a property's operating statement for the most recent 12 months, usually shown month by month, with income, operating expenses and net operating income.
Where do I get a T12?
Usually from the seller or the broker, often in the deal's data room. It normally comes from the property's accounting system. Ask for the Excel version, because a PDF is harder to check and to use.
What is the difference between a T12 and a T3?
A T12 covers the last 12 months. A T3 covers the last 3, usually multiplied by 4 to annualize it. A T3 shows recent performance but can be distorted by seasonality and timing, so read the two together.
What is a good expense ratio?
It depends on the property type, age, market and who pays which costs, so this tool applies no benchmark. Compare it with similar local properties, and look at the lines behind it rather than the single number.
Does a T12 include capital expenditures or debt service?
NOI should not. Both are usually shown below the line, after NOI. Statements vary, so check that nothing was moved above or below the line in a way that changes NOI.
Is my T12 uploaded when I use this tool?
No. The analysis runs in your browser, and your numbers are not sent to Pacific Software Ventures or saved. This page has no sign-up. Its site analytics do not record what you type.

Pacific Software Ventures built this tool and guide, and sells AI consulting and training to commercial real estate firms. This is general education, not investment, legal or tax advice.

Next step

Doing this on every deal? Let AI do the first read.

Ten minutes. An honest read on where AI would save your team time, and which option fits, including when it is not us.