Cowork Chargeback

One job, done well: turn your Copilot Cowork consumption and org exports into a finance-ready, invoice-reconciled chargeback — per cost center and per person, in dollars. 100% in your browser.

All processing happens locally. Your files never leave your device. No uploads, no servers, no telemetry.

How it works

Load your Entra user export(s) and your Copilot credit / Cost Management export. Every credit consumed is charged to its unit at your contracted rate, so the journal totals to 100% of the bill. Enter your Microsoft invoice total to reconcile.

Load your data

Entra user exports (CSV) · one or more

Drop Entra CSV files here or click to browse (multiple allowed)

No file selected

Copilot credit / Cost Management export (CSV)

Drop the Copilot credit CSV here or click to browse

No file selected

Contracted rate ($/credit) Credits are priced to dollars at this rate. Adjust live in the report too.

Fallback credit limit Used only for the secondary overage lens when the credit file has no per-user limit.

Where do I get these files?

Entra user export(s) — in the Microsoft Entra admin center, open Identity → Users → All users and choose Download users. That CSV carries the org attributes (Department, Cost Center, Job title, etc.) used to allocate each person to a unit. You can load more than one.
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 — you can remap the org column inside the report if needed. Every file is parsed locally in your browser; nothing is uploaded.

Changelog

2026-07-20

Added Spending-policy-driven credit limits, a "Cut by: Spending policy" view, and a Policy column in the line items and exports.
Added Prepaid credits purchased — pool value, % consumed, and remaining balance or PAYG overflow.

2026-07-17

Added Three billing models (PAYGO, Prepaid pack, Hybrid) shown side by side per department, plus a per-person model toggle.
Added Drill-down — click a unit to expand the people who make up its charge.
Added Total vs Daily-average toggle on the journal.
Added Multi-tab Excel workbook export (Summary, Allocation, Users, Model comparison) with live formulas.
Added Prepay sizing panel and tooltips on every visual.
Changed Sleeker sticky left-rail layout; summary reorganised into 2×3 cards.
Removed The single global billing-model toggle — replaced by side-by-side model columns and a per-person toggle.
Removed The journal "% of total" column and the "Overage only" basis — superseded by the three-model comparison.

Cowork Chargeback

Report controls

Cut by (GL key) Any org column from your Entra export (Department, Cost Center, Legal Entity, Region...). Unmapped users go to "Unallocated".

Contracted rate ($/credit) Credits to dollars.

Microsoft invoice total ($) Enter to reconcile chargeback vs invoice.

Prepaid rate ($/credit) Rate for prepaid credit packs.

Prepaid credits purchased Total prepaid credits you bought. Compares your pool against actual usage in the Prepay panel.

Days in period For per-day usage and daily charge.

Headroom % (forecast) Buffer above actual usage for the recommended prepay pack.

Line items

Filter the per-person table (export always includes all).

Find people Searches the per-person line items.

Filter to values (view as)

Scope the whole report to the selected values (RLS-style view-as). None selected = all.

Exports

Interactive Excel tool — pick a billing model, add adjustments, and Final $ recomputes. Tabs: Summary, Allocation, Users, Model comparison. Use this to run and share the allocation.

Per-department snapshot: one row per unit with PAYGO / Prepaid / Hybrid $, a TOTAL row, and invoice reconciliation. Static values — good for the GL or a quick summary.

Per-person snapshot: every user with Department / Cost Center / Business Unit and all three model $. Always includes everyone — ideal for audit or pivots.

← Back to the report

Request a change

Tell us what would make the Cowork Chargeback report more useful.

Please note: there is no Cowork data API or live connection today, so requests to build or grant API access are a known platform limitation and cannot be actioned through this form. This report also runs entirely in your browser and does not submit anything automatically — it composes a request you can email or copy to your Microsoft contact.

Examples we have already implemented

Three billing models (PAYGO / Prepaid / Hybrid), side by side
Per-unit to per-person drill-down
Prepaid credits purchased vs usage
Spending-policy-driven limits + cut by policy
Search + view-as (RLS) filter
Multi-tab Excel workbook export

These shipped from customer feedback. Tell us what to build next below.

Your request

First name *

Email *

Organisation *

Type

Priority

What would you like changed or added? *

First name, email and organisation are required. Submit via Microsoft Form for a tracked request (recommended) — or copy / open in email as a fallback.