What is a T12 in Real Estate?
A T12 (Trailing Twelve Months) is a financial statement showing a property's actual income and expenses over the most recent 12-month period, used by investors, lenders, and brokers to evaluate historical performance of a property.
When a commercial property changes hands, everyone involved wants to know the same thing: what is the story here? The T12 tells it. Twelve months of actual income, actual expenses, and actual NOI. No projections, no assumptions. Just what the property did. It is the starting point for nearly every underwriting conversation in commercial real estate.
T12 vs Pro Forma
Every deal comes with two versions of the financials. The T12 is what happened. The pro forma is what is projected to happen next.
The T12 looks backward. It shows the rent that was actually collected, the expenses that were actually paid, and the NOI that was actually produced. The pro forma looks forward. It projects what the property could earn under a new owner's business plan, higher rents, lower vacancy, reduced expenses.
Both matter. But they serve different purposes. The T12 grounds you in reality. The pro forma tells you where the opportunity is. Experienced investors read both together, and they always start with the T12.
What a T12 Includes
A T12 is broken into two sections: income and expenses. Each line item is shown month by month, with an annual total on the right.
The income section starts with gross potential rent, the maximum the property could collect if every unit or space were occupied and paying on time. From there you subtract vacancy, concessions, and bad debt to arrive at effective gross income. Other income sources like parking, laundry, or utility reimbursements are added in as well.
The expense section covers everything it costs to operate the property. Property taxes, insurance, utilities, repairs and maintenance, property management fees, payroll, and any other recurring operating costs. These are real numbers, not estimates.
NOI sits at the bottom. It is simply effective gross income minus total operating expenses. That single number is what lenders underwrite to, what buyers use to calculate cap rate, and what tells you whether a property is actually performing.
One important note: debt service and capital expenditures are typically shown below NOI, not included in it. NOI is a pre-debt, pre-capex number by convention.
A full T12 covers 12 months, but you will not always get a complete picture. Sometimes a seller provides a T6 or T3, especially on a newer acquisition or a property with limited operating history. When that happens, analysts will often annualize the available months to estimate a full year NOI. A T6 NOI divided by 6 and multiplied by 12 gives you an annualized figure. It is a reasonable estimate, but the fewer months you have, the less reliable the annualization becomes. Always note how many months of actual data you are working with.
What a T12 Looks Like
A T12 is typically a spreadsheet with line items running down the left side and months running across the top. Each cell contains the actual dollar amount for that line item in that month. The far right column shows the 12-month total.
In a perfect world every T12 you receive would be clean, consistent, and easy to read. In practice that is rarely the case. T12s come from property management software, from accountants, from sellers who built their own spreadsheet years ago. Every one looks different. Line items have different names. Subtotals are mixed in with actual line items. Some months are missing. Formatting is inconsistent.
This is the messy T12 problem. Before you can use a T12 for underwriting you often have to clean it up first. Standardize the line items, remove the subtotals, verify the math. That process takes time and introduces room for error if you are doing it manually.
Is a T12 the Same as a P&L or Income Statement?
Essentially, yes. A T12 is a profit and loss statement, or income statement, for a property covering the most recent 12 months. The terminology is different but the structure is the same: income at the top, expenses below, net income at the bottom.
The reason real estate uses T12 instead of P&L or income statement comes down to context. A P&L can cover any time period. A T12 is specifically the trailing twelve months, which is the standard window lenders and buyers use when underwriting a deal. It tells you what the property did over the most recent complete year, which is more relevant than a calendar year that may be months out of date.
So if someone hands you a T12 and you are used to reading P&Ls or income statements, you already know how to read it.
What is the Difference Between a T12 and a Rent Roll?
They are two different documents that together tell the full story of a property.
The T12 is historical. It shows what the property earned and spent over the past 12 months. The rent roll is a snapshot of right now. It shows every tenant, their unit or space, their lease terms, and their scheduled rent as of today.
The T12 tells you what happened. The rent roll tells you what is in place going forward.
When underwriting a deal you need both. The T12 shows you the track record. The rent roll shows you the current tenant base and whether the income on the T12 is likely to continue. If the T12 shows strong NOI but the rent roll shows several leases expiring in the next 90 days, that is a risk the T12 alone would not reveal.
How the T12 is Used in Practice
The T12 shows up at every stage of a commercial real estate transaction.
When a buyer is evaluating a property, the T12 is one of the first documents requested from the seller or broker. It is used to calculate NOI, which drives the cap rate and ultimately the offer price. A property generating $500,000 in NOI at a 6% cap rate is worth roughly $8.3 million. Change the NOI and the value changes with it.
When a lender is underwriting a loan, the T12 is the primary document used to calculate DSCR. Lenders want to see that the property's actual income can support the proposed debt payments with a required cushion. They are not underwriting to what the property might earn. They are underwriting to what it actually earned.
When an owner is managing a property, the T12 is a performance audit. Comparing month over month and year over year reveals expense spikes, revenue trends, and operational inefficiencies that might otherwise go unnoticed.
In every case the T12 is the document everyone trusts most because it reflects reality, not a projection.
The Messy T12 Problem
Here is the reality. Every T12 you receive looks different.
One broker sends a PDF export from AppFolio with 47 line items. Another sends a homemade Excel file with merged cells and subtotals mixed into the data. A seller sends a Word document. None of them use the same line item names, the same formatting, or the same level of detail.
Before you can use a T12 for underwriting you have to clean it up. That means standardizing the line items into a consistent chart of accounts, removing subtotal rows that would cause double counting, and verifying that the monthly figures actually add up to the annual totals shown.
If you are doing this manually on every deal it takes time and introduces room for error. The goal is to get every T12 you receive into the same clean format so you can compare properties side by side and plug the numbers directly into your underwriting model.
That is exactly what the T12 Template is built to do. Paste in any T12 you receive, tag each line item to a standardized category, and the template produces a clean condensed output in a consistent format every time.
Get the T12 Template
Every T12 you receive will look different. This template standardizes any T12 into a clean, consistent format ready for underwriting. Paste in your raw data, tag each line item, and get a clean output in minutes.
Download the free Excel template and see how it works.