Section 7: HR, finance-accounting, legal-compliance, procurement and operations

Scenario 65: Variance explanations and expense checks at close

Level: Intermediate · Tools: ChatGPT Data Analysis; XLSX or CSV and a policy PDF [71] [79].

Who and in what situation

Hakan is on the FP&A team at the holding company in İstanbul. Each month, he prepares a management report on budget-to-actual variances and compares expense samples against the expense policy.

How it is done today

The spreadsheet is filtered, and managers are asked about the reasons for large variances. Because the policy PDF is opened separately, the row to which each check applies is tracked manually.

How to do it with AI

  1. He prepares the file with clear column names and a single record per row; this layout is recommended for Data Analysis [71].
  2. He attaches the XLSX or CSV and the approved policy PDF using Add photos & files [79].
  3. He has it calculate the variance, showing the columns and denominators used, and add the policy clause, evidence, missing information and a follow-up question to each row.
  4. He reviews the calculation with the request Show your analysis code, assumptions and outputs; the finance manager approves the narrative and records [71].

Example prompt

Work on {period} using {budget-to-actual file} and {approved expense policy}. For each significant variance, write an explanation, policy clause, missing evidence and follow-up question using only evidence in the files. Do not guess the cause; if it is not in the data, say “no evidence.” Do not make accounting adjustments or approve payments.

Evidence and real-world example

No published customer case was found for this close and policy check. The basis is the Data Analysis documentation on summarizing tables, performing calculations, reviewing outliers and showing code/assumptions [71].

Points to consider

OpenAI states that analysis code, outputs and assumptions should be reviewed, and that scanned tables may be unreliable [71]. High-impact automation in financial decisions without human review violates OpenAI policy [123]. Use the approved business workspace for Confidential (Gizli) files [80].

Sources for this scenario

  1. Data analysis with ChatGPT (help.openai.com)
  2. Uploading files and audio to ChatGPT (help.openai.com)
  3. Business data privacy security and compliance (openai.com)
  4. OpenAI Usage policies effective October 29 2025 (openai.com)