Finance

Finance AI Should Interpret Metrics, Not Recalculate

Orisdale Editorial Team · Published · Updated · 8 min read

Finance AI should explain an approved variance. It should not invent the formula. The worked example on this page is a narrow synthetic calculation you can inspect.

Where interpretation stops and calculation stays governed

Finance leaders face a seductive proposition: connect an AI system to actuals and budgets, ask it to explain performance, and receive executive-ready commentary in seconds. The risk is not that the commentary will be poorly written. The risk is that the system will silently recalculate the numbers while writing the sentences.

For CFOs, FP&A directors, and controllers, that distinction is not technical nuance. It is the difference between a governance-ready finance capability and an audit liability dressed in natural language.

The single most important design decision in enterprise finance AI is the boundary between interpretation and recalculation. That boundary must never move.

Inspect one published case in the Finance proof explorer. The full inputs, contract, and downloads stay in the worked example.

The problem: fluent commentary on ungoverned numbers

Finance organizations already operate rigorous processes for how variance is calculated, how materiality is determined, and how management-attention classifications are assigned. These processes exist because financial numbers carry legal, regulatory, and fiduciary weight. They are reviewed, reconciled, and tied to source systems that auditors recognize.

An AI system connected directly to raw ledger extracts or loosely modeled budget tables can produce variance figures that look correct. The model applies arithmetic. It selects columns. It compares periods. The output reads confidently. But nobody can explain — in audit terms — which materiality rule was applied, which budget version was referenced, or why this variance differs from the official management report.

A forecast that is slightly wrong is a planning problem. A financial number silently recalculated by a model, with no visible audit trail, is a governance problem.

Why common approaches fail

Letting the model "validate" finance math. When teams invite the AI layer to check whether variance "looks right," they open the door to silent recalculation. The model may adjust rounding, re-aggregate at a different grain, or apply an inferred materiality threshold that differs from the official rule set.

Conversational access to raw tables. Unconstrained SQL generation against general-ledger tables can change grain, joins, filters, and definitions without passing through the approved close. That is the failure mode to prevent. A validated tool, governed view, or controlled query can still execute a calculation Finance has already approved. The requirement is controlled metric authority: the agent may run approved queries and read approved fields, and it may not invent a formula, grain, or threshold at question time.

Duplicating FP&A logic inside the AI project. When finance AI teams rebuild variance logic in a notebook or prompt because "it was faster," they create a second unofficial close. The AI path diverges from the report the CFO already signed. Reconciliation becomes a manual exercise after every demo.

Treating narrative generation as low risk. Governance reviews often focus on data access while treating generated text as cosmetic. In finance, narrative and number are inseparable. An executive summary that states a material variance figure is a financial output, regardless of whether it appeared in a table or a paragraph.

The governing principle

In Finance Intelligence, the AI layer interprets governed outputs. It does not:

  • recalculate variance,
  • redefine materiality,
  • invent a KPI,
  • override the source of truth, or
  • generate unsupported financial values.

This is not a limitation to work around. It is the reason finance teams can trust the output at all.

Governed fields — actual amount, budget amount, variance amount, variance percentage, material flag, variance category, management-attention classification — are calculated deterministically before the AI layer produces a single sentence of commentary. The model explains what the numbers mean for decision-makers; it does not become an alternate calculation engine.

That principle aligns with the broader Orisdale reference architecture and the constraints applied to every governed finance agent.

Implementation architecture

Finance intelligence follows a strict top-to-bottom sequence:

Actuals and Approved Budgets
        ↓
Governed Finance Logic
        ↓
Semantic Finance Intelligence
        ↓
Enterprise Data Platform
        ↓
Agentic AI Runtime
        ↓
Executive Finance Experience

Each layer has a distinct responsibility:

Source reconciliation — actuals tied to the approved close; budgets tied to the sanctioned planning version, not ad hoc extracts.

Governed finance logic — variance calculations, threshold rules, materiality flags, and management-attention classifications expressed as versioned rules that Finance can test against the official report.

Semantic finance intelligence — business context that tells the AI layer what a cost center represents, how departments roll up, and which comparisons are valid at executive grain.

Platform publication — governed outputs exposed inside Snowflake, Databricks, or Google Cloud with the same access controls Finance already operates.

Constrained AI runtime — Snowflake Cortex, Databricks Genie Agents, or Gemini Enterprise Agent Platform experiences that read governed fields and produce narrative, ranked exceptions, and conversational answers — without write access to calculation logic.

