A VP of Learning & Development at a 26,000-person equipment maker rebuilds FP&A's numbers before the CFO's mid-year review, with any AI chat her company allows.
An email from FP&A asking for cuts, an export with a currency column nobody read, and two short notes that change the answer.
Here the AI checks finance's numbers before you agree to cuts. The prompt asks it to show its arithmetic.
Use the AI tool your company approves: ChatGPT, Claude, Gemini or Copilot.
Copy the prompt and the four fictional inputs from the appendix into one message.
Redo the key sums yourself, then take the corrected table to FP&A before the meeting, not to the CFO.
I'm VP of Learning & Development at an industrial equipment maker with sites in the US, Brazil and India. Our fiscal year runs April to March. FP&A says we're over budget and wants an explanation or second-half cuts at the CFO's review on December 2. Below are FP&A's email, our first-half spend export, a note from our finance partner and a message from our India lead.
Please give me:
The CFO will check every number, so show your arithmetic. Check currencies, separate money spent from money committed, separate one-off costs from ongoing ones, and flag anything not yet posted. Don't add facts that aren't in the inputs.
Exactly as it came back, not edited. Read it the way Dana did: check each point against the source it cites.
No. Once Brazil is converted from reais to dollars and the unbilled academy purchase order is taken out, first-half spend is about $4.5M against a $5.5M budget. That is roughly $1.0M (18%) under budget, not $0.7M over. The $4.5M includes India's September invoices of about $0.1M, which India expects but has not yet posted. On posted figures alone, spend is $4.4M. C: posted first
Changes made
| # | Line | Change | Why | Source |
|---|---|---|---|---|
| A | Brazil plants | 1.5 → 0.3 | The 1.5 is in Brazilian reais (BRL), but the total added it as if it were US dollars. At the plan rate of BRL 5.0 = USD 1, 1.5 ÷ 5.0 = 0.3. | [2] found |
| B | Corporate leadership | 1.7 → 1.1 | 1.7 includes a $0.6M purchase order for the February 2027 academy. That money is committed but not yet invoiced, so it hasn't been spent. 1.7 − 0.6 = 1.1. | [3] found |
| C | India plants | 0.6 posted + ~0.1 not yet posted = ~0.7 | September is missing from the export. India puts it at "about $0.1M", posting next week. This is an estimate, not a posted figure. | [2], [4] found |
| D | US plants | No change to the amount (2.4) | It includes $0.5M for the LMS migration (the move to a new learning management system). That money was really spent, but it's a one-time cost that finished in July, so it's flagged here and kept out of any run-rate. | [3] found |
Corrected table
| Cost centre | Export (as shown) | Corrected spent | of which one-off | Committed, not spent | H1 budget | Variance (spent − budget) |
|---|---|---|---|---|---|---|
| US plants | 2.4 | 2.4 | 0.5 (LMS migration) | 0 | 2.5 | −0.1 |
| Brazil plants | 1.5 (BRL) | 0.3 | 0 | 0 | 0.4 | −0.1 |
| India plants | 0.6 | 0.7 (0.6 posted + ~0.1 not posted) | 0 | 0 | 0.7 | 0.0 |
| Corporate leadership | 1.7 | 1.1 | 0 | 0.6 (Feb 2027 academy) | 1.9 | −0.8 |
| Total | 6.2 | 4.5 | 0.5 | 0.6 | 5.5 | −1.0 |
Arithmetic
No. FP&A's $12.4M is 6.2 × 2: it doubles the first-half total. Each error in that total gets doubled with it. found
| Error carried into the forecast | Effect on 12.4 |
|---|---|
| Brazil counted in reais as if dollars (1.5 vs 0.3) | Overstated by 1.2 × 2 = 2.4 |
| Academy purchase order treated as spend | Overstated by 0.6 × 2 = 1.2. It's a single February 2027 event, but doubling counts it twice. |
| One-time LMS migration treated as recurring | Overstated by 0.5. It finished in July and isn't in the inputs as a second-half cost. |
| India September missing | Understated by 0.1 × 2 = 0.2 |
A corrected version of the same method is illustrative only, because it assumes the second half's ongoing spend matches the first half's:
Check: 12.4 − 2.4 − 1.2 − 0.5 + 0.2 = 8.5, plus the 0.6 commitment counted once = 9.1. The two methods agree.
What I can't confirm from the inputs:
Claude found every planted problem and showed its arithmetic. Dana's edits are about what a CFO will accept and how to keep FP&A on side.
Use it whenever finance questions your spend: a variance, a forecast, a request for cuts.
I'm the [your role] at a [industry] company with sites in [countries]. Our fiscal year runs [months]. [Finance] says we're [over budget / off forecast] and wants [what] at [the meeting] on [date]. Below are [their email, our spend export, and notes on commitments, one-off costs and anything not yet posted].
Please give me: 1. Are we really [over budget]? A two-sentence answer. 2. A corrected table in [currency], showing each change you made and why. 3. Is the full-year forecast right? If not, what's wrong with how it was worked out. 4. What I should say to [the CFO], in three or four lines.
[The CFO] will check every number, so show your arithmetic. Check currencies, separate money spent from money committed, separate one-off costs from ongoing ones, and flag anything not yet posted. Don't add facts that aren't in the inputs.
Copy the prompt, then all four inputs, into one message in a new chat. Everything here is fictional and safe to paste.
I'm VP of Learning & Development at an industrial equipment maker with sites in the US, Brazil and India. Our fiscal year runs April to March. FP&A says we're over budget and wants an explanation or second-half cuts at the CFO's review on December 2. Below are FP&A's email, our first-half spend export, a note from our finance partner and a message from our India lead. Please give me: 1. Are we really over budget? A two-sentence answer. 2. A corrected first-half table in US dollars, showing each change you made and why. 3. Is the full-year forecast right? If not, what's wrong with how it was worked out. 4. What I should say to the CFO, in three or four lines. The CFO will check every number, so show your arithmetic. Check currencies, separate money spent from money committed, separate one-off costs from ongoing ones, and flag anything not yet posted. Don't add facts that aren't in the inputs. [1] Email from Rahul Mehta, FP&A Subject: L&D mid-year review, Dec 2 Dana, L&D's first-half spend is $6.2M against a $5.5M budget, 13% over. On this run-rate the full year lands at $12.4M against $11.0M. Please explain at the Dec 2 review or bring $1.4M of second-half cuts. [2] ERP export: L&D spend, April to September (millions) | Cost centre | Currency of actual | H1 actual | H1 budget (USD) | |---|---|---|---| | US plants | USD | 2.4 | 2.5 | | Brazil plants | BRL | 1.5 | 0.4 | | India plants | USD | 0.6 | 0.7 | | Corporate leadership programmes | USD | 1.7 | 1.9 | | Total | | 6.2 | 5.5 | Plan exchange rate: BRL 5.0 = USD 1. India: September not yet posted. [3] Note from Sam Ortiz, L&D finance partner Two things in the H1 numbers: Corporate includes a $0.6M purchase order for the February 2027 leadership academy (committed, not yet invoiced). US plants includes $0.5M for the one-time LMS migration, finished in July. [4] Teams message from Priya Nair, L&D lead, India September invoices are about $0.1M. They'll post next week.I'm VP of Learning & Development at an industrial equipment maker with sites in the US, Brazil and India. Our fiscal year runs April to March. FP&A says we're over budget and wants an explanation or second-half cuts at the CFO's review on December 2. Below are FP&A's email, our first-half spend export, a note from our finance partner and a message from our India lead.
Please give me:
The CFO will check every number, so show your arithmetic. Check currencies, separate money spent from money committed, separate one-off costs from ongoing ones, and flag anything not yet posted. Don't add facts that aren't in the inputs.
Subject: L&D mid-year review, Dec 2
Dana, L&D's first-half spend is $6.2M against a $5.5M budget, 13% over. On this run-rate the full year lands at $12.4M against $11.0M. Please explain at the Dec 2 review or bring $1.4M of second-half cuts.
| Cost centre | Currency of actual | H1 actual | H1 budget (USD) |
|---|---|---|---|
| US plants | USD | 2.4 | 2.5 |
| Brazil plants | BRL | 1.5 | 0.4 |
| India plants | USD | 0.6 | 0.7 |
| Corporate leadership programmes | USD | 1.7 | 1.9 |
| Total | 6.2 | 5.5 |
Plan exchange rate: BRL 5.0 = USD 1. India: September not yet posted.
Two things in the H1 numbers: Corporate includes a $0.6M purchase order for the February 2027 leadership academy (committed, not yet invoiced). US plants includes $0.5M for the one-time LMS migration, finished in July.
September invoices are about $0.1M. They'll post next week.