For one Microsoft tenant shared by several separately budgeted organisations. Each organisation states its entitlement, the share of the prepaid Copilot credit pool it funded, and every bill is rebuilt from that. The organisation that consumed earliest does not keep the discount. 100% in your browser.
The share of the prepaid pool an organisation paid for. A claim on the money, not a reservation of credits. The tenant cannot ring-fence credits per organisation, so nothing stops one entity consuming another’s discounted credits. The entitlement is what lets you correct that after the fact: bill each organisation against what it funded rather than against what it happened to draw down first.
A single tenant, more than one budget holder. Divisions, subsidiaries, agencies, member firms, districts — any set of organisations that share one Microsoft tenant but answer for their own spend separately. If one finance team pays the whole Copilot bill, you do not need this report. If the bill has to be split back to organisations that each hold their own budget, you do.
Covers the shared prepaid pool problem, what spending policies do and do not do, the five-step settlement, the entitlement round trip through Excel, the surplus decision, and the Post to GL export. Download · captions
All processing happens locally. Your files are parsed in browser memory on your own machine and no customer data ever leaves the device. Press F12 and watch the network tab: the only outbound call is the site analytics tag, which records anonymous feature usage and never file contents.
Load your Entra user export(s) and your Copilot credit / Cost Management export, then give each entity the share of the prepaid pool it funded. Prepaid credits sit in one tenant-wide pool with no way to reserve part of it, so whoever consumes earliest in the month gets the discounted rate. Settlement re-bills each entity against its own funded share instead, which takes drawdown order out of the calculation.
One shared pool, consumed first, then pay-as-you-go. The order cannot be changed or reserved against, and the invoice never says which entity got the discounted credits.
Its entitlement: the share of the pool it paid for. A claim on the money, not a reservation of credits. Enter them directly, or propose a split of the pool by usage, by headcount, or evenly.
bill = min(used, entitlement) × prepaid rate + max(0, used − entitlement) × pay-as-you-go rate
Drawdown order is not an input, so it stops mattering. An entity gets the prepaid rate on the credits it funded whether it consumed them on the 1st or the 28th.
An entity that funded more than it used had the difference consumed by someone else at the prepaid rate, while that someone is billed pay-as-you-go for it. The gap is the unused entitlement multiplied by the difference between the two rates.
Redistribute lends unused entitlement to the entities that went over, at the prepaid rate. Rebate returns it to the entities that funded credits they did not use. Hold centrally keeps it. Redistribute and rebate both reconcile to the invoice exactly; they differ in who benefits.
The report walks these same five steps against your own numbers. There is also a flat internal rate mode, if you would rather charge every entity one blended rate and reconcile centrally.
A reasonable question: if spending policies already control Copilot spend, why is a settlement needed at all? Because the two do different jobs.
Spending policies, month-round.
Settlement, at month end.
The one input the platform cannot give you is who funded what share of the pool. That is a commercial agreement between the organisations, and it is what you enter below as entitlements.
One caveat worth knowing: usage above a per-user limit “isn't billed (at Microsoft's sole discretion), and doesn't appear as consumed credits” in Cost Management. Your chargeback still reconciles, because the tenant was not charged for it, but credits-used will understate the work actually done. Source: Managing AI experiences enabled by usage-based billing.
Drop Entra CSV files here or click to browse (multiple allowed)
No file selected
Drop the Copilot credit CSV here or click to browse
No file selected
Pick the currency you are invoiced in below. You set the contracted rate and prepaid rate inside the report — rates are kept separately for each currency, so a euro figure is never priced at a dollar rate.
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.
Measured on synthetic tenants, not estimated. There is no cap on the number of entities: 35 and 200 both settle and reconcile identically.
| Tenant | Time to report | Workbook | Line items CSV |
|---|---|---|---|
| 200,000 users, 35 entities | ~8 seconds | 3.5 MB | 31 MB |
| 200,000 users, 200 entities | ~9 seconds | 3.7 MB | 31 MB |
| 500,000 users, 35 entities | ~22 seconds | 3.5 MB | 78 MB |
Tell us what would make the Multi-Budget Chargeback Report 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.
These shipped from customer feedback. Tell us what to build next below.
First name, email and organisation are required. Submit via Microsoft Form for a tracked request (recommended) — or copy / open in email as a fallback.