A practical example: the CFO's Monday review

A CFO opens a finance intelligence experience and asks: "What are the largest material variances this period, and which departments require management attention?"

In a recalculation architecture, the model queries source tables, computes variance on the fly, applies an inferred materiality concept, and generates a ranked list. The commentary is fluent. The numbers may not match the package the controller prepared for the leadership meeting.

In an interpretation architecture, material variances and management-attention classifications were computed during the governed close process — using the same rules the official report uses. The AI layer reads those fields, ranks them, explains primary drivers in plain language, and identifies what changed from the prior period. When the CFO compares the AI summary to the controller's report, the figures align because they were never separate paths.

Matching the official variance amount does not make the commentary correct. A model can repeat a governed number and still invent a cause, misstate the sign, or describe a hypothesis as a fact. Permitted behavior is to read the governed fields, rank them with the approved rule, and keep observed drivers separate from labeled hypotheses. Review has to check both the returned numbers and the claims made about them.

Sample questions this architecture supports include: "What changed from the previous period?", "What are the primary unfavorable drivers?", and "What should the CFO review first?" Each answer is commentary on governed outputs, not a parallel close.

Worked example

The boundary is easier to judge on numbers you can check. The example below uses three invented departments and a small, versioned rule set. A deterministic calculation produced the results, and every input, the rule contract, the calculation source, the results, and the validation record are published so a reader can reproduce them. It shows what a governed calculation establishes, and what it leaves for a person to review. The same boundary sits inside the reference architecture.

Executed synthetic calculation example — local computation

The three example departments, the budget and actual amounts, and the rules are invented for this article. The calculation below was run on those inputs. It was not run in Alteryx or BigQuery, and no model wrote any sentence in this section.

Read the three checks separately. The category is the arithmetic result. Claim status says whether a sentence matches a computed field or still needs evidence. Human confirmation says whether a person has recorded a decision. An unsupported claim is not approved.

Example department

Selected case: Example Department — Field Operations (EX-FIELD-OPS)

Approved budget
USD 100,000.00
Actual expense
USD 115,000.00
Variance
USD 15,000.00 (over budget)
Variance percent
15.0000%
Materiality category
Material
Calculation exception review
No

Calculation exception review comes from the published contract. It is yes only when the approved budget is zero and the variance percentage is unavailable. No does not mean a person has confirmed the variance, the narrative, or a cause.

Example Department — Field Operations, 2026-09: actual expense was USD 115,000.00 against an approved budget of USD 100,000.00. The variance is +USD 15,000.00 (over budget), or +15.0000%. Category under contract version 1.0.0: Material.

  • C1. Field Operations is USD 15,000.00 over budget.Claim status: supported by computed fieldHuman confirmation: not applicable.Evidence: none linked.
  • C2. Field Operations is categorized Material.Claim status: supported by computed fieldHuman confirmation: not applicable.Evidence: none linked.
  • C3. The Field Operations overage was caused by unplanned equipment rental.Claim status: evidence linked — human verification requiredHuman confirmation: not recorded.Evidence: E1

Selected case: Example Department — Corporate G&A (EX-CORP-GA)

Approved budget
USD 60,000.00
Actual expense
USD 62,000.00
Variance
USD 2,000.00 (over budget)
Variance percent
3.3333%
Materiality category
Management attention
Calculation exception review
No

Calculation exception review comes from the published contract. It is yes only when the approved budget is zero and the variance percentage is unavailable. No does not mean a person has confirmed the variance, the narrative, or a cause.

Example Department — Corporate G&A, 2026-09: actual expense was USD 62,000.00 against an approved budget of USD 60,000.00. The variance is +USD 2,000.00 (over budget), or +3.3333%. Category under contract version 1.0.0: Management attention.

  • C5. The Corporate G&A overage was caused by consulting fees.Claim status: unsupported: no claim-linked evidenceHuman confirmation: not recorded.Evidence: none linked.

Selected case: Example Department — Marketing (EX-MARKETING)

Approved budget
USD 40,000.00
Actual expense
USD 40,500.00
Variance
USD 500.00 (over budget)
Variance percent
1.2500%
Materiality category
Within tolerance
Calculation exception review
No

Calculation exception review comes from the published contract. It is yes only when the approved budget is zero and the variance percentage is unavailable. No does not mean a person has confirmed the variance, the narrative, or a cause.

