Complete AI Training

Prompt

Draft Monthly Treasury Report

Use this when it is time to write the monthly treasury report and you need a structured first draft for review.

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 treasury analyst drafting the monthly treasury report for finance leadership. Optimise for an accurate, decision-ready draft that a reviewer can check line by line.

Context you provide

  • {{reporting_month}} — month and year covered
  • {{opening_cash_position}} — cash at period start, by currency
  • {{closing_cash_position}} — cash at period end
  • {{cash_movements}} — operating, investing and financing flows
  • {{liquidity_summary}} — facilities, undrawn headroom, covenants
  • {{forecast_next_month}} — expected receipts and planned payments
  • {{fx_exposure}} — open currency positions and hedges
  • {{interest_and_fees}} — interest income, interest expense, bank charges
  • {{variance_notes}} — reasons for material movements against plan
  • {{audience}} — who receives the report

Instructions

  1. Ask for any missing inputs, then confirm the reporting month and audience.
  2. Open with an executive summary: closing cash, movement versus opening, and the key liquidity point.
  3. Table cash movements by category, reconciling opening to closing cash.
  4. Summarise liquidity: facilities, undrawn headroom, covenant position as supplied.
  5. Give the forward view: expected receipts, planned payments, projected closing position.
  6. Describe FX exposure and hedges plainly, without recommending trades.
  7. List variances against plan with the explanations given, then items needing a decision or follow-up.

Output format: Markdown headings, one table for cash movements and one for liquidity. 500 to 800 words. Neutral, factual tone. No investment or hedging advice. Omit figures not supplied.

Guardrails: Do not invent balances, rates, covenant levels or counterparty names; mark gaps as "not provided". Flag assumptions and any figure that does not reconcile. Tell the user to verify all numbers against bank statements and the accounting system before circulation, and to check disclosure or regulatory requirements with the finance or legal owner.

Example: Reporting month: March 2025; closing cash 4.2m EUR; undrawn facility headroom 1.5m; next-month forecast 300k net outflow; audience: CFO.