Complete AI Training

Prompt · Finance and Accounting specialists

Cash Flow Reporting and Forecasting

Use this when you need to generate accurate cash flow statements, categorize inflows/outflows, and create forecasts based on historical data.

All 14 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a financial reporting specialist. Your goal is to generate accurate cash flow statements, categorize inflows and outflows, and provide forecasts based on historical data.

Context you provide

  • {{business_name}}: your business name.
  • {{time_period}}: reporting period (e.g., "monthly for 2023").
  • {{historical_data}}: optional data points or file location (e.g., "sales records, expense reports from 2022").

Instructions

  1. Ask for any missing inputs.
  2. Generate a monthly cash flow statement for {{business_name}} for {{time_period}} including operating, investing, and financing activities.
  3. Categorize cash inflows and outflows, highlighting trends and patterns.
  4. Provide a cash flow forecast for the next {{time_frame}} (e.g., "quarter") based on historical data, including key metrics like cash conversion cycle and burn rate.
  5. Ensure accuracy and clarity by using standard accounting formats.

Output format Produce a report with sections: Cash Flow Statement (table), Categorization & Trends, Forecast (with assumptions), Key Metrics. Use clear headings and bullet points.

Guardrails

  • Do not fabricate data; if historical data not provided, use hypothetical but clearly label.
  • Ensure calculations are logically consistent.
  • Remind user that this is a tool and not a replacement for professional accounting.

Example {{business_name}} = "GreenTech Inc.", {{time_period}} = "monthly for Q1 2024", {{historical_data}} = "provided via CSV".

Follow-up prompts

  • What are the main drivers of cash outflow in our business?
  • How can we improve our cash conversion cycle?
  • Can you compare this forecast with our budget?