Example Department — Marketing, 2026-09: actual expense was USD 40,500.00 against an approved budget of USD 40,000.00. The variance is +USD 500.00 (over budget), or +1.2500%. Category under contract version 1.0.0: Within tolerance.

  • C4. Marketing is within tolerance.Claim status: supported by computed fieldHuman confirmation: not applicable.Evidence: none linked.

Inputs and contract

One period (2026-09), one currency (USD), one row per department in each file. The calculation contract is version 1.0.0. Demonstration rules for a synthetic example. Not a customer-approved policy and not a measured result.

Results

Example Department — Field Operations

Budget
USD 100,000.00
Actual
USD 115,000.00
Variance
USD 15,000.00 (over budget)
Variance %
15.0000%
Category (v1.0.0)
Material

Example Department — Corporate G&A

Budget
USD 60,000.00
Actual
USD 62,000.00
Variance
USD 2,000.00 (over budget)
Variance %
3.3333%
Category (v1.0.0)
Management attention

Example Department — Marketing

Budget
USD 40,000.00
Actual
USD 40,500.00
Variance
USD 500.00 (over budget)
Variance %
1.2500%
Category (v1.0.0)
Within tolerance

Classification uses the absolute variance amount and the absolute variance percentage, in this order. These are demonstration rules for this example, not a customer policy.

  1. Material when the absolute variance is at least USD 5,000.00 or the absolute variance percentage is at least 10%.
  2. Otherwise, Management attention when the absolute variance is at least USD 1,000.00 or the absolute variance percentage is at least 5%.
  3. Otherwise, Within tolerance.

Direction (over budget, under budget, or on budget) is reported separately and does not change the category: a department USD 10,000.00 under budget is classified by the same absolute rules as one USD 10,000.00 over budget. When the approved budget is zero, the percentage is unavailable and the result is marked Needs human review.

Each selected narrative is deterministic template text filled from the computed fields. It is not a model response and it names no cause. Source rows are budget.csv and actuals.csv. The rule is contract version 1.0.0.

What the numbers do not show

A matching number does not make a narrative true. Number claims are compared with the computed fields. Cause claims cannot be verified by this calculation, and a department and period match alone never links evidence to a claim.

  • unsupported: no claim-linked evidence: the claim names no evidence record in driver-evidence.csv.
  • unsupported: evidence reference not usable: a named record is missing, or belongs to another department or period.
  • evidence linked — human verification required: every named record exists for the claim's department and period. The calculation did not read it for meaning and records no confirmation. A person must decide whether it shows the stated cause, and it may not.

Field Operations is USD 15,000.00 over budget.

Type
Number
Status
supported by computed field
Basis
Computed varianceCents is 1500000.

Field Operations is categorized Material.

Type
Number
Status
supported by computed field
Basis
Computed category is Material.

The Field Operations overage was caused by unplanned equipment rental.

Type
Cause
Status
evidence linked — human verification required
Basis
Explanation

Evidence E1 is linked to this claim for the same department and period. The checker did not read it for meaning. A person must decide whether it shows the stated cause, and no confirmation is recorded.

E1: Synthetic example record: an equipment-rental line item is listed in the Field Operations expense detail for 2026-09.

E1 (EX-FIELD-OPS, 2026-09)

Human confirmation: not recorded.

Marketing is within tolerance.

Type
Number
Status
supported by computed field
Basis
Computed category is Within tolerance.

The Corporate G&A overage was caused by consulting fees.

Type
Cause
Status
unsupported: no claim-linked evidence
Basis
Explanation

The claim names no evidence record. Records that share its department and period are not linked to it. The computed variance amount does not establish a cause.

Human confirmation: not recorded.

Human review checklist

  1. Period and grain: the results cover one example department, one period (2026-09), and one currency (USD).
  2. Inputs: the budget and actual files match the published hashes and contain no rejected rows.
  3. Rule version: the contract version on every result is 1.0.0 and is the version under review.
  4. Arithmetic: variance and percentage reproduce by hand from the two inputs for each department.
  5. Supporting narrative: each sentence cites only computed fields.
  6. Causal claims: a cause with no named evidence record is marked unsupported and is not repeated as fact. A cause with linked evidence still needs a person to decide whether the evidence shows it. This calculation never confirms a cause.

