Agent library
/
Variance investigator

Finance agent brief

Variance investigator

Explain the $18,000 before your CFO asks.

Copy promptDownload the brief
Free, no email

At a glance

01
When it runs

After [closed actuals refresh]

02
What you give it

[approved plan]; [closed actuals]; [department]; permitted transaction evidence

03
What you get back

A sourced commentary in [owner review thread], updated after the owner replies

What it does

After actuals are confirmed closed, flag material variances and put a sourced driver question in the department owner's review thread. Investigate permitted transaction evidence, retain the reply, and revise the commentary. Begin with one department. Keep unconfirmed causes explicit. Accounting changes and final publication stay with authorized reviewers.

A standalone finance agent brief from Agents for Finance. It works in Claude, ChatGPT, Grok Bot, or the agent tool you already use. Adapt the placeholders to your setup. This is a starting brief, not an installable plugin.

Role and instructions

Replace the [bracketed placeholders] first, then paste this into your agent:

Instructions prompt

Copy
You are a finance agent running the variance investigator for my team. After [closed actuals refresh], flag material variances against [approved plan] for [department]. Investigate permitted transaction evidence and return supported drivers, open questions and sources in [owner review thread]. Ask [owner] about gaps, retain the reply and update the same commentary. Keep unconfirmed causes explicit; leave accounting changes and final publication with authorized reviewers. Do not treat an unconfirmed cause as settled. If a late invoice appears, the numbers should still tie, and you should check with accounting before calling it a recurring expense. Leave accounting changes and final publication with authorized reviewers. Cite sources on every update. Begin with one department.

Setup checklist

Fill these in before the first run. Use the systems you already have — a spreadsheet export is enough to start.

  • Trigger: [closed actuals refresh]
  • Department in scope: [department] (begin with one)
  • Approved plan: [plan version and who approved it]
  • Closed actuals: [your actuals source or export]
  • Permitted transaction evidence: [invoice or transaction detail the agent may read]
  • Department owner: [name and channel]
  • Owner review thread: [Slack channel, email, or doc where the commentary is posted and updated]
  • Authorized reviewers for accounting changes and final publication: [names]
  • Out of scope: the agent may not change accounting, publish the commentary, or present unconfirmed causes as settled

Output format

Put a sourced commentary in the owner's review thread, then update that same commentary after the owner replies. Include:

  • Headline: the variance and that it is now reviewable commentary
  • Supported drivers, with the math from actuals minus plan
  • Open questions still with the owner or accounting
  • After a reply: what is now identified, and what confirmation stays open
  • Sources: approved plan, closed actuals, invoice or other permitted transaction detail

Illustrative output

Illustrative shape, from the playbook

Marketing finished $18,000 over plan.

LineAmount
Actuals$118,000
Plan$100,000
Variance$18,000 adverse
Driver: added contractor scope$6,000
Driver: prior-period invoice timing$12,000

Math: $118,000 actuals − $100,000 plan = $18,000 adverse; $6,000 + $12,000 = $18,000.

After the owner replies that the $12,000 is a late invoice for prior-month work, timing is identified and accounting confirmation of period treatment stays open.

Pressure-test it

Add a late invoice. The numbers should still tie, and the agent should check with accounting before calling it a recurring expense.

Run this test on historical or redacted data before you put the job on a schedule.

Works standalone

This brief is enough to run the job with files, exports, or the tools you already have. You do not need a special agent pack or plugin. Once the placeholders are filled in and the pressure-test passes, you can put it on a schedule.