Apply now on NEXA Mortgage's site, opens in a new tab

T-12 operating statement template

A T-12, or trailing twelve-month operating statement, shows a property's last 12 months of income and expenses, one column per month, ending in net operating income (NOI). Download our free Excel template, type in your actual figures, and it does the totals.

Free, no sign-up. One Excel sheet. File dated September 28, 2026.

When lenders ask for one

  • Commercial loans. For five-plus unit multifamily, mixed use, and other income-producing property, the first item on the commercial list in our investor loan document checklist is a trailing 12-month operating statement showing income and expenses.
  • Why NOI matters. Commercial loans are sized on the property's NOI, DSCR, and debt yield, and the loan has to pass all three tests, so the one that binds sets the amount. The T-12 is where that NOI comes from. Try the math in our commercial loan sizing calculator.

What is in the file

The file has one sheet, named T-12. At the head you enter the property name, address, the first month of the 12, the number of units, and the basis of your figures. The file writes the period covered for you, for example "Sep 2025 to Aug 2026".

Below that, each line item has 12 month columns, a 12-month total, and a per-unit figure. Month headings come from the first month you enter. Shaded cells are for your entries. The line items and month headings stay in view as you scroll.

Income lines

Income lines
Line in the fileWhat to enter
Gross potential rentEach month's rent for every unit, rented or not.
Vacancy and credit lossRent you did not collect, as a negative number.
ConcessionsRent discounts you gave tenants, as a negative number.
Other income: laundryLaundry income.
Other income: parkingParking income.
Other income: fees (late, pet, application)Fee income.
Effective gross incomeFormula. The sum of the lines above.

Operating expense lines

The file lists 16 expense lines, then a total:

  • Property taxes
  • Insurance
  • Utilities: water and sewer
  • Utilities: electric
  • Utilities: gas
  • Utilities: trash
  • Repairs and maintenance
  • Turnover
  • Landscaping
  • Pest control
  • Management fee
  • Payroll
  • Admin and legal
  • Marketing
  • Reserves for replacement
  • Other operating expenses
  • Total operating expenses (formula)

The bottom lines

  • Net operating income (NOI): effective gross income minus total operating expenses, for each month and for the year.
  • Expense ratio (operating expenses / EGI): total operating expenses divided by effective gross income.
  • Per unit (annual): each line's 12-month total divided by the number of units.

How the file defines its terms

The file's notes spell out the definitions it uses:

  • Effective gross income is gross potential rent, less vacancy, credit loss, and concessions, plus other income.
  • NOI is effective gross income less operating expenses.
  • Debt service, depreciation, and capital improvements are not operating expenses, and they stay off this statement.

What the example shows

The file opens with Example Apartments, a made-up 12-unit building in Tampa, from September 2025 through August 2026, on a cash basis from the owner's books. Over the 12 months:

What the example shows
Line12-month totalPer unit (annual)
Gross potential rent$233,400$19,450
Vacancy and credit loss-$13,150-$1,096
Concessions-$1,500-$125
Other income (laundry, parking, fees)$8,085$674
Effective gross income$226,835$18,903
Total operating expenses$121,587$10,132
Net operating income (NOI)$105,248$8,771
Expense ratio53.6%

The month-by-month view shows things a yearly total hides. In the example, NOI drops below $7,300 only in the four months with turnover costs. These are made-up figures, not a real property.

Mistakes the file's notes help you avoid

  • Entering vacancy and concessions as positive numbers. The instructions say to enter them as negatives, so effective gross income adds up.
  • Putting the mortgage payment in expenses. Debt service stays off this statement. So do depreciation and capital improvements.
  • Typing a budget instead of your books. The instructions ask for each month's actual income and expenses from your books.
  • Skipping the first month and the unit count. The month headings and the per-unit column depend on them.

How the T-12 and the rent roll fit together

A T-12 is the history: twelve months of income and expenses. A rent roll is a snapshot of who pays what today. Our two templates use the same example building, and this file's gross potential rent in its last six months, $19,550 a month, equals the rent roll's total market rent.

Preview: the layout of the file

Layout of the file, with the example figures
Line itemSep 2025Oct 2025Nov 2025Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026May 2026Jun 2026Jul 2026Aug 202612-month totalPer unit (annual)
Gross potential rent$19,350$19,350$19,350$19,350$19,350$19,350$19,550$19,550$19,550$19,550$19,550$19,550$233,400$19,450
Effective gross income$18,360$18,625$19,700$18,250$18,150$19,620$19,335$18,115$19,765$19,660$18,990$18,265$226,835$18,903
Total operating expenses$9,164$11,680$9,326$9,355$10,857$10,065$9,152$11,959$9,791$9,363$9,619$11,256$121,587$10,132
Net operating income (NOI)$9,196$6,945$10,374$8,895$7,293$9,555$10,183$6,156$9,974$10,297$9,371$7,009$105,248$8,771

Scroll the table sideways to see every column.

Example figures from the file. Replace them with your own.

Sending it

The file's last line asks you to send the completed file to info@aluracapital.com with your loan request. Please do not paste it into the scenario form on our homepage. That form is for a short description of the deal.

Ready to talk about the loan?

Run your scenario by us. A licensed loan officer calls you back the same business day.

The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.

Related templates and tools

Frequently asked questions

What is a T-12?

A T-12 is a trailing twelve-month operating statement: the last 12 months of a property's income and expenses, month by month, with a 12-month total and net operating income. Lenders commonly ask for one on commercial loans. Our free Excel template lays out the lines and does the math for you.

What belongs in effective gross income?

Effective gross income is gross potential rent, less vacancy, credit loss, and concessions, plus other income. The file's other income lines are laundry, parking, and fees such as late, pet, and application fees. Enter vacancy and concessions as negative numbers so the sum works the way the file expects.

Should debt service go on a T-12?

No. The file's notes say debt service, depreciation, and capital improvements are not operating expenses and stay off this statement. NOI is figured before any loan payment. The loan payment is tested against NOI separately, which is what the DSCR test in our commercial loan sizing calculator does.

Should my T-12 be cash basis or accrual?

The file has a Basis of figures line so you can say which one your books use. Its example reads "Cash basis, from the owner's books." The instructions ask for each month's actual income and expenses from your books, so state the basis those books follow.

What does the per-unit column show?

Per unit is each line's 12-month total divided by the number of units you enter at the head of the sheet. Set the unit count before you read it. In the example, a 12-unit building with $105,248 of NOI shows about $8,771 of NOI per unit for the year.