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

The month-end close copilot: reconcile, flag, narrate

The flagship build of the track. You will assemble an AI copilot that triages reconciliations, flags the anomalies that matter, and drafts board-grade variance commentary - then you will drive a live simulator that shows exactly why context and guardrails, not a fancier model, are what make the output trustworthy.

🟡 Builder track Practitioners: accounting · controllership · FP&A ChatGPT or Claude · a spreadsheet 45 min
0-3 · Welcome 3-17 · The close & the copilot 17-42 · Simulator + build-along 42-45 · Q&A
Part 0

Why the close is the perfect first copilot

Month-end close is repetitive, deadline-bound, and drowning in variance explanations that read the same every month - which is exactly why it is the highest-value, lowest-drama place to put AI to work. Nothing here replaces the accountant; it clears the busywork so judgment gets the time. Tonight you build the copilot in a chat tool, then use a live simulator to feel the one lesson that carries the whole track: a trustworthy answer is grounded and guardrailed, not just well-written.

Live - presented in session Self-study - read after class ★ Try it now prompt Official sources covered
★ What you walk out with today A three-job close copilot (reconcile-triage, anomaly-flag, variance-narrative), a reusable grounded prompt that drafts commentary you can defend, hands-on time with the lever simulator that proves grounding beats model-size, and the habit of a human sign-off on every number.
Part 1 · covers Coursera GenAI Essentials for Finance & Accounting + IE close use-cases

The close, and where AI actually fits 6 min live

The close is a pipeline: gather the data, reconcile and tie out, analyse the variances, write the commentary, and review before sign-off. AI earns its place in the messy middle - triage, flagging, drafting - while the human owns the two ends: what the numbers are, and whether they are right.

Reconcile-triage: from every line to the ones that matter Lines to check by hand 400 Lines AI flags to check 10 Reconcile-triage ranks the lines so you check the 10 that matter, not all 400.
🔍 Click to zoom - triage turns 400 lines into the 10 that need a human
1 · Gather human owns 2 · Reconcile AI triages 3 · Analyse AI flags 4 · Narrate AI drafts 5 · Sign-off human owns AI owns the middle busywork; a human still owns what the numbers are and whether they are right.
🔍 Click to zoom - the close pipeline: AI assists the middle three steps, a human owns both ends
LiveThe three jobs of a close copilot3 min▶

Everything a close copilot does falls into three jobs, each a grounded task you already met in b1 and b2:

  • Reconcile-triage: given two lists (ledger vs bank, sub-ledger vs GL), surface the items that do not tie and rank them by size, so you look at the 10 that matter, not all 400.
  • Anomaly-flag: given actuals vs budget and prior, flag what breaches a materiality threshold or breaks a pattern - and say WHY it was flagged.
  • Variance-narrative: given the reconciled numbers plus business context, draft the "what changed, why, and outlook" commentary in your house style.
Real world

Four days to two. A mid-market controller pointed a copilot at the recurring variance write-ups - the ones that say the same thing every month with new numbers. First drafts that used to eat two days of senior time came back in minutes, leaving the team to do the judgement part: challenge the drivers, chase the odd ones. The close did not get less rigorous. It got faster where rigor was not the point.

Self-studyWhat stays with the human - always2 min read▶

The copilot drafts and triages; it never signs. The non-negotiables, straight from the two rails:

  • The numbers themselves come from your system of record, not the model. AI reasons over figures you supply; it does not source them.
  • Every figure in the commentary is checked against the reconciled data before it goes anywhere near a board pack (remember b1: ungrounded numbers are fiction with formatting).
  • Sign-off is human. "The copilot wrote it" is not an answer to an auditor. You own the words and the numbers.
  • Real data needs a safe tool (rail one): pre-close management figures go in an enterprise or local tool, never a consumer chatbot.
Part 2 · the lever simulator

Drive it yourself: watch trust get built ★ 8 min · everyone plays

Here is the whole lesson of the track in one control panel. The copilot is drafting month-end variance commentary on a small P&L. Every lever you turn on feeds it more context or a tighter guardrail. Turn them on one at a time and watch the commentary go from confident fiction to a checkable, board-grade draft - and flip to the scorecard to watch accuracy climb across a golden set. Notice what never moves the needle: the size of the model.

What the simulator is teaching Start with everything off: the copilot invents numbers, just like an ungrounded chatbot. Add the data and it gets real but flat. Add prior period, business context, and account mapping and it starts to explain and classify. Add guardrails and it finally catches the Marketing overspend and the one-off legal item, and filters the immaterial noise. Grounding and guardrails did that - not a bigger brain.
Demo 1 of 2

Build the variance-narrative prompt for real ★ 12 min · everyone builds

Now rebuild what the simulator does, in your own chat tool, on your own small P&L. This is the reusable prompt you will run every close.

Take a small, safe P&L (public numbers or a synthetic 5-line set). Include Budget, Actual, and Prior for each line. Rail one: real pre-close numbers go only in an enterprise or local tool.

Give the copilot a role and the data, then ask for "what changed / why / outlook" commentary - and add every guardrail from the simulator: use only these numbers, show the variance math, apply a materiality threshold, and flag anomalies.

