Draft budget-versus-actual variance explanations from department notes

A draft variance commentary with each line's variance, explanation, evidence reference and a mismatch flag.

Choose one of three approaches. The steps for that option appear below.

Choose an option above. On a phone, swipe the tabs left or right to see all options →

Claude: maps notes to lines, drafts with flags

Claude reads the variance table and department notes, quotes each explanation verbatim, drafts commentary with consistency flags after heads confirm.

  1. You

    Get ready

  2. Claude

    Quote verbatim

  3. The department heads

    Confirm the meaning

  4. Claude

    Draft with flags

  5. The department heads

    Check and approve

  1. Have ready: table and notes

    Use: You

    The variance table and the six departments' explanation notes.

    Check

    Check the material is complete and you may upload it; keep the originals. Check your organisation's rules for restricted finance data before uploading it to any tool; this record does not establish that upload is permitted.

  2. Quote each explanation verbatim

    Use: Claude

    Upload the variance table and department notes; ask for one row per variance line with the explanation quoted verbatim and the figure it relates to.

    Details

    What to paste into the tool

    Task: Structured explanation table with verbatim source text. For each variance line, find the explanation in the notes and give: line, variance, explanation quoted exactly, source note, and a short neutral paraphrase. If no note covers a line, say so. Do not add causes.

  3. Confirm the representation

    Use: The department heads

    Each head reads their rows and confirms or corrects the representation; the meaning must be unchanged.

    Check

    Each department head confirms the structured explanation keeps their meaning; condensation must not change the claim.

  4. Draft the commentary with flags

    Use: Claude

    Give Claude the confirmed table and ask whether each explanation fits the numbers and for draft commentary with a consistency flag per line.

    Details

    What to paste into the tool

    Task: Draft commentary per line with consistency flags. For each line, say whether the explanation is consistent with the budget, actual and variance figures. Flag inconsistencies without editing the explanation. Label every explanation as a department claim, not an agreed cause.

  5. Check each line, then approve or hold

    Use: The department heads

    Read the draft, recompute cited figures and check each line against the variance table; approve only lines that fit, hold the rest.

    Check

    Each line must fit the figures and what you said. Finance director reviews flagged explanations with departments before the pack is finalised.

Before you paste into any AI tool, remove any confidential information. Put it back at the end.

Tools in this workflow

Deciding between ChatGPT and Claude for this? See the comparison.

Final check

Never paste credentials or full payment details.

Department heads confirm their explanations were represented faithfully.

Every explanation links to a figure and is labelled a department claim.

Inconsistencies are flagged, not edited away.

Recompute flagged variances before finalising the pack.

Check the result against your original inputs. Approve it before sharing or acting.

What still needs checking
  • Pricing and plan limits for the tools listed were not read for this proposal.

Share this page