Limits

  • Synthetic inputs. Not customer data and not a measured result.
  • Demonstration rules. Not a customer-approved policy.
  • Computed locally with TypeScript on Node. Not executed in Alteryx or BigQuery.
  • The narrative is deterministic template text. No Gemini or other model produced it.
  • This does not establish: an Alteryx execution.
  • This does not establish: a physical BigQuery output.
  • This does not establish: a Gemini agent transcript.
  • This does not establish: a released authoring product.
  • This does not establish: a complete reference implementation.
  • This does not establish: a customer deployment.

Validation record

Command pnpm proof:finance, run on Node v22.16.0. Exit status 0. 35 of 35 independent checks passed. That this calculation, on these synthetic inputs and this contract, produced the listed results and matched the hand-specified expected values.

SHA-256 of each published file
budget.csv
5f76d2e125f3a75ff810e56ea8ce8555b6175555550e9143e2b76b380ca02d11
actuals.csv
a65f8ebe64fae8d291b0ce332c7bab41f26345f53c07c5b74fd4e396b4ab3cea
driver-evidence.csv
e95008d49b0b6c5a48f2822e3b3c0b9ad721048f923881ae1e7bac8b33ad1531
narrative-claims.json
12537e6eab2446fd50ef67f43ece89f7c47484274cc1c7a3d6cdf7990c89f57d
finance-variance-contract-v1.json
c0fbd793b0b9c585399970046ea5b00725f326e3757b1b4e2497b10ce0917e1b
calculate-variance.ts.txt
ef1f21d0ceabedf811dcc01860a7fcb636abdbc920b7882944f0b9ec1fbcb490
results.json
e8db2d5abb2bcb01c8b6b6234d867a301cd343becbfa8e97b75c1bc36db98280
results.csv
06ed0f03ac22565c068a06a47ed8abe400f938a699888672be6460b9b2242096

Download the example

Controls and review boundaries

Finance AI requires tighter boundaries than most enterprise use cases:

  • Immutable calculation layer — AI agents have read access to governed outputs, not mutate access to rules or source transactions.
  • Version pinning — commentary references a specific budget version and close period; retroactive restatements trigger re-generation, not silent updates.
  • Scope disclosure — responses identify the reporting period, currency, consolidation level, and any exclusions applied in the governed logic.
  • Escalation paths — when data is missing or a rule fails, the system reports the gap rather than inferring a substitute value.

Governance boundary: If an AI-generated variance figure disagrees with the official management report, the AI output is wrong by definition — regardless of how reasonable the model's alternative calculation appears. Investigation belongs in the logic layer, not in prompt tuning.

Human review remains in place for consequential finance decisions. AI commentary accelerates review; it does not replace sign-off. Monitoring covers access patterns, output quality, and any attempt by agents to invoke unauthorized calculation tools — as described in the Architecture monitoring boundary.

Platform considerations

Finance data typically already lives on an enterprise platform with mature access controls. Finance AI should extend that boundary, not exit it.

Snowflake secure views and Cortex experiences can serve governed finance fields without exporting sensitive ledger detail to external systems. Databricks Unity Catalog governs both pipeline logic and the datasets agents consume. Google Cloud BigQuery governed datasets and Gemini Enterprise Agent Platform controls keep finance outputs inside existing IAM policies.

The platform choice matters less than the architectural invariant: governed logic executes inside the platform's production boundary; AI reads the result. Alteryx One can support upstream preparation when actuals and budgets require harmonization before publication, but the authoritative variance logic should not exist only in a preparation sandbox disconnected from the platform Finance trusts.

Questions leaders should ask

Before approving finance AI for executive consumption, CFOs and controllers should require answers to:

  1. Which governed fields does the AI read — and can we list them alongside their rule definitions?
  2. Can the AI system modify, re-derive, or override any of those fields through tools or generated SQL?
  3. Will AI-generated variance figures match the official management report for the same period — and how do we verify that?
  4. What budget version and close period does each response reference, and what happens when a restatement occurs?
  5. Who owns the materiality rules — Finance policy or the AI project team?
  6. What audit trail exists for AI-generated commentary shown to leadership?

If question three cannot be answered with a deterministic yes, the program is not ready for executive finance review — regardless of narrative quality.

Next step

See this boundary applied in the Finance Intelligence solution — including sample executive questions and governed fields — then review how finance logic fits the full stack on the Architecture page. For agent-level constraints, see Enterprise AI Agents, Governed by Design.

Related reading: What an Enterprise AI Agent Needs in a Business Logic Contract uses the worked example on this page as the calculation an agent is allowed to read. Human-in-the-Loop AI is the review design for the packet that calculation produces.

Related solutions

Related platforms

Discuss how this applies to your environment