learn-ai-finance-with-phoebe / Builder session 2 of 10
Learn AI + Finance with Phoebe · Builder track · Session 2 of 10

Prompting for financial analysis: turn a vague ask into a checkable answer

A finance prompt is not a wish - it is a spec. Tonight you learn the six parts that make an AI answer reliable, the handful of patterns that do the heavy lifting, and the guardrails that keep currency, periods, and rounding honest. You will rebuild a lazy "comment on these results" into a structured prompt that shows its work, then bottle it as a reusable template.

🟢 Builder track Practitioners: analysts · FP&A · accounting ChatGPT or Claude 45 min
0-3 · Why prompts are specs 3-23 · Anatomy, patterns, guardrails 23-43 · Build-along: rebuild + template 43-45 · Q&A
Part 0

A prompt is a work order, not a wish

Last session you learned the universal method: ground it, make it show its work, verify. This session is where you get good at the "ground it" half. Most disappointing AI output in finance is not a model problem - it is a briefing problem. You would never ask a junior analyst to "comment on these results" with no numbers, no format, and no deadline; a chat AI deserves the same respect. Tonight you write prompts the way you would brief a sharp new hire: role, context, data, task, format, and the rules they must not break.

Live - presented in session Self-study - read after class ★ Try it now prompt Official sources covered
★ What you walk out with today A six-part checklist for any finance prompt, the five patterns that cover almost everything you will ask, a guardrail block you paste into every prompt so currency and periods stay honest, and a reusable variance-commentary template with placeholders - the first entry in your own prompt library.
Part 1 · covers CFI advanced prompting + Coursera GenAI Essentials

Anatomy of a reliable finance prompt 6 min live

A strong finance prompt has six layers, and they stack. Drop one and the answer gets vaguer, more invented, or wrongly formatted. You do not need all six every time - but knowing the full stack means you know exactly which layer to add when an answer disappoints.

ROLE "You are an FP&A analyst..." sets the voice and the standard CONTEXT the business, the period, why it matters so the reasoning fits your world DATA the actual numbers, pasted in this is the grounding - no data, no trust TASK the one thing to do: explain, compare, draft specific verb, single job FORMAT table, bullets, or JSON - and how long so the output drops straight into your work CONSTRAINTS show work · only supplied numbers say "not in the data" · state assumptions = one strong prompt Answer disappointed? Add the missing layer - do not just say "try again".
🔍 Click to zoom - six layers that stack into one strong finance prompt
LiveThe six layers, in the order you write them3 min▶

Write them top to bottom and the prompt almost drafts itself. Each layer answers one question the model would otherwise guess at.

  • Role - "You are a controller / FP&A analyst / credit analyst." Sets vocabulary and rigour. A model told it is an analyst hedges and shows work; told nothing, it chats.
  • Context - the business, the period, the audience for the answer. "This is for a board pack" produces different prose than "explain to me".
  • Data - paste the actual numbers. This is rail-one grounding from b1. Public or synthetic data in a consumer tool; real financials in enterprise or local only.
  • Task - one clear verb: explain, compare, reconcile, draft. Two tasks in one prompt gives you two half-answers.
  • Format - table, bullets, JSON, word count. Say it up front and you stop re-asking "now put that in a table".
  • Constraints - the honesty rules: show every calculation, use only the numbers supplied, say "not in the data" instead of inventing, and state any assumption made.
The constraints layer is where finance lives Anyone can ask for a summary. The four constraint lines - show work, only supplied numbers, "not in the data", state assumptions - are what turn a chatty answer into one you can put your name on. Never skip them.
Self-studyThe constraint lines, ready to paste2 min read▶

Keep these four lines on a sticky note. They are the difference between an answer you trust and one you re-check line by line.

★ The reusable constraint blockRules: - Use ONLY the numbers I supplied above. Do not add outside figures. - Show every calculation step by step so I can check the math. - If something you need is missing, say "not in the data" - do not estimate. - State any assumption you make as a separate, labelled line.

Paste this at the end of any analytical prompt. It costs you four lines and buys you a checkable answer. Everything after this in the track assumes you are using something like it.

Part 2 · covers CFI advanced prompting patterns

The core patterns - five moves that cover most work 6 min live

You do not need fifty prompt tricks. Five patterns handle the overwhelming majority of finance asks, and they combine. Learn when each one earns its place and you stop guessing.

