Year-on-year comparison

Excel Has example + expected result Year-end

Two years of accounts in. A comparison sheet with formulas out, then plain-English notes for the year-end meeting and questions for the client.

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 prepares the source. The comparison sheet and notes feed Year-end review deck.
Version:
1.2 (October 2026)

Who it's for

Managers and partners preparing for a year-end review, a client meeting or a planning conversation. Variance hunter does month against budget; this does year against year.

The problem it solves

Year-end accounts mean little to a client until someone explains what moved and why. Building the comparison, working out which movements matter, calculating ratios for both years and writing notes the client can follow takes time before every meeting, and a figure worked out by hand can disagree with the accounts.

What it does

What the skill does

Give it two years of figures, the profit and loss at least and the balance sheet if you have it. It takes control totals from the source, builds a Comparison sheet with formulas for the movement in pounds and percent, a flag against your threshold (either the £ or the % test trips it) and whether each movement is favourable or adverse, after checking how the file stores costs, and checks the totals match. Balance sheet lines show an increase or decrease instead and aren't ranked with the profit and loss. It ranks the profit and loss lines that moved most, works out key ratios for both years where the data supports them and drafts short notes for the meeting. The notes connect balance sheet movements that explain each other, such as cash falling while debtors and borrowing rose. It only gives a current ratio when the balance sheet separates current liabilities. Otherwise it says the ratio can't be calculated from these accounts. Where it can't see a reason for a movement, it writes "to discuss with the client" and adds a question to a list.

Use cases

  • Preparing notes for a year-end meeting with an owner-managed business
  • Explaining why profit fell when sales rose
  • Comparing gross margin, net margin and overheads as a share of sales across two years
  • Building a list of questions to ask the client about movements nobody can explain
  • Preparing figures to hand to Year-end review deck

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 year-on-year-comparison 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 threshold, how many lines to highlight and your notes style.
  3. 3 In the Copilot pane, open Settings (...), then Manage skills > Custom skills > Create OneDrive folder > Open skills folder.
  4. 4 Put the year-on-year-comparison folder there, then select Refresh. The folder name must match the skill name, so don't rename it.
  5. 5 Point it at the two years of accounts, say which is current and which is prior and ask it to compare them and draft the notes.
  6. 6 Review the control total check, the notes and the question list before the meeting.

In Cowork

  1. 1 Download the zip file from this page and unzip it. You'll have a folder called year-on-year-comparison 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 threshold, how many lines to highlight and your notes 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 year-on-year-comparison 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 two years of accounts, say which is current and which is prior and ask it to compare them and draft the notes.
  7. 7 Review the control total check, the notes and the question list before the meeting.

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.

year-on-year-comparison/SKILL.md
---
name: year-on-year-comparison
description: Use when two years of accounts need comparing for a year-end review, a client meeting or a planning conversation. Builds a comparison sheet with formulas, shows control totals, lists the lines that moved most and drafts plain-English notes on each.
---

# Year-on-year comparison

Year-end accounts mean little to a client until someone says "sales were up 12%, mostly from the new contract, and overheads went up faster". This skill builds the comparison with formulas, finds the movements that matter and drafts the notes, ready for the year-end meeting.

Variance hunter does month against budget. This does year against year.

## 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.

- Threshold for "moved a lot": more than £[amount] or more than [percent]% of the prior-year figure. Either one trips the flag (defaults: £5,000 and 15%)
- How many lines to highlight: (default 10)
- Notes style: plain English for a business owner, two sentences per line, no jargon

## What you need from the user

Two years of figures in one file or two: P&L at least, balance sheet if available. Line descriptions must match between years, or close enough to map. Which year is current and which is prior.

If the line descriptions do not match and cannot be mapped confidently, list the unmatched lines and ask.

## Method

