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
| Line in the file | What to enter |
|---|---|
| Gross potential rent | Each month's rent for every unit, rented or not. |
| Vacancy and credit loss | Rent you did not collect, as a negative number. |
| Concessions | Rent discounts you gave tenants, as a negative number. |
| Other income: laundry | Laundry income. |
| Other income: parking | Parking income. |
| Other income: fees (late, pet, application) | Fee income. |
| Effective gross income | Formula. 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:
| Line | 12-month total | Per 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 ratio | 53.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
| Line item | Sep 2025 | Oct 2025 | Nov 2025 | Dec 2025 | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026 | Jun 2026 | Jul 2026 | Aug 2026 | 12-month total | Per 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
- Rent roll: unit-by-unit rents for the same property.
- Commercial loan sizing calculator: size a loan on NOI by LTV, DSCR, and debt yield.
- NOI and cap rate calculator: a quick NOI estimate before you have 12 months of books.
- All templates
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.