Add business context (a launch, a one-off cost) and watch attribution sharpen - the same jump the "business context" lever makes in the simulator.

Verify: check every figure against your data, confirm the flagged items are the real ones, and edit the wording to your house style. You own the final.

Save the prompt as your reusable "month-end commentary" template. Next month it is a two-minute job.

★ The close-copilot commentary promptYou are a senior management accountant drafting month-end variance commentary. Use ONLY the figures I provide - do not add or estimate any number. Data ($000): Revenue A 4,120 / B 4,000 / P 3,880; COGS A 2,610 / B 2,500 / P 2,380; Marketing A 470 / B 300 / P 290; G&A A 405 / B 400 / P 395; Legal A 180 / B 0 / P 0. Write commentary as: (1) what changed vs budget and vs prior, showing the variance math; (2) why, using this context - Marketing reflects the Q2 launch campaign, Legal is a one-off settlement; (3) a one-line outlook. Rules: flag any line more than 15% OR 100 over budget as an anomaly to investigate, note the Legal item as an unbudgeted one-off below the line, treat variances under the threshold as immaterial, and if anything needed is missing say "not in the data".
Notice the overlap That prompt is the simulator with every lever on: data, prior, context, mapping (below-the-line), and guardrails (threshold + flag + "not in the data"). The simulator is just this prompt made clickable.
Demo 2 of 2

Reconcile-triage: find the 10 that matter ★ 8 min · build your own

The other everyday close job: two lists that should agree but do not. The copilot triages; you investigate.

Make two short synthetic lists that should tie - e.g. a sub-ledger and a GL balance per account, with a few deliberate mismatches (a timing difference, a transposition, a missing entry).

Ask the copilot to compare them, list only the items that do NOT reconcile, rank by absolute difference, and suggest the likely reason for each (timing, transposition, missing) - as a hypothesis to check, not a conclusion.

Add the guardrail: "show the arithmetic for each difference and say 'cannot determine' rather than guessing a cause you cannot support".

✗ Guessing a cause AI states a reason, no arithmetic shown Confident claim, nothing to check A guess dressed as a conclusion ✓ Show the arithmetic 540 vs 450 = 90, flagged first 'Possible transposition' - to check Or 'cannot determine' - never a guess AI did not fix it; it just put it where a human would finally look.
🔍 Click to zoom - show the arithmetic, or say you cannot determine the cause

Investigate the top items yourself. The copilot narrowed 400 lines to the handful that matter; the judgement call on each is still yours.

★ The reconcile-triage promptHere are two lists that should agree: [SUB-LEDGER] and [GL]. Compare them and return ONLY the accounts that do not reconcile, as a table: account, sub-ledger, GL, difference (show the subtraction), and a likely-cause hypothesis (timing / transposition / missing entry) to investigate. Rank by absolute difference, largest first. If you cannot support a cause, say "cannot determine". Do not invent accounts or balances not in the lists.
Real world

The transposition that hid for three months. A team fed their intercompany recs to a copilot as a triage step. It ranked a 540 vs 450 difference to the top with "possible transposition" - a digit swap that manual eyes had skated past two closes running. AI did not fix it; it just put it where a human would finally look. That is the whole value: attention, aimed.

Homework

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

Source material

Official sources covered

Taught from public finance-AI curricula and vendor documentation; graded assessments and paid tooling stay with the official programs. This session covers:

✓Coursera - Generative AI Essentials for Finance & AccountingParts 1-2 · automating close workflows, commentary drafting
✓IE Business School - AI-Powered Finance (close + FP&A use-cases)Part 1 · where AI fits in the close pipeline
◐Vendor close-copilot patterns (Datarails and similar)Simulator + demos model the reconcile / flag / narrate jobs generically
Check yourself

Three questions before you go 🎯 ◐ 90 seconds

1 · In the simulator, what finally makes the copilot catch the Marketing overspend and the one-off legal item?

Grounding plus guardrails catch anomalies; model size does not. That is the lesson the whole track is built on.

2 · Which parts of the close does the copilot own?

AI assists the messy middle; a human owns what the numbers are and whether they are right. That is rail two in practice.

3 · Your variance prompt should always include which guardrail?

Grounding plus "show your work" plus "admit gaps" is what makes the draft checkable - and keeps invented figures out of the board pack.

Builder session 3 cheat sheet · pin this

The close copilotthree jobs: reconcile-triage, anomaly-flag, variance-narrative. Drafts and triages; never signs.
AI owns the middlegather + sign-off stay human. The model never sources the numbers or approves them.
The simulator lessontrust comes from grounding + guardrails, not model size. Levers move the score; a bigger brain does not.
Variance prompt spinerole + data + "what changed/why/outlook" + show the math + materiality threshold + flag + "not in the data".
Reconcile-triagereturn only items that do not tie, ranked by size, with a likely-cause hypothesis to check.
Always verifytick every figure against source before it reaches a board pack. You own the words and numbers.
Rail onereal pre-close figures go in enterprise or local tools only - never a consumer chatbot.
Next sessionb4 - FP&A forecasting: drivers, scenarios, and the narrative, with AI as a fast co-pilot.