Skip to main content
Module 1: Foundations

The finance AI tool stack

AI in Excel, ERPs, FP&A, close, AP, and expense — the ones that compute, not narrate.

The finance AI landscape spans your spreadsheets, ERPs, FP&A platforms, close tools, and AP/expense systems. Learn the categories and — crucially — favor tools that compute and show their work over ones that just narrate numbers (a 2026 snapshot; verify specifics, they change fast).

Spreadsheet AI (where much finance work lives):

  • Excel Copilot — natural-language formula generation, variance explanation, PivotTables, anomaly surfacing. Key point: when Copilot generates a formula, the number is computed by Excel's engine, not narrated by the model — that is exactly the accuracy pattern you want, and you can inspect the formula. But be careful: some Copilot outputs (chat summaries, and the in-cell =COPILOT() function's result) are model-generated text, not a deterministic Excel calculation — verify those like any narrated number. (Note: Microsoft has been reshaping Copilot in Excel — e.g., moving away from the in-cell =COPILOT() function toward a grounded side-pane with connectors and citations — so treat older "COPILOT function" tutorials as potentially outdated.)
  • Google Sheets Gemini — similar AI assistance in Sheets.

ERP AI (embedded in your system of record):

  • SAP Joule, Oracle Fusion AI agents, Microsoft Dynamics 365 Copilot — AI assistants and agents embedded in the ERP, increasingly coordinating specialized agents across finance workflows. Best fit follows your ERP. These compute from the system of record — good for accuracy — but still need verification and controls.

FP&A platforms:

  • Pigment (furthest on AI — analyst/modeler agents), Datarails (Excel-native, SMB/mid-market, NL chatbot), Cube (spreadsheet-native) — AI for planning, modeling, and commentary. The computation happens in the planning engine; AI assists the analysis and narrative.

Close and accounting automation:

  • BlackLine (high reconciliation-automation, continuous accounting; enterprise), FloQast (AI reconciliation, cuts days off close; mid-market). Important framing: these remain assistive — strong at matching and workflow, but journal entries and judgment stay human. Not "autonomous close."

AP automation:

  • BILL, Tipalti, AvidXchange, Stampli — OCR + AI to capture, code, and match invoices and route approvals. Real efficiency in a high-volume, rules-based area (Module 3).

Spend/expense:

  • Ramp and Brex — AI audit flags, receipt matching, autonomous receipt/approval agents. Efficiency in expense management with AI catching anomalies.

BI copilots — for financial reporting and dashboards (Power BI Copilot writing DAX and narratives, etc.).

How to choose (with the accuracy lens):

  • **Favor tools that *compute and show their work*** — where the number comes from a real engine (Excel's formula, the ERP, the database) and you can see the formula/query. Be wary of any tool that just has AI state financial numbers without a computation you can trace.
  • Start with the AI in tools you already use — Excel Copilot, your ERP's AI — before adding new platforms. You likely already have capability.
  • Match to your work — FP&A platform for planning/modeling; close tool for reconciliations; AP tool for invoices; expense tool for spend.
  • Verify accuracy claims — vendor efficiency numbers are directional; test on your data.
  • Keep the controls lens (Module 3) — any AI touching your financials must fit your control environment and audit requirements.

The mindset: the finance AI stack embeds AI across your spreadsheets, ERP, FP&A, close, AP, and expense tools — and the right ones share a trait you now prize: they compute the numbers (in a real engine) and show the work, rather than having AI narrate figures. Favor those, start with the AI in tools you already use, match tools to your finance work, and always apply the accuracy (compute-don't-narrate, verify) and controls lenses. A finance AI toolkit built around computed, traceable numbers is one you can trust; one built around AI stating numbers is a material-error risk. Choose for computation and traceability, and the stack becomes a genuine accelerator for finance work.

Try it

Inventory the AI in your current finance tools (Excel Copilot, your ERP's AI, your FP&A/close/AP tools). For each, ask the key question: does it *compute* numbers in a real engine and let you see the formula/query, or does it *narrate* figures? Favor and trust the former. Identify your highest-value, most-traceable starting point.

Stay in the loop

Enjoying the free lessons? Get an email when we publish new courses and updates — no spam, unsubscribe anytime.

Discussion (0)

Ask a question or share what worked for you. Comments are reviewed before they appear.

Log in to join the discussion and ask questions about this lesson.

No comments yet. Be the first to start the discussion!