T12 Reconciliation
Compare scheduled rent from your rent roll against actual collections in your T12 operating statement. Identify delinquencies, concessions, and collection issues before they become problems.
What is Reconciliation?
Reconciliation compares what tenants should pay (rent roll) against what was actually collected (T12).
Rent Roll
Shows scheduled rent—what tenants are contractually obligated to pay.
$200,000/year scheduled
T12 Statement
Shows actual collections—what was actually deposited over 12 months.
$185,000/year collected
Variance
The difference reveals delinquencies, concessions, or accounting issues.
$15,000 gap to investigate
Sample Variance Report
CleanRoll.ai generates a clear variance report highlighting any discrepancies.
| Category | Scheduled | Actual | Variance | % |
|---|---|---|---|---|
| Base Rent | $180,000 | $171,000 | -$9,000 | -5.0% |
| CAM Reimbursement | $24,000 | $23,500 | -$500 | -2.1% |
| Late Fees | $0 | $2,400 | +$2,400 | N/A |
| Total Income | $204,000 | $196,900 | -$7,100 | -3.5% |
Why Reconcile?
Catch Delinquencies
Identify tenants who aren't paying in full. The variance between scheduled and actual rent reveals collection issues.
Verify Concessions
Confirm that rent concessions are properly accounted for and match what was disclosed.
Spot Reporting Errors
Find discrepancies between property manager reports and bank statements before closing.
True NOI Calculation
Calculate Net Operating Income based on actual collections, not just scheduled rent.
Standard Categories
Our AI categorizes income and expenses into industry-standard categories for consistent analysis.
Income Categories (18)
Expense Categories (27)
Ready to Reconcile Your Documents?
Upload your rent roll and T12 to find collection issues in seconds. 3 free documents, no credit card required.