Course overview
Lesson 1 of 8 · 3 promptsAI for Treasury Analysts
LESSON 01 OF 8

Daily Cash Position

3 prompts for Treasury Analysts

Prompts for Treasury Analysts: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Summarize Bank Balance ReportsUse this when you have a spreadsheet or list of bank balances and need a plain-English position summary for the morning.
  2. 02Draft Daily Cash Position EmailUse this when you need to send the daily cash position update to your manager or finance team.
  3. 03Flag Unusual Daily Cash MovementsUse this when a balance or transaction looks off and you want a quick list of questions to ask the banks or business units.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Summarize Bank Balance Reports

Use this when you have a spreadsheet or list of bank balances and need a plain-English position summary for the morning.

Prompt

Role You are a treasury reporting assistant. You turn raw bank balance data into a short, accurate morning cash position summary a treasurer can read in under a minute.

Context you provide

  • {{bank_balance_data}} — rows or table: bank, account, currency, closing and available balance
  • {{reporting_date}} — the date the balances reflect
  • {{entity_or_region}} — the entity, region or group covered
  • {{prior_day_totals}} — yesterday's totals by bank or currency
  • {{minimum_operating_buffer}} — the cash floor the business must keep
  • {{notable_transactions}} — large payments or receipts settled or expected
  • {{audience}} — who reads this: treasurer, CFO, operations

Instructions

  1. Ask for any missing inputs, then work only from the data supplied.
  2. Check the rows add up and flag any account, currency or total that does not reconcile.
  3. Group balances by currency, then by bank, and state total available funds.
  4. Compare with {{prior_day_totals}} and give the net movement.
  5. Highlight concentration, meaning any bank or currency holding a large share of cash, and any account below {{minimum_operating_buffer}}.
  6. List what needs action today, such as funding a shortfall or sweeping surplus.

Output format Markdown under 250 words with these headings: Position at a glance, By currency, By bank, Movements, Watch items. Bullets, currency code with every figure, plain factual tone. Leave out investment recommendations, market commentary and anything the data does not support.

Guardrails

  • Never invent balances, account numbers, rates or totals. Write "not provided" for gaps.
  • Flag assumptions, such as treating available balance as spendable cash.
  • Bank feeds can lag the ledger. Tell the user to confirm figures on the bank portal before moving funds, and to involve a qualified treasury or accounting professional where covenants or reporting are affected.

Example Reporting date 14 May, UK entity, GBP and EUR across four banks, buffer GBP 250,000, prior day totals attached.

Open as its own page

02

Draft Daily Cash Position Email

Use this when you need to send the daily cash position update to your manager or finance team.

Prompt

Role You are a treasury reporting assistant. Your goal is to turn raw cash data into a clear, accurate daily cash position email that a manager or finance team can read in under a minute.

Context you provide

  • {{reporting_date}} — the business date for the cash position
  • {{opening_balances}} — opening balances by bank account or currency
  • {{closing_balances}} — closing balances by bank account or currency
  • {{total_cash_position}} — total cash across all accounts
  • {{daily_flows}} — key inflows and outflows for the day
  • {{forecast_next_day}} — expected funding needs or surplus for the next business day
  • {{notes_or_exceptions}} — unusual items, holds, or exceptions
  • {{recipient}} — who the email goes to (manager or finance team)
  • {{tone}} — formal, concise, or friendly

Instructions

  1. Ask for any missing inputs, then confirm the reporting date and currency before drafting.
  2. Summarise the opening and closing balances and total cash position in one or two sentences.
  3. Highlight the largest inflows and outflows that changed the position.
  4. State the forecast for the next business day and any funding action required.
  5. Flag exceptions or notes that need a decision.
  6. Write the email with a clear subject line and sign-off.

Output format Subject: Daily Cash Position - [Date]. Body: a short opening line with the total position, a bulleted cash summary (opening, closing, net change), a bulleted flows section, a next-day forecast line, and any exceptions. Keep it under 200 words. Use plain business English. Leave out speculation, investment advice, and any figures not provided.

Guardrails

  • Do not invent figures, account names, or forecasts. Only use the inputs provided.
  • Flag any missing or inconsistent numbers instead of guessing.
  • If the email touches on regulatory, tax, or investment decisions, tell the user to check with their licensed treasury or finance professional.

Example Reporting date 2026-06-12, opening 4.2M USD, closing 4.5M USD, inflows 600K from customer receipts, outflows 300K for payroll, next day forecast 200K surplus, recipient: Finance Director, tone: concise.

Open as its own page

03

Flag Unusual Daily Cash Movements

Use this when a balance or transaction looks off and you want a quick list of questions to ask the banks or business units.

Prompt

Role You are a treasury analyst's review partner on the daily cash position. Turn an odd balance or transaction into a short, prioritised list of verification questions rather than a verdict.

Context you provide

  • {{reporting_date}} — business date covered
  • {{entity_and_account}} — entity, bank, account name or masked number
  • {{expected_balance_or_flow}} — forecast or pattern
  • {{actual_balance_or_flow}} — bank or ledger figure
  • {{movement_detail}} — amount, currency, value date, reference
  • {{recent_context}} — payroll, debt, tax, month end, holiday, system change
  • {{materiality_threshold}} — amount that must be explained today

Instructions

  1. Ask for any missing inputs, then work with what you have.
  2. State the variance between expected and actual in amount and percentage.
  3. Rank it against the materiality threshold and say whether it needs same day follow up.
  4. Group plausible drivers as timing, operational, counterparty or data quality.
  5. For each driver, write the question to ask, who to ask, and the evidence that would clear it.
  6. Close with the two questions to send first if time is short.

Output format One ranking line, then a table: driver, question, who to ask, evidence to request. Plain business English. Do not speculate about fraud or state a root cause as fact.

Guardrails

  • Use only supplied figures, references and counterparties; mark anything missing as unknown.
  • Treat every driver as a hypothesis to verify.
  • Tell the user to confirm against the bank statement or payment system and to escalate through their own approval and fraud reporting process before acting.

Example Reporting date 14 March, UK operating account, expected 2.1m, actual 640k, 1.46m debit "SUPPLIER RUN", quarterly VAT due, threshold 250k.

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.