← All use cases

Review budget vs. actuals

Combine the plan, actuals and close notes in a workbook that shows variances.

Provide ZeroTwo with a budget, an actuals export, and close notes; it matches actuals to plan, computes variances, flags reconciliation problems, and keeps supported explanations apart from unresolved finance questions.

Easy
30m

Related links

Best for

  • Month-end budget versus spend reviews.
  • Finance commentary for leadership.

Skills & Plugins

  • Spreadsheets
    Cleans and maps rows, builds variance tables, and produces a workbook you can review ($spreadsheets).

Starter prompt

I've attached this month's budget file, the GL actuals export, and the controller's close notes. Map each actual line to its budget category, keep the raw inputs untouched on their own tabs, and build an editable .xlsx where variances are live formulas rather than pasted numbers. Treat revenue above plan as favorable and expense above plan as unfavorable, list any account that didn't map cleanly, and finish with a summary tab of the biggest swings and which ones the close notes actually explain.

Introduction

Give ZeroTwo the plan, actuals, and close notes and it assembles a review workbook with mapped categories, computed variances, and a summary.

Create the review workbook

  1. Attach the three sources, or name exact files.
  2. Run the starter prompt for an .xlsx.
  3. Open the workbook in the file viewer to check inputs, mappings, formulas, and summary. The viewer is read-only, so make changes by asking in chat or by using Annotate on the cell or object.
  4. Continue in chat to fix mappings or add department cuts.

Point to specific finance files instead of a broad Google Drive search.

Check the variances

Before sharing, ask ZeroTwo to list the largest favorable and unfavorable variances, doubtful mappings, unclear sign conventions, explanations the notes support versus those needing review, and formula issues, fixing safe ones.

Related use cases