Drop in any cash flow statement PDF — audited GAAP using the indirect method, internal management reports using the direct method, lender-prepared statements, or 10-K excerpts — and get a clean Excel file with operating, investing, and financing sections separated and reconciliation lines preserved.
Convert your first cash flow statement — free
Cash flow statements have more layout variation than balance sheets or P&Ls. The indirect method (used by most U.S. GAAP filers) starts with net income and reconciles via add-backs and working-capital changes; the direct method (used by some IFRS filers and most internal reports) lists actual cash receipts and payments. Within each method, line ordering and aggregation varies wildly — D&A might be one line or split across PP&E, intangibles, and right-of-use assets.
Pulling cash flow data into a peer-comp model means analysts retype line items repeatedly across companies, with the constant cleanup tax of inconsistent line naming and aggregation. Free cash flow calculations (Operating Cash Flow − CapEx) need both items extracted accurately or your FCF metric breaks.
PDFExcel reads cash flow statements by structure. Each line item becomes a row with the section preserved (Operating / Investing / Financing) plus a Sub-total flag for the section sub-totals (Net Cash from Operating Activities, Net Cash Used in Investing, Net Cash from Financing, Net Change in Cash). Indirect-method reconciliation lines (Net Income → adjustments → working-capital changes → operating cash flow) all extract with their hierarchy preserved.
Free cash flow components extract cleanly — Operating Cash Flow on one row, CapEx (typically 'Purchases of property, plant and equipment') on another, ready for FCF = OCF − CapEx in your model. Mix multiple companies in one batch upload. Pair with balance sheet and income statement extraction for full three-statement model input.
The model knows that 'Depreciation and amortization' is a non-cash add-back to Operating, that 'Purchases of property, plant and equipment' is CapEx in Investing, and that 'Repayment of long-term debt' belongs in Financing — and tags each line with its section regardless of how the source PDF orders them.
Cash flow is the messiest financial statement to extract because of layout variation. Most tools either need per-company templates or charge per-page at analyst volume. PDFExcel reads any cash flow PDF on the first try.
Each section grouped together. Sub-totals flagged. Reconciliation hierarchy from Net Income through Operating Cash Flow preserved.
| # | Section | Line Item | FY2024 | FY2023 | FY2022 | Sub-total |
|---|---|---|---|---|---|---|
| 1 | Operating | Net Income | $508.4M | $436.2M | $362.0M | |
| 2 | Operating | Depreciation and amortization | $184.0M | $162.4M | $148.2M | |
| 3 | Operating | Stock-based compensation | $98.2M | $84.6M | $72.4M | |
| 4 | Operating | Changes in working capital | ($24.6M) | $18.4M | ($12.0M) | |
| 5 | Operating | Net Cash from Operating Activities | $766.0M | $701.6M | $570.6M | Yes |
| 6 | Investing | Purchases of property, plant and equip | ($148.0M) | ($124.6M) | ($98.2M) | |
| 7 | Investing | Net Cash Used in Investing Activities | ($284.4M) | ($188.0M) | ($142.6M) | Yes |
| 8 | Financing | Repayments of long-term debt | ($80.0M) | ($80.0M) | ($60.0M) | |
| 9 | Financing | Net Cash from Financing Activities | ($362.0M) | ($301.4M) | ($248.0M) | Yes |
Equity research analysts modeling free cash flow, FP&A teams pulling competitive cash-conversion benchmarks, credit analysts reviewing borrower cash generation, M&A associates on diligence cash-flow modeling.
Pulls cash flow data for 8 sector peers for an FCF yield comp. Convert all 8 in one batch, pivot for OCF, CapEx, and FCF across years and companies. The reconciliation hierarchy lets them spot one-time adjustments easily.
Reviews 3 years of borrower cash flow statements for a credit decision. Convert all to Excel, focus on Operating Cash Flow trend and CapEx intensity to assess sustainable cash generation capacity.
Target's 5 years of cash flow statements arrive in PDFs. Convert all 5 as one batch, build the LBO base-case cash-conversion bridge in 30 minutes vs 3-4 hours of typing.
Yes. Indirect-method statements preserve the reconciliation from Net Income through add-backs and working-capital changes to Operating Cash Flow. Each line stays in its section (Operating) with the hierarchy intact.
Yes. Operating Cash Flow extracts as a sub-total row in the Operating section with the Sub-total flag set. CapEx ('Purchases of property, plant and equipment') extracts as its own row in Investing — making FCF = OCF − CapEx a one-formula calculation in your downstream model.
Yes. Direct-method statements (cash receipts from customers, cash paid to suppliers, etc.) extract with the same section structure. The Method column distinguishes Direct vs Indirect for cross-company comparability.
Yes. Internal cash flow statements (often monthly, often with budget-vs-actual columns) extract cleanly. The model adapts to whatever periods are shown — monthly, quarterly, year-to-date, full-year.
Yes. Built-in OCR runs automatically when there's no embedded text layer. Lender-provided cash flow statements scanned to PDF extract through the same workflow.