# AI in finance: a CFO's 90-day playbook for Claude, Copilot and ChatGPT

> Pilot AI on 2 structured workflows first, such as variance commentary, with a person signing off. Connect read-only, measure review time, decide at day 90.

- **URL**: https://www.nocodetalks.co/blog/ai-in-finance-cfo-playbook
- **Author**: Ankur Khandelwal, Nocodetalks
- **Updated**: Oct 19, 2026
- **Topic**: Cash & CFO
- **Sources checked**: 55

---

_A playbook for CFOs and finance leads._ Where AI earns its keep in close, commentary, forecasts and board packs, which Excel AI to pick, the controls to set, and a 90-day rollout with prompts you can copy.

## The short answer

Start with 2 pilots where the work is already structured, such as close prep, flux and budget-vs-actual commentary drafts, forecast builds or board-pack drafts, done in Excel with Claude, Copilot or ChatGPT and signed off by a person. In 12 AI month-end videos we timed, none showed a tie-out with the numbers on screen, so pilot the drafting and keep people on the checks. Pick the tool security will approve, connect it read-only, lock recurring work into templates or skills, and measure the whole process including review. Never let it post entries or own an untraced number.

## Where AI in finance pays off now, and where it's hype

In the demos and threads I read, AI pays off when inputs are structured and a person reviews the output. It disappoints when it owns a judgment or runs unattended.

| Work | Works now | Still hype or risky |
|---|---|---|
| Close | Prep: flagging balances over a threshold, suggesting matches, drafting recurring JEs for review | A "fully automated close". Accruals, cutoff, or posting without review |
| Flux and budget vs actual | First-draft commentary from a structured workbook, with formulas built once and reused | Explaining why a number moved without owner notes. It can rationalize a misposting |
| Forecasting | Building a 13-week or driver model, running stress cases, auditing inputs | Accepting its assumptions unchallenged |
| Board packs | Drafting slides and narrative from approved numbers | Regenerating the deck each month. Layouts change run to run |
| AP and AR | Drafting collection emails, suggesting codes from history | Paying bills or payroll with no approval step |
| Analysis in Excel | Cleaning exports, writing formulas, explaining inherited models | An AI review that says every formula is fine |

Excel University has Claude build the variance formulas, so next month doesn't need AI at all ([video @6:00](https://youtu.be/XnCrjcFxk4Y?t=360)). Luke Finance tells Claude to separate what the files prove from what it infers ([video @4:20](https://youtu.be/araz7e2DzX8?t=260)). Carolina Lago dropped AI-made PowerPoint because two runs gave different decks ([video @2:50](https://youtu.be/Yeqk35K0MRg?t=170)). Shin Financials says AI formula reviews always came back clean, yet mistakes turned up later ([video @14:20](https://youtu.be/shNYNFFCz2g?t=860)).

