Variance hunter

Excel Has example + expected result Works for any team Month-end and reporting

Builds a variance table with formulas, flags the movements over your threshold, labels them favourable or adverse and drafts the commentary.

Runs best in: Copilot in Excel, on the open workbook. Use Cowork when you want it run across several files or chained with other skills.

Works in:
Copilot in Excel, Copilot Cowork
Chains with:
Tidy this export and Spreadsheet health check prepare the source. The variance sheet feeds Numbers to board slides. Commentary uses House style.
Version:
1.2 (October 2026)

Who it's for

Accounts seniors, managers and reviewers who prepare or review monthly management accounts. It helps most where one person looks after several clients' month ends at once.

The problem it solves

Management accounts are only useful if someone explains the movements. Working out which lines moved enough to matter, labelling them favourable or adverse and writing the commentary takes time, and a figure worked out in someone's head or typed into the commentary can quietly disagree with the accounts.

What it does

What the skill does

Point it at a management accounts file with an actual column and a budget or prior period column. It takes control totals from the source, then builds a variance table on a new sheet using formulas rather than typed numbers and checks the totals match. It flags any line that moves more than your £ amount or your percentage, as either test trips the flag, checks whether the file stores costs as negatives before labelling each one favourable or adverse, and drafts short commentary for a business owner. Where it can't see a reason for a movement it says so and adds a question to a query list instead of guessing.

Use cases

  • Month-end review of a client's management accounts against budget
  • Comparing this month with the prior month or the same month last year
  • Drafting variance commentary before the pack goes to the client
  • Building a list of questions for the client or the bookkeeper
  • Preparing figures to hand to Numbers to board slides

How to use it

Install it, then use it

Install House style first. It's the one file every skill reads for your firm name, sign-off, voice and format. Fill it in once and this skill's Your firm block only needs the settings for this job. Skip it and the skill asks for your firm name and sign-off once.

In Excel

  1. 1 Download the zip file from this page and unzip it. You'll have a folder called variance-hunter with SKILL.md, README.md and an examples folder inside.
  2. 2 Open SKILL.md in any text editor and fill in the Your firm block at the top, such as your materiality threshold, default comparison and commentary style.
  3. 3 In the Copilot pane, open Settings (...), then Manage skills > Custom skills > Create OneDrive folder > Open skills folder.
  4. 4 Put the variance-hunter folder there, then select Refresh. The folder name must match the skill name, so don't rename it.
  5. 5 Point it at the management accounts file and ask it to run variance hunter. If you haven't set a threshold, it uses the default of £2,000 or 10% and says so.
  6. 6 Review the control total check, the commentary and the query list before anything goes to the client.

In Cowork

  1. 1 Download the zip file from this page and unzip it. You'll have a folder called variance-hunter with SKILL.md, README.md and an examples folder inside.
  2. 2 Open SKILL.md in any text editor and fill in the Your firm block at the top, such as your materiality threshold, default comparison and commentary style.
  3. 3 Open Customize > Skills, select the arrow next to Add, then Upload skill, and choose the zip (recommended) or the SKILL.md on its own. If you changed SKILL.md, upload that, or zip the folder's contents again first so SKILL.md stays at the top level.
  4. 4 Or skip the upload and put the variance-hunter folder in your OneDrive at Documents/Cowork/skills/. Keep the folder name as it is.
  5. 5 Start a new Cowork conversation so it picks up the skill.
  6. 6 Point it at the management accounts file and ask it to run variance hunter. If you haven't set a threshold, it uses the default of £2,000 or 10% and says so.
  7. 7 Review the control total check, the commentary and the query list before anything goes to the client.

The skill itself

Read the full SKILL.md

This is the whole skill. Your firm name, sign-off and voice come from House style. Change the settings under Your firm for anything specific to this job. Everything else follows them.

variance-hunter/SKILL.md
---
name: variance-hunter
description: Use when preparing management accounts commentary. Compares actuals against budget or the prior period in an Excel file, flags the movements that matter using the firm's threshold, and drafts the commentary. Uses formulas and shows control totals so every figure can be checked.
---

# Variance hunter

Management accounts are only useful if someone explains the movements. This skill finds the movements worth explaining and drafts the commentary, without ever doing arithmetic in its head. Every number comes from a formula, every total is checked against the source, and the output says where each figure came from.

## Your firm

Shared settings (firm name, sign-off, voice, how dates and money are written) come from the `house-style` skill in this pack. Fill that in once and every skill uses it. If it is not loaded, ask for the firm name and sign-off once at the start and carry on.

Settings specific to this skill. Edit before first use. If a setting is blank but has a default, use the default and say so in one line. If a blank setting has no default and the job cannot be done without it, ask for all such settings together in one message at the start. If the job can be done without it, leave it out and say so. Never make up a value for a firm setting.

- Materiality threshold: flag any line where the movement is more than £[amount] or more than [percent]% of the comparison figure. Either one trips the flag (defaults: £2,000 and 10%)
- Compare to: budget, prior month, prior year, or same month last year (default: budget if present, otherwise prior period)
- Commentary style: short, factual, one or two sentences per flagged line. Written for a business owner, not an accountant.

## What you need from the user

An Excel file (or a table pasted in) with at least: line description, actual for the period, and one comparison column (budget, prior period or prior year). A P&L is typical. Balance sheet and cash flow work too.

If the file has more than one period or more than one comparison, confirm which to use in one question. If the file has no comparison column, say so and stop; do not invent one.

