AI in finance, accounting and analysis
Memos, reconciliations and research - and why the numbers are the weak spot.
Learning goal: You keep an audit trail and never let a model be the source of truth.
1 / 9
A careful assistant for drafting and triage - never the source of truth for a number.
Before you start (prerequisites)
- Access to a general-purpose AI chat tool or one built into your accounting/analysis software, and clarity on which one your firm has actually approved.
- Basic comfort exporting data as CSV or copying tables out of your spreadsheet or ledger system.
- Know your firm's or client's confidentiality and data-handling policy before you paste anything in - many contain client financial data that should never leave an approved, contracted platform.
- Understand that "the model did the maths" is not an acceptable answer in an audit trail or to a regulator.
- A habit of keeping your working spreadsheet as the single source of truth, with AI output pasted in as a draft to be checked, not the other way round.
Do this first:
- Confirm with your firm which AI tools are approved for client data, and whether that approval covers uploading spreadsheets or just typing general questions. If in doubt, don't paste client data - use anonymised or dummy figures to test a prompt first.
- Pick one low-stakes task this week - a first draft of commentary, or triage of a reconciliation list - and run it alongside your normal process, comparing the two rather than replacing one with the other.
- Set up a personal rule: every number an AI tool gives you gets recalculated or traced back to source before it appears in anything a client or regulator will see.
Where things stand (as of 2026)
AI tools are genuinely useful for drafting commentary, summarising long filings, restructuring messy data, and speeding up first-pass triage of reconciliations or expense reports. Several accounting and finance platforms now have AI features built directly into the workflow - flagging anomalies, drafting narrative, suggesting categorisations.
What they are still not reliable at: arithmetic on anything non-trivial, especially across large or messy datasets, and producing citations or figures that are genuinely accurate rather than plausible-looking. Large language models predict likely text, not calculate; if a tool is doing genuine calculation, that's usually a separate function or plugin bolted on, not the model itself, and the boundary between the two isn't always visible to you. Firms have already had to correct AI-drafted reports where figures were subtly wrong but read fluently. This area moves fast - a tool's arithmetic reliability this year is not a guarantee for next year, so re-test rather than assume.
The mental model
animated · where the time goes
Stack up a single agent turn and see which stage eats the seconds.
running total 0.07s · a human gives up at ~3s
the lesson
Every stage is fast except the two that involve a model. Waiting is the default state of an agent.
Think of the AI as a fast, well-read junior who has read enormous amounts of financial writing and can produce fluent, structurally sound drafts - but who cannot actually run a calculator reliably, has no idea what your specific client's numbers should look like, and will not tell you when they're guessing unless you insist on it. Every number they write down needs to be traced back to a source you control.
Scenarios that work
Drafting a variance commentary for a monthly management pack
medium stakeswhat you want
a first-draft narrative explaining why actuals moved against budget, so the analyst can edit rather than start from a blank page
what most people type
Write commentary on this month's numbers
the briefed version
You are helping a management accountant draft board-pack commentary. Here is this month's actual-vs-budget table for the sales division (pasted below). Write three short paragraphs: overall movement, the two largest line-item drivers, and one forward-looking risk. Use a neutral, factual tone, no speculation about causes not shown in the data, and flag any number you are unsure how to interpret instead of guessing.
Stake: Wrong commentary in a board pack can mislead decision-makers even if the underlying numbers are correct.
Speeding up a bank reconciliation review
medium stakeswhat you want
help spotting likely matches and outliers in a long list of unreconciled items, not a final reconciliation
what most people type
Reconcile these two lists for me
the briefed version
Here are two CSV extracts: bank statement lines and ledger entries for March. You are not authorised to change any figures. Group the bank lines into likely matches with ledger entries based on amount and date proximity, list anything with no plausible match, and list any amount that appears twice. Output a table with your confidence (high/medium/low) for each match, and do not mark anything as reconciled - that decision is mine.
Stake: A missed reconciling item can hide an error or, in rare cases, fraud.
Summarising a company's public filings before a meeting
medium stakeswhat you want
a fast, readable briefing on a company from its own disclosures, to prepare for a client call
what most people type
Tell me about [Company]'s financials
the briefed version
I am preparing for a client meeting about [Company]. I've attached its most recent annual report PDF. Summarise revenue trend, margin trend, debt levels, and any risk factors the company itself discloses, each with the page number you took it from. Do not use any information you know from training data - only from this document. If a figure isn't in the document, say so.
Stake: Misreading a debt covenant or margin trend before a client call is an embarrassing and potentially costly mistake.
Explaining a technical accounting standard to a non-finance client
low stakeswhat you want
a plain-English explanation of a standard so a client understands why treatment changed
what most people type
Explain IFRS 16 to my client
the briefed version
Write a short, plain-English explanation of IFRS 16 lease accounting for a client who runs a retail business with 40 shop leases and no accounting background. Explain what changed, why it changed their balance sheet, and one concrete example using round numbers. Avoid technical jargon or define it the first time it's used. This is educational only - it does not replace their own accountant's application of the standard to their accounts.
Stake: Low risk as a plain-English primer, provided it's clearly labelled as general education, not the client's actual accounting treatment.
Where it fails, and what it costs you
Arithmetic errors that look correct. Language models generate numbers by pattern, not calculation. A variance percentage or a running total can be wrong while still being internally "plausible" - which makes it harder to spot than an obviously nonsensical error. If that number ends up in a client report or regulatory filing, you own the error, not the tool.
Fabricated or misattributed citations. Ask for a source on an accounting standard, tax rule, or market statistic, and a model can produce a confident-sounding reference that doesn't exist or doesn't say what it claims. This is the same failure mode that has caused professionals in other fields to submit fabricated citations to courts - the finance equivalent is a client report or valuation memo built on a source that isn't real.
Model risk and silent drift. Firms that build workflows around a specific AI model can find behaviour changes when the underlying model is updated, without warning. A prompt that reliably produced good variance commentary last quarter might behave differently this quarter. Treat any AI-dependent workflow as something to periodically re-validate, the same way you'd revalidate a spreadsheet macro after a software update.
Confidentiality and client data. Pasting client financial data into a consumer-grade AI tool without a data processing agreement can breach client confidentiality obligations and, depending on jurisdiction, data protection law. Some tools use input data to further train models unless you've specifically opted out or are on an enterprise contract that excludes it.
No audit trail by default. Regulators and auditors expect to be able to see how a number was derived. "An AI drafted it" is not a control. If AI is part of your process, document what it was used for, what was checked, and by whom - the same discipline you'd apply to any other draft-then-review step.
Never the source of truth. The single most important rule: AI output is a draft or a triage aid. The general ledger, the reconciled bank statement, the audited financial statements - these remain the source of truth. If an AI-generated number and your system disagree, the system wins until proven otherwise, not the AI.
How to check the answer
- Recalculate every number the AI produced using your own spreadsheet formulas or accounting system - do not accept a total, percentage, or ratio on faith.
- Trace every cited figure or claim back to its original source document and page or line reference.
- Cross-check totals: does the sum of the parts the AI listed actually equal the total it quoted?
- Ask a colleague who didn't see the AI draft to sanity-check the conclusion independently.
- Confirm no client-identifying or commercially sensitive data was entered into a tool without proper authorisation.
- Record, briefly, what the AI was used for and what you checked - treat it like any other piece of workpaper documentation.
How to read the docs and find the truth
Go to the primary source, not a summary of it. For accounting standards, that means the IFRS Foundation or your local standard-setter (e.g. FASB in the US, the FRC in the UK) - not a blog post or an AI-generated explainer. For tax and regulatory questions, use your tax authority's own published guidance and, where relevant, the actual legislation.
For the AI tool itself, read the vendor's model card or system card and its data-handling terms, not just marketing copy. Look for: what happens to data you input (is it used for training?), what the tool's known limitations are (most vendors now disclose that arithmetic and citation accuracy are limited), and the date of the document - AI vendor documentation changes often, and a page you read three months ago may already be out of date. A genuine source will have a visible publication or last-updated date and will link back to primary regulatory text rather than paraphrasing it.
Your one-page playbook
ROLE: You are a [drafting assistant / triage assistant] for [task]. INPUT: Here is the data or document you should use: [paste or attach]. BOUNDARY: Only use the data provided. Do not use outside knowledge for figures. Do not perform final calculations I will rely on without me checking your working. FORMAT: [table / three paragraphs / bullet list], tone: [neutral and factual]. UNCERTAINTY: If you are not confident in a figure or source, say so explicitly rather than estimating. OUTPUT IS A DRAFT: This will be reviewed and verified against source data before use. Do not present it as final.
Check yourself
- If an AI tool produces a variance percentage, what is your process for confirming it's correct before it goes in a client-facing document?
- What data-handling rule applies at your firm before you paste a client's financial data into any AI tool?
- Name one thing that could go wrong if you treated an AI-drafted reconciliation as complete without independent review.
- Where would you go to check whether an accounting standard has actually changed, rather than trusting an AI's explanation of it?