What finance people report
- When marketing sold an executive on AI running the whole month-end, replies said the executive had been oversold, and one finance leader called fully automating the close irresponsible. (commenters on r/Accounting (Sep 2026), https://www.reddit.com/r/Accounting/comments/1wd13dl/ai_automation_to_close_monthend/)
- A commenter who ran close for a 12-entity group says AI handled the boring 80%, but once explained a misposting as a real variance. They keep it away from accruals and cutoff. (a commenter on r/Accounting (Sep 2026), https://www.reddit.com/r/Accounting/comments/1wsxh2r/where_do_you_actually_trust_ai_in_the_monthend/)
- An FP&A analyst says Claude flipped their time from 90% building files, 10% conversations to the reverse. (a commenter on r/FPandA (Jul 2026), https://www.reddit.com/r/FPandA/comments/1ulcmjf/fpa_and_claude/)

## What do AI close demos show, and what do finance teams struggle with?

The 12 AI month-end videos we timed run 142 minutes in all. About 42 of those minutes go to building the reporting pack after the books are closed, and about 20 to variance commentary. In 2,483 YouTube comments on month-end videos, the problems people raise most come earlier: numbers that don't tie, accruals and cutoff, and not knowing how to review a close.

| Rank | Where the 12 AI videos spend their time | What commenters raise most |
|---|---|---|
| 1 | Building the reporting pack after the close (deck, dashboard, memo): about 42 min, 4 videos | Things don't tie, and people can't find why: about 30 + 30 + 16 comments. No video shows it |
| 2 | Writing variance commentary: about 20 min, 6 videos | Accruals and cutoff wrong in both directions: about 27. Partly shown: entries booked, amounts never sourced |
| 3 | Refreshing the monthly report by hand: about 16 min, 1 creator | Can make it balance, can't review it: about 18. Not shown |
| 4 | Getting the same output every month: about 13 min | AI output needs a full audit before anyone trusts it. Mentioned, never solved |
| 5 | Booking missed month-end entries: about 8 min, 2 creators | No close process or checklist: about 23 + 23. One video runs 3 checks |
| 6 | Gathering the close inputs: about 6.5 min, 1 creator | Processor deposits don't match sales: about 16. Not shown |

**What none of the 12 shows:**

- QuickBooks or Xero as the ledger. One video connects Claude to Zoho Books; the rest work from files.
- A bank-to-ledger or subledger-to-GL tie-out with the numbers on screen.
- A person checking an AI-written figure against its source. "Verification" means the AI checking itself or a quick visual skim.

Only one of the 12 applies a materiality threshold: an exception report of variances over $1,000 or 10% ([Excel University @5:16](https://youtu.be/XnCrjcFxk4Y?t=316)). The prompt that set it isn't shown, so you can't tell whether the person or Claude chose it.

One video closes a coffee shop's month with Claude posting straight into the ledger. It ends on a final P&L with $173,116 of net income, from a month of 19 bank transactions, and nobody questions the number ([Mike Dion @10:23](https://youtu.be/UP8jzq5mvJ0?t=623)).

**The rule we take from this:** pilot AI where the work is structured and a person reviews it, like the pack and the commentary. Don't buy a demo's promise for the steps no demo shows: tie-outs, accruals and cutoff, and review. Ask any vendor to run those on your own books, with the numbers on screen.

> Note: **How we measured.** Nocodetalks research, October 2026. We read the auto-captions of 12 creator videos from 2026 on AI and the month-end close, variance reports and bank recs (listed in sources), and timed each topic from the timestamps. Minutes are rough and topics overlap. On October 11, 2026 we pulled 12,754 comment threads from 166 month-end videos with the YouTube Data API, then read the 2,483 top-level comments on the 61 relevant ones by hand. Counts are approximate tallies from three groups of videos: controller and close, QuickBooks close and reconciliation, and variance analysis. Limits: commenters are mostly students, small-business owners and bookkeepers, many outside the US, not US finance teams. The 12 AI videos themselves had 0 to 8 comments each, except one with 269.

## Copilot vs Claude vs ChatGPT in Excel

All three now edit workbooks directly. Often the deciding factor is what IT will approve.

|  | Claude for Excel | Copilot in Excel | ChatGPT for Excel |
|---|---|---|---|
| Plans | Pro, Max, Team, Enterprise | Commercial Microsoft 365 Copilot, M365 Premium, or eligible business plans | All ChatGPT plans since May 5, 2026 |
| Strengths | Cell-level citations; keeps formulas intact; connectors and skills in the sidebar | Inside your Microsoft tenant; choose Claude or GPT models; custom skills stored in OneDrive | Links answers to cells; asks permission before editing |
| Watch | No macros, VBA or data tables. Not in Enterprise audit logs; the Compliance API covers it (beta) | Choosing a model needs a commercial Copilot license or M365 Premium | Off by default in Enterprise workspaces until an admin enables it |

In Josh Aharonoff's same-prompt test, Claude came first, Copilot second and ChatGPT last. He sells a competing add-in, used plain ChatGPT rather than its add-in, and ran Copilot on a free plan ([video @14:35](https://youtu.be/lfPcIQbEfac?t=875)).

**If your company only allows Copilot,** use it well rather than routing around it. On a commercial license, pick a Claude model and keep recurring instructions in Copilot skills. Finance subs are blunt: the top comment in one r/Accounting thread, with over 600 upvotes, calls Copilot the weakest assistant. But when an accountant admitted running client files through personal Claude, a reply with 160 upvotes asked whether IT had approved it. Shadow AI is the bigger risk.

## The connector and skill stack by team size

| Team | Assistant | Connect first, read-only | Skills and templates |
|---|---|---|---|
| Founder-led, 1 to 3 people on QuickBooks or Xero | Claude or ChatGPT; a Team or Business plan once a second person uses company data | QuickBooks or Xero, Stripe, your bank or card platform (Mercury, Ramp, Brex) | [Anthropic's small-business plugin](https://github.com/anthropics/knowledge-work-plugins/tree/main/small-business) (cash-flow-snapshot, close-month); [Intuit's QuickBooks plugin](https://github.com/intuit/quickbooks-claude-plugin) |
| Controller-led team on NetSuite | Claude Team or Enterprise, or ChatGPT Business or Enterprise | NetSuite's AI connector on a dedicated non-admin role; spend and payroll systems | [Anthropic's finance plugin](https://github.com/anthropics/knowledge-work-plugins/tree/main/finance) (close, variance analysis, SOX testing); [Oracle's NetSuite finance-analyst plugin](https://github.com/oracle/netsuite-suitecloud-sdk/tree/ai-plugins-dist/anthropic/netsuite-finance-analyst) |
| Microsoft-only company | Copilot in Excel with a Claude or GPT model | Your Microsoft 365 files, which Copilot can search | Custom Copilot skills for variance review and forecasts |

The plugins in that table are open source. In Claude Code, add Anthropic's marketplace once with `claude plugin marketplace add anthropics/knowledge-work-plugins`. Intuit's and Oracle's come from Anthropic's official directory, claude-plugins-official. In Cowork, install them from [claude.com/plugins](https://claude.com/plugins/).

| Plugin | Install in Claude Code | Notes (Oct 19, 2026) |
|---|---|---|
| [finance](https://github.com/anthropics/knowledge-work-plugins/tree/main/finance), by Anthropic | `claude plugin install finance@knowledge-work-plugins` | ~30.3k stars (whole repo), Apache-2.0. Skills include close-management, variance-analysis and sox-testing |
| [small-business](https://github.com/anthropics/knowledge-work-plugins/tree/main/small-business), by Anthropic | `claude plugin install small-business@knowledge-work-plugins` | Same repo. Skills include cash-flow-snapshot, close-month and month-end-prep |
| [intuit-quickbooks](https://github.com/intuit/quickbooks-claude-plugin), by Intuit | `/plugin install intuit-quickbooks@claude-plugins-official` | 0 stars, Apache-2.0, new official repo. Needs the QuickBooks connector; skills that write ask you first |
| [netsuite-finance-analyst](https://github.com/oracle/netsuite-suitecloud-sdk/tree/ai-plugins-dist/anthropic/netsuite-finance-analyst), by Oracle | `/plugin install netsuite-finance-analyst@claude-plugins-official` | ~357 stars (whole SuiteCloud SDK repo), UPL-1.0. Needs the NetSuite AI Connector Service |

For the first row, founder-led teams on QuickBooks Online and Stripe, there's also my free [month-end-review skill](https://www.nocodetalks.co/skills/month-end-review). It ties out the month, then drafts the variance commentary and an investor update with every number traced. It's read-only.

> Note: As of October 2026, Sage Intacct isn't in the Claude or ChatGPT connector directories. Gusto's Claude connector can run payroll, so keep payroll writes behind manual approval. More: [QuickBooks MCP vs Claude skills](https://www.nocodetalks.co/blog/quickbooks-mcp-vs-claude-skills-vs-custom-integration).

## Governance: plans, permissions, sign-off and audit trail

- **Business plans for company data.** Claude Team or Enterprise and ChatGPT Business or Enterprise don't train on your data by default.
- **Read-only first.** On Claude Team and Enterprise, an owner enables each connector for the org, and each person still signs in. Start read-only and set write actions to ask, as Jason Staats shows ([video @1:32](https://youtu.be/Yv51xj_1DOQ?t=92)).
- **A named reviewer signs.** AI output is a draft until a person ties it out. Mike Dion's rule: "Claude explains, you decide. Claude proposes, you approve." ([video @9:26](https://youtu.be/ksq1ZsNxvwE?t=566))
- **Keep the evidence.** File the prompt, input version, output and sign-off with the workpaper. Claude for Excel activity isn't in Enterprise audit logs, though the Compliance API covers it.
- **Mind the cloud change.** Since October 6, 2026, new Cowork tasks on Pro and Max run in Anthropic's cloud. Anthropic advises against giving Cowork sensitive financial files or scheduling tasks that touch them. For local-only work it points to Claude Code in the desktop app.
- **Keep AI out of SOX key controls until your auditor agrees.** Anthropic says Claude for Excel isn't recommended for audit-critical calculations without verification. Treat AI-built workbooks like any end-user spreadsheet: documented, reviewed, change-controlled.

> Note: This is general guidance, not audit or legal advice. Agree the SOX treatment with your external auditor. Plans and settings in detail: [Is Claude safe for client data?](https://www.nocodetalks.co/blog/is-claude-safe-for-client-data)

## Where do the close-time numbers AI quotes come from?

14 of 23 AI answers we collected to "Can AI automate the month-end close?" put a number of days on it. Every one of those 14 cited a page from a company that sells finance software. We asked ChatGPT, Claude, Perplexity and Google every day for six days, then opened the pages they cited.

| What the answer said | Engine (days, of 6) | The cited page behind it | Who publishes it |
|---|---|---|---|
| A 6 to 10 day close drops to 3 to 5 days | Claude (5), Perplexity (3) | [Datarails' blog](https://www.datarails.com/ai-powered-month-end-close/): "replace a 6-10 day manual close with a 3-5 day AI-assisted one" | Datarails, which sells FP&A software |
| Over 10 days down to 3 to 5, with 99% accuracy | ChatGPT (4) | Maximor's product page. By October 19 the link redirected to another company's page without those figures | The product's maker |
| Up to 10 times faster, or 70% faster | ChatGPT (4) | [FINA's month-end page](https://fina.team/month-end), which also says 3x faster and gives no method | The product's maker |
| 8 to 10 days down to 1 to 3 | Google (2) | [Nominal](https://nominal.so/blog/month-end-close-automation/) puts the usual close at 8 to 10 business days; [Upflow](https://upflow.io/blog/cfo-reads/month-end-close) says top teams close in 1 to 3. Neither page makes the whole claim | Two finance software vendors |
| A close 7.5 days shorter | Claude (2) | Claude cited blog pages, not the study. The figure traces to a Stanford and MIT study of 79 firms ([MIT Sloan](https://mitsloan.mit.edu/ideas-made-to-matter/how-generative-ai-can-make-accountants-more-productive)) | Academic researchers working with a maker of AI accounting software |

Claude repeated Datarails' sentence almost word for word on three days. Google's other four answers said "weeks to just a few days". The only research behind any figure is the 7.5-day study, which its authors call early evidence.

Whether a person stays in the loop depends on which engine you ask. Claude (6 of 6 answers) and Perplexity (5 of 5) said a person stays in charge of review, judgment or sign-off. ChatGPT's six answers listed vendors and their claims, with no human reviewer in the text we saved. Google's overview twice said close automation handles routine tasks "with minimal human help".

So set your target from your own baseline, measured as in the [next section](#roi-and-cost). In our sample, every answer that gave a range of days was repeating a software vendor's figure.

> Note: **How we measured.** Nocodetalks research, October 2026. From October 8 to 13 we sent the same question to ChatGPT (gpt-4o-mini, web search forced on), Claude (claude-sonnet-4-5, web search on) and Perplexity (sonar) through DataForSEO's [LLM Responses API](https://docs.dataforseo.com/v3/ai_optimization/chat_gpt/llm_responses/live/), and pulled Google's AI Overview with its [SERP API](https://docs.dataforseo.com/v3/serp/google/organic/live/advanced/). Google got the short keyword "month end close automation"; the others got the full question. 23 of 24 calls worked (one Perplexity call failed). We saved only the first 1,500 characters of each answer, so a caveat further down may be missing. We opened the cited pages on October 19, 2026, and pages change. Six days and one question is a small sample.

## Measure ROI honestly and budget for tokens

Time the whole process, not the step AI touched. Checking time eats the savings, and finance subs repeat that the work moves rather than shrinks.

> which half do you think has been automated?
> — a commenter on r/FPandA (Sep 2026) (https://www.reddit.com/r/FPandA/comments/1wddq98/boss_more_ai_more_ai_more_ai/)

1. **Baseline two cycles before AI.** Hours for prep, review and rework, plus errors found after review.
2. **Measure the same after.** Count corrections per output. If review takes as long as doing the work, redesign or stop.
3. **Redesign the whole process.** Approvals and handoffs don't speed up because one task did.
4. **Budget usage like any other spend.** Claude Team and seat-based Enterprise owners can set org-wide and per-member monthly spend limits. Run big jobs overnight, restart long chats from a summary, and default to a smaller model.

**If you hire someone to build it,** posted budgets are low and the field is crowded. In 30 finance-automation posts we checked on Upwork, the median fixed budget was $500 and the median top hourly rate was $30. Half drew 50 or more proposals. A fractional CFO firm posted [Developer - Finance Automation & AI](https://www.upwork.com/jobs/~022105179039826346045) at $15–30 an hour; a UK outsourced finance firm posted [AI/Claude Implementation Specialist](https://www.upwork.com/jobs/~022104277794399685044) at $30–80. At those budgets you're buying a build, so budget the review and upkeep hours too.

> Note: **How we measured.** Nocodetalks research, October 9, 2026. 20 Upwork searches returned 655 unique posts; we kept 30 that build automation, integrations, AI or dashboards for finance work. Medians use the 11 fixed-price posts and the 13 hourly posts that showed a rate. Proposal counts come from each post's public activity panel, which tops out at 50+. A snapshot of one marketplace, not market data.

What finance teams report on time and cost
- One team's close didn't get shorter: AI flagged more variances, so review meetings ran an hour longer. (a commenter on r/CFO (Sep 2026), https://www.reddit.com/r/CFO/comments/1wfvuhk/is_ai_actually_freeing_up_finance_teams_or_just/)
- After one immaterial wrong number on a single AI-built slide, a team went back to manual review of everything for a year. (a commenter on r/FPandA (Sep 2026), https://www.reddit.com/r/FPandA/comments/1wddq98/boss_more_ai_more_ai_more_ai/)
- A company that pushed AI hard later added token caps and cut frontier-model access. Replies advise having AI build scripts and Power Query you keep either way. (commenters on r/FPandA (Jun 2026), https://www.reddit.com/r/FPandA/comments/1tym2nb/i_was_told_ai_was_going_to_take_my_job_now_my/)
- In a cost thread, FP&A users report usage from tens of dollars a month for light users to a few hundred for heavy ones, on top of seats. (commenters on r/FPandA (Apr 2026), https://www.reddit.com/r/FPandA/comments/1t015hs/claude_ai_cost/)

## Train the team without losing juniors' judgment

If AI does the entry-level reps, who learns to spot a bad journal entry? Jason Staats' answer: juniors build expertise by supporting and reviewing the AI's work ([video @32:30](https://youtu.be/WlrRhDMhMGs?t=1950)).

- Juniors write the variance explanation first, then compare it with the AI draft.
- Juniors tie out a sample by hand every month.
- Teach one AI technique for 15 minutes a week, as Inbal Rodnay suggests ([video @5:11](https://youtu.be/yVOc7XE_QV4?t=311)).
- Reward catching AI errors, not just speed.

## A 90-day AI rollout plan for a finance team

Two pilots, three phases. Each prompt sits under the step that uses it, with a sample of what comes back. All sample data is fake.

### Step 1: Score your workflows and pick two pilots (days 1 to 30)

Liam Ottley's firm rebuild scored each workpaper by frequency, duration and difficulty ([video @1:37](https://youtu.be/IXDYEF22CG8?t=97)). Do the same for your recurring work, and keep anything that rests on judgment out of the first round.

Prompt for Any AI chat · Pick the first two pilots:

```
I'm choosing where to pilot AI in our finance team. Our recurring workflows, with frequency, hours per cycle and reviewer:
[PASTE LIST]
1. Convert each to hours a month. Score each 1 to 5 on time saved if AI drafts it, how structured the inputs are, and risk if an error slips through (5 = highest risk).
2. Recommend two pilots with the most time and structure and a risk of 3 or less.
3. For each pilot, list the inputs, the human review step, what AI must never do (post entries, send emails, pay anything), and how we'll measure time including review.
Show your reasoning and list what you had to assume.
```

Example output · Scores:

| Workflow | Hours a month | Time saved | Structure | Risk | Call |
|---|---|---|---|---|---|
| Budget vs actual commentary | 6.0 | 4 | 5 | 2 | Pilot |
| 13-week cash update (weekly) | 8.7 | 4 | 4 | 3 | Pilot |
| Balance sheet flux review | 5.0 | 3 | 4 | 2 | Next |
| AR collection emails (weekly) | 6.5 | 4 | 3 | 3 | Next |
| Month-end accruals | 4.0 | 2 | 2 | 5 | No |
| Board pack narrative (quarterly) | 4.0 | 3 | 3 | 4 | No |

_Fake data. Weekly work is hours × 52 ÷ 12; the quarterly pack is 12 hours ÷ 3._

Example output · Pilots:

```
Pilot 1: budget vs actual commentary. Time 4 + structure 5, risk 2.
Inputs: the BvA export and owner notes. Review: the controller ties totals to the TB and edits every line. Never: post entries or send the pack. Measure: prep, review and rework hours against 6.0 a month.

Pilot 2: 13-week cash update. Time 4 + structure 4, risk 3.
Inputs: bank balances, AR and AP aging. Review: opening cash checked to the bank. Never: move money or send it to the lender. Measure: against 8.7 hours a month.

Assumed: your list names no reviewer for the cash update, so I left it blank. Accruals score risk 5 because they rest on cutoff judgment.
```

_Fake data. Scores are judgment calls; change any you'd score differently._

### Step 2: Protect the data and record a baseline (days 1 to 30)

Pick the plan, write a one-page policy and connect read-only ([governance](#governance)). Then record each pilot's hours for prep, review and rework, and errors found after review, for the last two cycles ([how to measure](#roi-and-cost)).

### Step 3: Run each pilot once, formulas first (days 31 to 60)

Do each workflow interactively and ask for formulas rather than values, so next month's math doesn't need AI. Task guides: [budget vs actual](https://www.nocodetalks.co/blog/budget-vs-actual-with-ai), [flux](https://www.nocodetalks.co/blog/flux-analysis-with-ai), [13-week cash](https://www.nocodetalks.co/blog/13-week-cash-flow-forecast-with-ai).

Prompt for Claude · Variance commentary with a tie-out:

```
Use the [BvA] tab in this workbook. Don't change source tabs.
1. On a new Variance tab, build actual, budget, $ variance (actual minus budget) and % variance (of budget) with formulas, not values. Add F or U: revenue above budget or costs below it is F.
2. Flag lines over [$X] or [Y%].
3. Draft one line per flagged item: the number first, then the driver. Use only the owner notes in [Notes]. Label each driver 'confirmed by notes' or 'inferred'. Where notes are missing, write 'ask [owner]'.
4. Add a tie-out table: revenue, expenses and net income vs the [TB] tab, with any differences.
List anything you're unsure about. This is a draft for my review.
```

Example output · Variance:

| Line | Actual | Budget | $ var | % var | F/U |
|---|---|---|---|---|---|
| Revenue | 412,600 | 430,000 | -17,400 | -4.0% | U, flagged |
| Cost of revenue | 61,900 | 55,000 | 6,900 | 12.5% | U, flagged |
| Payroll and benefits | 238,400 | 241,000 | -2,600 | -1.1% | F |
| Software | 18,750 | 14,000 | 4,750 | 33.9% | U, flagged |
| Marketing | 22,300 | 35,000 | -12,700 | -36.3% | F, flagged |
| Rent | 14,500 | 14,500 | 0 | 0.0% |  |
| Net income | 56,750 | 70,500 | -13,750 | -19.5% | U, flagged |

_Fake data for September 2026, flagged at $10,000 or 10%. In the workbook, row 2's $ var is =B2-C2 and its % var is =D2/C2, and so on down._

Example output · Commentary:

```
Revenue -17,400 (-4.0%) U. Two annual renewals slipped to October. Confirmed by notes.
Cost of revenue +6,900 (+12.5%) U. AWS usage up during the data migration. Inferred: the note says 'migration' with no amount. Ask the VP Engineering.
Software +4,750 (+33.9%) U. Three annual licenses renewed in September. Confirmed by notes.
Marketing -12,700 (-36.3%) F. The trade show moved to Q4. Confirmed by notes.
Net income -13,750 (-19.5%) U, mostly the revenue timing.

Unsure: see Tie-out. Expenses don't tie, so treat these lines as a draft until that's fixed.
```

_Fake data. Every driver traces to a note or says it doesn't._

Example output · Tie-out:

| Total | Variance tab | TB tab | Difference |
|---|---|---|---|
| Revenue | 412,600 | =-SUMIFS(TB!C:C,TB!B:B,"Revenue") | 0 |
| Expenses | 355,850 | =SUMIFS(TB!C:C,TB!B:B,"Expense") | -1,200 |
| Net income | 56,750 | =C2-C3 | 1,200 |

```
Expenses are 1,200 below the TB. Account 6150 Bank fees has a balance on the TB but no line on the BvA tab. Map it, then rerun.
```

_Fake data. The TB tab is Account, Type, Balance, with credits negative, so revenue is flipped. The TB side computes to 412,600, 357,050 and 55,550._

### Step 4: Save the run as a skill (days 31 to 60)

Write the steps down while the run is fresh. Claude reads a SKILL.md file, and Copilot in Excel reads the same format from a OneDrive skills folder.

Prompt for Claude · Turn this month's run into a skill:

```
We just ran this month's [process] together. Write it up as a SKILL.md another analyst can run next month:
- inputs (file names, tabs, columns) and where they come from
- steps in order, with the formulas or checks used
- tie-out checks that must pass before any output
- output format (layout, rounding, headings)
- hard rules: never post entries, never send anything, flag rather than guess
Then list every step where you made a judgment call, so I can set the rule. Show me the file before you save it.
```

Example output · SKILL.md:

```
---
name: monthly-bva-commentary
description: Builds the Variance tab with formulas, ties it to the TB and drafts
  commentary for flagged lines. Use for the monthly budget vs actual pack.
---
# Monthly budget vs actual commentary
Inputs, one workbook from the close folder:
- BvA tab: Account, Line, Actual, Budget (the ERP's budget vs actual report)
- TB tab: Account, Type, Balance (trial balance, same period)
- Notes tab: Line, Owner, Note
Steps:
1. Variance tab: $ var = Actual - Budget, % var = $ var / Budget. Formulas only.
2. Flag lines over $10,000 or 10%.
3. Tie out revenue, expenses and net income to the TB. Any difference: stop and list it.
4. One line per flagged item: number first, then driver, labeled
   'confirmed by notes' or 'inferred'. No note: write 'ask [owner]'.
Output: whole dollars, % to one decimal, F or U last.
Never post entries, send anything, or invent a driver.
```

_Example for a fake company. Yours names your own files, tabs and thresholds._

Example output · Judgment calls:

```
Set a rule for each:
1. 6150 Bank fees was on the TB but not on the BvA tab. Should a new TB account always stop the run?
2. I called the AWS driver 'inferred' because the note had no amount. Does a note need a number to count as confirmed?
3. I rounded to whole dollars. Your board pack uses thousands. Which one?
```

_Fake data. Each answer becomes a line in the skill._

### Step 5: Add a read-only model review (days 61 to 90)

Run the second cycle from the skill. Then try a low-risk third use: a review that changes nothing, before the board sees the model.

Prompt for Copilot in Excel · Review a model before the board sees it:

```
Review this workbook before it goes to the board. Don't change anything.
Return an issue log: rank, sheet and cell, issue, impact, suggested fix.
Check for hardcoded numbers inside formulas, totals that don't foot, links to other files, inconsistent signs, and inputs that differ from the [Assumptions] tab.
Rank issues by impact on [cash / EBITDA / covenant test], in dollars where you can. List the cells you couldn't check, and say where you're unsure rather than guessing.
```

Example output · Issue log:

| # | Cell | Issue | Cash is | Fix |
|---|---|---|---|---|
| 1 | Forecast!H14 | 8% typed in; Assumptions!C6 says 6% | 25,000 high | =G14*(1+Assumptions!C6) |
| 2 | Cash!D40 | Total skips row 39, loan interest | 18,400 high | =SUM(D30:D39) |
| 3 | Opex!F22 | Rent credit entered as +4,200 | 8,400 low | Enter -4,200 |
| 4 | Covenant!C8 | Links to [Budget_v3.xlsx]Debt!B12 | Not measured | Paste it on Assumptions |

_Fake model, ranked by cash impact._

Example output · Notes:

```
1. H14 is =G14*1.08. At 6% instead of 8%, G14's $1,250,000 gives $25,000 less Q4 revenue, and less cash.
3. Costs are positive on Opex, so the credit should be -4,200. As entered, costs are $8,400 too high. Check the sheet's other credits.
4. Paste the linked value on Assumptions with its source and date.

Couldn't check: Covenant!C8, because Budget_v3.xlsx isn't open.
Unsure: Assumptions!C6 is labeled FY2027 growth. If Q4 sits in FY2026, the 8% may be intended. Ask the model's owner before you change it.
```

_Fake data. A clean log isn't proof the model is right._

### Step 6: Keep, fix or stop each pilot (day 90)

Compare both cycles with the baseline, review time included. Schedule only what passed a test run.

| After two cycles | Call |
|---|---|
| Hours down, review included, and corrections falling | Keep. Put the skill and the policy into onboarding |
| Hours down, but corrections aren't falling | Fix the inputs or the skill, then run two more cycles |
| Review takes as long as doing the work | Stop, or redesign the process around the review |
| An error got past review | Pause. Add the check that would have caught it, then rerun |

## Common questions

**Is Claude better than Copilot for finance work?**

Most finance users in Reddit threads who've tried both say so, and one same-prompt test agreed. But Copilot can run Claude models on a commercial license and already sits inside your Microsoft controls. Pick what security approves, then test it on your own workbook.

**Can AI close the books?**

Not on its own. It can prep, flag and draft. Accruals, cutoff, posting and sign-off stay with people. In 12 AI month-end videos we timed, none showed a tie-out with the numbers on screen.

**How much faster does AI make the month-end close?**

Chatbots often say a 6 to 10 day close drops to 3 to 5 days. In our six days of tracking, every answer that gave a range of days was repeating a software vendor's page. The one research figure, a close 7.5 days shorter, comes from an early study of 79 small and midsize firms. Measure your own baseline instead.

**What does AI cost a finance team?**

Seats plus usage, which varies widely by person. Set org-wide and per-person spend limits and watch usage by person for the first two months.

## Sources

- [Use Claude for Excel](https://claude.com/docs/office-agents/excel)
- [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)
- [Custom skills in Copilot in Excel](https://support.microsoft.com/en-us/excel/copilot/copilot-in-excel-skills)
- [Introducing ChatGPT for Excel and new financial data integrations](https://openai.com/index/chatgpt-for-excel/)
- [Use Claude Cowork on web, desktop and mobile](https://support.claude.com/en/articles/15520349-use-claude-cowork-on-web-desktop-and-mobile)
- [Use Claude Cowork safely](https://support.claude.com/en/articles/13364135-use-claude-cowork-safely)
- [Manage usage credits for Team and seat-based Enterprise plans](https://support.claude.com/en/articles/12005970-manage-extra-usage-for-team-and-seat-based-enterprise-plans)
- [Use connectors to extend Claude's capabilities](https://support.claude.com/en/articles/11176164-use-connectors-to-extend-claude-s-capabilities)
- [AI tooling for US finance work: a checked map (October 2026)](https://github.com/anthropics/knowledge-work-plugins/tree/main/finance)
- [Gusto connector](https://claude.com/connectors/gusto)
- [Use the Claude AI Add-In to Build Variance Reports in Excel, Excel University](https://youtu.be/XnCrjcFxk4Y?t=360)
- [Claude For CFOs: 3 INSANE Use Cases, Luke Finance. Sponsored video (Higgsfield)](https://youtu.be/araz7e2DzX8?t=260)
- [Claude for finance. From Trial Balance to board report in five minutes, Carolina Lago](https://youtu.be/Yeqk35K0MRg?t=170)
- [1 Month of Claude in Finance, Shin Financials](https://youtu.be/shNYNFFCz2g?t=860)
- [I Asked 4 AI Excel Tools to Build a Financial Model. Only One Passed, Josh Aharonoff (Your CFO Guy). Creator sells a competing add-in](https://youtu.be/lfPcIQbEfac?t=875)
- [Claude Cowork Ran My Accounting Firm's Email Inbox, Jason Staats. Sponsored video (Missive)](https://youtu.be/Yv51xj_1DOQ?t=92)
- [I Tested Claude in Excel on My Messiest Spreadsheet, Mike Dion (AI For Finance). Creator promotes a newsletter](https://youtu.be/ksq1ZsNxvwE?t=566)
- [AI Just Changed How We Should Run Our Accounting Firms, Accounting Firm Coach: Office Hours (Jason Staats). Sponsored episode](https://youtu.be/WlrRhDMhMGs?t=1950)
- [What the new Xero and Claude integration actually does (and doesn't do), Inbal Rodnay. Creator promotes a paid club](https://youtu.be/yVOc7XE_QV4?t=311)
- [I Rebuilt This 46-Person Accounting Firm With AI (in 4 Days), Liam Ottley. Sponsored video (Kylon)](https://youtu.be/IXDYEF22CG8?t=97)
- [AI automation to close month-end (thread)](https://www.reddit.com/r/Accounting/comments/1wd13dl/ai_automation_to_close_monthend/)
- [Where do you actually trust AI in the month-end close process? (thread)](https://www.reddit.com/r/Accounting/comments/1wsxh2r/where_do_you_actually_trust_ai_in_the_monthend/)
- [FP&A and Claude (thread)](https://www.reddit.com/r/FPandA/comments/1ulcmjf/fpa_and_claude/)
- [Excel has force added copilot... (thread)](https://www.reddit.com/r/Accounting/comments/1tjo3i4/excel_has_force_added_copilot_tried_using_it_to/)
- [Am I crazy or is Claude's own plug-in in Excel just better than Copilot's Claude model (thread)](https://www.reddit.com/r/Accounting/comments/1ssdawn/am_i_crazy_or_is_claudes_own_plugin_in_excel_just/)
- [Boss: MORE AI, MORE AI, MORE AI (thread)](https://www.reddit.com/r/FPandA/comments/1wddq98/boss_more_ai_more_ai_more_ai/)
- [is AI actually freeing up finance teams, or just moving the work around? (thread)](https://www.reddit.com/r/CFO/comments/1wfvuhk/is_ai_actually_freeing_up_finance_teams_or_just/)
- [I was told AI was going to take my job, now my company is taking AI away from me (thread)](https://www.reddit.com/r/FPandA/comments/1tym2nb/i_was_told_ai_was_going_to_take_my_job_now_my/)
- [Claude AI - Cost (thread)](https://www.reddit.com/r/FPandA/comments/1t015hs/claude_ai_cost/)
- [Is my data used for model training?](https://privacy.claude.com/en/articles/7996868-is-my-data-used-for-model-training)
- [anthropics/knowledge-work-plugins](https://github.com/anthropics/knowledge-work-plugins)
- [intuit/quickbooks-claude-plugin](https://github.com/intuit/quickbooks-claude-plugin)
- [oracle/netsuite-suitecloud-sdk: anthropic/netsuite-finance-analyst (branch ai-plugins-dist)](https://github.com/oracle/netsuite-suitecloud-sdk/tree/ai-plugins-dist/anthropic/netsuite-finance-analyst)
- [anthropics/claude-plugins-official](https://github.com/anthropics/claude-plugins-official)
- [Claude Skills for Finance: A Push-Button Month-End Close, Peta-Gaye Hardy](https://youtu.be/OHrRdu9vS6w)
- [Is AI Ready to Handle The Month End Close?, Accounting Firm Coach: Office Hours (Jason Staats)](https://youtu.be/84ZCFgJi1Lw)
- [Claude Just Replaced My Accountant (Full Month-End Close), Mike Dion](https://youtu.be/UP8jzq5mvJ0?t=623)
- [I Let Claude Cowork Run My Month-End Close, Mike Dion](https://youtu.be/-yeTf5YFlmw)
- [Copilot Agents Just Replaced My Month-End Close (Here's Proof), Mike Dion](https://youtu.be/llRedGPXBCM)
- [Claude For PowerPoint Just Replaced My Month-End Deck, Mike Dion](https://youtu.be/K87NNTvUOR4)
- [How to Automate Financial Reports (4 Levels Explained), Shin Financials](https://youtu.be/ueJ1e_4NLd4)
- [Microsoft Released Copilot Skills For Finance (No One Is Using Them), Mike Dion](https://youtu.be/zCx3cE4f9yk)
- [How to Do a Bank Reconciliation With Claude AI (Step by Step), Lvl 99 TechSkillz](https://youtu.be/PD1ETjRM9u8)
- [How To Close The Books For Dummies. Financial Close In 15 Steps, The Financial Controller](https://youtu.be/T_eyPp23UO8)
- [How to Undo a Previous Bank Reconciliation in Quickbooks Online, The Quickbooks University](https://youtu.be/09wKvMTazsg)
- [AI-powered month-end close (blog post by Anouk Amar)](https://www.datarails.com/ai-powered-month-end-close/)
- [Close Books 3x Faster (month-end product page)](https://fina.team/month-end)
- [Automated Close (product page, as cited by ChatGPT)](https://www.maximor.ai/automated-close)
- [Month-end close automation (blog post)](https://nominal.so/blog/month-end-close-automation/)
- [Month-end close (CFO Reads blog post)](https://upflow.io/blog/cfo-reads/month-end-close)
- [How generative AI can make accountants more productive (Zach Church, Aug 5, 2025)](https://mitsloan.mit.edu/ideas-made-to-matter/how-generative-ai-can-make-accountants-more-productive)
- [Live ChatGPT LLM Responses (API docs)](https://docs.dataforseo.com/v3/ai_optimization/chat_gpt/llm_responses/live/)
- [Live Google Organic SERP Advanced (API docs)](https://docs.dataforseo.com/v3/serp/google/organic/live/advanced/)
- [Developer - Finance Automation & AI (job post)](https://www.upwork.com/jobs/~022105179039826346045)
- [AI/Claude Implementation Specialist for UK Outsourced Finance Firm (job post)](https://www.upwork.com/jobs/~022104277794399685044)
