Key Takeaways
- The rent roll audit traces rent amounts from the rent roll to leases, bank deposits, and estoppel certificates.
- Compare the T-12 to tax returns—discrepancies greater than 5% indicate potential manipulation.
- Abstract every lease to identify hidden restrictions, unfavorable terms, and concentrated expiration risk.
- Visit the property unannounced to verify physical occupancy matches the reported rent roll.
Financial due diligence verifies every number in your underwriting by tracing seller-reported figures back to source documents. This lesson provides the systematic workflow for auditing rent rolls, verifying operating statements, abstracting leases, and uncovering hidden financial liabilities.
The Rent Roll Audit Process
The rent roll audit is a line-by-line verification of every tenant, unit, rent amount, and lease date. Step 1: Compare the rent roll to individual leases—does every unit on the rent roll have a corresponding signed lease? Do the rent amounts match? Step 2: Compare the rent roll to bank deposit records—does the total monthly rent collected match the T-12 revenue figure? Look for discrepancies that may indicate concessions, non-payment, or cash tenants not properly recorded. Step 3: Send estoppel certificates to all tenants and compare responses to the rent roll. Discrepancies between estoppels and the rent roll reveal side agreements, verbal rent reductions, or other arrangements not captured in formal documents. Step 4: Verify occupancy by visiting the property unannounced—are the units listed as occupied actually occupied?
T-12 Operating Statement Verification
The trailing-12-month operating statement is the primary financial document, but it is only as reliable as its source data. Verification steps: compare T-12 totals to the property's tax return (Form 1065 or Schedule E)—significant discrepancies indicate manipulation. Compare individual expense categories to supporting invoices: request copies of insurance declarations (verify premium matches T-12), property tax bills (verify tax amount matches T-12), and utility bills (verify total matches T-12). Look for expenses that should be present but are missing (management fees, legal costs, turnover expenses). Look for non-recurring items that inflate or deflate the T-12: a one-time insurance settlement, a major repair that should be capitalized, or an unusually low month that suppresses the annual total.
Lease Abstract and Tenant Analysis
Every lease should be abstracted into a summary format capturing: tenant name, unit number, lease start and end dates, monthly rent, security deposit amount, any rent escalation provisions, renewal options, landlord obligations (maintenance, utilities), tenant improvement allowances, and termination provisions. For commercial tenants, also capture: permitted use, exclusivity provisions, co-tenancy clauses, and personal guarantees. Analyze the lease expiration schedule—if 50%+ of leases expire within 6 months of closing, you face massive renewal/turnover risk. Identify any lease provisions that restrict your ability to operate: restrictions on rent increases, required landlord consent for building changes, or tenant options to terminate early.
Case Study: Financial DD Discovery on a 16-Unit Building
During financial DD on a 16-unit building, you discover discrepancies between the seller's representations and the source documents.
- 1Rent roll shows 15 of 16 units occupied at average rent $1,050/month = $189,000 GPR. But estoppel certificates reveal 2 tenants are paying $950, not $1,050 as listed—a $2,400/year revenue overstatement.
- 2T-12 shows $168,000 gross revenue. Tax return (Schedule E) shows $159,000. The $9,000 discrepancy traces to 3 months where the T-12 shows full rent for a unit that was actually vacant.
- 3Lease review reveals one tenant has a 5-year lease at $900/month with no escalation clause and 3.5 years remaining—well below market ($1,050) with no path to increase.
- 4Insurance: T-12 shows $6,200 but the actual current policy premium is $8,400—seller showed the old policy rate.
- 5No management fee is shown (self-managed), but the property is 45 minutes from the seller's home, suggesting actual self-management effort is significant.
- 6Corrected revenue: $156,000 (vs. $168,000 reported). Corrected expenses with imputed management and correct insurance: $82,500. Corrected NOI: $73,500 vs. seller's claimed $99,000—a 26% overstatement.
Financial DD revealed that the seller's NOI was overstated by 26%. At the agreed-upon cap rate, this translates to approximately $365,000 in overvaluation. You request a price reduction of $350,000 supported by detailed documentation. The seller agrees to $275,000 reduction, bringing the deal back to acceptable returns.
Key Takeaways
- ✓The rent roll audit traces rent amounts from the rent roll to leases, bank deposits, and estoppel certificates.
- ✓Compare the T-12 to tax returns—discrepancies greater than 5% indicate potential manipulation.
- ✓Abstract every lease to identify hidden restrictions, unfavorable terms, and concentrated expiration risk.
- ✓Visit the property unannounced to verify physical occupancy matches the reported rent roll.
Sources
Common Mistakes to Avoid
Accepting the seller's T-12 without reconciling against bank statements and tax returns
Consequence: Fabricated or inflated income figures go undetected, leading to overpaying for the property
Correction: Reconcile the T-12 line by line against bank deposits, cancelled checks, and tax return Schedule E to verify actual income and expenses
Not requesting tenant estoppel certificates to verify lease terms
Consequence: Relying solely on the rent roll may miss side agreements, concessions, or lease modifications
Correction: Request tenant estoppels from all tenants to independently verify rent amounts, lease terms, deposits, and any verbal agreements
Test Your Knowledge
1.What is the most effective technique for verifying actual rental income?
2.What should you look for when reviewing lease abstracts during financial DD?
3.What is a common financial DD discovery that changes the deal economics?