LivePattern picker - when to reach for each3 min▶
Do you want consistent style? Does the answer feed a system? yes no yes no FEW-SHOT: one example the quiet hero pattern OUTPUT CONTROL: format table, JSON, fixed columns STEP-BY-STEP: order math makes the work visible Self-check runs every time - list assumptions and what to verify before you use it.
🔍 Click to zoom - pick the pattern by what the answer needs to do next
PatternWhat it doesReach for it when...
Few-shot (show an example)Give one sample comment in your house style; the model matches itYou want consistent tone and structure across many outputs
Role prompting"You are a controller reviewing the close"You want the rigour and vocabulary of a specific finance role
Step-by-step decomposition"First compute variances, then rank, then comment on the top 3"The task has stages and you want the math visible and ordered
Output control"Return a 3-column table" or "return valid JSON with these keys"The answer feeds a doc, a sheet, or another system
Self-check"List your assumptions and what I should verify before I use this"Always - it is your built-in rail-two review step

Few-shot is the quiet hero. One good example of a variance comment teaches the model your style faster than three paragraphs of instructions ever will.

Self-studyFew-shot and self-check, shown2 min read▶

Few-shot means you supply the pattern, not just the instruction. Watch how one example locks the style:

★ Few-shot: teach the house style with one exampleHere is the style I want for variance comments: Example: "Marketing was 120 over budget (620 vs 500, +24%), driven by the Q2 campaign pulled forward from Q3. Timing, not overspend - full-year still on plan." Now write comments in that exact style for these three variances: [paste your variances]

Self-check makes the model hand you its own review notes - the single cheapest way to honour rail two inside the prompt itself:

★ Self-check: make it flag its own soft spotsAfter your analysis, add a short section titled "Verify before use": list every assumption you made, any number you were unsure about, and the one thing I should double-check against source before I send this.
Part 3 · finance-specific hygiene

Finance guardrails inside the prompt 3 min live

General prompting advice ignores the things that get finance people in trouble: the wrong currency, a quarter compared to a full year, or a percentage rounded three different ways in one memo. Bake the hygiene into the prompt so the model cannot drift.

LiveFive lines that stop silent finance errors2 min▶
  • Currency and units. "All figures in SGD thousands" - or the model may silently mix dollars and thousands, or assume USD.
  • Period labels. Spell out Q1 vs FY, actual vs budget, this year vs last. A comparison against the wrong base is worse than no comparison.
  • Rounding. "Round to whole numbers; percentages to one decimal." Consistency reads as competence in a board pack.
  • Materiality. "Only comment on variances above 50k or 10%." Stops the model narrating trivia and burying the real story.
  • Only these numbers. The b1 grounding rule, restated every time: no outside figures, no memory, no filling gaps.
Real world

The memo that mixed thousands and millions. An analyst pasted a P&L in thousands but asked for commentary "in millions" - the model gamely reported revenue of "4.1 million" when it was 4.1 thousand-times-something-else. It looked authoritative and was off by orders of magnitude. One line - "all figures in SGD thousands, do not convert" - would have prevented it. Guardrails are cheaper than corrections.

✗ No unit guardrail P&L pasted in thousands Asked for commentary in millions Got "4.1 million" - off by 1000x ✓ One guardrail line "All figures in SGD thousands" "Do not convert" stated upfront Output matches the real scale One line - "all figures in SGD thousands, do not convert" - would have prevented it.
🔍 Click to zoom - one guardrail line stops a thousand-times error
Demo 1 of 2

Rebuild "comment on these results" into a real prompt ★ 12 min · everyone builds

The most common finance prompt in the wild is also the worst: "comment on these results". We take that lazy ask, run it, feel the vagueness, then rebuild it layer by layer on a small supplied P&L - and iterate once to sharpen it.

Open ChatGPT or Claude. Paste the small P&L below (it is synthetic - safe for any tool, rail one). You will use it for both prompts.

Run the vague version first (Prompt A). Notice what you get: generic prose, maybe invented drivers, no math shown, no idea which variances actually matter.

Now rebuild it with the six layers (Prompt B): role, context, the data, one clear task, a table format, and the constraint block. Run it.

Compare. The structured answer ranks variances by size, shows the subtraction, respects your materiality threshold, and flags what to verify. That is the same fiction-to-checkable jump from b1, now on purpose.

Iterate once. Add a single refinement - "add a one-line 'so what' for the CFO under the table" - and re-run. Feel how cheap it is to steer once the structure is right. That is the whole skill.

