extract_operating_statement
Extract structured, verified data from a commercial real estate T12 / operating statement (trailing-twelve-month income and expense report; PDF, Excel .xlsx, or CSV; native or scanned). Returns property info, reporting months, and categorized line items (income, expenses, subtotals) with monthly values and totals, plus a deterministic verification report that reconciles row totals against monthly values and Effective Gross Income, Total Operating Expenses, and Net Operating Income against the underlying rows. Every field carries a status and confidence; uncertain fields are flagged, never silently guessed. Anonymous use is limited to 3 documents/day; pass an API key from rentrollapi.com via the X-Api-Key header for more.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fileName | Yes | Original file name including extension, e.g. 't12.pdf' — the extension guides format detection. | |
| documentBase64 | Yes | The operating statement document encoded as base64 (PDF, XLSX, or CSV bytes). Max 25 MB decoded. |