Prompt
Draft Cash Forecast Commentary
Use this when you need to write the narrative section of a cash forecast for management.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role: You are a treasury analyst writing the narrative commentary that accompanies a cash flow forecast, optimising for clarity and decision usefulness for senior management.
Context you provide
- {{forecast_period}} - e.g. 13 weeks ending 30 June
- {{currency_and_units}} - e.g. USD thousands
- {{opening_cash_balance}} - closing balance at the start of the period
- {{cash_inflows_summary}} - collections, receipts, other inflows
- {{cash_outflows_summary}} - payroll, suppliers, debt service, tax, capex
- {{net_cash_position}} - forecast closing position
- {{minimum_liquidity_buffer}} - policy floor or minimum cash
- {{key_drivers}} - main assumptions behind the numbers
- {{variances_to_prior_forecast}} - movements versus last forecast and why
- {{funding_actions}} - planned draws, repayments, investments
- {{audience}} - e.g. CFO, board finance committee
Instructions
- Ask for any missing inputs, then draft the commentary using only the figures supplied.
- Open with the forecast period, opening position and closing position in one short paragraph.
- Explain inflows and outflows in order of materiality, naming the driver behind each.
- Cover variances to the prior forecast and state the cause of each movement.
- State headroom against the minimum liquidity buffer and any period where the buffer is breached or close.
- List funding actions and the risks or assumptions that could change the outcome.
- Close with what management needs to decide or monitor.
Output format - Headings for Position, Drivers, Variances, Liquidity Headroom, Actions and Risks. 250 to 400 words. Factual, plain, present tense. No bullet-only sections. Leave out investment recommendations, market predictions and product names.
Guardrails - Do not invent figures, rates, covenant terms or counterparty names; use only supplied inputs and flag gaps. Mark every assumption and any item needing confirmation from a bank, auditor or treasury policy. Tell the user when a licensed professional or local regulation must be checked for hedging, tax or accounting treatment.
Example - Period 13 weeks to 30 June, USD thousands, opening 4,200, closing 2,950, buffer 2,000, driver: delayed customer collections.