A trailing twelve month statement is the backbone of multifamily underwriting. It is the seller's account of what the property actually collected and spent, and most acquisition models begin by rebuilding it line by line. The difficulty is that a T12 can be internally consistent, professionally formatted, and still be misleading. Catching the problems early, before the proforma hardens and the investment committee memo is written, is far cheaper than discovering them during confirmatory diligence or after closing.
A T12 is a property's actual income and expenses for the last twelve months, shown month by month. It is the main record of how a property really performed. That monthly structure is the point. Annual totals answer what happened. The monthly columns answer when it happened, and the timing frequently reveals more than the total does.
Start With What the Statement Is Supposed to Prove
Before flagging anything, be clear about the two questions a T12 has to answer. First, does reported income match what the rent roll says was billed and collected? Second, do reported expenses reflect the cost of running the property at its current condition and occupancy, with nothing removed that a new owner would have to pay? A statement that fails either test is not necessarily fraudulent. It is simply unreliable as an underwriting input until someone explains the gap.
Red Flags in the Revenue Section
Revenue problems are usually more consequential than expense problems because they compound through every year of the hold. They are also easier to test, since the rent roll and the T12 describe the same apartments from two different directions.
The rent roll and the T12 refuse to reconcile
Compare billed rent on the rent roll to reported rental income on the statement, month by month, not annually. Annual figures can match while every individual month is off in opposite directions. Look for unit count differences, occupied units that appear as vacant in one document, or a rent roll dated weeks away from the statement period. Ask which source the property manager considers authoritative and why the two disagree.
A clean annual total hiding a jagged monthly pattern
Twelve months of near-identical revenue is unusual at a property with turnover, seasonal move-outs, or unit renovations. A line that barely moves may reflect a true-up, a reclass, or an allocation rather than cash collected in that month. Flat lines deserve a follow-up question about who produced the number and from what system. Volatile lines deserve a question about what caused each spike, particularly if the spike sits in a month with no corresponding leasing activity.
Other income doing too much work
Fees for parking, pets, utilities, late payments, and damages are legitimate. What matters is whether they are recurring, whether they are billed and collected, and whether a new owner can keep charging them under the existing leases. An income line that grows faster than the rent roll, or that appears only in the final months of the period, needs a lease-level explanation. So does any category with a name that only the seller's staff understands.
Concessions and vacancy loss placed where they flatter the property
Concessions reduce effective rent. Vacancy loss reduces gross potential rent. Both can be presented as a deduction from revenue, netted inside a rent line, or pushed below the net operating income line entirely. Where they sit changes the reported margin without changing the economics. Ask for the lease file supporting current concessions and confirm that the method used in the T12 matches the method used in the rent roll.
Red Flags in the Expense Section
Expense manipulation is quieter than revenue manipulation. It usually takes the form of costs that belong to the property being absorbed somewhere else, deferred, or relabeled as capital.
Lumpy repairs dressed as recurring maintenance
A large repair in a single month is not automatically a red flag. The red flag is a large repair that appears in a recurring line, or a recurring line that spikes and then returns to normal, suggesting the cost will come back. Request invoices for anything materially above the trailing average and confirm whether the work was completed or merely approved. Unfinished work is a liability that arrives with the keys.
Categories that move between periods
Watch for the same cost appearing under a different label in different months, or a category that empties out in the second half of the period. It can indicate a chart of accounts change, a reclass, or a deliberate effort to bury a cost. A stable property should have reasonably stable category behavior. When it does not, ask for the general ledger detail behind the account and the date of any mapping change.
Payroll and management fees that change shape
On-site payroll, regional supervision, and the management fee are often the first place a seller adjusts the story, because a new owner may staff or contract the property differently. Confirm who is actually on site, whether any staff are shared across properties, and whether the fee shown is the fee that will be charged after closing. Ask for the management agreement and note whether the statement reflects it.
Real estate taxes and insurance treated as placeholders
Taxes and insurance frequently appear at the prior year's assessed or billed amount while a reassessment or renewal is pending. That is a timing issue, not a scandal, but it means the trailing figure may not represent the next twelve months. Ask for the current assessment, the current policy premium, and any notice of change. Underwrite from the verified obligation, not from whatever landed in the statement.
Red Flags in the Structure of the File Itself
The presentation of a T12 carries information too. Sloppy structure usually means the underlying data is not controlled, and an uncontrolled statement cannot be relied on for anything precise.
Missing months, partial periods, and a mismatched window
Confirm that the statement covers exactly twelve consecutive months and that all twelve are present for every account. Partial first or last months, a period that ends before the rent roll date, or an account that appears only in later months will distort every ratio built on top of it. Ask the seller for a complete export rather than a summary tab.
Cash and accrual basis mixed inside one statement
Some lines may be recorded when paid, others when incurred, and the mixture is rarely labeled. This matters most around year-end, insurance, and taxes, where the gap between incurred and paid can be significant. Ask the property manager which basis each section uses and whether any adjusting entries were posted after the period closed.
Manual overrides and version confusion
A final tab named as a copy, hard-coded cells inside otherwise formula-driven columns, or a second file circulating with different totals all point to a statement that has been edited outside its source system. Request the native export from the property management system so the numbers can be traced back to transactions, then compare that export to the seller's summary.
Quick Reference: Red Flag to First Request
| Red flag | What it usually signals | First request |
|---|---|---|
| Rent roll and T12 do not reconcile | Timing gap, rent roll dating, or missing billed rent | Month-by-month rent roll comparison for the same period |
| Flat revenue line | Allocation, true-up, or reclass rather than cash | General ledger detail behind the account |
| One-time repair inside a recurring line | Deferred maintenance or a cost that will repeat | Invoice and completion status |
| Taxes or insurance at last year's figure | Pending reassessment or renewal | Current assessment and policy declarations |
| Missing or partial months | Incomplete export or a truncated reporting window | Native export covering twelve consecutive months |
How to Surface These Early
The practical answer is sequencing. Reconcile the rent roll before modeling anything, because every revenue assumption downstream inherits the result. Map the seller's chart of accounts to your own standard categories next, so that a reclass cannot quietly change a comparison. Only then compare the trailing period to prior periods and to the operating budget.
Most of these checks are mechanical rather than judgment calls, which makes them a poor use of senior analyst time when done by hand. Structured parsing of the statement and the rent roll, with consistent account mapping applied across every deal, surfaces mismatches in minutes instead of hours and gives the acquisitions team a defensible record of what was asked and what was answered. Coastwise Analytics was built for that workflow, turning property management system exports into standardized statements and performance memos that hold up in an investment committee setting.
No single flag should kill a deal on its own. The goal is a list of explained and unexplained items before the site visit, with the unexplained ones priced or negotiated rather than assumed away.
Frequently Asked Questions
What is the most common T12 red flag?
Rent roll and statement mismatches come up most often. The two documents are usually pulled on different dates or from different reports inside the same property management system, so billed rent and reported rental income diverge. Some divergence is timing. Persistent divergence in one direction is a question the seller needs to answer before underwriting continues.
Does a messy T12 mean the deal is bad?
Not necessarily. Many properties are managed by teams with limited reporting resources, and a disorganized statement often reflects that rather than intent. Treat sloppiness as a diligence cost, not a disqualifier. The real concern is whether the underlying records exist and whether the seller can produce them promptly when asked.
Should an acquisitions team trust the seller's T12 or rebuild it?
Rebuild the parts that drive value and trust the rest only after verification. Revenue, payroll, taxes, insurance, and repairs warrant a full rebuild from source documents. Smaller categories can be sampled. The standard is whether you can explain each material line to an investment committee without deferring to the seller's summary tab.
How much history should accompany a T12 review?
A single trailing twelve month period shows performance but not direction. Request the preceding periods and the current year operating budget so that a one-time event can be separated from a trend. Consecutive periods also expose mapping changes and reclasses that are invisible inside one statement, and they make it easier to test the seller's forward assumptions.