## Method

1. **Read the file and describe what you found** in two lines: the sheet, the rows, the columns you will use as actual and comparison, and the period. Ask the user to confirm if there is any doubt.
2. **Take control totals from the source before touching anything**: the sum of the actual column and the sum of the comparison column, and the row count. Write them down.
3. **Build a working table** on a new sheet (never overwrite the source). Columns: Line | Actual | Comparison | Variance £ | Variance % | Flag | Direction. Every calculated column must be an Excel formula referencing the actual and comparison cells, not typed values. Variance £ = actual minus comparison. Variance % = Variance £ divided by the absolute value of the comparison, so its sign always matches the £ figure; blank if the comparison is zero. Flag = formula applying the threshold (either test).
4. **Check control totals** on the working table: sum of actual and sum of comparison must equal the source totals; row count must match. Show the check. If anything does not match, stop and say so.
5. **Direction matters, and depends on how costs are stored.** Check the file first. If costs are negative numbers (so profit is the sum of the column), a positive variance is favourable on every line. If costs are positive numbers, a positive variance is favourable on income and profit lines and adverse on cost lines. Say which convention the file uses, make Direction a formula, and label every line with a non-zero variance favourable or adverse.
6. **Draft commentary** only for flagged lines, in order of size. For each: what moved, by how much (£ and %), direction, and a possible reason only if it is visible in the data or the user has told you. Otherwise write "reason to be confirmed" and put it in a query list.
7. **Write a short overall summary**: top line, profit line, the three biggest movements, anything that needs a conversation.
8. **Produce the query list**: every flagged line where the reason is unknown, as a list of questions for the client or the bookkeeper.

## Output

1. **The Excel file** with the original sheet untouched and a new "Variance" sheet containing the working table (formulas, not values), the control total check and the flags.
2. **Commentary**, as a Word document if in Cowork, otherwise as text: overall summary, then flagged lines, then the query list. Marked DRAFT.
3. **A source note** at the end: which file, which sheet, which columns, which threshold, and the control totals.

## Guardrails

- Never type a number into a calculated cell. If you cannot write a formula for it, do not present it as calculated.
- Never calculate in prose. Every £ and % in the commentary must match a cell in the working table.
- Never invent a reason for a movement. Visible in the data, told by the user, or "to be confirmed".
- If control totals do not reconcile, do not produce commentary. Report the mismatch.
- British English. £1,000 and 10%.

Questions

Questions about this skill

Is the skill free?
Yes. Download it, fill in the Your firm block and use it. There is no email form and no charge.
Does it send anything?
No. It adds a Variance sheet to the file and drafts the commentary, marked DRAFT. The original sheet is left untouched and nothing goes to the client until you send it.
Will it make up explanations?
No. A reason only appears if it's visible in the data or you've told it. Otherwise it writes "reason to be confirmed" and adds a question to the query list.
How do I know the figures are right?
Every variance and flag is an Excel formula referencing the source cells, and every £ and % in the commentary matches a cell you can click on. If the control totals don't reconcile with the source, it reports the mismatch and doesn't write any commentary.
Is there a sample to try?
Yes. The download includes a 13-line profit and loss for a small business (11 typed lines plus gross profit and net profit as formulas) with actual and budget columns in the examples folder. Ask it to run variance hunter on that file with a £2,000 or 10% threshold. The examples folder also has expected.md, which lists the exact figures, flags and fail conditions the skill should produce on the sample, so you can check the result in a minute and re-check it after Copilot updates.

Firmwide

Want your own firm's procedures built in and kept working? That's a Firmwide install.

A fixed-price install, typically six to eight weeks: Copilot made safe and useful in your Microsoft 365, an agent and a skills pack for every department, handed over with training. Then Run keeps it working.

See Firmwide

Next step

Want this tailored to your firm?

A free 30-minute Copilot Readiness Check with James, online. You leave knowing where Copilot can and cannot see your data, the two jobs to automate first and a rough install price. Your own skills, built from your procedures and handed over to each department on its own work.

Related skills

All skills
  • Excel Has example + expected result Works for any team

    Tidy this export

    Turns a messy bank or practice software export into a clean Excel table on a new sheet, then proves nothing was lost with row counts and totals before and after.

    Includes a known export quirks table for Xero, Sage, QuickBooks Online, FreeAgent, bank CSVs and practice software.

    Job
    Getting data in shape
    Works in
    Copilot in Excel, Copilot Cowork
    Chains with
    Run it first on any export, then hand the clean sheet to Bank statement summary, Reconcile two lists, Aged debtors to action, Variance hunter or Year-on-year comparison.
    Version 1.2 Download Tidy this export
  • Excel Has example + expected result Works for any team

    Reconcile two lists

    Give it two lists that should agree. It matches them and builds a reconciliation sheet with formulas, with control totals proving the difference is fully explained.

    Job
    Getting data in shape
    Works in
    Copilot in Excel, Copilot Cowork
    Chains with
    Tidy this export cleans the inputs first. Unmatched invoices go to Aged debtors to action for chasing.
    Version 1.2 Download Reconcile two lists
  • PowerPoint

    Numbers to board slides

    Turns management accounts into a short board or client deck without anyone retyping a number.

    Job
    Month-end and reporting
    Works in
    Copilot in PowerPoint, Copilot Cowork
    Chains with
    Takes the output of Variance hunter directly. Uses House style for commentary and firm name.
    Version 1.2 Download Numbers to board slides