After eighteen months running AI adoption programmes with finance teams, one pattern is consistent: the output quality is almost always a function of prompt quality, not model quality. Here are the five mistakes I see most often — and the fixes that produce immediate improvement.
Mistake 1: Asking for conclusions without providing context
'What should our revenue forecast be for Q3?' produces useless output. AI has no access to your historical data, market position, or business model unless you provide it. The fix: front-load context. Before any analytical question, share relevant numbers, constraints, and assumptions. 'Given these Q1–Q2 actuals [data], our YoY growth trend, and a 12% currency headwind — model three Q3 scenarios: conservative, base, and upside.'
Mistake 2: Not specifying output format
Finance outputs need to work in Excel, in board packs, or in verbal briefings — and those formats are entirely different. Without a format specification, you get a generic paragraph that's useful to nobody. End every analytical prompt with explicit format instructions: 'Format as a table with columns for scenario name, revenue, gross margin, and one-line rationale. No introductory text.'
Mistake 3: Leaving out constraints
Analytical models without constraints produce unreliable output. Currency, time periods, accounting standards, rounding rules — if these aren't specified, AI makes assumptions that may not match your organisation's standards. Add a constraints block to complex prompts: 'GBP, FY ending 31 Dec, IFRS 15 revenue recognition, round to nearest £10k.'
Mistake 4: Treating prompting as single-shot
The best financial models take multiple iterations. First-pass AI output should be treated as a rough draft, not a final answer. Build an iterative workflow: first prompt for structure, second for refining assumptions, third for stress-testing, fourth for formatting. The incremental time investment is minimal; the quality improvement is substantial.
Mistake 5: Skipping validation
AI will confidently produce a calculation with a subtle error. Finance professionals who treat AI output as a black box — rather than a first draft to be reviewed — take on unnecessary risk. Treat AI outputs as analyst work product: your review process should be identical to reviewing a junior analyst's first draft.
The underlying problem isn't AI quality — it's that effective prompting requires the same discipline as good financial analysis. Bring that discipline to your prompts and the results follow.