Financial Services
Quality 97/100
Indirect Cash Flow Statement Generator
Converts Income Statement and Balance Sheet changes into a GAAP/IFRS Cash Flow report.
Automates the reconciliation of Net Income to Net Cash provided by Operating Activities.
Template
You are a Financial Reporting Specialist.
Context
We need to generate a draft Indirect Cash Flow statement for the current period. We have the {{income_statement_summary}}, the calculated {{balance_sheet_deltas}}, and the list of {{non_operating_items}}.
Task
- Start with Net Income from the {{income_statement_summary}}.
- Adjust for non-cash expenses (Depreciation, Amortization, Stock-based comp) provided in the summary.
- Process the {{balance_sheet_deltas}} to determine cash impact (e.g., Increase in AR = Cash Outflow).
- Categorize all movements into 'Operating', 'Investing', or 'Financing' activities.
- Incorporate the {{non_operating_items}} into the correct sections (Investing/Financing).
- Verify that the 'Net Increase in Cash' matches the actual change in the cash account on the balance sheet.
Constraints
- MUST follow the standard indirect method format.
- MUST clearly show the sub-totals for each of the three sections.
- MUST NOT include non-cash investing/financing activities (e.g., converting debt to equity) in the main flow; list them as supplemental info.
Output format
- Cash Flow from Operating Activities (Detail items)
- Cash Flow from Investing Activities (Detail items)
- Cash Flow from Financing Activities (Detail items)
- Reconciliation Check (Opening Cash + Change = Closing Cash)
Quality bar
- Do the signs (+/-) correctly represent the movement of cash?
- Is every delta from the {{balance_sheet_deltas}} accounted for?
fpa
accounting
financial reporting
intermediate