Prompt A - vague (produces generic, ungrounded prose)Here are our results. Comment on these results. Revenue 4,120. Marketing 620. Salaries 1,900. Operating profit 700.
★ Prompt B - the six-layer rebuildYou are an FP&A analyst preparing month-end commentary for the CFO. Context: this is our May actual vs budget, SGD thousands, one business unit. Data (use ONLY these numbers): Line Actual Budget Revenue 4,120 3,950 Marketing 620 500 Salaries 1,900 1,880 Other opex 900 920 Operating profit 700 650 Task: explain what drove the operating-profit variance vs budget. Format: a table with columns Line | Actual | Budget | Variance | % | Comment, then one line "So what for the CFO" beneath it. Rules: - Use ONLY the numbers above; all figures SGD thousands; percentages to 1 decimal. - Only comment on variances above 50 or 10%. - Show the subtraction for each variance so I can check it. - If something needed is missing, say "not in the data" - do not estimate. - End with "Verify before use": list any assumption and what I should double-check.
Why we rebuild rather than nag When Prompt A disappoints, the instinct is to type "no, be more specific". That is slow and unreliable. Adding the missing layers is faster and repeatable - and it is exactly what the anatomy diagram is for. Diagnose the gap, add the layer.
Demo 2 of 2

Bottle it: a reusable variance-commentary template ★ 8 min · build your own

A great prompt you have to rewrite every month is a chore. A great prompt with placeholders is a tool. We turn Prompt B into a template you fill in seconds - the first entry in your prompt library.

Take the structure of Prompt B and replace the specifics with clearly marked placeholders in square brackets: role, period, currency, the data table, and the materiality threshold.

Save it somewhere you will find it - a notes doc, a shared team page, or your tool's saved-prompts feature. Give it a name: "Variance commentary v1".

Test the template by filling it with this month's numbers. If a placeholder is unclear, tighten the wording now, while you remember what you meant.

Start a running "prompt library" file. Every reusable prompt from this track goes in it - by b10 you will have a small, battle-tested toolkit no one handed you.

★ Variance commentary template (fill the [placeholders])You are a [FP&A analyst / controller] preparing [monthly / quarterly] commentary for [the CFO / the board]. All figures in [SGD thousands]. Period: [May actual vs budget]. Data (use ONLY these numbers): [paste your table: Line | Actual | Budget] Task: explain the drivers of the [operating-profit] variance vs [budget]. Format: a table with columns Line | Actual | Budget | Variance | % | Comment, then one line "So what for [the CFO]". Rules: - Use ONLY the numbers above; percentages to [1] decimal. - Only comment on variances above [50] or [10%]. - Show each subtraction so I can check the math. - Say "not in the data" for anything missing - do not estimate. - End with "Verify before use": assumptions + what I should double-check.
Real world

From two hours to twenty minutes. A group FP&A analyst templated her monthly variance pack this way. The first draft used to eat a morning; now she pastes the numbers, runs the template, and spends her time on the judgement - checking the math and sharpening the "so what". The AI did not replace her. It deleted the boring 80% so she could do the 20% that is actually her job.

Homework

Try it yourself - this week ◐ 30-45 min total

Source material

Official sources covered

This session teaches from public prompting curricula for finance. Certificates, graded assessments, and paid tooling stay with the official programs - noted honestly. This session covers:

✓CFI - AI for Finance: advanced promptingParts 1-2 · anatomy, few-shot, role, decomposition, output control
✓Coursera - Generative AI Essentials for Finance & AccountingParts 1-3 · prompt engineering for finance workflows, ChatGPT + Claude
◐Finance prompt hygiene (currency, period, materiality)Part 3 · practitioner guardrails, applied through b3-b5
Check yourself

Three questions before you go 🎯 ◐ 90 seconds

1 · What are the six layers of a reliable finance prompt?

Role sets the standard, context fits your world, data grounds it, task is the one job, format shapes the output, and constraints carry the honesty rules. Drop one and the answer drifts.

2 · You need the same style of variance comment across twenty line items. Which pattern helps most?

One concrete example teaches style faster than any amount of instruction. Few-shot is the quiet workhorse of consistent finance output.

3 · Why add a self-check line ("list your assumptions and what I should verify")?

Self-check hands you the model's own soft spots to verify. It does not replace your review - it focuses it. That is rail two, baked into the prompt.

Builder session 2 cheat sheet · pin this

A prompt is a specbrief the AI like a sharp new hire - role, context, data, task, format, rules. Vague in, vague out.
Six layersROLE + CONTEXT + DATA + TASK + FORMAT + CONSTRAINTS. Answer weak? Add the missing layer, do not just nag.
Constraint blockonly supplied numbers · show every step · "not in the data" · state assumptions. Paste it every time.
Five patternsfew-shot, role, step-by-step, output control, self-check. Few-shot is the quiet hero for consistency.
Finance guardrailscurrency + units, period labels (Q1 vs FY), rounding, materiality threshold, only these numbers.
Self-check = rail 2"list assumptions and what I should verify" builds your review step into the prompt itself.
Templates, not rewritesbottle a good prompt with [placeholders]; start a prompt library that grows across the track.
Next sessionb3 - month-end close copilot: reconcile, spot anomalies, and draft the variance narrative on real close data.