Built for
For multifamily acquisition teams receiving inconsistent property-manager exports, broker spreadsheets, PDFs, and operating statements that must be cleaned before analysis begins.
Rent roll and T12 extraction
Extract the rent roll and T12 together—then reconcile the story they tell
A rent roll shows the current lease schedule. A T12 shows recorded operations over time. Rook extracts both and preserves the differences an acquisition team needs to investigate.
The outcome
Produce a structured unit schedule and historical operating base, reconcile where the documents overlap, and map the reviewed result into the firm’s underwriting model.
How it works
From source package to reviewable work
- 01
Read both source files
Capture unit, lease, rent, status, income, expense, period, and account information without flattening the original structure.
- 02
Normalize without erasing
Create consistent fields and categories while retaining the source labels, rows, months, and reporting context.
- 03
Reconcile the overlap
Compare scheduled rent with reported revenue and explain differences through vacancy, concessions, bad debt, timing, and ancillary income.
- 04
Send reviewed values downstream
Map approved historical facts into the Excel model and keep unresolved items visible for diligence.
What the team gets
Fast enough to use. Clear enough to review.
Unit-level rent roll extraction
Structure unit type, square footage, status, lease dates, contract rent, market rent, and recurring charges.
Period-aware T12 extraction
Preserve monthly and trailing totals, account labels, signs, subtotals, and the reporting window.
Cross-document reconciliation
Show why point-in-time scheduled rent and period collections do not match instead of treating the mismatch as an error to hide.
Model-ready mapping
Translate the reviewed facts into the workbook’s unit-mix, revenue, expense, and historical input locations.
Why the details matter
The value is in the reconciliation, not just the extraction
Extracting two tables is useful, but underwriting begins when the tables are interpreted together. The rent roll is a point-in-time schedule; the T12 is a period record. Vacancy, concessions, delinquency, move-ins, and timing create legitimate differences.
Rook keeps both source surfaces available and creates a consistent layer for analysis. That lets reviewers trace an aggregate to the underlying units or accounts and determine whether a gap is expected, incomplete, or material.
The resulting historical base is easier to defend because the underwritten changes sit on top of preserved evidence rather than on a manually retyped spreadsheet with no audit trail.
Frequently asked questions
Questions acquisition teams ask
Why extract the rent roll and T12 together?
The rent roll describes current unit and lease conditions, while the T12 describes recorded operations over a trailing period. Reviewing both together makes occupancy, concessions, collections, and revenue differences easier to explain.
Can Rook process Excel and PDF files?
Rook is designed for the common spreadsheets, PDFs, and operating exports included in multifamily deal packages. Exact handling depends on the file structure and readability.
Does extraction automatically create the pro forma?
Extraction creates a historical and current operating base. A pro forma still requires explicit forward assumptions, timing, financing, capital plans, and scenario judgment.
Can the extracted data populate our model?
Yes. Reviewed values can be mapped into the relevant locations in the firm’s existing Excel underwriting model while source context remains available for review.
Keep exploring
Related acquisition workflows
Bring a deal and the model you use today.
See how Rook handles the source package, the unresolved questions, and the workbook your team already reviews.