Why does the chart of accounts matter more than the extraction?

Because extraction only has to happen once and coding has to be consistent forever. Two statements coded differently are not comparable, which quietly breaks every portfolio view built on top of them — and neither statement looks wrong on its own.

What happens when the coded total does not tie to the statement's NOI?

It is surfaced rather than absorbed. A spread that does not reconcile to its source is not yet evidence, and the gap is usually informative: a missed line, a reclassification, or a statement that parenthesises its expenses and its expense total.

Can it handle statements that present expenses as negatives?

Yes, and it has to. One P&L prints an operating expense as 12,000 and the next prints the same cost as (12,000). Polarity is resolved per line from its own history rather than by taking an absolute value, which would destroy any genuine credit.

How to Automate CRE Financial Statement Spreading

Workflow Guide

Last updated 2026-03-122 min readWorkflow Guides

The Problem

Financial spreading — converting raw property financials into standardized analytical formats — is a manual bottleneck in CRE underwriting. Every property uses different chart of accounts, formatting, and reporting conventions. Manually re-keying and classifying 100+ GL line items for each property is slow and introduces classification errors that affect NOI calculations.

Step-by-Step Automation Workflow

Upload statements, T-12s, GL exports and rent rolls

Upload operating statements, T12s, GL exports, and rent rolls in any format (PDF, Excel, CSV).

Code every line to a standard chart of accounts

Every revenue and expense line item is classified to a standardised chart of accounts, so statements from different owners become comparable.

Reconcile rent roll revenue to statement collections

Reconcile rent roll revenue against operating statement collections.

Normalise for the property type

Apply property-type-specific normalization (e.g., NNN expense treatment, management fee normalization).

Produce the T-12 with per-SF and variance analysis

Generate standardized output: T12 with per-SF metrics, year-over-year variance analysis, and trend identification.

Export to the underwriting model

Export to underwriting model templates (Excel, Argus-compatible).

Time Saved

Statements are read and coded to underwriting heads rather than re-keyed

Cost Impact

Improved classification accuracy reduces NOI modeling errors, which at scale can represent millions of dollars in valuation precision

Frequently Asked Questions

Automate This Workflow

See this workflow in action with your documents

Crevanta provides the extraction and structuring foundation that makes CRE workflow automation possible.