Finance & OperationsClose package and variance narrativeHigh

Explain the numbers. Make the gaps visible.

Bring close data, comparisons, and business commentary into a sourced leadership-ready package.

Works inExcelPower BI / FabricPowerPointWord
Preview — real Cowork captures and reviews still pending

Not a verified training release. The deck’s prompts and workflows have not yet been run in this environment. Authentic screenshots, translation review, and model approval are still required.

Business context

Does this sound familiar?

The close numbers arrived. The explanations have not.

The multi-ledger close consumes the team for days each month. Material variances are explained by chasing owners after the numbers land. The board-ready package is assembled by hand from workbooks and email. Narrative quality depends on who is available that month.

The workflow to aim for

One review-ready close narrative with sources and open items.

Cost Savings: close and package assembly hours recaptured. Risk Mitigation: variances explained with sources before review. Innovation: a repeatable, scheduled close narrative.

CapacityRisk reductionRepeatability

What could this be worth to your team?

Value of the time saved each year

USD 53,333

For the whole team, not per person — the salary cost of the hours Cowork could free up. Not cash back.

1,000People in the team
80%Active rate
90%Conservative risk discount

Training deck headline: USD 228K — The deck also counts revenue and risk effects; this estimate counts recaptured time only.

How you would measure success

Days to close · report generation time · variance explanation cycle time

Cookbook defaults

Illustrative model · review pending · not cash savings or net ROI
Cookbook-authored estimate; not the original slide’s benefit figure.

How this is calculated

Under these assumptions, 9,600 annual hours of capacity are valued at USD 53,333.33 after a 90% risk reduction. This is not a promise of cash savings.

Annual hours saved before risk adjustment
9,600
Active users in this function
800
Hourly employee cost (USD)
USD 55.56
Value retained after risk adjustment
10%
  • Close preparation: USD 53,333.33
    4000 × 12 × 0.8 × 25% h × USD 55.56/h × 10%

Only labor capacity is monetized. Revenue and risk benefits remain qualitative to avoid unsupported totals and double counting.

Source-informed inputs: deck slide 110. Formula: cookbook capacity model v1, not a reconstruction of the missing pilot formulas.

Is it worth running?

Cost vs value — one run and one month

For the finance team · one run per monthly close

6,944.4×value for every USD 1 spent on Cowork
MeasureOne runOne month (≈ 1 runs)
Time saved1,000 h1,000 h
Value of that timeUSD 55,555.56USD 55,556
Estimated Cowork costUSD 8.00USD 8
Value left after costUSD 55,548

It pays for itself if each run saves at least 8.64 minutes of work.

How cost and value are estimated
  • Cowork is billed per use in Copilot Credits. Credits per run are an estimate set by your cookbook admin — actual use depends on how much context is read, how many steps and tools run, and how long the task takes. The credit price is also set by the admin (the pay-as-you-go list price is USD 0.01; prepaid packs can be cheaper).
  • Value here is the salary cost of the time saved. The yearly team estimate above is more cautious and keeps only part of it; on that basis one run is worth USD 5,555.56.
  • Microsoft Copilot Credit Estimator · How Cowork billing works (Microsoft Learn)

Credits per run are set by the cookbook admin.

What you will work toward

  • Variance narrative
  • Exceptions and open questions
  • Follow-up actions

Why Cowork?

Close data lands quickly; the commentary that explains it does not. Cowork combines: close data, plan, forecast and prior-period comparison, collected commentary, sourced variance explanations, flagged gaps, and a drafted package, into one repeatable close workflow.

On this page

Before you start

What you are asking Cowork to achieve

Finish the close with the material swings already explained instead of discovered in review. Compress the work of pulling numbers, commentary, and variance logic into one leadership-ready package.

Works in

ExcelPower BI / FabricPowerPointWord

Connects to

ERP/general ledger; consolidation system; Excel; Power BI/Fabric; Teams/Outlook; SharePoint

Complexity

High High. Needs ERP / ledger data reachable through Excel or Power BI.

Good to know

Replace bracketed placeholders with your intended context before submitting. Use only sources you are authorized to access. The original prompts include approval boundaries for sharing, scheduling, publishing, or writebacks; preserve those boundaries. Reading this page does not authorize any action.

Requires the relevant Microsoft plugin, approved connector, agent, API, local-browser path, or governed export. Availability depends on tenant configuration, permissions, region, and source-system controls. Cowork acts only within the signed-in user’s authorized access.

Run it in Cowork — step by step

  1. Open Cowork and start a new task

    In Microsoft 365 Copilot, select the Cowork toggle at the top of the left navigation. Can’t see it? See “Do you have Cowork?” in Getting started, or ask your IT admin.

  2. Fill in the brackets

    The prompt has placeholders in [square brackets]. Replace each one with your own details:

    [Period]

  3. Copy the prompt and send it

    Copy the prompt, paste it into Cowork, replace the highlighted brackets, then send. This is the original wording from the training deck.

    Prompt · English original
    I’m building the close package for [Period] and need the material variances explained in a leadership-ready narrative.
Pull the close data:
Use the ERP or general ledger, consolidation system, Excel close workbooks, prior close packages, Power BI or Fabric, and any commentary in Teams, Outlook, SharePoint, or OneDrive.
Identify the biggest swings versus plan, forecast, and prior period where relevant.
Bring together the financial data and the commentary already sitting in different places.
Explain the variances:
Summarize the likely driver behind each material swing and note where support is still incomplete.
Flag the exceptions or unresolved items that leadership should know before review.
Package it:
Draft the close narrative and supporting review list, and hold any distribution or writebacks for my review.

    Copies the exact original text.

  4. Follow Cowork through the workflow

    Cowork works through these stages from the deck. Use them to follow its progress and notice where it asks for missing information.

    1. Pull → Close data from the ledger

      📷 Screenshot coming soon

    2. Compare → Plan, forecast and prior period

      📷 Screenshot coming soon

    3. Collect → Commentary from the business

      📷 Screenshot coming soon

    4. Explain → Material variances with sources

      📷 Screenshot coming soon

    5. Flag → Gaps and open items

      📷 Screenshot coming soon

    6. Draft → Review-ready close package

      📷 Screenshot coming soon

  5. Review before you approve

    The prompt asks Cowork to draft the close narrative and review list, and hold any distribution or writebacks for your review.

    Check the result against “What you will work toward”, confirm the cited sources, and look at anything flagged as missing. Only then approve the next action.

What you get back

A close package with the variance narrative, supporting exceptions, open questions, and the follow-up actions needed to resolve remaining issues before leadership review.

About this material

The deck provides workflow stages and prompts, not a verified click-by-click walkthrough. No additional task prompts or sample datasets are supplied here. Actual Cowork runs and screenshots are still required before this becomes a verified training guide.

Adapted from source slides: 88–89 · Nifty Fifty