# Budget vs actual report with AI: template + variance commentary

> Let formulas compute the budget vs actual report and AI draft the variance commentary: the setup, four prompts and the tie-out back to the trial balance.

- **URL**: https://www.nocodetalks.co/blog/budget-vs-actual-with-ai
- **Author**: Ankur Khandelwal, Nocodetalks
- **Updated**: Oct 7, 2026
- **Topic**: Month-end close
- **Sources checked**: 29

---

_For controllers, CAS teams and FP&A who already write the pack._ Pull the BvA from QuickBooks or Xero, let formulas flag the variances, have Claude, Copilot or ChatGPT draft comments from owners' notes, then tie every number back to the TB.

## The short answer

Let formulas do the math and AI do the wording. Run the budget vs actual report in QuickBooks Online or Xero, or put P&L actuals beside the budget in Excel, and flag lines over your threshold with a formula. Then have Claude in Excel, Copilot in Excel or ChatGPT draft commentary from the flagged lines and owners' notes in your house style, marking 'needs input' where nobody gave a reason, and tie every number back to the trial balance before it goes out.

## What you need: the report, the notes and one AI surface

Start with the report you already have. As of October 2026, QuickBooks Online Plus and Advanced run Budgets vs. Actuals, and Xero Growing and Established include budgets for its Budget Variance report. On QuickBooks Simple Start or Essentials, export Profit and Loss by Month and add a budget column.

Connectors don't replace that export yet. Intuit's QuickBooks connector and Xero's connector both read the P&L, but neither lists a budget tool, so the budget comes from your file.

| Surface | Use it for | Watch out for |
|---|---|---|
| **Claude in Excel** | Building the BvA formulas and drafting comments next to the numbers, with cell citations. | Chat history stays in your browser. Put standing rules in its Instructions field or a skill. |
| **Copilot in Excel** (edit mode) | Microsoft-only firms. It writes formulas and loads custom skills from OneDrive. | Choosing a Claude model needs a commercial Copilot or Microsoft 365 Premium license. |
| **ChatGPT for Excel** | ChatGPT teams. It ships default skills for financial modeling and finance formatting. | Duplicate the file before big edits, as OpenAI advises. |
| **Claude Project** or **Cowork folder** | Keeping owners' notes and last month's approved pack in one place. | Since October 6, 2026, Pro and Max Cowork sessions run in Anthropic's cloud. |
| **Claude for PowerPoint** | Turning approved commentary into slides that follow your slide master. | Anthropic doesn't recommend it for final deliverables without human review. |

**Files to have ready:** the BvA export, the trial balance for the same period and basis, GL detail for flagged accounts, a one-line note from each budget owner, last month's approved commentary, and your threshold rule in writing.

## Set up a budget vs actual template so formulas do the math

