Have you had AI draft the variance commentary from your budget-vs-actual table?

You paste the numbers and your notes on why they moved, and AI writes the first draft. You still check every figure before it goes to leadership.

How to automate it

How to automate “build the monthly management or board pack”

Here are 3 ways to spend less time on this, best first. Each comes with steps you can follow today and, for AI fixes, a prompt to copy.

240 min

typically, once a month

50%

of the time can be automated

Some setup

to set up

Fix 1 of 3

Process fixBest fix

Freeze the board pack format and link it to the source

When the pack layout stays the same and the tables are linked to the data, each month you only update commentary.

Typically saves about 35% of the time3 h to set up

1Agree the pages and KPIs with the CEO or board chair and stop changing them monthly.
2Link tables and charts in PowerPoint to the Excel source, or build them in a reporting tool.
3Keep a one-page "what changed" section for new requests.
4Draft commentary with AI from the numbers, then review.

Tools: Excel and PowerPoint linked objects · Power BI · Fathom or Syft

Fix 2 of 3

Have AI draft the variance commentary from your numbers

Paste the budget-vs-actual table and your notes; AI writes the first draft of the commentary. Numbers going to the board stay your responsibility, so check every figure.

Typically saves about 50% of the time10 min to set up

1Export the budget-vs-actual table with prior period.
2Add one line of context for the big movements (you know the why; the AI does not).
3Use the prompt below in an approved AI tool or Copilot in Excel.
4Check every number in the text against the table before it goes out.

Prompt to copy

Here is our budget-vs-actual for [PERIOD] with prior month:
[PASTE TABLE]

My notes on the main drivers:
[PASTE NOTES]

Write management commentary: a three-sentence summary, then one short paragraph per line where the variance is over [THRESHOLD $ OR %]. Use only the numbers in the table and the reasons in my notes. If a big variance has no reason in my notes, write [NEED REASON] instead of guessing.

Tools: ChatGPT, Claude, Gemini or Microsoft Copilot (company-approved account) · Copilot in Excel

Fix 3 of 3

Automation

Build the report once so it refreshes itself

Connect the spreadsheet or dashboard straight to the source so next week's report is already done.

Typically saves about 80% of the time4 h to set up

1List where each number comes from.
2Use Power Query (Excel), a connected sheet, or a Google Data Studio or Power BI dashboard pulling from the source.
3Schedule the refresh and send the link instead of an attachment.

Tools: Excel Power Query · Power BI · Google Data Studio (formerly Looker Studio) · Google Sheets connectors

Quick wins

Have you tried…

Have you had AI draft the variance commentary from your budget-vs-actual table?: You paste the numbers and your notes on why they moved, and AI writes the first draft. You still check every figure before it goes to leadership.

Who does this task

Roles in our library that list this as one of their common tasks. Each guide covers the rest of that role’s week.

Controller / accounting manager FP&A analyst CFO / finance manager

HourLeak · the 8-minute work audit

How many hours does this cost you?

The free 8-minute check works out where your week goes and gives you your top fixes. The team scan does the same for everyone and adds it up, so you know which leaks to fix first.

Take the free check Scan my team, $49

Answers are anonymous. Leaders only see team totals.