Drop in any balance sheet PDF — audited GAAP, lender-prepared, internal management report, or 10-K excerpt — and get a clean Excel file with line items, multi-period comparatives, sub-totals flagged, and footnote references linked. Single company or peer-set batch.
Convert your first balance sheet — free
A balance sheet is laid out as a tall narrow table with two or three period columns and 30+ line items. Each section (Current Assets, Long-term Assets, Current Liabilities, Long-term Liabilities, Stockholders' Equity) ends with a sub-total. Generic PDF tools either fragment the line items across rows, miss the sub-totals (so Total Current Assets shows up as a regular line and breaks the math), or lose the period columns entirely.
Multi-period balance sheets compound the problem. A 10-K typically shows 2 fiscal years side by side; lender financials sometimes show 3 or 4 years. Pulling them into a peer comp model means analysts retype line items into Excel from each company — a half-day of data entry per company before any actual analysis.
PDFExcel reads balance sheets by structure. Each line item becomes a row with period columns preserved (FY2024, FY2023, FY2022 typical for a 10-K). Sub-totals (Total Current Assets, Total Assets, Total Equity) are flagged in their own column so your downstream model knows not to double-count. Footnote references like 'See Note 7' link to a Notes column for analytical depth.
Mix multiple companies in a batch upload — the workbook tags each row with company name. Built-in OCR handles scanned lender-provided balance sheets. The whole financial statement family (income statement, cash flow, equity) extracts the same way, so a peer-comp model can pull from one batch upload across all four statements.
The model knows that 'Total Current Assets' is a sub-total of the line items above it, that 'Goodwill' belongs in Long-term Assets even when it's listed before PP&E, and that 'Accumulated Other Comprehensive Income' is part of equity not liabilities. Trained on real audited GAAP balance sheets.
Most balance-sheet extractors either need a paid data-vendor subscription (Capital IQ, FactSet) or charge per-page at analyst volume. PDFExcel reads any company's filed balance sheet directly.
Each section grouped together. Sub-totals flagged so your model knows not to double-count. Footnote references preserved.
| # | Section | Line Item | FY2024 | FY2023 | FY2022 | Sub-total |
|---|---|---|---|---|---|---|
| 1 | Current Assets | Cash and Cash Equivalents | $284.2M | $211.8M | $148.4M | |
| 2 | Current Assets | Accounts Receivable, net | $186.4M | $162.1M | $148.9M | |
| 3 | Current Assets | Inventory | $94.4M | $82.5M | $74.2M | |
| 4 | Current Assets | Total Current Assets | $612.8M | $498.4M | $412.7M | Yes |
| 5 | LT Assets | Property, Plant & Equip | $842.6M | $764.2M | $682.0M | |
| 6 | LT Assets | Goodwill | $1,248.0M | $1,248.0M | $1,184.2M | |
| 7 | Total Assets | $2,894.6M | $2,612.4M | $2,318.8M | Yes |
Equity analysts pulling peer-comp data, credit analysts reviewing borrower financials, M&A diligence associates building target models, audit teams preparing analytical-review workpapers.
Pulls balance sheet data for 12 peer companies in industrials. Convert all in one batch, pivot into a side-by-side balance-sheet comp showing leverage and working capital across the peer set.
Reviews 3 years of borrower balance sheets. Convert all to Excel with sub-totals flagged. Drop into the bank's credit-decision model showing leverage trajectory and current-ratio trend.
Target company shares 5 years of audited balance sheets. Convert all 5 as one batch, build the LBO base-case balance sheet bridge in 30 minutes vs 4 hours of typing.
Yes. FY2024, FY2023, FY2022 (or however many periods are shown) extract as separate columns. Line items are rows — the natural orientation for peer-comp pivot tables and trend analysis.
Yes. Sub-totals get a 'Yes' in their own column so your downstream model knows not to sum sub-totals into another sum (the classic double-count error).
Yes. Footnote references like 'See Note 7' or '(11)' stay attached to their line items in a Notes column. The footnote detail itself is read but not auto-merged — separate workflow if you need full footnote breakouts.
Yes for IFRS — most line-item naming conventions overlap with GAAP. Non-GAAP supplemental disclosures (adjusted goodwill, pro-forma equity) extract as separate fields when they appear.
Yes. Built-in OCR runs automatically when there's no embedded text layer. Lender-provided balance sheets, audited statements scanned to PDF, and faxed copies all extract with the same workflow.