Convert Operating Statement PDF to Excel and CSV

Upload the operating statement PDF to the converter at the top of this page, let it read each line item, and download the result as an Excel file. It takes seconds and needs no software. Every income and expense line lands in its own row with the monthly columns beside it, so you can total the year and calculate net operating income right away.

A T12, short for trailing twelve months, is an operating statement showing a property's actual income and expenses over the past twelve months. It lists gross rental income, other income, vacancy loss, and every operating expense month by month, ending in net operating income. Lenders and buyers rely on the T12 to judge real performance instead of projections.

Drop the T12 PDF into the converter above and download an XLSX. The engine keeps each line item on its own row and preserves the twelve monthly columns plus the annual total, so the grid stays intact. Once it is in Excel, the monthly figures sum correctly and you can rebuild the income and expense rollups yourself.

A typical operating statement comes out with gross rental income, other income, vacancy loss, and effective gross income on the income side, then property taxes, insurance, utilities, repairs and maintenance, management fees, and payroll on the expense side. Net operating income sits at the bottom. Each line keeps its monthly values and annual total in adjacent columns.

Net operating income equals effective gross income minus total operating expenses. Once the T12 is in Excel, sum the income lines net of vacancy to get effective gross income, sum the operating expense lines, then subtract. Leave debt service, capital expenditures, and depreciation out, since NOI measures unlevered operating performance before financing.

Yes. Whether the operating statement is a clean export from a property management system or a scanned page from a broker package, built-in OCR reads it and still returns structured rows. You get the same income, expense, and monthly columns without retyping figures off a printout, then you reconcile the annual totals against the source.

If a column will not sum, the amounts most likely came in as text rather than numbers, so Excel treats them as words. Select the column, use Data then Text to Columns and click Finish, and the values become real numbers. After that each monthly total and the annual figure should match the totals printed on the original statement.

It is safe here because files are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once the conversion finishes. An operating statement carries sensitive property financials, so it is never stored long term, shared, or reused. Be cautious with free tools that keep uploads on unknown servers.