Built for
For acquisition teams comparing broker packages, property-manager exports, and owner statements that use different account names, layouts, period conventions, and levels of detail.
AI T-12 analyzer
Read a trailing 12-month operating statement without rebuilding it by hand
Rook converts a property operating statement into reviewable historical inputs while preserving the period, sign, units, and source behind each material number.
The outcome
Build a defensible historical operating picture, identify what needs recasting, and start the underwriting model from sourced data rather than manual transcription.
How it works
From source package to reviewable work
- 01
Read the statement and its period
Rook identifies the reporting window, account structure, totals, and supporting monthly detail available in the source file.
- 02
Normalize the operating categories
Income and expense lines are mapped to the categories expected by the firm's model without erasing the seller's original labels.
- 03
Flag accounting questions
Unclear signs, partial periods, totals that do not reconcile, unusual accounts, and potential non-recurring items are surfaced for analyst treatment.
- 04
Populate historical model inputs
Reviewed values are carried into the existing underwriting workbook with their source context, ready for the firm's forward assumptions and adjustments.
What the team gets
Fast enough to use. Clear enough to review.
Period-aware extraction
Keep monthly, year-to-date, and trailing-period values from being treated as interchangeable observations.
Income and expense normalization
Translate varied chart-of-accounts labels into the categories used by the acquisitions team while retaining original descriptions.
Reconciliation checks
Surface missing months, mismatched subtotals, inconsistent signs, and other issues that can distort a quick NOI calculation.
Historical versus underwritten clarity
Separate what the property reported from the adjustments and forward assumptions the investment case applies afterward.
Why the details matter
Keep the historical base separate from the investment case
A T-12 is often treated as a simple list of revenue and expenses, but its meaning depends on the exact months included, the operator's accounting categories, and whether the statement is cash- or accrual-oriented. Those details matter before any normalization begins.
Rook preserves the supplied values and their reporting context, then maps them into the firm's categories. That gives analysts a clear base from which to evaluate payroll, repairs, utilities, taxes, insurance, concessions, bad debt, and other potential adjustments.
Seller-reported performance and the buyer's pro forma remain distinct. Reviewers can see which number came from the statement, which change was proposed, and where judgment entered the model.
Frequently asked questions
Questions acquisition teams ask
What is a T-12 in commercial real estate?
A T-12 is a trailing 12-month property operating statement. It typically shows revenue and expenses for the most recent twelve months and is used as a historical starting point for underwriting.
What should a T-12 analyzer check?
It should confirm the reporting period, preserve source line items, map income and expenses consistently, check totals and signs, and surface missing or unusual records before calculating a historical operating picture.
Can Rook map a T-12 into our own Excel model?
Yes. Rook is designed to map historical operating values into the relevant locations in a firm's existing workbook while keeping the source evidence and proposed assumptions distinguishable.
Does Rook decide which expenses to remove from the T-12?
Rook can identify and explain potential classification or normalization questions, but acquisition teams should review recasting decisions against diligence, firm policy, and current market evidence.
Keep exploring
Related acquisition workflows
Rent roll analyzer
Connect reported operations to the current unit and lease schedule.
Learn more →Multifamily underwriting software
Carry the historical base into the complete acquisition model.
Learn more →Investment committee memo generator
Explain historical performance and key adjustments for review.
Learn more →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.