AT Think

An AI-generated P&L is only as good as the data beneath it

Generative artificial intelligence is changing how finance teams interact with corporate data. Instead of navigating reports, exporting spreadsheets, or waiting for variance analysis, executives increasingly expect to ask questions in natural language:

Processing Content
  • "Why did EBITDA decline this quarter?"
  • "Which business units experienced the largest margin compression?"
  • "What drove the unfavorable operating expense variance?"

In the right environment, AI can answer these questions in seconds. It can analyze financial and operating data, identify drivers, summarize variances and explain results clearly. But AI cannot compensate for weak financial data governance or an inadequate control environment.
If revenue, margin, customer, product, headcount or EBITDA are defined differently across systems, an AI-generated analysis may sound convincing while relying on the wrong source, calculation or reporting definition. For accounting organizations, the data beneath AI is therefore not simply a technology issue, but a financial reporting and internal control issue.

The problem is often upstream of the AI

Consider a seemingly straightforward request: "Show EBITDA by business unit for the quarter and explain the variance from last year."

Answering it may require information from the general ledger, ERP, sales systems, payroll applications, procurement platforms, operational databases and spreadsheets outside core financial systems.

Those sources may not agree. Business units or product hierarchies may be defined differently across systems. Finance may calculate gross margin using allocations not reflected in operational reporting. One headcount report may include contractors while another does not.

Even EBITDA may have several definitions, such as reported EBITDA versus management-adjusted EBITDA excluding restructuring costs, transaction expenses, stock-based compensation or other items.

A language model does not inherently know which definition represents management's approved reporting policy. This creates a familiar accounting problem in a new form: multiple versions of the truth.

The controller's role becomes more important, not less

Finance organizations have historically addressed these issues through reconciliations, accounting policies, chart-of-account structures, consolidation processes, master data and controlled management reporting. AI does not eliminate those disciplines. It makes them more important.

Before AI is permitted to generate or explain financial results, controllers should understand what data it uses, where the data originates, how it has been transformed and which definitions govern the calculations. Revenue, gross margin, EBITDA, working capital, customer profitability and other important measures should have documented definitions, approved calculation methodologies and authoritative data sources.

Key dimensions also need to be reconciled across systems. Customers, vendors, products, facilities, business units, accounts and legal entities often carry different identifiers across applications. Without controlled mappings, AI can combine records incorrectly even when its query is technically accurate.

The goal is not necessarily one enormous, centralized database. It is a governed financial data layer that allows the organization to interpret information consistently regardless of where the underlying records reside.

AI-generated reporting requires controls

Accounting teams should treat AI-generated financial reporting within a control framework similar to other technology-enabled reporting processes.

Key questions include:

  • Data completeness: Did the AI access all relevant transactions, entities and reporting periods?
  • Data accuracy: Do the amounts reconcile to the general ledger, consolidation system or other authoritative source?
  • Calculation integrity: Are margins, variances, EBITDA adjustments and other metrics calculated using approved methodologies?
  • Access controls: Can users retrieve only financial information they are authorized to access?
  • Change management: Are changes to definitions, mappings or calculations reviewed and reflected consistently?
  • Evidence and retention: Can the organization demonstrate which data and calculations supported a material AI-generated conclusion?

These controls become especially important when AI output moves from informal analysis into management reporting, forecasting, disclosure preparation or other processes affecting financial decisions.

Separate the calculation from the explanation

One important architectural principle is separating deterministic financial calculations from generative explanations. Large language models are probabilistic. Their wording may vary each time a question is asked. Core accounting calculations should not.

Revenue, gross margin, EBITDA, account balances and variances should generally be calculated by governed systems, controlled queries or approved analytical models. The AI layer can then interpret and explain those results.

For example, a controlled process might determine that EBITDA decreased $8.3 million because of a $4.1 million volume impact, a $2.6 million unfavorable product-mix effect and $1.6 million higher operating costs. AI can translate those findings into a concise management explanation. But the underlying $8.3 million calculation should remain traceable and reproducible.

Ideally, an organization should be able to move backward from an AI-generated conclusion to the calculation, then to the governed dataset and ultimately to the source transactions or systems. That lineage is essential for auditability.

From financial reporting to financial analysis

Once this controlled foundation exists, AI can do considerably more than summarize a P&L. Executives may ask:

  • What is driving the margin decline in our largest business unit?
  • Which customers contributed most to the unfavorable revenue variance?
  • What would happen to EBITDA if material costs increased 5%?

Agentic AI systems can potentially retrieve governed information, run calculations, evaluate scenarios and explain the resulting financial and operational impacts.
But greater autonomy increases the importance of controls. Each additional analytical step creates another opportunity for an incorrect mapping, data source, assumption or calculation to propagate through the analysis.

Data governance is becoming part of AI governance

For controllers, CFOs and accounting leaders, the central question should not simply be: "Which AI platform should we use?" It should also be: "Can we demonstrate that the financial information the AI is using is complete, consistent, controlled and auditable?"

Preparing for AI will expose problems many organizations already have: inconsistent KPI definitions, uncontrolled spreadsheets, disconnected systems, undocumented transformations and limited lineage between executive reporting and source transactions. Addressing those weaknesses creates value even before AI is introduced.

The future of financial reporting may include executives receiving increasingly sophisticated P&L analysis from AI assistants rather than relying exclusively on static reports and dashboards. But the credibility of that analysis will depend less on the sophistication of the language model than on whether the controllership function can trust, trace and demonstrate control over the corporate data beneath it.


For reprint and licensing requests for this article, click here.
MORE FROM ACCOUNTING TODAY
Load More