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.
How each line was sorted
Change any line that is wrong. The results update straight away.
| Line | Total | Treated 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 income | Gross potential rent, less vacancy, concessions and bad debt, plus other income |
|---|---|
| NOI | Effective gross income, less operating expenses |
| Expense ratio | Operating expenses divided by effective gross income |
| T3 annualized | The last 3 months, times 4 |
| T1 annualized | The last month, times 12 |
| Cap rate | NOI divided by purchase price |
How to analyze a T12, in order
- Check that it adds up. Monthly columns should tie to the totals, and the stated NOI should equal income less expenses.
- 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.
- Compare the last 3 months with the 12. A gap tells you something changed. Find out what, and whether it lasts.
- Check it against other documents. Rent should tie to the rent roll, and collections to bank statements. Taxes should tie to tax bills.
- 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
| Document | Answers | Looks |
|---|---|---|
| T12 | What did the property earn and spend? | Back, 12 months |
| Rent roll | Who pays what rent, today? | A snapshot of today |
| Pro forma | What 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.
Keep reading
Offering memorandum checker
Compare what an OM states with what the T12 shows.
Rent roll analyzer
Occupancy, loss to lease and rollover, to compare with the T12.
All CRE calculators
Cap rate, NOI, DSCR, debt yield and more, free and private.
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.