Skip to main content

Credit consumption & cost

What Copilot costs, where it goes, and who to bill.

Templates, browser tools and methodology for tracking Microsoft Copilot credit consumption and cost — from a single view of spend across products, through to departmental chargeback and spend policy.

New · Power BI template

Consumption Central

One template for Copilot credit consumption and cost across four products — Cowork / Work IQ, Copilot Studio, GitHub Copilot and Azure AI Foundry. Today that is four portals and four exports with no single view.

  • Group spend by your own org data — department, cost centre, country, manager
  • Forecast to the end of the billing period, with overage and unused capacity against prepaid packs
  • Three deployment paths — local CSV, Fabric, or straight from Viva
  • Synthetic sample data ships with it — see the whole report before touching a tenant

It reports; it does not enforce. Limits and policies stay in the admin centre — this tells you what they should be.

Two-minute walkthrough — what it covers and how it fits together. Watch on YouTube ↗

Two templates on this page

They read different exports, so which one fits depends on what you have access to and what you need out the other end.

Cowork Chargeback

Runs on Microsoft 365 admin center credit exports plus an Entra user export. Built for departmental chargeback — billing models, prepaid pool allocation, and per-user allowances.

Consumption Central

Reads the Viva Insights consumption export alongside Power Platform, GitHub and Azure, so Copilot Studio, GitHub Copilot and Foundry spend land in the same model as Cowork.

Power BI template · CSV or live Viva Direct Query

Cowork Credit Chargeback

Turns Cowork credit consumption into a departmental bill, from the Microsoft 365 admin center export plus your Entra user list, or live from Viva Insights with no exports at all.

  • Live from Viva Insights (Direct Query): a self-refreshing variant that connects straight to Viva, supports scheduled refresh, and needs no CSV exports
  • Three billing models priced side by side — pay-as-you-go, prepaid, hybrid, with the cheapest flagged
  • Prepaid pool allocation — split by usage, by headcount, or by budgeted allowance
  • Per-user limits and an over-limit watchlist — who needs their allowance adjusted
  • Row-level security — department heads see only their own line
  • FOCUS cost view — the chargeback in FinOps Open Cost & Usage Specification columns

Walkthrough — Consumption, Chargeback, Billing Models, Prepaid Allocation. Watch on YouTube ↗

Cowork browser tools

No install, no setup. Each runs entirely in your browser on exports you already own. Nothing is uploaded anywhere.

3 more tools

Not sure which one? Chargeback and the FinOps report run on the same data. Chargeback answers “bill this department.” FinOps answers “show Cowork next to our other cloud spend.” If the customer already has a FinOps practice, start with FinOps. If they just need to bill departments, start with Chargeback. Policy Helper is the follow-up either way: Chargeback tells you what already happened, Policy Helper stops it happening again.

Where do I get these files?

Each browser app above runs on two CSV exports you already own — nothing is uploaded, everything is parsed locally in your browser:

  1. Entra user export(s) — in the Microsoft Entra admin center, open Identity → Users → All users and choose Download users. This CSV carries the org attributes (Department, Cost Center, Job title, etc.) used to allocate cost and group people.
  2. Copilot credit / Cost Management export — in the Microsoft 365 admin center, go to Copilot → Cost management → Consumption and choose Export CSV. It just needs one row per user with the credits they consumed.

Column names are auto-detected, so most export layouts work as-is. The Power BI report & template uses the same two sources.

Cowork time-savings methodology

How the ROI model turns Cowork tasks into hours saved: per-category time-savings bands, each traceable to a published study.

Cowork Time-Savings Methodology · v4
↓ PDF

Per-category time-savings bands, each traceable to a published study. Download the PDF for the full-resolution version.

Downloads & resources

Questions or feedback on the methodology?

Reach the Copilot ROI Advisory team directly at copilot-roi-advisory-team-gh@microsoft.com.