best ai for financial modeling

Best AI for Financial Modeling in 2026: Which Tool for Which Job

Anthony Barbey

Anthony Barbey

· 8 min read

Share

Short answer: pick the AI by the job, not by the brand. To draft a model, use the assistant you already pay for, Claude or ChatGPT, or a modeling agent. To work on a workbook you received, use an Excel add-in. To keep a model true month after month, add a model layer that the assistant edits. Most finance people end up with two of these, not one.

Facts about each tool come from its public pages, checked on the date shown. Usage figures come from the 2026 Fractional CFO Study, a survey of 173 practitioners run by Layerz in October 2026.


What Do Finance People Actually Use?

Among the 140 fractional CFOs who named their tools in the 2026 Fractional CFO Study:

ToolShare using it
Claude88 %
Excel79 %
ChatGPT60 %
Google Sheets51 %
Gemini42 %
Copilot34 %

The overlap is the point: Claude and Excel together, ChatGPT for some clients, Copilot where the client's IT has standardised on Microsoft 365. The question is less "which AI" than "which AI for which part of the work".


Three Jobs, Three Kinds of Tool

Financial modeling with AI comes down to three jobs:

  1. Drafting a new model from a description and some numbers.
  2. Working on a workbook you received: understanding it, checking it, changing it.
  3. Maintaining a model: monthly actuals, a rolling forecast, scenarios, a version you sign.

Each tool below is strongest on one of them.


Claude: Best for Reasoning on a Model

Claude is the most used assistant among finance practitioners in the study. It is strongest on the reasoning around the numbers: structuring a model, proposing assumptions, reading a 20-tab workbook you inherited, explaining a variance, writing the board commentary. Projects keep instructions and files per client, Skills create Excel files, and custom connectors over MCP reach other tools.

Pick it when you need to think a model through, understand someone else's, or turn numbers into a narrative. Guide: Claude for Financial Modeling.


ChatGPT: Best for Analysis on an Export

ChatGPT runs real code on an uploaded file, so a pivot, a cohort table or a chart is computed rather than guessed. It drafts model structures and formulas well, and many practitioners have used it for more than a year.

Pick it when you have an export and a question: which customers pay late, what drove the margin drop, a quick break-even. Guide: ChatGPT for Financial Modeling. Comparison: ChatGPT vs Claude for Finance.


Excel Add-ins: Best for a Workbook You Received

Three add-ins put an assistant inside Excel, working on the open workbook:

  • Claude in Excel (Anthropic) reads and edits the workbook, cites the cells it uses, and is included in paid Claude plans.
  • ChatGPT for Excel (OpenAI) builds and updates models in the open workbook, cites cells and asks before editing; generally available on ChatGPT plans since May 2026, also in Google Sheets.
  • Copilot in Excel (Microsoft) adds finance skills such as a DCF or a variance analysis, data connectors to providers like FactSet and S&P Global, and tracks edits in Show Changes, with a Microsoft 365 Copilot licence.

Pick one when the deliverable is the workbook itself, or the client requires everything to stay in their Microsoft 365. Copilot is the natural choice where IT has standardised on Microsoft and its data providers. Comparisons: Claude in Excel, ChatGPT for Excel, Copilot in Excel.


Shortcut: Best for a Fast Standard Draft in Excel

Shortcut is an AI agent for Excel that drafts DCF, LBO and three-statement models in the workbook, with its own bundled agent, also available in Google Sheets, on the web and as a desktop app.

Pick it when you want a first draft of a standard model inside Excel, quickly, with nothing to connect first. Comparison: Layerz vs Shortcut.


Claude Sheets: Best for a Quick Shared Sheet

Claude Sheets, launched in beta on 10 November 2026 on paid Claude plans, is a spreadsheet Claude builds and edits with you inside the Claude app: tabs, formulas, formatting and drop-downs from a prompt, shared with teammates, exported to .xlsx or CSV. Anthropic describes its scope as simple spreadsheet functionality for now.

Pick it when you need a tracker, a hiring budget or a first cash view today, and a colleague will keep editing it with Claude. Guide: Claude Sheets for Finance.


A Model Layer: Best for a Model You Maintain

The tools above are strong at the sheet in front of you. A model updated every month asks for something else: conventions that persist, actuals kept beside the budget, versions you can restore, and the same model whichever assistant you open it in. In the study, 27 % of 139 fractional CFOs got AI numbers they could not trust in the previous month, and 24 % saw the AI forget context between sessions.

Layerz is a structured spreadsheet, ready for AI. It has no AI of its own: your assistant (Claude, ChatGPT, Claude Code, Codex) edits it over MCP.

  • A deterministic engine computes every figure, through an explicit dependency graph.
  • Each model carries its conventions in a FINANCE.md file the assistant reads first.
  • Actuals sit on their own branch over the budget; every change is versioned, with diff and restore.
  • Every model exports to .xlsx with formulas intact.

Pick it when the model is updated every month, read by a board or an investor, or signed. It works alongside the tools above: draft anywhere, keep the model in Layerz, export to Excel for whoever needs the file. Free for one person working alone.


Which AI Should You Pick? A Quick Guide

Your situationStart with
Think a new model through, explain a varianceClaude
Analyse an export, run numbers on a fileChatGPT
Understand or fix a workbook you receivedClaude in Excel or ChatGPT for Excel
Client on Microsoft 365, market data providersCopilot in Excel
Standard DCF or LBO draft in Excel, fastShortcut
A tracker or a draft budget to share todayClaude Sheets
A model updated monthly, versioned, signedYour assistant + a model layer (Layerz)

FAQ

What is the best AI for financial modeling? It depends on the job. Claude is the most used assistant among finance practitioners (88 % in the 2026 Fractional CFO Study). For a workbook you received, an Excel add-in fits best. For a model you maintain month after month, pair your assistant with a model layer.

Can AI build a financial model on its own? It can draft one in minutes. Check that derived cells are formulas and not values, and expect the hard part to be the second month: new actuals, changed assumptions, a reviewer. See Stop AI From Hardcoding Your Financial Model.

Is ChatGPT or Claude better for financial modeling? Most practitioners use both. Claude leads on reasoning and reading models; ChatGPT is strong on analysis of uploaded files. The comparison, with study data: ChatGPT vs Claude for Finance.

Is there a free AI for financial modeling? Claude and ChatGPT both have free plans with limits, and Layerz is free for one person working alone. Claude in Excel and Claude Sheets come with paid Claude plans, ChatGPT for Excel has limited usage on ChatGPT's free plan, and Copilot in Excel needs a Microsoft 365 subscription that includes Copilot. Check each vendor's page for the current terms.

Can I use several of these tools on the same model? In Excel, yes, through the file. With a model layer, the same model opens in Claude, ChatGPT, Claude Code and Codex, and exports to Excel for anyone else.


The Takeaway

The best AI for financial modeling is the one matched to the job: an assistant to think, an add-in for the workbook in front of you, an agent for a fast draft, and a model layer for the model you keep. Most finance teams will use two of them. Keep Excel as the way out.


Keep Reading

Anthony Barbey

Anthony Barbey · Founder, Layerz

Anthony spent his career in finance and consulting, close to the modeling workflows of M&A, transactions, and advisory. He now builds Layerz, the finance workspace that keeps Claude in the context of your model so it doesn’t drift, forget between sessions, or burn tokens on grids.

Related articles

Ready to build models that are defensible by design?

Layerz separates model structure from data so every number is traceable.

Explore Layerz