Ask the AI to build the formulas once. Don't have it calculate variances every month. Excel University's Claude demo has the add-in combine the actuals and budget tables with formulas, so future months update without Claude ([1:19](https://youtu.be/XnCrjcFxk4Y?t=79)).

Shin Financials adds layout rules that improve the commentary: explicit current, budget and prior-year columns, an exclude flag instead of prompt instructions, and qualitative notes on their own tab ([10:31](https://youtu.be/shNYNFFCz2g?t=631)).

| Tab | What's on it |
|---|---|
| Actuals | P&L export from QuickBooks or Xero, pasted as values |
| Budget | Approved budget by account and month |
| BvA | Account, budget, actual, $ variance, % variance, favorable or unfavorable, flag. All formulas. |
| Notes | Owner, one-line reason, timing or permanent |
| Commentary | Draft comment, reviewer, status |
| Check | Totals tied to the trial balance |

Prompt for Copilot in Excel · Build the variance table with formulas:

```
Using the [Actuals] and [Budget] tables, build a BvA table on a new tab: account, budget, actual, $ variance, % variance, favorable/unfavorable.
Use formulas only. Don't type values into calculated cells.
Show favorable variances as positive for revenue and expense accounts, and label the sign convention at the top.
Add a flag column for lines over $[AMOUNT] or [PERCENT]%. Show 'n/m' when the budget is zero.
Add a check cell: total actual net income equals [P&L net income cell].
Then list the formula patterns you used and any account you weren't sure how to classify.
```

## Draft the variance commentary from owners' notes

1. **Close first.** Run the BvA on closed books only.
2. **Collect one line per flagged account** from its owner, on the Notes tab.
3. **Draft.** Give the AI the flagged lines, the notes and last month's approved commentary as the style guide. Nothing else.
4. **Check notes against numbers.** Mike Dion's Copilot Studio agent states the dollar and percent change first, then says whether the manager's story matches ([7:36](https://youtu.be/llRedGPXBCM?t=456)). In another test, Cowork found 20 months where manager comments contradicted the P&L, and ChatGPT Work caught much the same ([6:39](https://youtu.be/RJJfqxcX3xI?t=399)).
5. **Review every comment** against GL detail, edit it and sign off.

Prompt for Claude · Draft commentary in house style:

```
Draft variance commentary for [MONTH] using only:
- flagged lines on [BvA]
- owner notes on [Notes]
- last month's approved commentary on [Commentary] as the style guide.
For each flagged line: the $ and % variance, the cause from the owner's note, timing or permanent, the outlook in dollars, and the owner. Two sentences maximum.
If there's no note, or the note doesn't explain the size of the variance, write 'needs input' and say what's missing. Never invent a cause. Never write 'timing' without saying what moved and when it reverses.
Put drafts in the Draft column. Don't overwrite reviewed comments.
```

Prompt for Any AI chat · Check owners' notes against the numbers:

```
Here are the BvA lines for [MONTH] and each owner's note: [PASTE OR ATTACH].
For each note, say whether the numbers support it: yes, partly or no.
Where a note explains less than [80]% of the variance, say how much is unexplained.
List any flagged line where a single transaction or journal entry drives most of the variance, so I can check it isn't a misposting.
Show your workings. Don't rewrite the notes.
```

**Skills you can read and adapt.** Anthropic's official finance plugin (anthropics/knowledge-work-plugins, about 27,000 stars) has a variance-analysis skill with a narrative template and a list of anti-patterns, including bare 'timing'. Anthropic's month-end-closer plugin in anthropics/financial-services (about 39,000 stars, built for financial institutions) has a variance-commentary skill that writes 'driver unclear' and flags it for the controller instead of inventing a reason. Not everyone rates them: Jason Staats says Anthropic's finance plugin reads like it was made by developers and suggests building your own ([16:11](https://youtu.be/SAGeq_LTOpg?t=971)).

**For the deck,** Claude for PowerPoint reads your slide master and builds native charts. Dion's demo goes brand first, then one BvA slide, then edits, then a nine-slide deck ([7:13](https://youtu.be/K87NNTvUOR4?t=433)). Carolina Lago switched to HTML slides from Claude Code because PowerPoint output varied from run to run ([2:50](https://youtu.be/Yeqk35K0MRg?t=170)).

## Tie the commentary back to the trial balance

None of the 62 finance AI demos in our YouTube research ties commentary, decks or dashboards back to the TB or GL. That's the step that protects you. A simple version:

1. **Workbook to TB.** Total actual revenue, expenses and net income on the BvA tab equal the trial balance for the same period and basis. A formula on the Check tab shows zero difference.
2. **Commentary to workbook.** Every number in the commentary points to a cell. Run the tie-out prompt below and fix anything that doesn't match.
3. **Cause to GL.** For each flagged line, find the transactions behind the variance in the GL detail. If one entry explains most of it, rule out a misposting before you write a cause.
4. **Reason to a person.** Each cause traces to an owner's note or a document, never to the AI alone.

Prompt for Claude · Tie-out table for the commentary:

```
Read the draft commentary on [Commentary].
List every number it states, one per row: the number as written, the cell it should come from, the value in that cell, and match yes/no. Treat rounding to the nearest $[1,000] as a match.
Then compare total revenue, total expenses and net income on [BvA] with the trial balance on [TB] and show any differences.
For each flagged line, list the five largest transactions on [GL detail] and say whether they support the stated cause.
Don't edit the commentary. Report mismatches as a list for me to fix.
```

## Faster next month

- **Save the method as a skill:** threshold, sign convention, comment format, banned phrases and the tie-out. The SKILL.md format works in Claude, ChatGPT and Copilot in Excel, though output still differs by tool. Dion's Copilot variance skill carries a rule never to guess a cause ([8:27](https://youtu.be/zCx3cE4f9yk?t=507)).
- **Keep the approved pack** as next month's style guide.
- **Keep the numbers on refresh.** Paste new actuals into the same tables and the formulas and flags update. The AI only touches the wording.

What people report
- A VP of product at an accounting firm said board packs stopped drifting once the report spec lived in a markdown file the agent reads every run. (a commenter on r/CFO (April 2026), https://www.reddit.com/r/CFO/comments/1sqxcw7/what_we_use_ai_for_in_finance/)
- FP&A teams describe putting stakeholder check-in notes in a folder Claude reads, then asking for variance drivers by department. (commenters on r/FPandA (2026), https://www.reddit.com/r/FPandA/comments/1u84k4y/are_people_using_claude_if_so_what_are_you_using/)

## Where AI fails on variance commentary

What finance people say
- AI is good at the what, like a line rising 11%, and weak on the why: who decided, what the logic was, what it means for operations. Another commenter had heard Copilot's default explanation is 'timing'. (commenters on r/FPandA (April 2026), https://www.reddit.com/r/FPandA/comments/1st2g51/how_fucked_are_we/)
- A team tested AI commentary before a board presentation and found it too surface level to present. (a commenter on r/FPandA (April 2026), https://www.reddit.com/r/FPandA/comments/1st2g51/how_fucked_are_we/)
- A controller for 12 entities said AI once wrote a convincing explanation for a variance that was really a misposting. (a commenter on r/Accounting (September 2026), https://www.reddit.com/r/Accounting/comments/1wsxh2r/where_do_you_actually_trust_ai_in_the_monthend/)
- One immaterial wrong number on a single slide sent a team back to fully manual review for a year. (a commenter on r/FPandA (2026), https://www.reddit.com/r/FPandA/comments/1wddq98/boss_more_ai_more_ai_more_ai/)
- Some analysts feel AI-written commentary devalues their role. (commenters on r/FPandA (2026), https://www.reddit.com/r/FPandA/comments/1u84k4y/are_people_using_claude_if_so_what_are_you_using/)

> 80% there means we have to audit 100% of the output
> — a commenter working in accounting, on a YouTube video about Claude in finance (2026) (https://www.youtube.com/watch?v=shNYNFFCz2g)

Plan for that review time; it's where much of the saving goes. And don't ask the AI to audit its own formulas as proof: Shin found it reported no errors while some calculations were off ([14:20](https://youtu.be/shNYNFFCz2g?t=860)).

## Data safety

Use a business or enterprise plan that doesn't train on your data. Claude for Excel and PowerPoint delete inputs on the backend within 30 days, but don't inherit custom org retention and aren't in Enterprise audit logs. OpenAI notes that Microsoft's add-in terms may let Microsoft read workbook content. Open only trusted workbooks: Anthropic warns that outside files can carry hidden instructions. Before client numbers go in, read [is Claude safe for client data](https://www.nocodetalks.co/blog/is-claude-safe-for-client-data).

## Common questions

**Can AI write budget vs actual variance commentary?**

It can draft it. Give it only the flagged lines, the owners' notes and last month's approved commentary, and tell it to write 'needs input' where no reason exists. A person who knows the business reviews and signs every line.

**Should the AI calculate the variances?**

No. Have it write the formulas once. Variances, percentages and threshold flags are spreadsheet math, and formulas get them right every month without sending the numbers to an AI again.

**Can Claude or ChatGPT pull the budget vs actual report straight from QuickBooks or Xero?**

Not fully, as of October 2026. Intuit's QuickBooks connector and Xero's connector read the P&L, but neither lists a budget tool. Run Budgets vs. Actuals in QuickBooks or Budget Variance in Xero, or export the budget, and give the AI the file.

**Which tool is best for variance commentary?**

The one inside the workbook your firm allows. Claude in Excel, Copilot in Excel and ChatGPT for Excel can all build formulas and draft comments. Reddit threads lean toward Claude, but many firms allow only Copilot, which can run Claude models with the right license.

**How do I stop the AI from blaming everything on timing?**

Ban it in your skill unless the comment says what moved and when it reverses, and make 'needs input' the default when no owner note exists.

## Sources

- [Use the Claude AI Add-In to Build Variance Reports in Excel](https://youtu.be/XnCrjcFxk4Y?t=79)
- [1 Month of Claude in Finance](https://youtu.be/shNYNFFCz2g?t=631)
- [Copilot Agents Just Replaced My Month-End Close (Here's Proof)](https://youtu.be/llRedGPXBCM?t=456)
- [I Tested ChatGPT Work Against Claude Cowork on Day One](https://youtu.be/RJJfqxcX3xI?t=399)
- [Microsoft Released Copilot Skills For Finance (No One Is Using Them)](https://youtu.be/zCx3cE4f9yk?t=507)
- [Claude For PowerPoint Just Replaced My Month-End Deck](https://youtu.be/K87NNTvUOR4?t=433)
- [Claude for finance. From Trial Balance to board report in five minutes.](https://youtu.be/Yeqk35K0MRg?t=170)
- [A Claude Cowork Guide for Accounting Firms (2026)](https://youtu.be/SAGeq_LTOpg?t=971)
- [Create budgets in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/taxation/create-import-budgets-quickbooks-online/L7SvmSAsU_US_en_US)
- [Reports included in your QuickBooks Online subscription](https://quickbooks.intuit.com/learn-support/en-us/help-article/purchase-orders/reports-included-quickbooks-online-subscription/L0s4KrGgr_US_en_US)
- [Budget Variance report](https://central.xero.com/0/article/Budget-Variance-report)
- [Pricing Plans (US)](https://www.xero.com/us/pricing-plans/)
- [QuickBooks connector (Intuit)](https://claude.com/connectors/quickbooks)
- [Xero connector](https://claude.com/connectors/xero)
- [Use Claude for Excel](https://claude.com/docs/office-agents/excel)
- [Use Claude for PowerPoint](https://claude.com/docs/office-agents/powerpoint)
- [Frequently asked questions about Copilot in Excel (edit, plan and chat modes)](https://support.microsoft.com/en-us/office/frequently-asked-questions-about-agent-mode-in-excel-1cfd906d-40b4-46be-8e2d-65b893e28a02)
- [Use skills with Copilot in Excel to complete repeatable tasks](https://support.microsoft.com/en-us/excel/copilot/copilot-in-excel-skills)
- [ChatGPT for Excel and Google Sheets](https://help.openai.com/en/articles/20001063-chatgpt-for-excel-and-google-sheets)
- [Skills in ChatGPT and Codex](https://learn.chatgpt.com/docs/build-skills)
- [What are Skills?](https://support.claude.com/en/articles/12512180-what-are-skills)
- [Use Claude Cowork on web, desktop and mobile](https://support.claude.com/en/articles/15520349-use-claude-cowork-on-web-desktop-and-mobile)
- [anthropics/knowledge-work-plugins: finance plugin, variance-analysis skill](https://github.com/anthropics/knowledge-work-plugins/tree/main/finance)
- [anthropics/financial-services: month-end-closer variance-commentary skill](https://github.com/anthropics/financial-services/tree/main/plugins/agent-plugins/month-end-closer)
- [how fucked are we?](https://www.reddit.com/r/FPandA/comments/1st2g51/how_fucked_are_we/)
- [Where do you actually trust AI in the month-end close process?](https://www.reddit.com/r/Accounting/comments/1wsxh2r/where_do_you_actually_trust_ai_in_the_monthend/)
- [Boss: MORE AI MORE AI MORE AI](https://www.reddit.com/r/FPandA/comments/1wddq98/boss_more_ai_more_ai_more_ai/)
- [Are people using Claude? If so, what are you using it for?](https://www.reddit.com/r/FPandA/comments/1u84k4y/are_people_using_claude_if_so_what_are_you_using/)
- [What we use AI for in Finance](https://www.reddit.com/r/CFO/comments/1sqxcw7/what_we_use_ai_for_in_finance/)