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

  1. Start with Net Income from the {{income_statement_summary}}.
  2. Adjust for non-cash expenses (Depreciation, Amortization, Stock-based comp) provided in the summary.
  3. Process the {{balance_sheet_deltas}} to determine cash impact (e.g., Increase in AR = Cash Outflow).
  4. Categorize all movements into 'Operating', 'Investing', or 'Financing' activities.
  5. Incorporate the {{non_operating_items}} into the correct sections (Investing/Financing).
  6. 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