AI implementation

How AI can speed up financial modelling, scenario planning, and reporting

AI can speed up finance work around models, scenarios, and reporting without replacing the underlying finance discipline. This guide shows where it helps and where control still matters.

Nick Lawton9 min read

AI can make finance work faster, but mostly around the model rather than instead of the model. The useful gains come from structuring assumptions, preparing scenarios, explaining changes, drafting commentary, and reducing repetitive reporting work. The dangerous version is pretending a model is still robust when no one can explain how the numbers were produced.

Use AI around the model before you trust it inside the model

Most businesses should start by using AI around financial workflows rather than allowing it to silently drive the numbers. That means helping with scenario framing, assumption capture, variance commentary, narrative summaries, and first-pass reporting packs before it takes on anything that needs finance-grade traceability.

that means spreadsheet-heavy work still lives in Excel or Sheets, while ChatGPT or Claude help accelerate the explanatory layer and the repetitive prep around it.

The best-fit finance workflows are repetitive and explainable

AI works best where the team can still explain every important assumption and quickly sense-check the output. If a workflow becomes hard to audit, it is not a good first candidate.

  • Drafting scenario narratives and assumptions before the numbers are finalised
  • Preparing board and leadership commentary from model outputs and actuals
  • Turning recurring reporting inputs into first-pass packs and update summaries
  • Explaining formula logic, structure, and model changes for internal clarity

A good-fit versus bad-fit test

The right use case improves speed without obscuring accountability. The wrong one makes the workflow faster and less trustworthy at the same time.

  • Good fit: scenario comparison, commentary drafting, assumptions logs, recurring report preparation
  • Good fit: internal explanation of model structure, formula logic, and options under review
  • Bad fit: unreviewed pricing logic, contractual numbers, or financial outputs no one can trace
  • Bad fit: any workflow where the team cannot explain the source data or validate the assumptions

Keep the finance owner and the audit trail visible

AI can make reporting and modelling work more efficient, but only if the workflow still has an owner, a review point, and a clear record of what changed. If the business cannot show where the inputs came from, which assumptions were accepted, and who signed off the output, the efficiency gain is not worth much.

  • Keep the source workbook, assumptions, and outputs clearly separated
  • Use AI to prepare commentary, not to hide weak logic
  • Retain named human sign-off on anything that leaves the business
  • Treat explainability as part of the workflow, not an optional extra

Questions and discussion

Have a question about this, or an experience to add? Ask me below. Please leave out anything confidential.

No questions yet. What would you like to know?

Ask me a question

Got a question, a different result or a mistake I should look at? I’d like to hear it.

Shown publicly with your approved question.

Kept private. We will email you a confirmation link.

Please leave out client names, credentials and private project details.

Once you confirm your email, I’ll read your message before it appears here. You won’t be added to a marketing list. Read our privacy notice.

Our discussion guidelines
  • Ask a question, challenge a finding or share what worked for you. You don’t have to agree with me.
  • Keep it relevant and respectful. Advertising, harassment and repeated spam will not be published.
  • Do not share personal information about others, private client work, access details or confidential material.
  • Nick approves every reader contribution. An email confirmation checks that you control the address, not your identity.

Manage your questions and reply emails.

Keep reading.

Use an RSS reader? Add this feed and my new posts will appear there. No extra account needed.

Get the RSS feed