How to prepare a T12 (trailing 12 month statement) for a rental property
A T12 is a month-by-month income and expense report for the last twelve full months, ending with net operating income (NOI). To prepare one, take each month's profit and loss from your books, keep the same line items in every column, move loan principal, depreciation and improvements out of operating expenses, and total the twelve months. Lenders and buyers use it to see what the property really earns.
What a T12 is, and who asks for it
T12 stands for trailing twelve months. It is a table with one column for each of the last twelve months, one row for each kind of income and expense, and a total column on the right. The point is to show the property's real, recent performance instead of a single year-end number that hides seasonal swings, a vacant spell or a one-time repair.
Two people ask for it most often. A lender or a buyer asks for it when you refinance or sell, usually together with the rent roll. And you should ask for it yourself when you buy: a seller's T12 is the first check on whether the numbers in the listing are real. A T12 is not a tax form. It uses the same books as your tax return, but it is arranged for someone judging the property, not for the IRS.
The layout that lenders and buyers expect
Keep it plain. The rows run from income at the top to NOI at the bottom, and every month uses exactly the same rows.
| Section | Rows | Notes |
|---|---|---|
| Income | Gross potential rent, vacancy and concessions, bad debt, other income (laundry, parking, fees) | Show scheduled rent first, then what you lost, so the gap is visible |
| Effective gross income | Total of the income rows | This is the money that actually came in or was earned |
| Operating expenses | Taxes, insurance, utilities, repairs and maintenance, payroll or contract labor, management fee, administrative, marketing | Use the same categories every month |
| Net operating income | Effective gross income minus operating expenses | Before loan payments, depreciation and capital work |
| Below the line | Loan interest and principal, capital improvements, reserve deposits | Show them separately, never inside operating expenses |
If you have used the Schedule E expense lines as your accounts, as described in Schedule E expense categories for rental property, most rows already exist. The exceptions are depreciation and mortgage interest, which are real on your return but sit below the line in a T12. For the definition of NOI and what to leave out of it, see how to calculate NOI.
Five steps to prepare it
- Pick the twelve months. Use the last twelve full calendar months that are closed. If it is mid-November, the T12 runs November of last year through October of this year, and October must already be reconciled to the bank.
- Close each month first. Every bank line should be categorized and the bank balance should agree with the books. A T12 built from unreconciled months copies the errors. The steps are in the month-end close checklist.
- Pull one profit and loss report with months as columns. Most accounting tools can show a profit and loss by month. If you keep a spreadsheet, add a pivot table or a SUMIFS by account and month.
- Move non-operating items below the line. Take out principal, depreciation, capital improvements and owner contributions or distributions. Interest is a financing cost, so it goes below NOI too.
- Check the total against the bank. Total the twelve months of deposits on the T12 and compare them with the twelve months of deposits on the statements. A gap means a mis-categorized deposit, such as a security deposit counted as rent.
A worked example
Example a made-up 10 unit building with scheduled rent of $1,200 per unit per month. Gross potential rent is 10 x $1,200 x 12 = $144,000. Vacancy and concessions were $7,200, bad debt was $1,800 and other income (laundry and pet fees) was $4,100. Effective gross income is $144,000 - $7,200 - $1,800 + $4,100 = $139,100.
Example the same building's operating expenses were property taxes $14,000, insurance $6,500, utilities $9,800, repairs and maintenance $11,200, management fee $8,346 (6% of $139,100), administrative $2,400 and marketing $1,300, for $53,546. NOI is $139,100 - $53,546 = $85,554. The loan interest ($31,000), principal ($9,000) and a $12,000 roof replacement all sit below the line, so none of them lowers NOI.
Read the example the way a lender would. Expenses are 38.5% of effective gross income ($53,546 divided by $139,100). A lender who sees a ratio far outside what is normal for similar buildings will ask why, so be ready to explain unusual rows before they ask.
Mistakes that make a T12 unreliable
- Mixing cash and accrual. Rent paid in advance for next month is not this month's income under accrual. Pick one method for all twelve months. The IRS describes the two methods in Publication 538; see also cash vs accrual for rental property.
- Counting security deposits as income. Deposits you may have to return are a liability, as explained in security deposit accounting.
- Leaving out owner-paid costs. If you do the repairs yourself or manage the building yourself, a buyer will add a management fee and labor to your expenses. Many owners show a market fee on a separate pro forma line and keep the actual T12 untouched.
- Changing categories partway through. If January calls it repairs and July calls it maintenance, a reader cannot compare months.
- Burying one-time items. A one-off $12,000 roof belongs below the line as a capital item. A burst pipe that was repaired belongs in repairs; footnote it so the reader knows it will not recur.
How DoorKeeping handles it
In DoorKeeping, each property's LLC keeps its own books with bank feeds, and month-end close ties every month to the bank before you rely on it. You can ask your AI app for a property's profit and loss by month or its net operating income, then hand your lender or buyer the monthly figures. Anything that moves money or takes a legal step waits for your one-tap approval, and the numbers support your lender's or tax preparer's work; they do not replace it.
Sources
- IRS, Publication 538, Accounting Periods and Methods, read Oct 30, 2026
- IRS, Publication 527, Residential Rental Property (income and expenses), read Oct 30, 2026
Questions
- What does T12 stand for?
- Trailing twelve months: a month-by-month income and expense statement for the most recent twelve full months, ending in net operating income.
- Should a T12 include the mortgage payment?
- No. Loan principal and interest are financing costs and sit below net operating income. Include them only in a separate cash flow section after NOI.
- Is a T12 the same as a profit and loss statement?
- It is a profit and loss laid out by month for twelve months, with non-operating items such as depreciation, principal and capital improvements moved below the line.