1. **Describe what you found**: sheets, columns, which is current and prior, how many lines, any lines in one year but not the other.
2. **Control totals from the source**: sum of each year's figures, line count, as formulas. Write them down.
3. **Build the Comparison sheet** (never overwrite the source). Columns: Line | Prior year | Current year | Movement £ | Movement % | Flag | Direction. Movement £ = current less prior. Movement % = Movement £ divided by the absolute prior-year figure, so its sign always matches the £ (blank if prior is zero). Flag applies the threshold (either test). Direction is a formula and depends on how costs are stored: if costs are negative numbers, a positive movement is favourable on every line; if costs are positive numbers, a positive movement is favourable on income and profit lines and adverse on cost lines (ask once if it is not obvious from the labels). Say which convention the file uses. For balance sheet lines, Direction is "Increase" or "Decrease" in the balance itself, not favourable or adverse: for assets it follows the sign of Movement £; for liabilities stored as negatives it is the reverse, written "Increase (more owed)" or "Decrease (less owed)"; for liabilities stored as positive numbers and deducted, a positive Movement £ is "Increase (more owed)" and a negative one "Decrease (less owed)". Say which storage the file uses. Format as a table.
4. **Check**: sums on the comparison sheet equal the source sums; line count matches. Show the check.
5. **Rank** the P&L lines by absolute Movement £ and highlight the top N over the threshold. Balance sheet lines are listed with their movements but not ranked with the P&L; any balance sheet movement over the threshold goes into the notes.
6. **Key ratios**, as formulas, both years: gross margin, net margin, overheads as a percentage of sales. Balance sheet if present: debtor days and creditor days (say the formula used). Current ratio only if the balance sheet separates current liabilities, including the part of any loan due within a year, VAT, PAYE and tax. If it does not, write "Current ratio: not calculable from these accounts" and say what is missing. Never leave a line out to make a ratio work. Only ratios the data supports.
7. **Draft the notes**: one short paragraph on the year overall, then two sentences per flagged line. In the overall paragraph, connect balance sheet movements that explain each other arithmetically: if cash fell while debtors, stock or fixed assets rose and borrowing increased, say so plainly (for example "cash fell by £7,880 while customers owed £19,500 more and the loan rose by £15,000: growth has been funded by borrowing rather than collected cash"). That is reading the figures, not inventing a reason. For each flagged line: what moved, by how much, and a possible reason only if visible in the data or told by the user. Otherwise "to discuss with the client".
8. **Question list**: every flagged line with no known reason, as a question to ask at the meeting.

## Output

1. **The Excel file**: source untouched, Comparison sheet, Ratios block, check block, all formulas.
2. **Notes**, as a Word document if in Cowork, otherwise text: overall paragraph, flagged lines, ratios in plain English, question list. Marked DRAFT.
3. **Source note**: which file, which columns, which threshold, the control totals.

## Guardrails

- Formulas only. Every figure in the notes matches a cell.
- Never invent a reason for a movement.
- Ratios only where the data supports them. Do not estimate missing balance sheet items.
- If the check does not reconcile, stop and say so.
- British English. £1,000 and 12%.

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 change my numbers?
No. It builds a new Comparison sheet and leaves the source untouched. Every change, percentage and ratio is a formula, and every figure in the notes matches a cell you can click on.
Will it make up reasons for the movements?
No. A reason only appears if it's visible in the data or you've told it. Otherwise the note says "to discuss with the client" and the line goes on the question list.
What if the line descriptions differ between years?
It maps lines that are close enough. If it can't map them confidently, it lists the unmatched lines and asks you.
Is there a sample to try?
Yes. The download includes a profit and loss and a summary balance sheet for two years in the examples folder, with a few deliberate big movements. 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

    Spreadsheet health check

    Before anyone relies on a client's workbook, this looks under the bonnet and ends with a verdict on whether it can be relied on. It changes nothing.

    Job
    Getting data in shape
    Works in
    Copilot in Excel, Copilot Cowork
    Chains with
    Run it on a client model before Variance hunter or Numbers to board slides rely on it. Tidy this export fixes layout problems it finds in raw exports.
    Version 1.2 Download Spreadsheet health check
  • Excel Has example + expected result Works for any team

    Variance hunter

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

    Job
    Month-end and reporting
    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 Download Variance hunter
  • PowerPoint

    Year-end review deck

    Turns year-end accounts into the deck for the client meeting. Eight slides, one message each, plain English, speaker notes for the partner.

    Job
    Year-end
    Works in
    Copilot in PowerPoint, Copilot Cowork
    Chains with
    Takes the output of Year-on-year comparison. Explain it to the client handles any line the client queries afterwards. Uses House style.
    Version 1.2 Download Year-end review deck