Drop in any income statement / P&L PDF — audited GAAP, internal management report, lender-prepared, or 10-K excerpt — and get a clean Excel file with revenue, COGS, gross profit, operating expenses, EBITDA, interest, taxes, and net income across multiple periods or segments.
Every analyst, lender, and operator spends time pulling P&L data into Excel. A typical 10-K income statement has 15-25 line items across 3 fiscal years, plus segment reporting that breaks revenue and operating income into 4-6 reportable segments. Generic PDF tools fragment line items, lose period columns, and miss the segment table entirely.
Internal management P&Ls are worse — variable layouts per company, monthly comparatives, year-to-date columns, sometimes budget-vs-actual variance columns. Analysts reviewing private-company financials end up retyping P&L data again and again across investments, deals, or peer benchmarks.
PDFExcel reads income statements by structure. Each line item becomes a row with period columns preserved (FY2024, FY2023, FY2022 for a 10-K; or Jan / Feb / Mar / YTD for an internal P&L). Sub-totals (Gross Profit, Operating Income, EBITDA, Net Income) are flagged. Segment reporting tables extract as separate sheets with revenue and operating income broken out per segment.
Mix multiple companies in a batch upload — the workbook tags each row with company name and statement type. Built-in OCR handles scanned management P&Ls. Drop the export into your DCF model, comp set pivot, or trend analysis. Pair with balance sheet extraction and cash flow extraction for full three-statement model input.
The model knows that 'Gross Profit' = Revenue − COGS, that 'Operating Income' = Gross Profit − Operating Expenses, and that EBITDA can be presented either as a sub-total or as a non-GAAP supplemental disclosure. Trained on real audited P&Ls and management reports.
Most P&L extractors either need a paid data-vendor subscription or charge per-page at analyst volume. PDFExcel reads any company's income statement — audited or internal — directly.
Each line item × period as separate columns. Sub-totals (Gross Profit, Operating Income, EBITDA, Net Income) flagged. Segment data on a separate sheet.
| # | Line Item | FY2024 | FY2023 | FY2022 | Sub-total | Segment |
|---|---|---|---|---|---|---|
| 1 | Revenue | $2,890.4M | $2,612.1M | $2,318.8M | Consolidated | |
| 2 | Cost of Revenue | $1,184.0M | $1,089.4M | $986.2M | Consolidated | |
| 3 | Gross Profit | $1,706.4M | $1,522.7M | $1,332.6M | Yes | Consolidated |
| 4 | Sales & Marketing | $612.0M | $554.8M | $498.4M | Consolidated | |
| 5 | Research & Development | $284.2M | $248.6M | $211.8M | Consolidated | |
| 6 | Operating Income | $680.8M | $594.1M | $502.4M | Yes | Consolidated |
| 7 | Net Income | $508.4M | $436.2M | $362.0M | Yes | Consolidated |
Equity analysts running peer comps, FP&A teams pulling competitive benchmarks, credit analysts reviewing borrower P&Ls, M&A associates on diligence, founders / CFOs benchmarking against public peers.
Pulls quarterly P&L data for 8 public SaaS comps for the board pack. Convert all 8 in one batch, pivot into a side-by-side comp showing growth, gross margin, and operating leverage trends.
Reviews 3 years of borrower P&Ls for a $25M revolver renewal. Convert all to Excel with EBITDA flagged, drop into the bank's leverage and coverage covenant model.
Pulls last-12-months P&Ls for 6 closest public competitors. Convert all in one batch, build a 'where we compare' slide for the deck — half a day of analyst work, done in 60 minutes.
Yes. FY2024, FY2023, FY2022 (or whatever periods are shown — quarterly, monthly, YTD all work) extract as separate columns. Line items are rows.
Yes. Sub-totals get flagged in their own column so your downstream model knows not to double-count them in a sum or pivot.
Yes. Reportable-segment tables (revenue and operating income per segment) extract as a separate sheet in the output workbook. Useful for sum-of-the-parts valuation work and segment trend analysis.
Non-GAAP measures (adjusted EBITDA, organic revenue, free cash flow reconciliations) extract as separate fields when they appear. The model preserves whether each measure is GAAP or non-GAAP.
Yes — both. Internal management P&Ls (monthly columns + YTD + budget-vs-actual variance) extract cleanly. Most operators use it for board-pack prep where the source is the internal accounting-system PDF export.